configuring jdbc with oracle...

Fri, 23 Feb 2001 12:49:12 -0800

I am having great problems trying to connect to oracle thru JDBC on orion. Here is my data-sources file:

//////////////////////////////////////////////////

<data-source

class="com.evermind.sql.DriverManagerDataSource"

name="Oracle"

location="jdbc/DefaultCoreDS"

xa-location="jdbc/xa/DefaultXADS"

ejb-location="jdbc/DefaultDS"

connection-driver="oracle.jdbc.driver.OracleDriver"

username="webluser"

password="webluser"

url="jdbc:oracle:thin:@ultra:1521:dual"

inactivity-timeout="30"

/>

/////////////////////////////////////////////////

and here is the JSP page I am using to test...

 

///////////////////////////////////////////////

<%@ page import="java.sql.*, javax.sql.DataSource, javax.naming.InitialContext" %>

<%
       InitialContext ctx = new InitialContext();
       DataSource ds = (DataSource) ctx.lookup("jdbc/DefaultDS");
       Connection con = null;
       Statement stmt = null;
       con = ds.getConnection();
  
       try
       { 
             stmt = con.createStatement();
             out.println("statement");
             ResultSet rs = stmt.executeQuery("SELECT * FROM dual");
             out.println("query");
       }
       catch(Exception e)
       {
             out.println("BOOM!!!!!!!");
       }
       finally
       {
             con.close();
       }
%>

////////////////////////////////////////////////////////////

the output from my page is:  BOOM!!!!!!!

The line stmt = con.createStatement(); is blowing up, and i cant figure out why. It seems to make the connection alright, but can see why createStatement() is expolding?

Any ideas?

Paul Wilcox

[EMAIL PROTECTED]

 

Reply via email to