TCreateTable error

[Anonymous]

Hi,

I wanted to create a table with the script if the table doesn't exist. I didn't know how to give the script instead I used TCreateTable Component and edited the schema manually and gave "Drop table if exists and Create" for Table Action.

When I tried to run, the following error occurred:

 Exception in component tCreateTable_1 (create_table)
java.lang.RuntimeException: Creating table failed
at local_project.create_table_0_1.create_table.tCreateTable_1Process(create_table.java:399)
at local_project.create_table_0_1.create_table.runJobInTOS(create_table.java:832)
at local_project.create_table_0_1.create_table.main(create_table.java:681)
Caused by: java.lang.NullPointerException
at local_project.create_table_0_1.create_table.tCreateTable_1Process(create_table.java:385)
... 2 more

Am I missing out anything? Kindly advice on this further. Thanks in advance.

Thanks,

Sowmiya R

[David_Beaty]

Hi,

You might have a couple of things to check here:

1. The user you're connecting as has permission to create tables in the required DB schema
2. The schema within Talend for the Create Table is complete (all data types and field lengths are entered).

[Anonymous]

Hi @dsoulalioux ,

Yes, Instead of using the existing connection I manually entered the connection credentials and created the table. Kindly let me know how to create an index for the created table by using Script. I used TDBRow and its throwing null pointer exception error. 

Thanks,

Sowmiya R

[manodwhb]

@sowmi333 ,is that script is working form outside of Talend?

[Anonymous]

Hi @manodwhb ,

Yes it's working perfectly fine while executing in the front end tool.

Thanks,

Sowmiya R

[manodwhb]

@sowmi333 ,can you show me the job design and the component of tDBRow?

[manodwhb · Accepted solution]

@sowmi333 ,I believe you might have not provided schema name or some other parameter in tDBrow