[jboss-user] [JCA/JBoss] - Re: Microsoft JDBC Driver for SQL Server 2008 Failure

[treespace]

The only change was to use DefaultDS as the jndi-name in mssql-ds.xml and remove hsqldb-ds.xml to eliminate the conflict. The assumption being the file name is irrelevant (any *-ds.xml pattern will do) and that all JDBC drivers must adhere to precisely the same interface. 

Looks like Quartz is using a column called CLUSTERED in a query? That raises some interesting questions in terms of reserved words and how a vendor can add extra ones not addressed by JDBC (or some other spec). 

Here is the error message:

17:59:30,625 INFO  [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
17:59:30,640 INFO  [RAMJobStore] RAMJobStore initialized.
17:59:30,640 INFO  [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Qua
rtz package: 'quartz.properties'
17:59:30,640 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2
17:59:30,640 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
17:59:31,140 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS
' to JNDI name 'java:DefaultDS'
17:59:34,671 INFO  [ServerPeer] JBoss Messaging 1.4.3.GA server [0] started
17:59:38,343 WARN  [JDBCSupport] SQLException caught, SQLState S0001 code:156- assuming deadlock detected, try:1
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'CLUSTERED'.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)



View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4220107#4220107

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4220107