Hi,
I've spent two or three days trying to figure some of this stuff out, and
I'd be *really* happy if someone could help me.
Basically I'm trying to add a portlet in the style of DatabaseBrowserTest,
but connecting to an Oracle database of my own instead of to the default
HSQL coffees table. I don't mind if the user/turbine tables are kept in HSQL
or Oracle.
So here's what I've done succesfully:
* Gotten the distributed jetspeed binary (of 12/3/02) up: it works fine.
* Established a workable JDBC connection to the (remote) Oracle 732 database
using Oracle JDBC drivers and JDK1.4
But I'm having trouble connecting jetspeed-turbine to JDBC
* I tried configuring the Torque.properties like this:
--------------------
database.default=default
database.default.driver=oracle.jdbc.driver.OracleDriver
database.default.url=jdbc:oracle:thin:@oraclehost:1521:eza
database.default.username=<valid login>
database.default.password=<valid password>
database.adaptor=DBOracle
#database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
database.adaptor.DBOracle=org.apache.turbine.util.db.adapter.DBOracle
--------------------
...and I have DBOracle.class in turbine-2.2-b2-dev.jar, in my CLASSPATH...
...I also tried Oracle's own driver (commented out above)...
but in both cases I got this:
------------------
Horrible Exception: java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): No suitable driver
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTu
rbineUserPeer.java:130)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTur
bineUserPeer.java:109)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(
TurbineUserManagement.java:164)
at
org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMana
gement.java:98)
-------------------
* Then I tried turning my own demonstrably working jdbc test app into a
portlet. I deployed it with ant, but something about the (valid) Oracle
calls makes the entire display frame disappear.
* Then I tried deploying a standalone Turbine in it's own little sandbox to
see if I could get some good configuration data. I *was* able to get "ant
init" to connect and build the turbine tables, but the resulting test app
site kept asking me to login, never actually giving me any data.
SO!
I can't think of anything else to try.
Can someone point me in a productive direction? I'm biting my leg off with
frustration.
Thanks,
Bill
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
