topic Pervasive DB connection - Syntax Error problem in Installing and Upgrading

Pervasive DB connection - Syntax Error problem

Anonymous — Sat, 16 Nov 2024 11:15:01 GMT

Hi,
So I'm trying to connect a Pervasive DB V11 via JDBC link using TOS.
Things that works :
- Connection to Pervasive DB
- SQL queries
BUT... Whenever I'm doing a simple job (here attached screenshot of a data transfer from Pervasive to Flat File, only one field is transfered) I'm always getting the same error :

Exception in component tJDBCInput_1
java.sql.SQLException: Syntax Error: SELECT AATESTINGODBC.AAC.<< ??? >>SysNum, AATESTINGODBC.AAC.Crc_1, AATESTINGODBC.AAC.Crc_2, AATESTINGODBC.AAC.Crc_3, AATESTINGODBC.AAC.Crc_4, AATESTINGODBC.AAC.CreDate, AATESTINGODBC.AAC
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937)
at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256)
at com.pervasive.jdbc.lna.LNAStatement.execDirect(LNAStatement.java:351)
at com.pervasive.jdbc.v2.Statement.execute(Statement.java:222)
at com.pervasive.jdbc.v2.Statement.executeQuery(Statement.java:110)
at test.test2_0_1.test2.tJDBCInput_1Process(test2.java:1355)
at test.test2_0_1.test2.runJobInTOS(test2.java:2338)
at test.test2_0_1.test2.main(test2.java:2206)

I've done myself the xml mapping file (as it doesnt exist for Pervasive...) - maybe there's an error in this one ?

Thanks for your help !

Re: Pervasive DB connection - Syntax Error problem

Anonymous — Fri, 17 Apr 2015 11:40:41 GMT

Hi,
What's your quey in tJDBCInput? We cannot see your screenshot in our side. Could you please take a look at it?
Best regards
Sabrina

Re: Pervasive DB connection - Syntax Error problem

Anonymous — Fri, 17 Apr 2015 16:16:00 GMT

Hi,
My query is very simple, it's just a SELECT. I also don't understand why in the error I have "<<???>>" in AATESTINGODBC.AAC.<< ??? >>SysNum

SELECT AATESTINGODBC.AAC.SysNum, AATESTINGODBC.AAC.Crc_1, AATESTINGODBC.AAC.Crc_2, AATESTINGODBC.AAC.Crc_3, AATESTINGODBC.AAC.Crc_4, AATESTINGODBC.AAC.CreDate, AATESTINGODBC.AAC.CreTime, AATESTINGODBC.AAC.UpdDate, AATESTINGODBC.AAC.UpdTime, AATESTINGODBC.AAC.CreUsr, AATESTINGODBC.AAC.UpdUsr, AATESTINGODBC.AAC.ProdVer, AATESTINGODBC.AAC.DataVer, AATESTINGODBC.AAC.ValNiv, AATESTINGODBC.AAC.Value1, AATESTINGODBC.AAC.Value2, AATESTINGODBC.AAC.Value3, AATESTINGODBC.AAC.Value4, AATESTINGODBC.AAC.DescrNld, AATESTINGODBC.AAC.DescrFra, AATESTINGODBC.AAC.DescrEng, AATESTINGODBC.AAC.DescrDeu, AATESTINGODBC.AAC.Code, AATESTINGODBC.AAC.Text1, AATESTINGODBC.AAC.Text2, AATESTINGODBC.AAC.Text3, AATESTINGODBC.AAC.Text4, AATESTINGODBC.AAC.Info_1, AATESTINGODBC.AAC.Info_2, AATESTINGODBC.AAC.AnaAccType, AATESTINGODBC.AAC.CardUse, AATESTINGODBC.AAC.Levels, AATESTINGODBC.AAC.TrnBalance, AATESTINGODBC.AAC.BrowseVisible, AATESTINGODBC.AAC.EntryAdmitted, AATESTINGODBC.AAC.SyncStatus, AATESTINGODBC.AAC.SyncReference, AATESTINGODBC.AAC.SyncProtected, AATESTINGODBC.AAC.FutureUse_1, AATESTINGODBC.AAC.FreeToUse_1 FROM AATESTINGODBC.AAC";
Screenshots :