It may be that you're using the "ejb-location" name
rather than the "location" name of the data source.
I've used both the standard Orion datasource and
the pooled datasource with Oracle, and it has worked fine.
Good luck,
Doug
--
Doug Smith
http://www.eviciti.com
mailto:[EMAIL PROTECTED]
"Paul Wilcox"
<[EMAIL PROTECTED]> To: Orion-Interest
Sent by: <[EMAIL PROTECTED]>
owner-orion-interest@orion cc:
server.com Subject: configuring jdbc
with
oracle...
02/23/2001 12:49 PM
Please respond to
Orion-Interest
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]
