Receiving the following exception when querying a table:
java.sql.SQLException: null to acquire table Call
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.concurrent.ah.L(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.z.a(Unknown Source)
at com.hxtt.sql.access.n.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.dc.a(Unknown Source)
at com.hxtt.sql.d8.do(Unknown Source)
at com.hxtt.sql.dc.a(Unknown Source)
at com.hxtt.sql.dc.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.de.executeQuery(Unknown Source)
at com.syncvoice.databuffer.input.JdbcInput.processPendingRecords(JdbcInput.java:464)
at com.syncvoice.databuffer.input.JdbcInput.processConnection(JdbcInput.java:246)
at com.syncvoice.databuffer.input.RunnableInput.run(RunnableInput.java:133)
at com.syncvoice.commons.lang.Thread$MyRunnable.run(Thread.java:38)
at java.lang.Thread.run(Thread.java:595)
The query is:
SELECT Call.ID, Connect.CallTableID, Connect.PortID, Connect.PortName, Connect.GroupID, Connect.GroupName, Call.Extension, Call.CallType, Connect.PartyID, Connect.CtrlPartyID, Call.DialedNumber, Call.CallerID, Connect.Duration, Connect.ConnectTime FROM Call INNER JOIN Connect ON Call.ID = Connect.CallTableID WHERE Call.CallType in (2,3,4) AND Connect.PartyType = 2 and Call.ID > ? order by Call.ID;
Using the latest version of the driver so I removed the double-quotes from the "Call" and "Connect" table names.
Thanks,
Kevin
|
SQL State | Description
S1T00 | Timeout expired
It means that HXTT Access failed to acquire a table in a timeout. Whether there's many threads to access those tables? You can use a bigger value for lockTimeout connection property.
|
Main
webmaster@hxtt.com