Hi, I'm very new to EJBs in general and am trying to replace some POJO classes used to access mySQL in a tomcat webapp. I've had a very interesting journey configuring all the relevant xml files and so forth but have hit against the following error message:
11-Apr-2006 00:50:25 org.exolab.castor.jdo.engine.DatabaseImpl finalize WARNING: An open database instance ([EMAIL PROTECTED]:Local_TX_Database) against database: Local_TX_Database has been encountered. This instance will be closed now to release system resources. Please consider changing your code as well to enforce that all database connections are closed after use.SQL executed, but not closed:null 11-Apr-2006 00:50:25 org.castor.jdo.engine.DatabaseRegistry loadDatabase I'm using mySQL 5, Tomcat 5 and the stable release of openEJB 1.0 I was curious as to whether the fact tomcat is still connecting to mySQL via a JDCB declaration in its server.xml could cause this error - although surely mySQL can handle simultaneous connections. I saw this was recorded as a bug (http://www.mail-archive.com/[email protected]/msg00595.html) and its apparently resolved so I'm really stuck as to what to try next. I can provide all my relevant source and conf files if it helps, in this instance I'm trying to retreive a pre-existing users details via their logon id (primary key integer in the db) using a findByUserID(int id) method - perhaps its just me doing something wrong with the remote, home, object classes. Thanks in advance for your help! -- Jason Woollard
