[opencms-dev] SQL Server Spupport: Error in Project Management

[shishank.mathur at wipro.com]

Hi,

I am using OpenCms 6_0_1 tag with Sql Server 2000 and Weblogic 8.1 SP4.
When I try to access Administration View --> Project Management -->
Project History I encounter the following error:

Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query:
net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 624a40.
 at
org.opencms.db.mssql.CmsBackupDriver.readBackupProjects(CmsBackupDriver.
java:108)
 at
org.opencms.db.CmsDriverManager.getAllBackupProjects(CmsDriverManager.ja
va:2894)
 at
org.opencms.db.CmsSecurityManager.getAllBackupProjects(CmsSecurityManage
r.java:1688)
 ... 50 more
Caused by: java.sql.SQLException: Line 1: Incorrect syntax near '@P0'.
 at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java
:364)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:620)
 at
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.ja
va:372)
 at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrepare
dStatement.java:672)
 at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
 at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
 at
org.opencms.db.mssql.CmsBackupDriver.readBackupProjects(CmsBackupDriver.
java:83)
 ... 52 more


Any Pointers?

Kind Regards,
Shishank
http://goshishank.blogspot.com





Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or Mailadmin at wipro.com immediately
and destroy all copies of this message and any attachments.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050926/da38a61a/attachment.htm>