ejb's with SQL Server

[fstarsinic]

is anyone using ejb's with sql server? i'm having a
hard time with cmp and sql server. i'm using the JdbcOdbcBridge. I've heard that there are problems with it.

Does anyone think that CMP with SQLServer is a piece of cake. If so, let me know. I'm about to test the merant driver to see if i have better luck.

frank

[simonm99]

yes, it works with SQL server 7- i'm using the JNet Direct driver and it works superbly

[barnaby33]

Where can I find this driver? I have tried using both Meran't and Weblogic's drivers and neither one will successfully login when the pool starts. I get this exception. Only its not harmless as some people on the forums have mentioned. The connections never get created.


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:107)
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)

[volker666]

Use the Microsoft JDBC Driver.
http://www.microsoft.com/sql/downloads/2000/jdbc.asp

An MBean setting for this driver can be found here:
http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/

[michaelvec]

Simon,

could you please be so kind to post your entries made to the jboss.jcml file. I cannot get it to work. It always fails.

Thanks a lot.
Mike