Installing Oracle JDBC-Driver On Wildfly / JBoss

  1. Download the driver: ojdbc[VERSION].jar
  2. Create subfolders [WILDFLY_HOME]/modules/system/layers/base/com/oracle/main/
  3. Copy the downloaded ojdbc[VERSION].jar into the freshly created folder
  4. Create a file module.xml, in the same folder as above, with the contents:
<module xmlns="urn:jboss:module:1.1" name="com.oracle">
<resources>
<resource-root path="ojdbc[VERSION].jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>

5. In the configuration file standalone.xml add the entry: within the <drivers> tag.

<driver name="oracle" module="com.oracle">
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
</driver>

6. Add a datasource definition within the <datasources> tag (next to ExampleD)

<datasource jndi-name="java:/[NAME]" pool-name="OracleDS" enabled="true">
<connection-url>jdbc:oracle:thin:@[HOST_NAME]:1521:[SID]</connection-url>
<driver>oracle[has to match the driver name]</driver>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>5</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<user-name>[USERNAME]</user-name>
<password>[PASSWORD]</password>
</security>
</datasource>

--

--

--

intforce software is software service company and providing complete IT solution with fresh perspective. https://intforcesoftware.com/

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Sign jar files with your gradle build

Introduction to Amazon S3

An Overview and Comparison of Datastax Dependencies for Cassandra, Spark and Graph

QFD Workshops in Corona Times

On chain proposal

1/13 Google Workspace Roundup: Updates that Matter Most

Are You Lucky Enough To Have Great Mentorship?

Day 18: Making our player grab a ledge and snap to a good hand position

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Intforce Software

Intforce Software

intforce software is software service company and providing complete IT solution with fresh perspective. https://intforcesoftware.com/

More from Medium

JDK 18 and the UTF-8 as default charset

Haversine Forumula With Spring Boot

Managing Libraries without Maven

Design Patterns — Singleton Pattern