You need an entry like this in your jboss.xml that gets jarred up with your
ejb code:
<resource-managers>
<resource-manager>
<res-jndi-name>java:/sequence</res-jndi-name>
<res-name>jdbc/sequence</res-name>
</resource-manager>
</resource-managers>
----- Original Message -----
From: "Dave King (WebEKG)" <[EMAIL PROTECTED]>
To: "Jboss-User@Lists. Sourceforge. Net" <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 3:55 PM
Subject: [JBoss-user] DataSource problems
> Greetings
>
> I've got jBoss running with MS SQL server for CMP no problem. (The
> documentation team should take a bow) It's set as my default pool.
>
> But when I try to get a DataSource from the pool things get weird.
>
> If I start jBoss up I get this message
>
> [Container factory]
> Deploying:file:/D:/JBoss-2.2.1/tmp/deploy/Default/demoejb.jar
> [Verifier] Verifying
> file:/D:/JBoss-2.2.1/tmp/deploy/Default/demoejb.jar/ejb1001.jar
> [Container factory] Deploying CustomerBean
> [Container factory] Deploying BenchMarkBean
> [Container factory] Deploying SequenceBean
> [JAWS] Table 'CustomerBean' already exists
> [Container factory] No resource manager found for jdbc/sequence
>
> and if I run my client I get (first two lines are mine)
> [SequenceBean] nextKey called
> [SequenceBean] looking for java:comp/env/jdbc/sequence
> [SequenceBean] javax.naming.NameNotFoundException: jdbc not bound
> (stack trace deleted: it was long)
>
> What's odd is if I re-deploy while the server is running
> I get
> [Container factory]
> Deploying:file:/D:/JBoss-2.2.1/tmp/deploy/Default/demoejb.jar/
> [Verifier] Verifying
> file:/D:/JBoss-2.2.1/tmp/deploy/Default/demoejb.jar/ejb1002.jar
> [Container factory] Deploying CustomerBean
> [Container factory] Deploying BenchMarkBean
> [Container factory] Deploying SequenceBean
> [JAWS] Table 'CustomerBean' already exists
> [Container factory] Deployed application:
> file:/D:/JBoss-2.2.1/tmp/deploy/Default/demoejb.jar/
> [J2EE Deployer Default] J2EE application:
> file:/D:/JBoss-2.2.1/deploy/demoejb.jar is deployed.
>
> and if I run the client, I get
> [SequenceBean] nextKey called
> [SequenceBean] looking for java:comp/env/jdbc/sequence
> [SequenceBean] org.opentools.minerva.jdbc.xa.XAPoolDataSource@5d391d
>
> so I'm getting a data source but it hangs when I call getConnection()
>
> Seems like two problems to me,
> 1) deploy on stat up doesn't seem to happen in the right order (just a
> guess)
> 2) I can't get a connection from a pool that works for CMP.
>
> I'm not sure what do about number 1, I do have some question about 2.
> in my bean I have
> <resource-ref>
> <description>the db for key
> sequences</description>
> <res-ref-name>jdbc/sequence</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
> as my resource
> and is standardjaws,xml I have
> <datasource>java:/SQLServerPool</datasource>
> <type-mapping>MS SQLSERVER</type-mapping>
>
> is there anything more I need to map jdbc/sequence to the SQLServerPool?
It
> feels like I'm missing a step maping jdbc/sequnce to my sql server pool
but
> I don't know where to do that.
>
> like I said, the pool works fine for CMP.
>
> To quote Neo, "Trinity, a little help?"
>
> -Peace
> Dave
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
