4 Replies Latest reply on Dec 18, 2001 1:59 PM by Michael Vec

    ejb's with SQL Server

    frank starsinic Newbie

      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

        • 1. Re: ejb's with SQL Server
          simon Newbie

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

          • 2. Re: ejb's with SQL Server
            Josh Newbie

            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)

            • 4. Re: ejb's with SQL Server
              Michael Vec Newbie

              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