1 Reply Latest reply on Nov 12, 2002 12:08 AM by koltar

    Datasource PostgreSQL HELP!

    koltar

      I am almost there hopefully this is the last configuration I have to bang my head on the desk over.

      I know how to setup Datasources in many other servers but this server is a wild monkey, its nuts.

      Alright,

      I created a mysite-service.xml and only changed the below

      jdbc/mysite


      <config-property name="ConnectionURL" type="java.lang.String">jdbc:postgresql://localhost:5432/mysite</config-property>
      <config-property name="DriverClass" type="java.lang.String">org.postgresql.Driver</config-property>
      <!--set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String">myuser</config-property>
      <config-property name="Password" type="java.lang.String">mypw</config-property>




      I copied in the pgjdbc2.jar into the default/lib, the mysite-service.xml is located in the default/deploy

      What else do I need to do to get my JSPs to be able to see jdbc/mysite? It works fine in tomcat when I deploy on jboss it fails.

      Thanks in advance!

        • 1. Re: Datasource PostgreSQL HELP!
          koltar

          This was fixed it was the JNDI name in jboss is java:/mycustomds and in tomcat it is java:/comp/env/jdbc/mycustomds

          A complete example of this in the getting started documentation would be extremely useful. This took me several weeks to get this stuff working way more than it should have since I had working examples in Tomcat, Oracle9ias and Weblogic. This should have been a one nighter not a 2 weeker(Moonlighting).