On 9/21/2006 4:15 PM, Lars Huttar wrote:
Hello,
Does anyone have Cocoon connecting successfully to SQL Server 2005?
We've been using Cocoon for quite some time (currently 2.1.7) with SQL
Server 2000.
Now I've been trying to switch to 2005 and Cocoon keeps giving an error
ERROR (2006-09-21) 16:03.33:230 [sitemap.generator.serverpages]
(/mount/gem/enterprise/sMicrosoft/IT_Servers/guest/select_IT_Server)
http-80-Processor25/select_IT_Server_xsp:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Error establishing socket.
I tried replacing the three ms jars (mssqlserver.jar, msutil.jar, and
msbase.jar) with sqljdbc.jar, the new sql server 2005 jdbc driver from
ms download site. (This in Cocoon's WEB-INF\lib folder.) I also
adjusted WEB-INF\web.xml to change the driver class name from
com.microsoft.jdbc.sqlserver.SQLServerDriver
to
com.microsoft.sqlserver.jdbc.SQLServerDriver
However, I still get the error
(core.log:)
WARN (2006-09-21) 16:14.13:299 [core.manager]
(/mount/gem/enterprise/sMicrosoft/IT_Servers/guest/select_IT_Server)
http-80-Processor25/ResourceLimitingJdbcDataSource: Could not return
Connection
java.sql.SQLException: No suitable driver
(error.log:)
ERROR (2006-09-21) 16:14.13:299 [sitemap.generator.serverpages]
(/mount/gem/enterprise/sMicrosoft/IT_Servers/guest/select_IT_Server)
http-80-Processor25/select_IT_Server_xsp:
java.sql.SQLException: No suitable driver
(Yes, I restarted Tomcat after each change.)
Any suggestions or reports of success would be appreciated.
Lars
20 months later...
Turns out we also needed to change our db connection URLs (in the
datasources in cocoon.xconf).
We had to change 'jdbc:Microsoft:sqlserver://' to 'jdbc:sqlserver://',
i.e. get rid of Microsoft and everything was fine. ;-)
Thanks to Rick Harman for discovering this.
Lars
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
