multiple database connection pools

[xpgao]

I want to have more than one database connection pools. For instance, one for a Oracle database, another for a UDB database. Is it doable with JBoss? If it is doable, how can it be done? I tried to just add an entry for an Oracle database in addition to the default one in jboss.jsml. It didnot work. Help would be really appreciated.

Many thanks.

Xiaoping

[oravecz]

That's the way you do it. We have several pools defined. nothing tricky.

[xpgao]

Many thanks for your reply.

I used the JBoss-Jetty(JBoss-2.4.4_Jetty-3.1.3-1). It hungs after
[INFO,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS.


Which one do you use?

Xiaoping

[pluellen]

Xiaoping,

If it's any consolation, I'm having the same difficulty.

I'm using Jboss-2.4.4 and am trying to see if (for instance) I can run both the Hypersonic datasource that comes with JBoss as the DefaultDS and DB2 SAMPLE as an additional datasource. I'm able to run them both individually no problem. I'm also able to run JBoss to access two separate DB2 databases at the same time - no problem.

However, when I have two different JdbcProviders defined in my jboss.jcml file, JBoss hangs at startup at the same place yours does - [INFO,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS.

I'll keep digging and let you know if I find anything.

Pete

[pluellen]

Xiaoping,

Take a look at David Jencks' response to my query topic "multiple JdbcProviders".

[davidjencks]

The other thing you have to be careful about is to make sure the XADataSourceLoader mbeans have different ObjectNames. That gets me periodically when I duplicate an mbean config and forget to make a new name.