Access Datasouce in java main method

[ravisha andar]

Hi,

I have a datasource configured in my server(WebSphere).

Is it possible to use that datasource in my main method and run it as a java application.

Thanks.

[Vijitha Kumara]

It is advised to use an enterprise bean to access the database from client applications (link).

[ravisha andar]

Hi

Thanks for the post.

But I do not want to run my application on the server. I want to run it as a java application ( in the main(String[] args) method

[Vijitha Kumara]

But I do not want to run my application on the server. I want to run it as a java application ( in the main(String[] args) method

You may need to access the data base directly with DriverManager JDBC API then.

[Jeanne Boyarsky]

The datasource runs on the server. You can't access it from a standalone program outside the container.

[SreeHarsha Kotturu]

Hi ,

I tried in the following way to get connection object of Oracle XE 10g through Data source configured in my Web sphere server .

If this helps try to use this.

package com.test;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Hashtable;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class DataSourceMainClass  {

	public static void main(String args[]) {

		Context ctx;
		try {

			Hashtable env = new Hashtable();
			env.put(Context.INITIAL_CONTEXT_FACTORY,
					"com.ibm.websphere.naming.WsnInitialContextFactory");
			// 2810
			// corbaloc:iiop:localhost:2810
			// CHECK the boot strap address  2809  or not in the server ports 
			// corbaloc:iiop:1.0@hp-pc:2809/NameService
			// hp-PCNode02
			// env.put(Context.PROVIDER_URL,
			// "corbaloc:iiop:1.0@hp-pc:2810/NameService");
			// env.put(Context.PROVIDER_URL, "corbaloc:iiop:1.0@hp-pc:2810");

			ctx = new InitialContext(env);

			System.out.println(" ctx::" + ctx);

			DataSource ds = (DataSource) ctx.lookup("jdbc/MyOracleXEDBJNDI");

			
			System.out.println(" dsss::;" + ds);

			Connection con = ((DataSource) ds)
					.getConnection("system", "system");
			System.out.println(" CON:" + con);

			if (con != null) {
				System.out.println(" Conn is established ");

				Statement stmt = con.createStatement();

				String sql = "select * from testdate";

				ResultSet rs = stmt.executeQuery(sql);

				while (rs.next()) {

					System.out.println(" result Set::" + rs.getInt("testid"));
				}

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		/*
		 * STEPS TO ACCESS THE ORACLE XE CONNECTION OBJECT USING DATA SOURCE
		 * 
		 * 1) LOGIN TO ADMIN CONSOLE 2) CREATE DATA SOURCE 3) CREATE DATA
		 * PROVIDER with a jnDi name (jdbc/MyOracleXEDBJNDI ) 4) PROVIDE THE USER ID & PASSWORD AS ALIAS NAMES
		 * 
		 * 5) TEST THE CONNECTION FROM ADMIN CONSOLE 6) WRITE JAVA PROGRAM AND
		 * USING INITIAL LOOK UP OF WEBSPHERE URL 7) ADD
		 * com.ibm.ws.webservice.thinclient.jar ( from base v61 runtimes) 8) add
		 * rsahelpers.jar to external jars( C:program files\
		 * IBM\SDP\runtimes\base_v61\runtimes\lib) 9) change the scopes of
		 * datasource and data provider to " ALL SCOPES " 10) restart the server
		 * as well as scopes are changed 11) add client jar for Oracle xe data
		 * source ojdbc14.jar 12) get connection object by passing the userid
		 * and passwordas args to getconenction method.
		 */

	}

}

[Piyush Mangal]

Jeanne Boyarsky wrote:The datasource runs on the server. You can't access it from a standalone program outside the container.

This is incorrect. DataSource can be bound to JNDI server through Application Server and can then be accessed from any java client through JNDI API.

[SreeHarsha Kotturu]

I tried it worked. If it helps try to use it. I had a similar question, is not able to hit a webservice from a standalone java program?