On 3/22/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I hope that I am missing something obvious -- if someone could point me in
the right direction, I would be very appreciative.
I have XML data that I am trying to convert into SQL DML for Oracle (my XML to DDL works fine).
My XML data includes Timestamps (and/or Dates), and I believe that in order to insert this into
Oracle, I am going to have to call the Oracle functions "to_timestamp" (or
"to_date"). (If I am mistaken, please let me know.)
My data looks like (summarized),
<pubtitle id="1" pubtitle="Some Title" price="32.12" pubdate="1998-01-02
00:00:00.0" />
My schema looks like (summarized),
<table name="pubtitle">
<column name="id" primaryKey="true" required="true" type="VARCHAR" size="10"
autoIncrement="false"/>
<column name="pubtitle" primaryKey="false" required="true" type="VARCHAR" size="80"
autoIncrement="false"/>
<column name="price" primaryKey="false" required="false" type="DOUBLE" size="53"
autoIncrement="false"/>
<column name="pubdate" primaryKey="false" required="true" type="TIMESTAMP" size="23,3"
autoIncrement="false"/>
</table>
(Note the timestamps.)
And unfortunately, my SQL results in:
insert into pubtitle values( '1', 'Guide to Backpacking', '32.12',
'1/2/1998' );
But I think it needs to be something like this (either using to_date, or
to_timestamp):
insert into pubtitle values( '1', 'Guide to Backpacking', '32.12',
TO_DATE('1/2/1998', 'MM/DD/YYYY'));
Are there Ant tasks or properties (or even Java API) that can be used to
create SQL suitable for insertion into Oracle, including dates / timestamps?
Note that I just want the SQL, I can't use Java to read/populate the database
directly.
That is odd. DdlUtils should generate an ISO-formatted timestamp
literal for which no TO_DATE function call is necessary. Could you
post the build file or code snippet where you use DdlUtils ?
Tom
