db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tfisc...@apache.org
Subject svn commit: r1213047 - in /db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific: database-howtos/hsqldb-howto.xml database-howtos/oracle-howto.xml database-howtos/sybase-howto.xml supported-databases.xml
Date Sun, 11 Dec 2011 19:39:39 GMT
Author: tfischer
Date: Sun Dec 11 19:39:38 2011
New Revision: 1213047

URL: http://svn.apache.org/viewvc?rev=1213047&view=rev
Log:
- TORQUE-174: Remove adapters which are not supported any more
- Remove outdated information

Removed:
    db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/sybase-howto.xml
Modified:
    db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/hsqldb-howto.xml
    db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/oracle-howto.xml
    db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/supported-databases.xml

Modified: db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/hsqldb-howto.xml
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/hsqldb-howto.xml?rev=1213047&r1=1213046&r2=1213047&view=diff
==============================================================================
--- db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/hsqldb-howto.xml
(original)
+++ db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/hsqldb-howto.xml
Sun Dec 11 19:39:38 2011
@@ -47,10 +47,7 @@ drop table $table.Name if exists;</sourc
 drop table $table.Name if exists CASCADE;</source>
 
     <p>
-      This does not work with HSQLDB 1.7.x any more. For supporting drop table
-      statements in HSQLDB 1.7.x, remove the &quot;CASCADE&quot; from the file 
-      sql/base/hypersonic/drop.vm in your templates jar and repackage 
-      the jar file.
+      This does not work with HSQLDB 1.7.x any more.
     </p>
 
   </section>

Modified: db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/oracle-howto.xml
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/oracle-howto.xml?rev=1213047&r1=1213046&r2=1213047&view=diff
==============================================================================
--- db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/oracle-howto.xml
(original)
+++ db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/database-howtos/oracle-howto.xml
Sun Dec 11 19:39:38 2011
@@ -29,21 +29,6 @@
   <section name="Oracle Howto" >
 
     <p>
-      Oracle has long used a custom way to access and write LOB objects,
-      and did not support standard LOB usage. However, this has changed
-      with the 10.2.0.1 version of the oracle jdbc driver.
-      <br/>
-      For older drivers, 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 and later</a>.
-      <br/>
-      For the 10.2.0.1 drivers and later, the standard village library can be
-      used. However, village 2.0. has an issue concerning null values in
-      lob columns, so empty lobs still can not be read.
-    </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.
@@ -78,236 +63,10 @@ criteria.add(c1.or(c2));
 
       <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
+        Oracle 8.1.7. Use the types DATE or TIME instead of TIMESTAMP.
       </p>
 
     </subsection>
-
   </section>
