I am having 2 problems using the driver to access a clipper database. Below are the errors.
1. When doing my SELECT the UPPER command generates an error
01/11 10:35:41.49 Debug(TPConnection):ExecuteQuery. Person query:SELECT P_PERKEY, P_ATYPE, P_ACOUNT, P_DISPLAY,
P_NAME, P_DOB, P_STREET, P_CITY, P_STATE, P_ZIP, P_COUNTRY, P_PHONE, P_CURRENTA, P_ADDRDATE, P_TYPE, P_RACE, P_SEX,
P_HAIR, P_EYES, P_HEIGHT, P_WEIGHT, P_DLNO, P_DLSTATE, P_SSNO, P_FBINO, P_SIDNO, P_PHOTO, P_PHOTDATE FROM PERSON
WHERE UPPER(P_NAME) LIKE UPPER('DEMELLO%')
01/11 10:35:41.53 Error: ExecuteQuery. Retry:0 Caught exception:
java.sql.SQLException: Failed to parse: Stopped parse at UPPER
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.f(Unknown Source)
at com.hxtt.sql.a7.k(Unknown Source)
at com.hxtt.sql.y.if(Unknown Source)
at com.hxtt.sql.y.a(Unknown Source)
at com.hxtt.sql.y.executeQuery(Unknown Source)
at com.ctccore.talonpoint.TPConnection.ExecuteQuery(TPConnection.java:268)
at leindata_emudps.ProcessQuery(leindata_emudps.java:494)
at leindata_emudps.ProcessDatacoder(leindata_emudps.java:304)
at leindata_emudps.GetResponse(leindata_emudps.java:192)
at com.ctccore.amserver.VTSESS.LoadClass(VTSESS.java:1862)
at com.ctccore.amserver.VTSESS.GetResponse(VTSESS.java:1393)
at com.ctccore.amserver.LSTNINFO.getResponse(LSTNINFO.java:1253)
at com.ctccore.amserver.STCLI.ProcessRcvdData(STCLI.java:439)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessFullMsg(BUFFEREDPROTOCOL.java:191)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessRcvdData(BUFFEREDPROTOCOL.java:245)
at com.ctccore.util.LENGTHBYTECONTIN.ProcessRcvdData(LENGTHBYTECONTIN.java:164)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessFullMsg(BUFFEREDPROTOCOL.java:191)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessRcvdData(BUFFEREDPROTOCOL.java:245)
at com.ctccore.util.LENGTHBYTECONTIN.(LENGTHBYTECONTIN.java:75)
at com.ctccore.util.PROTOCOLSELECTOR.ProcessRcvdData(PROTOCOLSELECTOR.java:114)
at com.ctccore.util.SOCK.RecvLoop(SOCK.java:1609)
at com.ctccore.util.SOCK.RunInThread(SOCK.java:1712)
at com.ctccore.util.THREAD.run(THREAD.java:142)
2. When I remove the upper option I still get an error because it doesn't appear to find the index file.
01/11 11:27:33.72 Debug(leindata_ddp):ExecuteQuery. Person query:SELECT P_PERKEY, P_ATYPE, P_ACOUNT, P_DISPLAY,
P_NAME, P_DOB, P_STREET, P_CITY, P_STATE, P_ZIP, P_COUNTRY, P_PHONE, P_CURRENTA, P_ADDRDATE, P_TYPE, P_RACE, P_SEX,
P_HAIR, P_EYES, P_HEIGHT, P_WEIGHT, P_DLNO, P_DLSTATE, P_SSNO, P_PHOTO, P_PHOTDATE FROM PERSON WHERE P_NAME LIKE
'DEMELLO%'
01/11 11:27:33.96 Error running GetResponse in leindata_ddp:java.lang.NoSuchMethodError session:1
java.lang.NoSuchMethodError
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.i.a(Unknown Source)
at com.hxtt.sql.dbf.d.a(Unknown Source)
at com.hxtt.sql.dbf.d.(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.a7.if(Unknown Source)
at com.hxtt.sql.cl.a(Unknown Source)
at com.hxtt.sql.cl.a(Unknown Source)
at com.hxtt.sql.a7.a(Unknown Source)
at com.hxtt.sql.a7.a(Unknown Source)
at com.hxtt.sql.y.a(Unknown Source)
at com.hxtt.sql.y.a(Unknown Source)
at com.hxtt.sql.y.executeQuery(Unknown Source)
at com.ctccore.talonpoint.TPConnection.ExecuteQuery(TPConnection.java:268)
at leindata_ddp.ProcessQuery(leindata_ddp.java:506)
at leindata_ddp.ProcessDatacoder(leindata_ddp.java:310)
at leindata_ddp.GetResponse(leindata_ddp.java:198)
at com.ctccore.amserver.VTSESS.LoadClass(VTSESS.java:1862)
at com.ctccore.amserver.VTSESS.GetResponse(VTSESS.java:1393)
at com.ctccore.amserver.LSTNINFO.getResponse(LSTNINFO.java:1253)
at com.ctccore.amserver.STCLI.ProcessRcvdData(STCLI.java:439)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessFullMsg(BUFFEREDPROTOCOL.java:191)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessRcvdData(BUFFEREDPROTOCOL.java:245)
at com.ctccore.util.LENGTHBYTECONTIN.ProcessRcvdData(LENGTHBYTECONTIN.java:164)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessFullMsg(BUFFEREDPROTOCOL.java:191)
at com.ctccore.util.BUFFEREDPROTOCOL.ProcessRcvdData(BUFFEREDPROTOCOL.java:245)
at com.ctccore.util.LENGTHBYTECONTIN.(LENGTHBYTECONTIN.java:75)
at com.ctccore.util.PROTOCOLSELECTOR.ProcessRcvdData(PROTOCOLSELECTOR.java:114)
at com.ctccore.util.SOCK.RecvLoop(SOCK.java:1609)
at com.ctccore.util.SOCK.RunInThread(SOCK.java:1712)
at com.ctccore.util.THREAD.run(THREAD.java:142)
|
>WHERE UPPER(P_NAME) LIKE UPPER('DEMELLO%')
You can use p_name ilike 'DEMELLO%'.
>WHERE P_NAME LIKE 'DEMELLO%'
>01/11 11:27:33.96 Error running GetResponse in >leindata_ddp:java.lang.NoSuchMethodError session:1
>java.lang.NoSuchMethodError
>at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
It means HXTT DBF is using your index file to quicken query, but can't call a compiled method. What's your JDK version?
|
|
You can login to http://www.hxtt.com/download.jsp?product=dbf, and download the latest commerical package to replace your DBF JDBC20 and JDBC30 trial package.
|
1. ILIKE works great
2. It is 1.42, I found that the JDBC 2.0 works fine?
|
Please try the latest JDBC30 package. BTW, if you're using other HXTT packages(HXTT Access, HXTT Paradox, HXTT CSV, and so on), please replace those package with the relative latest package, then your issue should disappear. If you're adding JDBC20 package and JDBC30 package in the same classpath, you should remove one of them.
If you still get a NoSuchMethodError, please send us your index file (CDX, NTX suffix) since we can't recure that issue on JDK1.4.2.
|
Main
webmaster@hxtt.com