Installation Oracle database driver 12c ojdbc7.jar as module

[schlumpf]

Hi all,

I trying to install the oracle database driver ojdbc7.jar as module via jboss-cli.sh.

But it doesn't work for me.

The command returned no error and there was new folder in the module-path togeher with module.xml-file,

But I cannot select the driver for create a new datasource with the administration console.

Sorry for the following questions, but I am I newbie in wildfly 8:

- Does anybody know which dependencies the ojdbc7.jar needs?

- Can I inform myself about the installed modules with the CLI or administration console? I am searching for a list, where I can see which module ist installed.

Thanks a lot!

schlumpf

[wdfink]

Could you show your commands and what the result is in your modules directory?

normally for a db driver you need to have javax.api and javax.transaction.api as dependency

[schlumpf]

Hi Wolf-Dieter,

I have used the command 'module add --name=oracle.jdbc --resources=/tmp/ojdbc7.jar --dependencies=javax.api,javax.transaction.api'  resulting in the folder structure (directories) $JBOSS_MODULEPATH/oralce/jdbc/main with the ojdbc7.jar and module.xml file in it.

Then I have started the administration console and wanted to create a new JDBC datasource, but there isn't any Oracle driver to select.

[wdfink]

Not I got it.

You 'only' add the jar as a module to the server directory, nothing more.

Now you need to add the driver and datasource via CLI or console

i.e. try:

jboss-cli.sh

>/subsystem=datasources/jdbc-driver=Oracle:add(driver-name="Oracle", driver-module-name="oracle.jdbc", driver-xa-datasource-class-name="oracle.jdbc.xa.client.OracleXADataSource")

>/subsystem=datasources/data-source=Oracle:add(jndi-name=java:/Oracle, connection-url= jdbc:oracle:thin:@x.x.x.x:1521:orcl, driver-name=Oracle, user-name=X, password=X)

I've looked into the http management but did not found a possiblility to add the driver, maybe it's intentional as you can't add the module from here.

So ATM you need to add the datasources-drivers-driver by CLI

[schlumpf]

Hi Wolf-Dieter,

thank you for you help, it works fine.

[wdfink]

Hello Knut,

great to know that it's working.

Could you mark the related answer and the thread as answered to help other find the solution quicker?