CMP 2.0 Oracle JDBC Configuration

[netchhe]

It would be great, if somebody could give me some links to documentation
and/or hints for configuring CMP 2.0 to be used with the Oracle JDBC Thin Driver.

[tosht]

Hi David,

I have the same problem with configuring datasource with JBoss 2.4.4_Tomcat4.0.1. I tried to do what you've suggested, set blocking=true. However, JBoss server hangs at here:
[INFO,MSSQLPool] Starting
[INFO,MSSQLPool] XA Connection pool MSSQLPool bound to java:/MSSQLPool

I wonder what has gone wrong. Previously, when I have not set blocking=true, it throws me a NullPointerException and I've tried to search through the forum, have yet find any solutions. Basically I'm trying to configure MS SQL 7 datasource, which resides on another machine (Windows platform), with JBoss2.4.4_Tomcat4.0.1 under Linux platform (RedHat 7.2). I changed all the things that I've found from the forum but it still throws NullPointerException and until now it hangs there. Therefore, I'm hoping someone where I can consult with to have a look at my jboss.jcml's JDBC config portion. Please tell me where have I missed. Would really appreciate if there's anyone who can help, thank you!

p/s: Below is previous's testing result when I have not set blocking=true

Regards,
Karen

###### JBoss output ########
...
[INFO,JdbcProvider] Initializing
[INFO,JdbcProvider] Loaded JDBC-driver:com.microsoft.jdbc.sqlserver.SQLServerDriver
[INFO,JdbcProvider] Loaded JDBC-driver:org.postgresql.Driver
[INFO,JdbcProvider] Initialized
[INFO,MSSQLPool] Initializing
[INFO,MSSQLPool] Initialized
[INFO,PostgreSQLPool] Initializing
[INFO,PostgreSQLPool] Initialized
...
...
...
[INFO,JdbcProvider] Starting
[INFO,JdbcProvider] Started
[INFO,MSSQLPool] Starting
[INFO,MSSQLPool] XA Connection pool MSSQLPool bound to java:/MSSQLPool
[ERROR,MSSQLPool] Stopped
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
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:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
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: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.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
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:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
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: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,PostgreSQLPool] Starting
[INFO,PostgreSQLPool] XA Connection pool PostgreSQLPool bound to java:/PostgreSQLPool
[INFO,PostgreSQLPool] Started

####### jboss.jcml #######



com.microsoft.jdbc.sqlserver.SQLServerDriver,
org.postgresql.Driver




MSSQLPool
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

jdbc:microsoft:sqlserver://PA2300:1433;DatabaseName=MASTERDB;SelectMethod=cursor
1200000
sa
100
sa
false
false
true
false
120000
1800000
true
false
1.0
0

[netchhe]

Giving myself a link:

http://www.jboss.org/online-manual/HTML/ch03s12.html

or

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/manual/src/examples/resources/jca/

Shows examples of different database configurations, also Oracle.