You are not logged in.
I have a simple job for truncating a mysql table before loading with bulk function.
I use tMysqlRow with the query "truncate table mytable".
No error shows up but by table is not truncated.
I tried to force commit using "Commit every"=1.
Even tried "truncate table mytable;commit;" but no chance.
Using the command line tool mysql, same user, host, database, the truncate statment works perfectly.
Any idea ?
Maybe add a check box on the bulk loading component "truncate before loading" ?
I assume that you have a 2.0.0 version.
This is a bug on Java tDBRow components which have been reported and corrected a few weeks ago.
Yopu can either upgrade (current version is 2.0.2) or follow instructions in [Forum, topic 604] How to execute a "ALTER TABLE" ? (it's for tOracleRow but it's the same problem)
Truncate option will be added to Java DB Components in version 2.1 ([Bugtracker, bug 1102, fixed] [Java DB] Clear Table Option)
It works fine now, thanks
Another question: is there a way to force the creation of the table before loading ?
I mean, if the table does not exist, automate the creation ?
Last edited by Eric Blanchet (2007-05-29 15:11:15)