Has anyone done this successfully? CAn you give me a play by play on what you did to get it to work? I just keep getting hypersonic and I've guessed at several ways to configure it and none of them work. I'm using postgres in a BMP Entity Bean. Thanks, Andy -----Original Message----- From: Tobias Frech To: JBoss-User Sent: 2/28/01 9:38 AM Subject: Re: [jBoss-User] minerva using wrong JDBC driver Hi Gerald! Did you tell JAWS to use the PostgreSQL datasource ? You have 3 alternatives: a) include a jaws.xml file in the META-INF dir of your bean package with the right values. b) adjust conf/default/standardjaws.xml c) edit jboss.jcml: make the DefaultDS entry look like your PostgreSQL entry but keep the "DefaultDS" name. Also take care of using the correct mapping ! Might this be the thing you were missing ? Cheers, Tobias Gerald Turner wrote: > > >From a stack trace it looks like minerva is delegating executeQuery to a > Hypersonic PreparedStatement rather than a PostgreSQL PreparedStatement. Is > this a bug? Am I configuring jboss wrong? > > -- > > For the last couple weeks I've been struggling with jboss and tomcat, > at the moment everything is working well except that the DataSource is > failing. > > I'm using a CVS checkout of jboss and contrib/tomcat. The only modifications > I've made the dist configuration are: with jboss.conf, added the > ClassPathExtension for Tomcat MLET, and with the jbosss.jcml, uncommented the > EmbededTomcatService mbean, added org.postgresql.Driver to the Drivers > attribute of the JdbcProviders mbean, and finally added the following mbean: > > <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=efindsDS"> > <attribute name="PoolName">efindsDS</attribute> > <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourc eImpl</attribute> > <attribute name="URL">jdbc:postgresql://localhost/efinds</attribute> > <attribute name="JDBCUser">efinds</attribute> > <attribute name="Password">efinds</attribute> > <attribute name="LoggingEnabled">true</attribute> > </mbean> > > On startup, everything looks happy: > > ... > [JDBC provider] Initializing > [JDBC provider] Loaded JDBC-driver:org.hsql.jdbcDriver > [JDBC provider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver > [JDBC provider] Loaded JDBC-driver:org.postgresql.Driver > [JDBC provider] Initialized > ... > [efindsDS] Starting > [efindsDS] XA Connection pool efindsDS bound to java:/efindsDS > [efindsDS] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl created new Connection (org.postgresql.jdbc1.Connection) with XAResource org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl. > [efindsDS] No transaction right now. > [efindsDS] Pool efindsDS [0/0/Unlimited] gave out new object: org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@3bf1ca > [efindsDS] Pool efindsDS [0/1/Unlimited] returned object org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@3bf1ca to the pool. > [efindsDS] Started > ... > > However, upon executing the first SQL statement (ejbFindByPrimaryKey) in an > entity bean which uses this DataSource, the following exception occurs: > > [CustomerEJB] TRANSACTION ROLLBACK EXCEPTION:null; nested exception is: > javax.ejb.EJBException > [CustomerEJB] java.sql.SQLException: Table not found: CUSTOMER in statement [select id from customer where id = 18] > [CustomerEJB] at org.hsql.Trace.getError(Trace.java:124) > [CustomerEJB] at org.hsql.Result.<init>(Result.java:70) > [CustomerEJB] at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644) > [CustomerEJB] at org.hsql.jdbcConnection.execute(jdbcConnection.java:540) > [CustomerEJB] at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499) > [CustomerEJB] at org.hsql.jdbcStatement.executeQuery(jdbcStatement.java:37) > [CustomerEJB] at org.hsql.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.java:9 9) > [CustomerEJB] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(Prepared StatementInPool.java:71) > [CustomerEJB] at com.respond2.experiment.j2eedemo.model.CustomerBean.ejbFindByPrimaryKey( CustomerBean.java:813) > [CustomerEJB] at java.lang.reflect.Method.invoke(Native Method) > [CustomerEJB] at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersiste nceManager.java:458) > [CustomerEJB] at org.jboss.ejb.plugins.BMPPersistenceManager.findEntity(BMPPersistenceMan ager.java:211) > [CustomerEJB] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:419) > [CustomerEJB] at java.lang.reflect.Method.invoke(Native Method) > [CustomerEJB] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityCont ainer.java:639) > [CustomerEJB] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(Entity SynchronizationInterceptor.java:160) > [CustomerEJB] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanc eInterceptor.java:87) > [CustomerEJB] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java: 135) > [CustomerEJB] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor CMT.java:263) > [CustomerEJB] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java: 86) > [CustomerEJB] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor .java:119) > [CustomerEJB] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) > [CustomerEJB] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316) > [CustomerEJB] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPCo ntainerInvoker.java:358) > [CustomerEJB] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPCo ntainerInvoker.java:412) > [CustomerEJB] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:19 8) > [CustomerEJB] at $Proxy2.findByPrimaryKey(Unknown Source) > [CustomerEJB] at com.respond2.experiment.j2eedemo.controller.CustomerServlet.doGet(Custom erServlet.java:84) > [CustomerEJB] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > [CustomerEJB] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > [CustomerEJB] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) > [CustomerEJB] at org.apache.tomcat.core.Handler.service(Handler.java:286) > [CustomerEJB] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) > [CustomerEJB] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.jav a:797) > [CustomerEJB] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) > [CustomerEJB] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(H ttpConnectionHandler.java:210) > [CustomerEJB] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416 ) > [CustomerEJB] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:49 8) > [CustomerEJB] at java.lang.Thread.run(Thread.java:484) > [EmbeddedTomcat] javax.transaction.TransactionRolledbackException: null; nested exception is: > javax.ejb.EJBException > [EmbeddedTomcat] javax.ejb.EJBException > ... > > -- > -------------------------------------------------------------- > To subscribe: [EMAIL PROTECTED] > To unsubscribe: [EMAIL PROTECTED] > List Help?: [EMAIL PROTECTED] -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] List Help?: [EMAIL PROTECTED] -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] List Help?: [EMAIL PROTECTED] -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED]
