topic [resolved] tablecreate component using JDBC in Talend Studio

[resolved] tablecreate component using JDBC

Anonymous — Tue, 03 Jun 2014 10:14:46 GMT

Hi,
I have created JDBC connection in repository, the database connection property may change during execution from mysql to postgress... how can I create table using tTableCreate component using this connection.
Is this supported or not?
I am using TOS 5.3
Vaibhav

Re: [resolved] tablecreate component using JDBC

Anonymous — Wed, 04 Jun 2014 09:11:26 GMT

Executing multiple queries is not allowed using tJDBCRow component?? is if possible?
Vaibhav

Re: [resolved] tablecreate component using JDBC

Anonymous — Wed, 04 Jun 2014 09:37:47 GMT

How can i create a database having multiple tables using SQL query with JDBCRow component?
Any logical work around?
Vaibhav

Re: [resolved] tablecreate component using JDBC

Anonymous — Wed, 04 Jun 2014 09:44:16 GMT

Hi,

I have created JDBC connection in repository, the database connection property may change during execution from mysql to postgress... how can I create table using tTableCreate component using this connection.

It's not possible currently. Table list cannot link to tjdbcconnction connection.
It suggest you should open a work item/ feature jira issue of DI project.

Executing multiple queries is not allowed using tJDBCRow component?? is if possible?

Usually, we use update "Additional JDBC Parameters" to include "allowMultiQueries=true" then execute multiple SQL statements with one tXXXRow(tMysqlXXX) component, however, here is no configuration parameter "Additional JDBC Parameters" field in tJDBCRow.(Execution may stop after the first semi-colon.)
Best regards
Sabrina

Re: [resolved] tablecreate component using JDBC

Anonymous — Wed, 04 Jun 2014 10:57:25 GMT

Here is a work around for table creation using query with JDBCRow... Pl check the screenshot...
- Put your query in context variable
- use tnromalize with ; as separator
- set results to another context variable
- use that variable value n tJDBCRow
Vaibhav

Re: [resolved] tablecreate component using JDBC

Anonymous — Wed, 04 Jun 2014 11:07:24 GMT

Here is a work around for table creation using query with JDBCRow... Pl check the screenshot...

Fine. Actually, the job iterates each query and execute one by one.
Shong

Re: [resolved] tablecreate component using JDBC

Anonymous — Wed, 04 Jun 2014 11:11:24 GMT

Yep, I missed to write that statement about iteration...
Vaibhav