SreeHarsha Kotturu

Greenhorn
+ Follow
since Dec 04, 2011
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by 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?

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.
*/

}

}
11 years ago
please check the following progam i think it may help

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.
*/

}

}
11 years ago
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.