3 Replies Latest reply on Sep 4, 2001 10:19 AM by Ronaldo Nascimento

    Postgresql JDBC driver ?

    jbossejb Newbie

      Hi to all
      I'm wondering does someone could recomend me a
      Postgresql JDBC driver
      I know only 2
      first is jdbc7.0-1.2.jar which i succesfully pooled
      second is jxDBCon-net-jdbc3-0.5.jar which i didn't
      manage to pool it give me an exception :

      java.lang.NullPointerException:
      at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:106)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
      at $Proxy0.start(Unknown Source)
      at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.Main.(Main.java:210)
      at org.jboss.Main$1.run(Main.java:116)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:112)

      for this driver is interesting that it didn't work
      even when i call it throw a simple program like
      it gives me an exception ot getConnection
      if(!isODBC)
      {
      Class.forName("org.sourceforge.jxdbcon.JXDBConDriver");
      }
      else
      {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      }
      java.sql.Connection c = DriverManager.getConnection(dbUrl,prop);

      Does Someone Could give me an idea how to pool it
      or better is someone to give me a hint which driver to Use is there other that i don't know
      Best Regards
      Anton Kostov