Unable to Invoke a JDBC service in Process

[Former Community Member]

In JBOSS i have configured 2 Mysql servers

1st server is where all the adobe related data is present

2nd server i the one from which I have to retrieve the data.

However when I try toto invoke the 2nd Mysql server I am unable to retrieve th e data.

Can some one help me in this regards

Regards

Amol

[MarcelBoucher]

Amol,

Have to defined a datasource in JBoss for this second MySQL database? You will need to do this.

Once the datasource is defined in JBoss, then in the properties of the JDBC service, you need to identify that datasource similar to this:

java:MyDataSourceName

Then it should work.

[Former Community Member]

Marcel,

thanks for answer i had done all the things you had told.But i was setting datasource properties as a variable and the variable was not gettting populated properly . after i debugged it propely it worked.

Regards

Amol