1 Reply Latest reply on Oct 20, 2009 6:52 AM by Scott.Jiang

    Preparing to Upgrade to LiveCycle® ES from 7.x document error: page 85

    Scott.Jiang

      Preparing to Upgrade to LiveCycle® ES from 7.x document error: page 85, when configuring the JMS with Microsoft SQL Server 2005 for JBoss 4.0.3 SP1. Step 5: Modifiy <local-tx datasource> element .....   <connection-url> jdbc:microsoft.sqlserver ..... <c/onnection-url>, in mssql-ds.xml file:

       

      Should be: <connection-url>jdbc:sqlserver://.... </connection-url>

      Notice the word "microsoft" needs to be removed as this is SQL 2005, not SQL 2000.

       

      Also, in the same JMS configue file, com.microsoft.jdbc.sqlserver.SQLServerDriver should be changed to com.microsoft.jdbc.sqlserver.SQLServerDriver as the driver-class.

       

      We are using

      SQL 2005 SP1

      Windows 2003 SP1

      Adobe ES 8.2

       

       

      If not corrected, you'll see some error like this in log file:

       

      Caused by: org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.jdbc.sqlserver.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.microsoft.jdbc.sqlserver.SQLServerDriver)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(L ocalManagedConnectionFactory.java:287)
      .......