topic Re: Trouble inserting row in database in Talend Studio

Trouble inserting row in database

Martintin — Sat, 16 Nov 2024 01:58:18 GMT

Hi guys,

I wanna insert rows without the tDBOutput because it is clearer with what i'm doing in parallel in my job.

I use a tJavaFlex to do so with the following code :

Initial code :

java.sql.Connection myConn = (java.sql.Connection)globalMap.get("conn_tDBConnection_2");
java.sql.Statement stmt = myConn.createStatement();

Principal code :

String query = "INSERT INTO DEVERYWARE.dbo.PEOPULSE_STDC(MATRICULE, MONTANT) VALUES('"+row4.matricule+"','"+row4.heure+"');";
stmt.executeUpdate(query);

I think that i'm doing the right thing but nothing appears in my table.

Also, there is something strange, if i manually create a row in my table, the id is automatically given, which is normal.

So let's imagine it gets the id "500". If i execute my job, nothing appears in the table.

But if i try to create a new row manually, it'll get the id "600", as if the rows that should have been inserted with my job had been in the table at a moment.

It's probably not too much of a talend problem but more like a java/sql one, though I'd really appreciate some help.

Thanks in advance and sorry for the bad english (not my native language)

Martin

Re: Trouble inserting row in database

Anonymous — Mon, 06 Jul 2020 15:37:51 GMT

Are you committing?

Re: Trouble inserting row in database

Anonymous — Mon, 06 Jul 2020 15:37:51 GMT

Are you committing?

Re: Trouble inserting row in database

Martintin — Tue, 07 Jul 2020 07:19:13 GMT

Thanks for the answer !

No, I thought there was no need to.

I checked in several JDBC tutorial and they never mentionned any commit.

I'll see if it's the problem.

Re: Trouble inserting row in database

Martintin — Tue, 07 Jul 2020 07:19:13 GMT

Thanks for the answer !

No, I thought there was no need to.

I checked in several JDBC tutorial and they never mentionned any commit.

I'll see if it's the problem.

Re: Trouble inserting row in database

Martintin — Tue, 07 Jul 2020 07:25:25 GMT

That's exactly what it was.

Thank you mate!

Re: Trouble inserting row in database

Martintin — Tue, 07 Jul 2020 07:25:25 GMT

That's exactly what it was.

Thank you mate!