You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-11-09 10:56:26

Ashutosh1
Member
8 posts

Ashutosh1 said:

How to call SP in amazon aurora database in Talend

Hi ,

Is there any sp like tmysqlSp for amazon aurora???

if not then what is the alternative ?
note : I need to use an existing connection ( that is tamazonAuroraConnection) for calling SP so that i can rollback.

Offline

#2 2016-11-09 18:30:38

jlolling
Member
3186 posts

jlolling said:

Re: How to call SP in amazon aurora database in Talend

Currently you can only do this task with pure Java code in a tJava component.
Here an idea (not complete or tested but it gives you an idea).

try {
   java.sql.Connection conn = (java.sql.Connection) globalMap.get("conn_tAmazonAuroraConnection_1");
   java.sql.Statement stat = conn.createStatement();
   String sql = "select my_proc()";
   stat.execute(sql);
   stat.close();
} catch (java.sql.SQLException sqle) {
   globalMap.put("ERROR_MESSAGE", sqle.getMessage());
   throw sqle;
}

You have to change the unique id of the connection in the first line and the sql code of the procedure call.

Last edited by jlolling (2016-11-09 18:33:32)


Talend Certified working for cimt objects AG in Berlin

Offline

#3 2016-11-10 12:12:10

Ashutosh1
Member
8 posts

Ashutosh1 said:

Re: How to call SP in amazon aurora database in Talend

Thank you so much jlolling.  Yes it gave me an idea.

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy