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) 1
Richard,
Thanks for your suggestion.
So you're saying that you had to load the driver using Class.forName()
before trying to open a connection.
Where did you put this Java code? in the SQLTransformer class?
One hates to tack on custom Java modifications, but if it's the only way
to get SQL Ser
On 9/22/2006 9:47 AM, Lars Huttar wrote:
On 9/21/2006 6:15 PM, Laurent Perez wrote:
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.)
Don't know i
On 9/21/2006 6:15 PM, Laurent Perez wrote:
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.)
Don't know if you are free to switch your db driver if
I appreciate this suggestion. I gave it a try, but am still getting the
same error:
http-80-Processor25/ResourceLimitingJdbcDataSource: Could not return
Connection
java.sql.SQLException: No suitable driver
I also tried cleaning out Tomcat's work folder, but to no avail. I will
now try JTDS as
hi
We are testing succesfully MS SQL 2005 with microsoft's jdbc driver.
Here is a part of our web.xml, try to add the missing class:
load-class
com.microsoft.sqlserver.jdbc.SQLServerDriver
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
On 9/21/2006 6:15 PM, Laurent Perez wrote:
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.)
Don't know if you are free to switch your db driver if
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.)
Don't know if you are free to switch your db driver if your code
depends on specific implementatio