Turbine/Jetspeed:
turbine-2.2-dev-20010912.jar
What is the proper format for adding other database adapter besides the
default?
I've tried this:
database.default.driver=org.hsql.jdbcDriver
database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
database.default.username=sa
database.default.password=
# These are the supported JDBC drivers and their associated Turbine
# adaptor. These properties are used by the DBFactory. You can add
# all the drivers you want here.
database.adaptor=DBHypersonicSQL
database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
database.adaptor=DBOracle
database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
database.DBOracle.url=jdbc:oracle:oci8:@mydatabase.world
database.DBOracle.username=username
database.DBOracle.password=password
I'm trying to use two db connections. hsql for user database, and oracle for
the main database. Logging in is no problem, so my default db is working
fine. If I use straight JDBC I can contect/retrieve from the database fine.
This works.
DBConnection m_connection = TurbineDB.getConnection(
"oracle.jdbc.driver.OracleDriver",
"jdbc:oracle:oci8:@mydatabase.world",
"user",
"password");
When I use OM classes or try doing a "TurbineDB.getConnection("DBOracle")" I
get the following error:
[Thu Sep 27 11:10:23 CDT 2001] -- DEBUG -- VelocityAction: building maximize
[Thu Sep 27 11:10:23 CDT 2001] -- WARN -- IDBroker is being used with db:
DBOracle
which does not support transactions. It is possible to
generate duplicate keys, if multiple JVM's are used or other
means are used to write to the database.
[Thu Sep 27 11:10:23 CDT 2001] -- INFO -- IDBroker thread was started.
[Thu Sep 27 11:10:23 CDT 2001] -- DEBUG -- SELECT ... <- removed for
clarity
[Thu Sep 27 11:10:23 CDT 2001] -- ERROR -- java.sql.SQLException: Connection
object is null!
[Thu Sep 27 11:10:23 CDT 2001] -- DEBUG -- template exists:
C:\AnyJ3.1\lib\tomcat\webapps\jetspeed\WEB-INF\templates\vm\portlets\html\ne
wwebnoms-hello.vm returning /html/newwebnoms-hello.vm
When I look at the objects through the debugger I can see the driver, url,
username, password all have correct values.
Help!!! What am I overlooking.
Marty
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
