This is probably a Torque bug. The data import/export functionality for more exotic data types (I'm sad to say this als includes dates and timestamps) does not work well and often it does not work at all.

You might want to use dddlutils for that task. http://db.apache.org/ddlutils

    Thomas

On Sat, 25 Nov 2006, Markus Daniel wrote:

Hi all,
I try to dump data from an oracle database into a xml file.
For this purpose I try to use
Torque 3.2, Maven-Plugin, Goal: torque:datadump
Oracle JDBC Driver version - 9.0.2.0.0

corresponding row in the schema
<column name="aDate" required="true" type="TIMESTAMP"/>

trying to convert the oracle Timestamp into a String fails

[torque-data-dump] [ERROR] Exception fetching value aDate: Conversion to String 
failed

On the mysql the datadump works fine.

So I don't know if this is a bug or an oracle feature ;-)
or is there a missunderstanding from me ??

Any ideas?

Thanks a lot,
Markus


--
/**
* Markus Daniel
* Bachelor of Science in Computer Science
* Synyx GmbH & Co. KG
* Karlstr. 68
* 76137 Karlsruhe
* phone  +49(0)721 66 48 79 31
* fax    +49(0)721 66 48 877
* eMail  [EMAIL PROTECTED]
* www    http://www.synyx.de
* irc    http://irc.synyx.de
*/



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to