5 Replies Latest reply on Jul 18, 2002 9:00 PM by rschiavi

    JDBC Driver classes not found on Solaris

    Pieter Newbie

      Hi,

      I'm trying to connect a JBoss instance on Solaris to DB2 on Windows. First I've tried to IBM's net (applet) driver, but experiencing a classnotfound exception at JBoss' boot I switched to HOBLink J-DRDA. But the same problem occurs with this driver!

      I've tried to put the driver in lib/ext, tried to add the jar in classpath, but I always get something like

      java.lang.ClassNotFoundException: ob.sql.JHJDBCDriver
      at javax.management.loading.MLet.findClass(MLet.java:800)
      at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
      at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
      at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Class.java:120)
      at org.jboss.jdbc.JdbcProvider.initService(JdbcProvider.java:71)
      at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:77)
      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.init(Unknown Source)
      at org.jboss.util.ServiceControl.init(ServiceControl.java:54)
      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:207)
      at org.jboss.Main$1.run(Main.java:110)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:106)

      DB2 seems to be quite famous for his JDBC problems, but I don't find the info to integrate JBoss on Solaris with DB2.

      Any help is much appreciated!
      Pieter Van Gorp.

        • 1. Re: JDBC Driver classes not found on Solaris
          Werner Ramaekers Newbie

          Pieter,

          make sure you make the right changes to the jboss.jcml
          especially the driver setting
          which should be the COM.ibm.db2.jdbc.app.DB2Driver
          and the db2java.zip file from the sqllib folder should be on the classpath of JBoss.

          I am running JBoss on Solaris 8 against a DB2 on production systems so if you need more info, mail me tomorrow.

          Werner

          • 2. Re: JDBC Driver classes not found on Solaris
            Pieter Newbie

            > especially the driver setting
            > which should be the COM.ibm.db2.jdbc.app.DB2Driver
            Hey this amazes me: I've always experienced (with WL & DB2's admin tools) that the app driver only worked locally... that's why I didn't try it this time. Well it's never to late to try it again... Thanks Werner!

            > and the db2java.zip file from the sqllib folder
            > should be on the classpath of JBoss.
            done

            > I am running JBoss on Solaris 8 against a DB2 on
            > production systems so if you need more info, mail me
            > tomorrow.
            great

            • 3. Re: JDBC Driver classes not found on Solaris
              Pieter Newbie

              Problem solved!
              > especially the driver setting
              > which should be the COM.ibm.db2.jdbc.app.DB2Driver
              Werner, I did not use the app driver after all. The net driver is doing fine. The problem was caused by the following error:
              | COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver]
              | CLI0621E Unsupported JDBC Server configuration
              IBM's website learned me that it was a driver version problem. I've only got one DB2 installation CD, but I had used the db2java.zip from an earlier installation (another machine). Quite tricky :)

              Pieter.

              • 4. Re: JDBC Driver classes not found on Solaris
                Pieter Newbie

                It's much more likely that the bad db2java.zip came from an evaluation download of DB2 I once used (=> personal edition or something like that) whereas the DB2 instance I'm using righ now is the Enterprise Edition. So it wasn't so weird after all. I hope this can help others.

                Regards,
                Pieter.

                • 5. Re: JDBC Driver classes not found on Solaris
                  rschiavi Newbie


                  what/where is the JBoss classpath defined?

                  thanks,

                  rich