hi,
we recently changed the database to oracle from hypersonic SQL. this is the
procedure we followed (as instructed by David Taylor). paths are relative to the src
distribution directory:
1. From SQL PLUS, create a user schema, and log in as that user, and
run:
a. src/sql/external/turbine-oracle.sql
b. src/sql/external/populate-oracle.sql
the scripts are avaialable in the src distribution
2. Edited build/torque/build.properties
## torque.database=hypersonic
torque.database=oracle
4. Build jetspeed from the build dir
ant war
5. Copy the oracle JDBC driver into lib directory(avaialable at
http://jakarta.apache.org/turbine/tdk/tdk-howto.html)
6. Rename it from classes12.zip to classes12.jar
7. Edit webapp/WEB-INF/conf/Torque.properties
comment out the hypersonic entries
uncomment the Oracle entries, and point it at my database
Torque.database.default.adaptor=oracle
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
torque.dsfactory.default.connection.driver = oracle.jdbc.driver.OracleDriver
torque.dsfactory.default.connection.url = jdbc:oracle:thin:server:port:instance
torque.dsfactory.default.connection.user = turbine
torque.dsfactory.default.connection.password =turbine
8. Run the unit-test from the build directory
build unittest-security-user
all unit tests pass
9. run the server and access the application.
hope it solves ur problem
regards,
Ritesh Radhakrishnan
-----Original Message-----
From: Ionut Scutaru [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: Oracle database
Hi,
Has anybody succesfully changed the database to Oracle with jetspeed 1.4-b3
version ? I tried but it seems that I have the same problem as Bill Weir in
http://www.mail-archive.com/[email protected]/msg06880.html
Thank you very much,
Ionut Scutaru
Ionut Scutaru
Sun Certified Programmer (Java 2)
ITC Networks SRL, Bucharest, Romania
Email-1: [EMAIL PROTECTED]
Email-2: [EMAIL PROTECTED]
Mobile: +40 91 411050
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
