Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

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)

1 Reply


Level 1

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