Hi all,
I am trying to pull data from two different databases. The first thing I
did was change in my TR.properties file the database name from
database.default to database.mccatalog:
#database.default.driver=sun.jdbc.odbc.JdbcOdbcDriver
#database.default.url=jdbc:odbc:torque_mccatalog_trujillo
#database.default.username=SilverUserLogin
#database.default.password=******
database.mccatalog.driver=sun.jdbc.odbc.JdbcOdbcDriver
database.mccatalog.url=jdbc:odbc:torque_mccatalog_trujillo
database.mccatalog.username=SilverUserLogin
database.mccatalog.password=******
I changed my schema from:
<database name="default" package="com.museumcompany.db.mccatalog.om"
defaultIdMethod="null" baseClass="BaseObject" basePeer="BasePeer">
to
<database name="mccatalog" package="com.museumcompany.db.mccatalog.om"
defaultIdMethod="null" baseClass="BaseObject" basePeer="BasePeer">
I rebuilt, and recompiled my om objects, and restarted my server, and my OM
objects work. However, I was executing a custom SQL statement by doing:
SQL = "select c.category_id from categories_admin ca, categories c where
c.category_id=ca.category_id and ((ca.cj_category_id is null and c.store_id
in (1,4)) or (ca.aol_category is null and c.store_id in (1,4)) or
(ca.yahoo_category is null and c.store_id in (1,4))) and
c.parent_category_id is not null order by c.category_id";
Vector categoryIds = CategoryAdminPeer.executeQuery(SQL);
This used to work, but now that I renamed my database, I get output like
this:
errorConnection object is null!
java.sql.SQLException: Connection object is null!
at
org.apache.turbine.util.db.pool.DBConnection.getConnection(DBConnecti
on.java:362)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1281)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1251)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1202)
at
org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1167)
at
com.museumcompany.admin.modules.screens.ProductDataFeedMissingInfo.ge
tEntries(ProductDataFeedMissingInfo.java:121)
at
com.museumcompany.admin.modules.screens.ProductDataFeedMissingInfo.do
BuildTemplate(ProductDataFeedMissingInfo.java:86)
<snip>
Now, is this because I must have a database called database.default? I went
and changed the name back to database.default instead of database.mccatalog
and things worked again...
Eric
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
