Friday, May 2, 2014

DATASOURSE FROM WEBLOGIC -- Connection pool

//CPM Example with //Weblogic server

import javax.sql.*;
import javax.naming.*;
import java.sql.*;
import java.util.*;

class CPMTest
{
public static void main(String as[])
{
PreparedStatement ps=null;
Connection con=null;
try{
Properties p=new Properties();
p.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
p.put(Context.PROVIDER_URL,"t3://localhost:7001");
Context ctx=new InitialContext(p);
Object o=ctx.lookup("---- JNDI NAME---");
DataSource ds=(DataSource)o;
con=ds.getConnection();
ps=con.prepareStatement("select sname,email from student");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
System.out.println(rs.getString(1)+""+rs.getString(2));
}
}catch(Exception e)
{
System.out.println(e);
}
finally
{
try{
if(ps!=null)
ps.close();
if(con!=null)
con.close();
}catch(Exception e)
{
}
}
}
}
/*
1)run setEnv.cmd
2)set classpath=%classpath%;.;
3)compile
4)run
error:
javax.naming.CommunicationException [Root exception is java.net.ConnectException
: t3://localhost:7001: Destination unreachable; nested exception is:
java.net.ConnectException: Connection refused: connect; No available rou
ter to destination]
5)start weblogic server
6)run
Error:
javax.naming.NameNotFoundException: Unable to resolve 'jdbc.B10ConnectionPool' R
esolved jdbc; remaining name 'B10ConnectionPool'
*/

No comments: