By changing my mccatalog database back to being called "default" I have things working. My other database I am trying to reach is called "reporting", and it works. I ahve database.reporting.* properties all set.
So, I am not sure why I need at least one "default" database, but things seem to be working. I know lots of changes are soon to be forthcoming for multiple databases. My new problem is trying to read data from a view.. I am doing "SELECT top 10 * from promo_orders" and getting "promo_orders object does not exist" using .executeQuery(). I am using MSSQL2000. Has anyone else using SQL2K been able to select from views and execute stored procedures? Eric -----Original Message----- From: Pugh, Eric [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 2:47 PM To: 'Turbine Users List' Subject: Multiple Database Problem 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
