db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tfisc...@apache.org
Subject cvs commit: db-torque/xdocs oracle-howto.xml
Date Fri, 22 Apr 2005 05:31:04 GMT
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:torque-dev@db.apache.org">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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message