-
-
-<section name="Introductory note for the following sections">
-
-<p>
-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://turbine.apache.org/">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>
-
-</section>
-
-<section name="Oracle Howto for Turbine">
-
-<p>
-This HOWTO aims to be a simple guide to make Turbine run with an existing
-Oracle 8i database. The process of making Turbine run is not covered in
-this guide, proceed to the
-<a href="http://turbine.apache.org/">Turbine</a> site for
-help on how to install Turbine.
-</p>
-
-</section>
-
-<section name="Creating the Database">
-
-<p>
-If you do not have a database already set up, you will need to create one so
-we can create the necessary tables for Turbine. The steps below are simple
-steps to take to create a new database. If you already have a database ready for
-use, you can skip this part.
-</p>
-
-<p>
-1. Open the Oracle Database Configuration assistant
-</p>
-
-<p>
-2. Create a database with the Global Database Name 'turbine.project' and
-SID 'turbine'
-</p>
-  <ul>
-  <li>Global Database Name : turbine.project</li>
-  <li>SID : turbine</li>
-  <li>SYSTEM account password : manager</li>
-  <li>SYS account password : change_on_install</li>
-  </ul>
-
-<p>
-3. Wait for the database to be created.
-</p>
-
-<p>
-4. Good idea to stop the services from running if the Oracle database
-isn't being used as they are memory hungry for a development desktop machine.
-Check if the Oracle TNS Listener and the correct service are running when
-trying to connect.
-</p>
-
-</section>
-
-<section name="Populating the Database from the .sql Scripts">
-
-<p>
-5. Start SQL *PLUS and login to the database using the username and
-password for the database. You may want to use the same username and password you will
-use for Turbine, or you will need to create synonyms for the tables and grant the
-necessary privilieges (SELECT, UPDATE, INSERT, etc), so Turbine can access the
-tables directly without using "user"."table_name".
-</p>
-
-<p>
-6. Run the Oracle specific scripts.  For the cvs version of Turbine,
-these can be found in turbine/src/sql .  In SQL*PLUS type :
-</p>
-<p>
-<font face="courier">@path/to/oracle-turbine.sql</font>
-</p>
-
-<p>
-7.The oracle-turbine.sql script creates an oracle sequence
-for each turbine table.  To use these sequences for primary
-key generation, the oracle-turbine-security.sql script should
-be modified.  For example, the following command from the script :
-</p>
-<p>
-<font face="courier">INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE,
FIRST_NAME, LAST_NAME)
-VALUES (0, 'turbine', 'turbine', 'turbine', 'turbine');</font>
-</p>
-<p>
-would be changed to something like :
-</p>
-<p>
-<font face="courier">INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE,
FIRST_NAME, LAST_NAME)
-VALUES (TURBINE_USER_SEQ.nextval, 'turbine', 'turbine', 'turbine', 'turbine');</font>
-</p>
-<p>
-When your changes, if any, are made to the script, run it from SQL*PLUS :
-</p>
-<p>
-<font face="courier">@path/to/oracle-turbine-security.sql</font>
-</p>
-
-<p>
-8.If you would rather use Turbine's id-broker to generate
-primary keys, run the following scripts to create and populate the
-id-broker table :
-</p>
-<p>
-<font face="courier">@path/to/oracle-id-table-schema.sql</font>
-</p>
-<p>
-<font face="courier">@path/to/oracle-turbine-id-table-init.sql</font>
-</p>
-
-</section>
-
-<section name="Setting up Turbine to Connect to Oracle">
-
-<p>
-9. Download and install the Oracle 8i JDBC type 4 Thin driver for JDK
-1.2.x from the Oracle website. Add the classes12_01.zip file to the
-classpath of the servlet engine. In JServ add to the jserv.properties file
-the line:
-</p>
-   <ul>
-   <p><font face="courier">
-   wrapper.classpath=/path/to/classes12_01.zip
-   </font></p>
-   </ul>
-
-
-<p>
-10. Ensure that the OracleoracleTNSListener service and the
-OracleServiceTURBINE service is running before using the driver.
-</p>
-
-
-<p>
-11.  Follow the Turbine installation document
-for Turbine with the following differences. To link up the Oracle
-database and driver to Turbine, edit the TurbineResources.properties file;
-</p>
-
-<ul>
-  <li>Uncomment the lines:</li>
-
-   <ul>
-    database.default.driver=oracle.jdbc.driver.OracleDriver<br/>
-    database.default.url=jdbc:oracle:thin:@localhost:1521:ORCL
-   </ul>
-
-    <p>
-        and ensure no other database.default.driver or database.default.url
-        is left uncommented.</p>
-
-    <li>Edit the database.default.url to the oracle thin driver
-        format drivername:@servername:portnumber:SID</li>
-
-    <ul>
-        database.default.driver=oracle.jdbc.driver.OracleDriver<br/>
-        database.default.url=jdbc:oracle:thin:@localhost:1521:turbine
-    </ul>
-
-
-    <p>
-    The  servername is the Oracle server name and the port is the port
-    that oracle uses. It is important not to confuse the Oracle servername
-    and port with the Apache server name and port. Refer to the Oracle 8i
-    documentation if there are any conflicts in this regard.
-    Take care to use the correct SID for the database you have set up.
-    </p>
-
-
-    <li>Edit the database.default.username and
-        database.default.password to match the username and password of your
-        database.</li>
-
-    <p>
-    You may need to check if a Turbine database adaptor has been setup for Oracle.
-    Look for the following lines in TurbineResources.properties, and add them in
-    case you do not find:
-    </p>
-
-    <ul>
-        database.adaptor=DBOracle<br/>
-        database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
-    </ul>
-
- </ul>
-
-</section>
-
-<section name="Connecting to the Oracle Database">
-
-<p>
-12. Point your web browser at http://servername:port/servlets/Turbine
-(the URL may vary depending on your servlet engine) and login as username
-turbine, password turbine. After logging in you should see the congratulatory
-"Welcome To The Default Screen".
-</p>
-
-</section>
-
 </body>
 </document>

