I have been using multiple DBs with Turbine for a while,
with no problems. Now they stopped working... This is
the relevant piece of my TR.props:
#### Default database
database.default.driver=org.gjt.mm.mysql.Driver
database.default.url=jdbc:mysql://localhost:3306/turbine
database.default.username=turbine
database.default.password=turbine
#### Oracle test database
database.oracle.driver=oracle.jdbc.driver.OracleDriver
database.oracle.url=jdbc:oracle:thin:@pdcmidas:1521:oracledb
database.oracle.username=gonzo
database.oracle.password=gonzo
I define a Criteria like this:
Criteria criteria = new Criteria(dbName_);
and dbName_ is "oracle" (I'm sure, I print it right before
defining the criteria, as you can see in the log). When I
do a doSelect() with that criteria, the log shows:
[Thu Feb 01 11:28:40 GMT-04:00 2001] -- INFO -- CartolaTx::execute(oracle)
[Thu Feb 01 11:28:40 GMT-04:00 2001] -- ERROR --
Exception: java.sql.SQLException: General error: Table
'turbine.cartola' doesn't exist
Stack Trace follows:
java.sql.SQLException: General error: Table 'turbine.cartola'
doesn't exist
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
at
com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:112)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1180)
To me, that looks like it is trying to use mySQL, even though the
Criteria specified a different database.
If I comment out the "default" DB in TR.props, and just leave the
"oracle" one, I get:
Exception: java.lang.NullPointerException
Stack Trace follows:
java.lang.NullPointerException
at
com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:111)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1180)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1142)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1092)
at org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:1021)
at com.bice.peer.BaseCartolaPeer.doSelect(BaseCartolaPeer.java:129)
at com.bice.peer.BaseCartolaPeer.doSelect(BaseCartolaPeer.java:102)
Again, this was working yesterday, before I did a cvs update of
Turbine that brought in a lot of changes. Anyone has any idea
what may be happening?
--
Gonzalo A. Diethelm
[EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
