14 Replies Latest reply on Jul 15, 2002 4:17 PM by Marc Sturm

    My Jboss Project with Postgresql

    Parul Agarwal Newbie

      Hi,

      I have to start work on a project using Jboss. I am new to Jboss. The project detail is as follows: I wish to have a registration form that should be served to user to register himself. When the user submits the form, the processing has to be done by Jboss and the data has to be put into Postgresql database.

      Since I am new to Jboss, pls tell me how to go about doing all this.

      Regards,
      Parul

        • 1. Re: My Jboss Project with Postgresql
          Parul Agarwal Newbie

          It is really strange as to why no one has replied to my query?? Pls help me out.

          Regards,
          Parul

          • 2. Re: My Jboss Project with Postgresql
            Joel Vogt Master

            we would like to help you but it's a secret

            • 3. Re: My Jboss Project with Postgresql
              Parul Agarwal Newbie

              What kind of secret are you talking about. Pls elaborate a bit more on this topic. I have installed jboss-3.0.0-src.tgz on my redhat 7.2 machine.On the browser, http://localhost:8082/, I get some kind of description of beans. What next?? Do I need to configure Tomcat/Jetty with my jboss installation or is it already been done??
              Pls help me out.

              Regards,
              Parul

              • 4. Re: My Jboss Project with Postgresql
                Kevin Decelles Newbie

                I'm running JBoss 3.0 on Redhat 7.2 with Postgres 7.2.1 with no problems.

                There are 3 steps to making this work and I've attached all relevant files (except postgresql.jar)


                1. You need to create a postgresl-service.xml file which goes in the server/default/deploy directory
                I've inlcuded my postgres-service.xml file. I found this on various sites. The only thing I've changed (security purposes) is the name of my server and database (I've now called it orin and orinnet)
                The postgresql-service file defines 3 mbeans which setup a connection pool, connection manager and a datasource. Do not specify any user Id's or password in this file. The login-config.xml file takes care of this (see below)

                2. Modify the login-config.xml file (also in the server/default/deploy directory)
                In the login-config.xml file the only thing I added was the PostgresDbRealm application policy. I found that placing this near the top of the file wor

                • 5. Re: My Jboss Project with Postgresql
                  Kevin Decelles Newbie

                  (continued from previous)

                  works best (don't know why)

                  3. Place the postgresql.jar file in the server/default/lib directory. This causes the jdbc driver to be loaded by the vm.


                  Finally I simply restarted JBoss for good measure and after doing so the PosgresDS datasource is bound to JNDI and I could access it from my beans.

                  Let me know if this helps.

                  Kevin.

                  • 6. Re: My Jboss Project with Postgresql
                    Kevin Decelles Newbie

                    Parul, I send you an email with all of this included. Let me know if this helps.

                    • 7. Re: My Jboss Project with Postgresql
                      Stefan Kuehn Newbie

                      Hi Kevin!

                      I'm an absolute JBoss-Beginner.

                      I just wanted to ask you where you have learned to use JBoss3.0.

                      Did you know how to use the prior versions?

                      How did you get to learn it at all?
                      Have you read the "JBoss book"?

                      It seems to me, that it isn't very easy to get to learn how to use JBoss.

                      I worked my way in to the reference imp. from SUN and i also develloped my web based app using that app server.
                      Now i want to port it all to JBoss/PostgreSQL, but im still struggling with the 3.0 template project.

                      By the way, the files you added will probably be of good use for me too. Indeed that was one of my main questions.
                      I.e. how to sett upp a data source and a queue
                      Another question is: How do i deploy JSP-Files?

                      Do you have some usefull hint, where i can find information/documentation/user groups on JBoss?

                      Thank you very much!
                      Rgds.
                      Stefan

                      • 8. Re: My Jboss Project with Postgresql
                        Julian Gosnell Expert

                        JSPs are deployed by packaging them into a .war file and copying that into server/deploy/

                        There are loads of tutorials on J2EE packaging and .war, ejb-jar and .ear files on the web. You will need to read one of these.....

                        Jules

                        P.S.

                        for a simple .jsp make a directory called my.war, put your jsp in it, copy my.war into server/<configuration./deploy and hit localhost:8080/my/<your-jsp-here>.jsp

                        Good luck.

                        • 9. Re: My Jboss Project with Postgresql
                          Kevin Decelles Newbie

                          I started by downloaded the software (2.4) and then following examples from the web site etc. I purchased the documentation (9.99 from flashline) and eventually ended up downloading the source code and tracing through the source to find out why things don't work.

                          To the credit of the development team, the product has almost always worked straight out of the box.

                          When in doubt I've never hesitated to email a developer directly to get an answer that I want.

                          Learn by doing!

                          • 10. Re: My Jboss Project with Postgresql
                            Marc Sturm Newbie

                            Kevin,

                            I did all what you wrote but when run Jboss3, it looks for the DefaultDS to deploy the container managed entity beans instead of the PostgresDS. Do you know why?
                            Thanks for your response.

                            Marc

                            • 11. Re: My Jboss Project with Postgresql
                              Joel Vogt Master

                              unless you include a jaws.xml jboss will use standardjaws.xml which maps to the default ds

                              • 12. Re: My Jboss Project with Postgresql
                                Chuck Irvine Newbie


                                > 2. Modify the login-config.xml file (also in the
                                > server/default/deploy directory)
                                > In the login-config.xml file the only thing I added
                                > was the PostgresDbRealm application policy. I
                                > found that placing this near the top of the file wor

                                In the login-config.xml file, there are three settings: principal, userName, and password. What exactly do these parameters refer to? I'm guessing that userName and password refer to the username and password for the associated postgreSQL database. Correct? I really have no idea what principal might be referring to.

                                And, in general, is there documentation that describes the login-config.xml file.

                                Thanks for your help.

                                • 13. Re: My Jboss Project with Postgresql
                                  Kevin Decelles Newbie

                                  I also do not know what prinicpal is for. Sorry. The user id and password are used to connect to the database.

                                  • 14. Re: My Jboss Project with Postgresql
                                    Marc Sturm Newbie

                                    Thank you Joelvogt, I got it now.

                                    Marc