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);
} <html> </html>
