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
