1 Reply Latest reply on Dec 11, 2001 6:13 PM by shaun

SQL Server 2000 as DefaultDS

shaun Dec 11, 2001 12:43 PM

Hello,

I've set up one of the RHM CMP examples and it works using the default hypersonic db set as DefaultDS. By following the documentation I've managed to set up SQL Server 2000 with the same name. The log file shows that this has worked correctly. When I run my client example it fails and I get the following in my log :

[JAWS] java.sql.SQLException: Unable to create PreparedStatement!
[JAWS] at org.jboss.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XAClientConnection.java:169)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135)
[JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:128)
[JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:231)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:616)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:843)
[JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:231)
[JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:154)
[JAWS] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:108)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:103)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:420)
[JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:372)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
[JAWS] at sun.rmi.transport.Transport$1.run(Unknown Source)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Unknown Source)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
[JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
[JAWS] at java.lang.Thread.run(Unknown Source)
[JAWS] java.sql.SQLException: Unable to create PreparedStatement!
[JAWS] at org.jboss.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XAClientConnection.java:169)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135)
[JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:128)
[JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:231)
[JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:616)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:843)
[JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:231)
[JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:154)
[JAWS] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:108)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:103)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:420)
[JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:372)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
[JAWS] at sun.rmi.transport.Transport$1.run(Unknown Source)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Unknown Source)
[JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
[JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
[JAWS] at java.lang.Thread.run(Unknown Source)

Any ideas on how I can fix this?

I guess it may have something to do with security but cannot find any hints about that.

Many Thanks,

Shaun

1. Re: SQL Server 2000 as DefaultDS

shaun Dec 11, 2001 6:13 PM (in response to shaun)

I think I've solved my own problem by searching through the forums. The answer (according to http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ is

"With the Microsoft driver the problem seems to be solved by setting the driver parameter SelectMethod=cursor.

E.g. in jboss.jcml you have to specify

jdbc:microsoft:sqlserver://:1433;DatabaseName=;SelectMethod=cursor

in the MBean section."

I recommend doing some searching before you post :-)

Shaun
Actions