Hi
I am trying to connec to Oracle databese from Webdynpro application.
As given in many of the forums replys I created a datasource in Visual administrator.
and using following code in my WdDoInit in View Controller :
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/XYZ");
Connection con = ds.getConnection();
String query = "select * from VEHICLE";
Statement stmt = con.createStatement();
try {
ResultSet rs = stmt.executeQuery(query);
wdContext.currentNodeElement().setOne(rs.getString("NAME"));
try {
}
} finally
{rs.close();}
} finally {
stmt.close();
}
}catch( Exception e) {
}
Application compiles fine, but seems to be in debugger mode, Control doesnt go to next line after :
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/XYZ");
it simply comes out.
Can someone help me with this? IS it something like WD application cant find Data somehting like it. Can I trace from webdynpro whether connection is established with oracle db or not?
Pls help
Deeps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.