Try following code in your .jsp file:
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("jdbc/Oracle");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM dual");
while( rs.next() ){
out.println( rs.getString(1) + "<br>" );
}
conn.close();
with best wishes,
Taavi
> Thanks everybody for helping me with this problems. It works now!
> However, I
> could not have the jsp example code work!
- Re: Using the mailing list Johan Fredriksson
- Is it orion compatible with FORM METHOD = POST ???... waheed_rahuman
- Re: Is it orion compatible with FORM METHOD = P... Tim Endres
- Can anyone campare JRUN with Orion1.3.8 waheed_rahuman
- Re: Can anyone campare JRUN with Orion1... Hani Suleiman
- Thanks alot and one waheed_rahuman
- problem running oracle with orion:... Roland Dong
- RE: problem running oracle wit... elephantwalker
- Re: problem running oracle wit... denis despinoy
- RE: problem running oracle wit... Roland Dong
- RE: problem running oracle wit... Taavi Tiirik
- RE: problem running oracle wit... Allen Fogleson
- Re: problem running oracle wit... Justen Stepka
- Re:Is it orion compatible with FORM METHOD = PO... jmorgenstein
- Re: Using the mailing list Raul Vidal
