One Star

Cannot specify database schema

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: http://www.talendforge.org/forum/viewtopic.php?id=1681
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
1 REPLY
One Star

Re: Cannot specify database schema

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.