dcsimg
JTA enabled data source on WAS3.5 using Oracle as database
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   P_Manchanda
Posted On:   Tuesday, February 12, 2002 12:38 AM

Hi, I am using WAS 3.5. I have a datasource created on it which is JTA enabled. My problem is that when i insert records into a table, the changes are not reflected in the database. But when i issue select from my code, it shows the new records. Do i need to do something extra to commit the changes to the database. My database is Oracle 8.1.5. My JSP code is given below: <%@ page import="javax.sql.DataSource,java.sql.*,java.rmi.RemoteException,java.util.*,javax.rmi.*, javax.naming.*" %; Context initContext=null; try{ out.println("First 11"); Properties properties = new Properties(); properties.put(Context.PROVIDER_URL   More>>

Hi,


I am using WAS 3.5. I have a datasource created on it which is JTA enabled. My problem is that when i insert records into a table, the changes are not reflected in the database. But when i issue select from my code, it shows the new records.

Do i need to do something extra to commit the changes to the database. My database is Oracle 8.1.5.

My JSP code is given below:


<%@ page import="javax.sql.DataSource,java.sql.*,java.rmi.RemoteException,java.util.*,javax.rmi.*, javax.naming.*" %;

Context initContext=null;

try{

out.println("First 11");

Properties properties = new Properties();

properties.put(Context.PROVIDER_URL,"iiop://localhost:900");

properties.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.ejs.ns.jndi.CNInitialContextFactory");

initContext = new InitialContext(properties);

out.println("2");

}//End of try

catch(NamingException ne)

{

out.println("Exception inside "+ne.toString());

}//End of catch()

try{

out.println("3");

DataSource ds = (DataSource)
initContext.lookup ("jdbc/skDataSource");

out.println("4");

Connection cn = ds.getConnection("lms","lms");

out.println("5");

Statement smt= cn.createStatement();


int i=smt.executeUpdate("insert into test1 values('khare','1')");


out.println("succese i= "+i);

ResultSet rs= smt.executeQuery("select * from test1");

while(rs.next())

out.println("name ="+rs.getString(1));

if(smt!=null)

smt.close();

out.println("Close");

if(cn!=null)

cn.close();

out.println("conn Close");


}

catch(Exception e)

{

out.println("Exception inside"+e);

}

   <<Less
About | Sitemap | Contact