Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have to create an Access database file, getting data from an Oracle database.
net.ucanaccess.jdbc.UcanaccessSQLException: unexpected token: , required: )
at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:145)
I placed an Access component in my job. I had to download some jars : jackcess-2.1.0.jar and jackcess-encrypt-2.1.0.jar.
However, they couldn't be downloaded by Talend itself... I had to download them on the net manually :
Here http://www.java2s.com/example/jar/j/download-jackcess210jar-file.html and here http://www.java2s.com/example/jar/j/download-jackcessencrypt210jar-file.html and add them clicking on the jar icon, on the Windows showing that these jar are necessary.
I could connect to my Acess DB file. However, when I try to insert data, I have the above error.
Has anyone encountered this error ?
Thank you everyone,
I found the solution :
FIRST : you have to check the index order type and set it on General or General - Legacy
SECOND : in the job, in the tAccessOutput schema, check if the database column is correctly set, because in my case, it was empty and in an orange color.
🙂
Thank you for your help !
Hi
Check this error always occurs whatever data is inserted or only occurs on a certain row? If the latter, output the reject rows to see which data has the error?
..tDBOutput--reject--tLogRow.
Regards
Shong
Hello @Shicong Hong
I restarted Talend, and I saw that the error doesn't occur anymore.
HOWEVER, when I get the data from another Oracle table, the error get back...
The job dies in case of error, whereas die option is not activated on the tAccessOutput component...
I found the solution :
FIRST : you have to check the index order type and set it on General or General - Legacy
SECOND : in the job, in the tAccessOutput schema, check if the database column is correctly set, because in my case, it was empty and in an orange color.
🙂
Thank you for your help !