Tomcat 5 and oracle

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Struts - A MVC web framework

Tomcat - JSP/Servlet container

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

JSP - A mailing list about Java Server Pages specification and reference

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Oracle Connection Pooling in 3 2 2
•	Servlet : Session invalidate
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Tomcat and webapplication specific java library path
•	Running a Simple JMS Example
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	Cannot find message resources under key org apache struts action MESSAGE
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	url string for connecting jboss to oracle
•	Value attribute of <html:checkbox
•	javax servlet ServletException: BeanUtils populate
•	HTTP Status 404 The requested resource is not available
•	5 0 18: Windows XP Pro vs Windows 2000

Tomcat 5 and oracle

Tomcat 5 and oracle

2003-12-10 - By Jonathan Drnek

Back

Reply: 1 2 3 4 5 6 7 8 9 10 >>

I am having a problem setting up a data source in tomcat. I seem to
remember having this problem last time I played with it several moths
ago but I don't remember what I did to fix it.

I am running Tomcat 5.0.16 with JVM version 1.4.2_03-b02 on windows
2000.

I am trying to connect to an Oracle 8.1.7.1.0 database.

I have placed the ojdbc14.jar file in common\lib

The error I am getting is

javax.servlet.ServletException

Source code of javax.servlet.ServletException

: Cannot create JDBC driver of class ''
for connect URL 'null', cause: No suitable driver

I am using oracle.jdbc.driver.OracleDriver because that's what the docs
said, but I seem to recall that was not correct. I just can't find
anything that tells me what other driver I should be using.

My server.xml file has

.
.
.
<Resource name="jdbc/ordt" type="javax.sql.DataSource

"/>
.
.
.
</ResourceParams>
<ResourceParams name="jdbc/ordt">
<parameter>
<name>validationQuery</name>
<value>select * from dual</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@(protected):1521:ORDT</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>username</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
.
.
.

web.xml looks like

<?xml version="1.0" encoding="ISO-8859 (See http://ISO-8859.ora-code.com)-1"?>

<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>
<display-name>Metrology Lab</display-name>
<description>
First Source Metrology Lab
</description>

<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/ordt</res-ref-name>
<res-type>javax.sql.DataSource

</res-type>
<res-auth>Container</res-auth>
</resource-ref>

</web-app>

my code looks like

Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/ordt");
Connection conn = ds.getConnection();

Thanks for any help,

Jon Drnek

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas
-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@(protected)">

<style>

</style>

</head>

<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>

<div class=Section1>

I am having a problem setting up a data source in
tomcat.  I seem to remember having
this problem last time I played with it several moths ago but I don’t
remember what I did to fix it.<o:p></o:p>

<o:p> </o:p>

I am running Tomcat 5.0.16 with JVM version 1.4.2_03-b02 on windows
2000.<o:p></o:p>

<o:p> </o:p>

I am trying to connect to an Oracle 8.1.7.1.0 database.<o:p>
</o:p>

<o:p> </o:p>

I have placed the ojdbc14.jar file in common\lib<o:p></o:p>

<o:p> </o:p>

The error I am getting is<o:p></o:p>

<o:p> </o:p>

<pre>javax.servlet.ServletException

: Cannot create JDBC driver of class ''
for connect URL 'null', cause: No suitable driver<o:p></o:p></pre
>

<o:p> </o:p>

I am using oracle.jdbc.driver
.OracleDriver
because that’s what the docs said, but I seem to recall that was not
correct.  I just can’t find
anything that tells me what other driver I should be using.<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

My server.xml file has<o:p></o:p>

<o:p> </o:p>

.<o:p></o:p>

.<o:p></o:p>

.<o:p></o:p>

<Resource name="jdbc/ordt
"
type="javax.sql.DataSource

"/><o:p></o:p>


.<o:p></o:p>

.<o:p></o:p>

.<o:p></o:p>

</ResourceParams><o:p></o:p>


  <ResourceParams name="jdbc/ordt"><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>validationQuery</name
><o:p></o:p>

        <
value>select * from dual</value><o:p></o:p>

     
</parameter><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>url</name><o:p></o:p
>

       
<value>jdbc:oracle:thin:@(protected):1521:ORDT</value><o:p></o
:p>

     
</parameter><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>password</name><o:p></o:p>

        <
value>password</value><o:p></o:p>

     
</parameter><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>maxActive</name><o:p
></o:p>

        <
value>4</value><o:p></o:p>

     
</parameter><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>maxWait</name><o:p><
/o:p>

        <
value>5000</value><o:p></o:p>

     
</parameter><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>driverClassName</name
><o:p></o:p>

       
<value>oracle.jdbc.driver.OracleDriver
</value><o:p></o:p>

     
</parameter><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>username</name><o:p></o:p>

        <
value>username</value><o:p></o:p>

     
</parameter><o:p></o:p>

      <parameter><o:p></o:p>

        <
name>maxIdle</name><o:p><
/o:p>

        <
value>2</value><o:p></o:p>

     
</parameter><o:p></o:p>

</ResourceParams><o:p></o:p>


.<o:p></o:p>

.<o:p></o:p>

.<o:p></o:p>

<o:p> </o:p>

web.xml looks like
<o:p></o:p>

<o:p> </o:p>

<?xml
version="1.0" encoding="ISO-8859 (See http://ISO-8859.ora-code.com)-1"?><o:p></o:p>

<o:p> </o:p>

<!DOCTYPE
 web-app<o:p
></o:p>

   
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application
2.3//EN"<o:p></o:p>

   
"http://java.sun.com/dtd/web-app_2_3.dtd"><o:p></o:p>

<o:p> </o:p>

<web-app><o:p></o:p>

 
<display-name>Metrology Lab</display-name><o:p></o:p>


  <description><o:p></o:p>

    
First Source Metrology Lab<o:p></o:p>

 
</description><o:p></o:p>

<o:p> </o:p>

 <resource-ref><o:p></o:p>

 <description>Oracle Datasource
example</description><o:p></o:p>

 <res-ref-name>jdbc/ordt</
res-ref-name><o:p></o:p>

 <res-type>javax.sql.DataSource

</res-type><o:p></o:p>

 <res-auth>Container</res
-auth><o:p></o:p>

</resource-ref> <o:p></o:p>

 <o:p></o:p>

</web-app><o:p></o:p>

<o:p> </o:p>

my code looks like<o
:p></o:p>

<o:p> </o:p>

     
       Context
initContext = new InitialContext();<o:p></o:p>


     
       Context
envContext
  = (Context)initContext.lookup("java:/comp/env");<o:p></o:p>

     
       DataSource ds = (DataSource)envContext
.lookup("jdbc/ordt");<o:p></o:p>

     
       Connection
conn = ds
.getConnection();<o:p></o:p>

<o:p> </o:p>

Thanks for any help,<o:p></o:p>

<o:p> </o:p>

Jon Drnek<o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)