Running following query "select ID, CallID, StartTime, EndTime, CallNote, BillingCode, Extension, Duration, CallType, DialedNumber, CallerID from Call where ID > ? order by ID". Exception thrown is:
<37> <>
java.sql.SQLException: Syntax error: Stopped parse at Call
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.g(Unknown Source)
at com.hxtt.sql.bm.m(Unknown Source)
at com.hxtt.sql.ag.if(Unknown Source)
at com.hxtt.sql.de.(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.prepareStatement(Unknown Source)
at com.hxtt.sql.bm.prepareStatement(Unknown Source)
at com.hxtt.sql.bm.prepareStatement(Unknown Source)
at com.syncvoice.databuffer.input.JdbcInput.processPendingRecords(JdbcInput.java:454)
at com.syncvoice.databuffer.input.JdbcInput.processConnection(JdbcInput.java:244)
at com.syncvoice.databuffer.input.RunnableInput.run(RunnableInput.java:161)
at com.syncvoice.commons.lang.Thread$MyRunnable.run(Thread.java:38)
at java.lang.Thread.run(Thread.java:595)
Can run similar statements against tables in same database that do not have AUTONUMBER field as primary key and query runs fine. Any suggestions?
|
It hasn't any relation with AUTONUMBER column. CALL is a reserved word in SQL 99. You can try:
select ID, CallID, StartTime, EndTime, CallNote, BillingCode, Extension, Duration, CallType, DialedNumber, CallerID from "Call" where ID > ? order by ID
|
Main
webmaster@hxtt.com