Hi Thomas, hi Greg,
thanks for your quick answer.
For future purpose I will have a look at
DdlUtils and on the torque-addons
both is very interesting...
but for now I quick fixed the TorqueDataDumpTask.java TableTool
like this:
public String get(String columnName)
{
try
{
return (rs.getString(columnName));
}
catch (Exception se)
{
log("Exception fetching value " + columnName + ": "
+ se.getMessage(), Project.MSG_ERR);
if (getDatabaseDriver().contains("Oracle")) {
log("A Oracle DB.", Project.MSG_INFO);
log("Try to fix this.", Project.MSG_INFO);
int columnNo;
ResultSetMetaData rsMetaData;
try {
columnNo = rs.findColumn(columnName);
rsMetaData = rs.getMetaData();
if
(rsMetaData.getColumnTypeName(columnNo).equalsIgnoreCase("timestamp")) {
log("The String representation of that timestamp :
" +
rs.getTimestamp(columnName).toString());
return rs.getTimestamp(columnName).toString();
} else {
log("Not able to fix column type : " +
rsMetaData.getColumnTypeName(columnNo));
}
} catch (SQLException ex) {
log("Exception fetching value " + columnName + ": "
+ ex.getMessage(), Project.MSG_ERR);
}
}
}
return null;
}
not very nice (specially getDatabaseDriver().contains("Oracle") in hope the
driver name will always contains Oracle ;-(
) but it works fine and fixes the issue with oracle timestamp.
But after that I run into other problems with booleanchar and date/datetime
because on the java side there is boolean in
oracle it gets to char represented with Y or N and the datadump doesn't know
anything about the former boolean and gives
back an character (without ") so inserting this into mysql will fail...
I quick fixed this in a similar way, but this is to dark to tell ;-)
In future I will use the tool you mentioned.
Thanks a lot
regards,
Markus
Greg Monroe schrieb:
> FYI - There is also an XML import/export runtime add-on
> for the 3.3 version that's in RC1 stage (very stable).
>
> This lets you import and export from your application
> rather than via ant/maven. See:
>
> http://torque-addons.sourceforge.net
>
>
>
>> -----Original Message-----
>> From: Thomas Fischer [mailto:[EMAIL PROTECTED]
>> Sent: Sunday, November 26, 2006 5:23 AM
>> To: Apache Torque Users List
>> Subject: Re: torque:datadump on oracle 10g
>>
>> 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]
>>
>>
>
> Duke CE Privacy Statement
> Please be advised that this e-mail and any files transmitted with it are
> confidential communication or may otherwise be privileged or confidential and
> are intended solely for the individual or entity to whom they are addressed.
> If you are not the intended recipient you may not rely on the contents of
> this email or any attachments, and we ask that you please not read, copy or
> retransmit this communication, but reply to the sender and destroy the email,
> its contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is strictly
> prohibited.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
/**
* 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
*/
signature.asc
Description: OpenPGP digital signature
