topic Re: create table if doesn't exist ,drop table if exist and create options in Talend Studio

create table if doesn't exist ,drop table if exist and create options

Anonymous — Mon, 27 Oct 2014 05:40:04 GMT

create table if doesn't exist ,drop table if exist and create options are not working.
when i used "drop table if exist and create " it was throwing exception like "name is already used by an existing object". It shouldn't throw like that .Please let me know how to resolve this issue

Re: create table if doesn't exist ,drop table if exist and create options

Anonymous — Mon, 27 Oct 2014 07:20:09 GMT

Hi,
Which DB component are you using? Could you please give us more information about your current job design?
Best regards
Sabrina

Re: create table if doesn't exist ,drop table if exist and create options

Anonymous — Mon, 27 Oct 2014 08:50:47 GMT

toracle output.and action on table is "drop table if exist and create"
throwing exception like
"
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-00955: name is already used by an existing object
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1731)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tFileInputPositional_1Process(Bassett_Furniture.java:2230)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tSetGlobalVar_2Process(Bassett_Furniture.java:1101)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tOracleConnection_1Process(Bassett_Furniture.java:988)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tFileInputProperties_1Process(Bassett_Furniture.java:825)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tPrejob_1Process(Bassett_Furniture.java:476)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.runJobInTOS(Bassett_Furniture.java:3485)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.main(Bassett_Furniture.java:3352)
disconnected"

Re: create table if doesn't exist ,drop table if exist and create options

Anonymous — Mon, 27 Oct 2014 08:52:23 GMT

from 5 months it was working properly .since yesterday it was getting problem

Re: create table if doesn't exist ,drop table if exist and create options

Anonymous — Mon, 27 Oct 2014 09:01:21 GMT

Hi,
It is probably caused by your DB.
Could you please search your table in SQL. such as: select OBJECT_NAME,CREATED,STATUS,TIMESTAMP from user_objects where OBJECT_name='TableName'; to see if there any procedure with same name?
Best regards
Sabrina

Re: create table if doesn't exist ,drop table if exist and create options

Anonymous — Mon, 27 Oct 2014 12:21:08 GMT

Hi,
If i drop the table explicitly from sql developer and using job it was working.for the next time i run the same job with drop table if exist and create it was not working and throwing that error

Re: create table if doesn't exist ,drop table if exist and create options

Anonymous — Tue, 28 Oct 2014 08:10:04 GMT

Hi,

If i drop the table explicitly from sql developer and using job it was working.for the next time i run the same job with drop table if exist and create it was not working and throwing that error

Could you please indicate the build version you are using? Does this issue repro on other talend studios?
I have splited your XulRunner issue into a new topic.
Best regards
Sabrina

Re: create table if doesn't exist ,drop table if exist and create options

Dmitry2 — Wed, 08 Jul 2015 15:15:37 GMT

Hi,
I have the same issue.

When I specify the schema in the filed "Table" and select "Drop table if exists ant create" the table isn't removed. So I get the error "ORA-00955 name is already used by an existing object".
If the schema isn't specified (only table name), it works.
If the schema is specified and the action "Drop and create" is selected, it works.
It seems to be a component bug.
Regards