Re: SQL Server 2005?

[Lars Huttar <la...@sil.org>]

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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org