Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Boost 1
Level 1
Scott_Jiang
Level 1

Like

1 like

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Scott_Jiang
Level 1

Like

1 like

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
Scott_Jiang
Level 1

20-10-2009


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
JBoss 4.0.3 SP1
Windows 2003 SP1
Adobe ES 8.2


If not corrected, you'll see 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)
.......