Talend community forum / Error attempting to insert into Sybase IQ

Paul Norris · 2009-07-20 23:08:49

Tags: [ASA error, database, error, java, sybase, Sybase IQ]

I have successfully used jdbc in the past to insert data into Sybase IQ. Now I'm running into a problem that has had me stuck for days. Every attempt I have made gets error
ASA Error -131: Syntax error near '(' on line 1

I get this with different tables and have never been able to insert anything into this database using Talend. I have no idea where this left paren is coming from. It's not in the data I'm sending; I have verified this by putting a delimited file between the tMap and the tJdbcOutput that is attempting to insert the data.

Any ideas how I can debug this? How can I intercept the statement that is being sent to the database and causes this error?

I am using TOS 3.1.3r26090.

Paul Norris · 2009-07-21 00:12:24

I may have resolved this problem by switching from jdbc to odbc to connect to Sybase IQ for the insert operation. Still, this is a bit disconcerting. The jdbc used to work, at least in other ETL projects.

I saw an old post saying that odbc was the preferred method for connecting to Sybase IQ. Could someone please confirm this and perhaps expand on it? Why is ODBC preferred?

jandry · 2009-07-21 01:18:41

Paul Norris wrote:
Any ideas how I can debug this? How can I intercept the statement that is being sent to the database and causes this error?

You can see what Talend is sending to the DB by selecting the component and then clicking on the "Code Viewer" tab, then select ALL from the drop-down arrow on the top right of the tab.

In the main section of the code you will see the DB call

Announcement

Unanswered posts

#1 2009-07-20 23:08:49

Error attempting to insert into Sybase IQ

#2 2009-07-21 00:12:24

Re: Error attempting to insert into Sybase IQ

#3 2009-07-21 01:18:41

Re: Error attempting to insert into Sybase IQ

Paul Norris wrote:

Board footer