Cannot specify database schema

_AnonymousUser — Sat, 16 Nov 2024 14:24:13 GMT

Hi, all:
I try to run my first TOS from one table to another, but it threw exception: Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid object name.
I search the old log and found this: https://community.talend.com/t5/Design-and-Development/Cannot-specify-database-schema/td-p/66483
Can you tell me if TOS 2.3.2 has been fixed or not? and how to setup database schema? like dbo.table1.
Thanks
Vincent

Re: Cannot specify database schema

_AnonymousUser — Tue, 08 Apr 2008 18:25:40 GMT

Hi, all:
I come up with the work around:
1) Under Metadata\DB Connections\yourDB\Table schemas,
Define your table schema name: CUSTOMER].. (,,,,,,) VALUES (?,?,?,?,?,?,?)");
This is specific for MS SQL 2000, I didn't test MS SQL 2005 if the same.

topic Cannot specify database schema in Talend Studio

Cannot specify database schema

Re: Cannot specify database schema