Expand my Community achievements bar.

Elevate your expertise and be recognized as a true influencer! Nominations for the exclusive Adobe Community Advisor program 2023 are now OPEN.

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


Level 1

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)

0 Replies


Level 1

Sorry - wrong spot. I will re-post this in ES Installation Discussion forum.