You need to find some way of setting all the properties for the XADataSourceLoader/JDBCDataSourceLoader that are normally set by the jboss mbean configuration mechanism. I have no idea how to do this with Castor. One possibility would be to run sub-micro jboss consisting of only the jmx server + mbean configuration bits, and load as if you were in jboss.
If you aren't wedded to mysql you could try Firebird with the client-java driver which features built in connection pooling in one of its standalone configurations. Unfortunately you have to compile this driver yourself at the moment, I haven't had time to write up release notes and make a binary package. david jencks On 2002.03.15 23:06:25 -0500 Michael Mok wrote: > Has anyone got this to work? > > The error I get on startup is .. > > java.lang.IllegalStateException: Factory and Name must be set before pool > initialization! > at org.jboss.pool.ObjectPool.initialize(Unknown Source) > at org.jboss.pool.jdbc.JDBCPoolDataSource.initialize(Unknown > Source) > at org.jboss.pool.jdbc.JDBCPoolDataSource.getConnection(Unknown > Source) > at > org.exolab.castor.jdo.engine.DatabaseRegistry.createConnection(DatabaseRegis > try.java:399) > at > org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(Transactio > nContextImpl.java:203) > at > org.exolab.castor.persist.TransactionContext.query(TransactionContext.java:6 > 44) > at > org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:458) > at > org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:414) > at > com.consultech.fbb.util.DatabaseLoader.testATDW(DatabaseLoader.java:152) > at > com.consultech.fbb.util.DatabaseLoader.main(DatabaseLoader.java:236) > > Thanks in advance. > > Michael Mok > www.teatimej.com > > ----- Original Message ----- > From: "fabio rojas" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 02, 2001 5:48 AM > Subject: [castor-dev] jbosspool usage with Castor and MySQL > > > > I'm trying to use jbosspool (formerly minerva) as a standalone jdbc > connection pool provider for Castor using a MySQL database. > > As anyone else working with such a configuration? > > > > i modified my castor database.xml as follows: > > > > <database name="dbname" engine="generic" > > > <data-source class-name="org.jboss.pool.jdbc.JDBCPoolDataSource"> > > <params pool-name="DefaultDS" > > JDBCURL="jdbc:mysql://domain/dbname" > > JDBCUser="user" > > JDBCPassword="pass" > > blocking="true" > > min-size="3" > > max-size="10"/> > > </data-source> > > <mapping href="mapping.xml" /> > > </database> > > > > My OSL query just sits there, i don't get an exception. > > > > JDBCPoolDataSource (is for non-transactional pools). > > Looking for a jdbc pool system to use with castro in a servlet without > an > ejb or app-server container. > > > > > > > > > > ------------------------------------------------------------ > > iThugMail is a hardcore component of iThug.com > > . . . . . http://www.ithug.com/ . . . . . > > > > ----------------------------------------------------------- > > If you wish to unsubscribe from this mailing, send mail to > > [EMAIL PROTECTED] with a subject of: > > unsubscribe castor-dev > > > > > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > > > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
