Try to add this jboss.xml to your jar.
<?xml version="1.0" encoding="Cp1252"?>
<jboss>
<secure>false</secure>
<container-configurations />
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>jdbc/efindsDS</res-name>
<res-jndi-name>efindsDS</res-jndi-name>
</resource-manager>
</resource-managers>
<enterprise-beans>
<entity>
<ejb-name>beanname</ejb-name>
<jndi-name>lookup-name</jndi-name>
<configuration-name></configuration-name>
<resource-ref>
<res-ref-name>jdbc/efindsDS</res-ref-name>
<resource-name>jdbc/efindsDS</resource-name>
</resource-ref>
</entity>
</enterprise-beans>
</jboss>
----- Original Message -----
From: "oliver2, andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 7:51 PM
Subject: [jBoss-User] hypersonic vs postgres, its keeps selecting the wrong
one
>
> 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]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
