Richard DeMello | 2006-01-11 00:00:00.0 | |
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. 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. 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. 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. 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) | ||
HXTT Support | 2006-01-11 00:00:00.0 | |
>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? | ||
HXTT Support | 2006-01-11 00:00:00.0 | |
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. | ||
Richard | 2006-01-11 00:00:00.0 | |
1. ILIKE works great
2. It is 1.42, I found that the JDBC 2.0 works fine? | ||
HXTT Support | 2006-01-11 00:00:00.0 | |
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. |