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 "CASCADE" 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:[email protected]";>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:[email protected]";>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:[email protected]";>Thomas Fischer</a></td>
</tr>
<tr>
- <td>Firebird</td>
- <td>org.firebirdsql.jdbc.FBDriver</td>
- <td>idMethod="native" does not work</td>
- <td><a href="mailto:[email protected]";>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:[email protected]";>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:[email protected]";>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: [email protected]
For additional commands, e-mail: [email protected]
