File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JTA Enabled data source on WAS 3.5 with Oracle. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JTA Enabled data source on WAS 3.5 with Oracle." Watch "JTA Enabled data source on WAS 3.5 with Oracle." New topic
Author

JTA Enabled data source on WAS 3.5 with Oracle.

Prince Manchanda
Ranch Hand

Joined: Jun 25, 2001
Posts: 47
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>


Thanks and Regards
P Manchanda
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 565
Your insert statement should auto-commit if you haven't told it otherwise.
However I haven't used JTA - perhaps somebody else who has done can help.

It's not clear what you mean - does the inserted record never ever turn up again?
Your last catch block looks a bit weird too. It should be e.toString() or e.getMessage()
Adam


I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JTA Enabled data source on WAS 3.5 with Oracle.
 
Similar Threads
Connection not working (Oracle and Sun one web server)
Problem using JNDI to a Oracle database
EJB 3 Persistence in a remote Stateless Session Beans
not redirecting to main page
search EJB JNDI Name