Help for setting up PostgreSQL JDBC pool
gifkins May 23, 2002 2:47 PMI am using JBOSS 2.4.5 and try to set up JBDC pool for Postgresql.
my PostgreSQL version is 7.2.1
I tried both jdbc7.0-1.2.jar and pgjdbc2.jar as driver
code i put in jboss.jcml are:
org.postgresql.Driver
shaneTestDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:postgresql://192.168.255.198:5432/shane_test
1200000
postgres
10
false
false
false
true
120000
1800000
false
false
1.0
0
relevant code I put in standardjaws.xml are
java:/shaneTestDS
<type-mapping>PostgreSQL</type-mapping>
false
for some reason when I startup Jboss, it shows error like this:
//**************Jboss server output********************
[INFO,JdbcProvider] Starting
[INFO,JdbcProvider] Started
[INFO,shaneTestDS] Starting
[INFO,XAPoolDataSource] Creating XA Pool
[INFO,shaneTestDS] XA Connection pool shaneTestDS bound to java:/shaneTestDS
[ERROR,XAConnectionFactory] Can't get an XAConnection
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADat
aSourceImpl.java:176)
at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnectionF
actory.java:282)
at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1004)
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:663)
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
e.java:215)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
a:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
igurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[ERROR,shaneTestDS] Stopped
java.lang.RuntimeException: Could not create connection
at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1008)
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:663)
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
e.java:215)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
a:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
igurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[ERROR,ConfigurationService] Unexpected error
java.lang.RuntimeException: Could not create connection
at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1008)
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:663)
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
e.java:215)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
a:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
igurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[INFO,HypersonicDatabase] Starting
[INFO,STDERR] Server 1.6 is running
//***************************************
any idea about why this may happen? or are there anything else i didnt think about?
Thank you.
Shane(gifkins@hotmail.com)