[JBoss-user] RE: CMP OrderBy DESC problem

[Dave, P. <PD...@us...>]

Dan, here is the server log

(I am using JBoss 2.0 final, SQL Server 6.5, and inet tds "UNA" driver)

[JAWS] java.sql.SQLException: [RFSRVDEV]Incorrect syntax near the keyword
'DESC'.
[JAWS] 	at com.inet.tds.TdsConnection.a(Unknown Source)
[JAWS] 	at com.inet.tds.TdsStatement.if(Unknown Source)
[JAWS] 	at com.inet.tds.TdsStatement.a(Unknown Source)
[JAWS] 	at com.inet.tds.TdsStatement.executeQuery(Unknown Source)
[JAWS] 	at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatemen
tInPool.java:70)
[JAWS] 	at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleRe
sult(JDBCQueryCommand.java:58)
[JAWS] 	at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158
)
[JAWS] 	at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand.
java:60)
[JAWS] 	at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEnti
tiesCommand.java:114)
[JAWS] 	at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersisten
ceManager.java:138)
[JAWS] 	at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManag
er.java:216)
[JAWS] 	at org.jboss.ejb.EntityContainer.find(EntityContainer.java:392)
[JAWS] 	at java.lang.reflect.Method.invoke(Native Method)
[JAWS] 	at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:639)
[JAWS] 	at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:160)
[JAWS] 	at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:86)
[JAWS] 	at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] 	at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
[JAWS] 	at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] 	at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:126)
[JAWS] 	at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] 	at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
[JAWS] 	at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:143)
[JAWS] 	at java.lang.reflect.Method.invoke(Native Method)
[JAWS] 	at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
[JAWS] 	at sun.rmi.transport.Transport$1.run(Unknown Source)
[JAWS] 	at java.security.AccessController.doPrivileged(Native Method)
[JAWS] 	at sun.rmi.transport.Transport.serviceCall(Unknown Source)
[JAWS] 	at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
[JAWS] 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown
Source)
[JAWS] 	at java.lang.Thread.run(Unknown Source)