-
1. Re: ojdbc set up instructions
mayerw01 Mar 7, 2017 12:04 PM (in response to mn4891)This guide should also work for Oracle JDBC Driver / DataSource Setup · HAL Management Console
-
2. Re: ojdbc set up instructions
mn4891 Mar 7, 2017 2:38 PM (in response to mn4891)Wolfgang:
First, thanks for your help and speedy reply. I really appreciate it. I basically took the directions and substituted the word oracle for mysql and ojdbc6.jar for mysql-connector-java-5.1.35-bin.jar. I have a quick question, however. When it asks me to enter the length command in the cli, what should i substitute for MysqlXADataSource ?
Here is the command it asks to be entered:
[standalone@localhost:9990 /] /subsystem=datasources/jdbc-driver=mysql:add(\
driver-name=mysql,\
driver-module-name=com.mysql,\
driver-class-name=com.mysql.jdbc.Driver,\
driver-xa-datasource-class-name=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource\
)Again, thanks for your help.
-Mike Nastav
-
3. Re: ojdbc set up instructions
jbertram Mar 8, 2017 9:50 AM (in response to mn4891)When it asks me to enter the length command in the cli, what should i substitute for MysqlXADataSource ?
I believe that would be oracle.jdbc.xa.client.OracleXADataSource.
-
4. Re: ojdbc set up instructions
mayerw01 Mar 8, 2017 10:36 AM (in response to mn4891)You should take the entry from your driver jar (which is indeed oracle.jdbc.xa.client.OracleXADataSource for Oracle)
-
5. Re: ojdbc set up instructions
emag Mar 8, 2017 5:17 PM (in response to mn4891)It would be help for you though the following documents are for JBoss EAP 7. Regarding to Datasources settings, It should be available for WildFly as well.
Oracle DB Example is here.
-
6. Re: ojdbc set up instructions
mn4891 Mar 9, 2017 3:37 PM (in response to mn4891)After exploring the jar I found that for oracle ojdbc it is "oracle.jdbc.xa.client.OracleXADataSource".
Yoshimasa, Justin and wolfgang (cool name) THANKS A LOT for all your prompt and very clear help. Itis greatly appreciated!
Mike N