Is it possible to connect two different database onto a sing

[rajesh_cbe2000]

Hi everybody,

Please answer for the following question?

Is it possible to connect two different database onto a single JBoss Application Server deployment? Actually I am using JBoss 3.2.3 database is Oracle. I've deployed one application on JBoss. That application uses one database user. What I want to do is within the same application another database also I want to connect for another customer. Is it possible?

Thanks in advance,

Rajesh.S

[jaikiran]

You can have as many datasources as you want in a single instance of a server. See these on how to configure datasources:

http://www.jboss.org/community/wiki/DSdotXML

http://www.jboss.org/community/wiki/ConfigDataSources

[rajesh_cbe2000]

Thank u for the reply jaikiran. Actually I'm using IBatis framework for connecting with Oracle. I've mentioned database url, username, pwd in a properties file. From that only connectivity is happening. How to configure datasources as u mentioned in ibatis framework?

[jaikiran]

How to configure datasources as u mentioned in ibatis framework?

http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=12582997. Ignore the top half in that article and read for the sqlmap.xml configurations.

[rajesh_cbe2000]

Thank u jaikiran. Actually I'm using Jdk1.5, JBoss 3.2.7 with ibatis framework. I want to use 2 or more database connections in my application. For ex:
for Client1 -> db1 database/user
for Client2 -> db2 database/user
like that.
Please help me.
Thank u very much.
Regards,
Rajesh.S

[rajesh_cbe2000]

I'm using Jdk1.5, JBoss 3.2.7 with ibatis framework. Database is Oracle. I want to use 2 or more database connections in my application. For ex:
for Client1 -> db1 database/user
for Client2 -> db2 database/user
like that.
Please help me.
Thanx in advance.
Regards,
Rajesh.S

[ganeshneelekani]

Hi Kiran/Rajesh,

i have a one .war file which consist of all sql queries,in drools environment

Whenever i deploy .war file in jboss server all datas present in database is populating.

If i do any small changes i need to redeploy again and again,This is becoming series issue.

So can you suggest me any idea so that no need to redeploy .war files again and again.

Regards

Ganesh N

Team Agile