tfischer 2005/04/21 22:31:04 Modified: xdocs oracle-howto.xml Log: Added documentation for the usage of the types DATE, TIME and TIMESTAMP See issue TRQS263 in Scarab Revision Changes Path 1.5 +56 -10 db-torque/xdocs/oracle-howto.xml Index: oracle-howto.xml =================================================================== RCS file: /home/cvs/db-torque/xdocs/oracle-howto.xml,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- oracle-howto.xml 19 Aug 2004 02:24:49 -0000 1.4 +++ oracle-howto.xml 22 Apr 2005 05:31:04 -0000 1.5 @@ -8,25 +8,71 @@ <body> -<section name="Introductory note"> + <section name="Oracle Howto" > + + <p> + Saravana Kannan is maintaining a patched version of Village that + supports Oracle LOBs: + <a href="https://sweb.uky.edu/~skkann2/village/index.html";>Village 2.0 + Patched for Oracle LOBs - For use with Torque 3.1</a> + </p> + + <p> + The data type TIME only has day accuracy for Oracle. This is due to the + underlying village library and the fact that oracle does not support + a SQL type TIME. + If you are using Oracle 9i and later, you can use the type TIMESTAMP + instead which gives you millisecond accuracy. + </p> + + <subsection name="Oracle versions"> + <p> + This version of Torque is optimized for Oracle 9i and later. + The following issues exist for older versions of Oracle: + </p> + + <p> + The data type TIMESTAMP is not supported up to and including + Oracle 8.1.7. Either use the types DATE or TIME instead of TIMESTAMP + or change the following line in the class + org.apache.torque.engine.platform.PlatformOracleImpl + in the generator source + </p> + + <source> +setSchemaDomainMapping(new Domain(SchemaType.TIMESTAMP, "TIMESTAMP"));</source> + + <p> + to + </p> + + <source> +setSchemaDomainMapping(new Domain(SchemaType.TIMESTAMP, "DATE"));</source> + + <p> + and rebuild the generator from source. + However, both possibilities will give you only day accuracy for the + data types DATE, TIME and TIMESTAMP + </p> + + </subsection> + + </section> + + +<section name="Introductory note for the following sections"> <p> -This HOWTO was written some time ago and was targeted at Oracle 8i and the -version of Torque that was coupled with the +The following part of this HOWTO was written some time ago and was +targeted at Oracle 8i and the version of Torque that was coupled with the <a href="http://jakarta.apache.org/turbine/";>Turbine</a> application framework. Contributions towards updating the information below can be submitted to the <a href="mailto:[email protected]";>Torque Dev mailing list</a>. </p> -<p> -Saravana Kannan is maintaining a patched version of Village that supports Oracle -LOBs: <a href="https://sweb.uky.edu/~skkann2/village/index.html";>Village 2.0 -Patched for Oracle LOBs - For use with Torque 3.1</a> -</p> - </section> -<section name="Oracle Howto"> +<section name="Oracle Howto for Turbine"> <p> This HOWTO aims to be a simple guide to make Turbine run with an existing
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
