How to connect to ORACLE, DB2, MYSQL databases from Jboss EAP / Jboss AS / Wildfly Using JDBC driver and DataSource.



How to connect to ORACLE, DB2, MYSQL databases from Jboss EAP / Jboss AS / Wildfly.

There are two ways.

  • Programmatically using JDBC Driver.
  • Using Datasource.
  • How to connect to ORACLE, DB2, MYSQL databases from Jboss EAP / Jboss AS / Wildfly. Using JDBC Driver


    Download the latest JDBC Jar if you are using oracle database download the driver from ORACLE


    Once you have downloaded the jar, add the downloaded jar to the development tool you are using ( eclipse, STS, Intellij ). If running from command prompt use -cp option set the jar class path.


    Once you are done with above steps, run the below code snippet. Below code snippet loads the jdbc driver and gets the connection


    DBUtility

    						 
    package com.database.util;
    
    import java.sql.DriverManager;
    import java.sql.Connection;
    import java.sql.SQLException;
    
    /**
     * 
     * @author Techoral.com
     * 
     *         This program demonstrates how to use Jdbc7 driver to connect to
     *         ORACLE Database
     *
     */
    
    public class DBUtility {
    
    	public static void main(String[] args) {
    
    		try {
    
    			Class.forName("oracle.jdbc.driver.OracleDriver");
    
    		} catch (ClassNotFoundException e) {
    
    			System.out.println("No JDBC driver loaded!!!, check the wheather JDBC jar is in the classpath");
    			e.printStackTrace();
    
    		}
    
    		// create connection
    		Connection connection = null;
    
    		try {
    			// If the DB servers is on the another host, replace the localhost with that
    			// hostname
    			// make sure database shcema, port number and credentials are correct.
    			connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:stdev", "dbusername",
    					"dbpassword");
    
    		} catch (SQLException e) {
    
    			System.out.println("Error while connecting to DB please check the exception stackstrace!");
    			e.printStackTrace();
    
    		}
    
    		if (connection != null) {
    			System.out.println("##########################################");
    			System.out.println("connection successull.");
    		} else {
    			System.out.println("connection failed");
    		}
    	}
    
    }
    
    						


    Run the Snippet in Command Prompt:

    						 
    C:\jdbc>javac DBUtility.java C:\jdbc>java -cp c:\jdbc\lib\ojdbc7.jar;c:\jdbc DBUtility
    ########################################## 
    connection successfull. 
    						


    How to connect to ORACLE, DB2, MYSQL databases from Jboss EAP / Jboss AS / Wildfly. Using Datasource


    Standard way to connect to ORACLE, DB2, MYSQL databases from Jboss EAP / Jboss AS / Wildfly is to use the Datasource. Datasource can be configured from the respective application server's admin console or from the server configuration files


    In case of JBOSS, datasource can be configured in standalone.xml / standalone-ha.xml / standalone-full-ha.xml files which are available in configuration directory

    /JBOSS-HOME-DIR/standalone/configuration

    Datasource configuration is same in all standalone.xml / standalone-ha.xml / standalone-full-ha.xml files

    Here is how Datasource configurationion in standalone-ha.xml looks like


    standalone-ha.xml


    Make sure that ojdbc7.jar module.xml are present under below path :

    \jboss-eap-home-directory\modules\system\layers\base\com\oracle\ojdbc7\main


    Make sure that module.xml points to ojdbc7.jar



    Once you are done with above steps, start the jboss server and run the below code snippet in command prompt or in elipse or sts.

    Below code snippetDataSourceUtility.java gets the connection from data source

    						 
    package com.database.util;
    
    import java.sql.Connection;
    import java.sql.SQLException;
    import javax.naming.InitialContext;
    import javax.naming.NamingException;
    import javax.sql.DataSource;
    
    public class DataSourceUtility {
    
    	public static void main(String[] args) {
    
    		Connection connection = null;
    		try {
    			InitialContext context = new InitialContext();
    			DataSource dataSource = (DataSource) context.lookup("java:/PRDS");
    			connection = dataSource.getConnection();
    		} catch (NamingException e) {
    			e.printStackTrace();
    		} catch (SQLException e) {
    			e.printStackTrace();
    		}
    
    		if (connection != null) {
    			System.out.println("##########################################");
    			System.out.println("connection successfull.");
    		} else {
    			System.out.println("connection failed");
    		}
    	}
    }
     
    							
    							


    Run the below snippet in Command Prompt:

    Command Prompt

    						 
    C:\datasource>javac DataSourceUtility.java
    
    C:\datasource>java -cp c:\datasource DataSourceUtility
    ###################################### 
    connection successfull. 


Search
Code Camp!
Register for a free code camp.
email: info@techoral.com

x