On Thu, 1 Mar 2001, oliver2, andy wrote:
>
> Has anyone done this successfully? CAn you give me a play by play on
> what
> you
> did to get it to work?
Tobias gave you several options... the first one is probably the
best. You need to specify the data source to use in jaws.xml in you ejb
jar file. I don't remember the exact structure of this file - go RTFM.
Tom
> -----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]
>
>
--
"If you mess with something for long enough it will break." - Schmidt
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
