[resolved] tOracleOutput: Table or View does not exist error.

One Star

[resolved] tOracleOutput: Table or View does not exist error.

Hi,
i am trying to insert the records from .cvs file into a table on Oracle. My table's name is 'ext_matrix_table'. The mapping is fast 1 to 1. When i execute the job, i 've got an error : "Table or View does not exist" from Oracle. I think the table's name is the issue. I have tried 'Select * from ext_matrix_table' in SQL Builder and 've got the same result. But when i type 'Select * from "ext_matrix_table" ', it works. The problem is how can i tell Talend to use "ext_matrix_table" insteed ext_matrix_table. The generated code is showed as following:

dbschema_tOracleOutput_1 = "TEST2";
conn_tOracleOutput_1 = java.sql.DriverManager.getConnection(
url_tOracleOutput_1, dbUser_tOracleOutput_1,
dbPwd_tOracleOutput_1);

conn_tOracleOutput_1.setAutoCommit(false);
int commitEvery_tOracleOutput_1 = 10000;
int commitCounter_tOracleOutput_1 = 0;
int batchSize_tOracleOutput_1 = 10000;
int batchSizeCounter_tOracleOutput_1 = 0;

if (dbschema_tOracleOutput_1 == null
|| dbschema_tOracleOutput_1.trim().length() == 0) {
tableName_tOracleOutput_1 = "ext_matrix_table";
} else {
tableName_tOracleOutput_1 = dbschema_tOracleOutput_1 + "."
+ "ext_matrix_table";

As you can see, it set the table name as Test2.ext_matrix_table, what i use is Test2."ext_matrix_table". How should i do? Thank you for any suggestions.

More Informations:
OS: Windows XP Prof. SP3
Oracle 9i
Talend Open Studio 3.2.2, Build id: r33000-20091120-1245.

Re: [resolved] tOracleOutput: Table or View does not exist error.

if you have the table name quoted in the tOracleOutput_1 component, this may be a bug. if you dont, then try it again with quotes around the table name.

as an aside, I would suggest using Perl.

Besides the huge performance advantage, you no longer need to worry about data types and you gain huge advantages in string processing. You do however, give up machine independence. If this is required for your project, java may be a better choice.
One Star

Re: [resolved] tOracleOutput: Table or View does not exist error.

Hi,
thank you for your advise. The table name has been already quoted with ". It works with "normal" table name (for example AGENTS) but with ext_matrix_table, it doesn't work. We need somthing like this:

tableName_tOracleOutput_1 = dbschema_tOracleOutput_1 + "." + """ +
+ "ext_matrix_table" + """;

but how can i tell Talend to do that? I hope to hear something from Talend's experts. Thank you in advance.

JohnGarrettMartin wrote:
if you have the table name quoted in the tOracleOutput_1 component, this may be a bug. if you dont, then try it again with quotes around the table name.

as an aside, I would suggest using Perl.

Besides the huge performance advantage, you no longer need to worry about data types and you gain huge advantages in string processing. You do however, give up machine independence. If this is required for your project, java may be a better choice.
Community Manager

Re: [resolved] tOracleOutput: Table or View does not exist error.

Hello
but how can i tell Talend to do that?

Set the table name filed of tOracleOutput as : "\"ext_matrix_table\"".

Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] tOracleOutput: Table or View does not exist error.

Hi,
it works. Thank you

shong wrote:
Hello
but how can i tell Talend to do that?

Set the table name filed of tOracleOutput as : "\"ext_matrix_table\"".

Best regards

shong

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog