Pervasive DB connection - Syntax Error problem

One Star

Pervasive DB connection - Syntax Error problem

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 !

Moderator

Re: Pervasive DB connection - Syntax Error problem

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Pervasive DB connection - Syntax Error problem

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 :