> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, March 17, 2002 11:59 PM
> To: [EMAIL PROTECTED]
> Subject: cvs commit:
> jakarta-turbine-torque/src/java/org/apache/torque/util BasePeer.java
>
>
> dlr 02/03/17 23:59:03
>
> Modified: src/java/org/apache/torque/adapter DB.java
> DBOracle.java
> src/java/org/apache/torque/util BasePeer.java
> Log:
> Merged in patch by Bill Schneider <[EMAIL PROTECTED]> to improve
> support for Oracle:
>
> "Here goes -- this patch should take care of native limits
> on Oracle +
> date formatting in Oracle adapter. Why not kill two birds with one
> stone?"
>
> Bill's patch included handling of native limits for Sybase, which I
> commented out because it was not mentioned in his
> description, I have
> no Sybase installation to test against, and the MS SQL adapter
> subclasses from the Sybase adapter (making the change seem more
> risky). I also cleaned up the date handling portion of the patch to
> call a private method which I added to reduce code duplication.
>
<snip>
> + /**
> + * This method is used to format any date string using Oracle's
> + * <code>TO_DATE</code> built-in function.
> + */
> + private final String formatDate(String date)
> + {
> + char delim = getStringDelimiter();
> + return ("TO_DATE(" + delim + date + delim + ", " + delim +
> + "yyyy-mm-dd hh24:mi:ss" + delim + ')');
> + }
> }
>
are you guys sure standard JDBC escapes do not work for Oracle? If they do
why not use them?
fedor.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