Modified: db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/supported-databases.xml
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/supported-databases.xml?rev=1213047&r1=1213046&r2=1213047&view=diff
==============================================================================
--- db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/supported-databases.xml
(original)
+++ db/torque/torque4/trunk/torque-site/src/site/xdoc/version-specific/supported-databases.xml
Sun Dec 11 19:39:38 2011
@@ -39,72 +39,18 @@
           <th>Tester</th>
         </tr>
         <tr>
-          <td>Axion</td>
-          <td>org.axiondb.jdbc.AxionDriver</td>
-          <td>Alpha, Runtime only</td>
-          <td></td>
-        </tr>
-        <tr>
-          <td>Cloudscape</td>
-          <td>COM.cloudscape.core.JDBCDriver</td>
-          <td></td>
-          <td></td>
-        </tr>
-        <tr>
-          <td>DB2</td>
-          <td>COM.ibm.db2.jdbc.{app|net}.DB2Driver</td>
-          <td></td>
-          <td></td>
-        </tr>
-        <tr>
-          <td>DB2/AS400</td>
-          <td>com.ibm.as400.access.AS400JDBCDriver</td>
-          <td>Possible case-insensitivity issues</td>
-          <td><a href="mailto:Sweaver@rippe.com">Scott Weaver</a></td>
-        </tr>
-        <tr>
           <td>Derby</td>
           <td>org.apache.derby.jdbc.EmbeddedDriver</td>
           <td>Only the embedded driver works.</td>
           <td><a href="mailto:fischer@seitenbau.de">Thomas Fischer</a></td>
         </tr>
         <tr>
-          <td>Firebird</td>
-          <td>org.firebirdsql.jdbc.FBDriver</td>
-          <td>idMethod=&quot;native&quot; does not work</td>
-          <td><a href="mailto:fischer@seitenbau.de">Thomas Fischer</a></td>
-        </tr>
-        <tr>
-          <td>Hypersonic</td>
+          <td>Hsqldb</td>
           <td>org.hsql.jdbcDriver</td>
           <td></td>
           <td></td>
         </tr>
         <tr>
-          <td>Informix</td>
-          <td>com.informix.jdbc.IfxDriver</td>
-          <td></td>
-          <td></td>
-        </tr>
-        <tr>
-          <td>InstantDB</td>
-          <td>org.enhydra.instantdb.jdbc.idbDriver</td>
-          <td></td>
-          <td></td>
-        </tr>
-        <tr>
-          <td>Interbase</td>
-          <td>interbase.interclient.Driver</td>
-          <td></td>
-          <td></td>
-        </tr>
-        <tr>
-          <td>MS Access</td>
-          <td>sun.jdbc.odbc.JdbcOdbcDriver</td>
-          <td></td>
-          <td></td>
-        </tr>
-        <tr>
           <td><a href="database-howtos/mssql-howto.html">MS SQL</a></td>
           <td>com.microsoft.jdbc.sqlserver.SQLServerDriver</td>
           <td></td>
@@ -125,7 +71,7 @@
         <tr>
           <td><a href="database-howtos/oracle-howto.html">Oracle</a></td>
           <td>oracle.jdbc.driver.OracleDriver</td>
-          <td>Issues with LOBs</td>
+          <td>No known problems</td>
           <td></td>
         </tr>
         <tr>
@@ -134,27 +80,6 @@
           <td>No known problems</td>
           <td><a href="mailto:seade@backstagetech.com.au">Scott Eade</a></td>
         </tr>
-        <tr>
-          <td>SapDB</td>
-          <td>com.sap.dbtech.jdbc.DriverSapDB</td>
-          <td></td>
-          <td></td>
-        </tr>
-        <tr>
-          <td><a href="database-howtos/sybase-howto.html">Sybase</a></td>
-          <td>com.sybase.jdbc2.jdbc.SybDriver</td>
-          <td>
-          JDBCToXMLSchema task will not generate the schema properly.
-          All other tests pass.
-          </td>
-          <td><a href="mailto:brekke@apache.org">Jeffrey D. Brekke</a></td>
-        </tr>
-        <tr>
-          <td>Weblogic</td>
-          <td>weblogic.jdbc.pool.Driver</td>
-          <td></td>
-          <td></td>
-        </tr>
       </table>
 
       <p>



---------------------------------------------------------------------
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