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#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...