driver not found ?

2005-03-14 Thread Philippe Couas
Hi, 
 
I search to connect with Sun Odbc driver to  my Datasource configured in
tomcat 
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver
What is wrong ?
 
Thanks
Philippe
 
 
server.xml
  ResourceParams name=jdbc/Agi  
  parameter  
   namedriverClassName/name
   valuesun.jdbc.odbc.JdbcOdbc/value   
  /parameter 
   
  parameter  
   nameurl/name
   valuejdbc:odbc://localhost/AGI/value
  /parameter 


Re: driver not found ?

2005-03-14 Thread Parsons Technical Services
Philippe,
Watch the list and please answer questions asked as the information needed 
to help you has not been included in your email.

Please tell us the version of Tomcat.
What Operating System are you using?
Please post the server.xml, web.xml and context.xml or appname.xml
This may make a big email but too much information is better that too 
little.

Thank You,
Doug
- Original Message - 
From: Philippe Couas [EMAIL PROTECTED]
To: tomcat-user@jakarta.apache.org
Sent: Monday, March 14, 2005 9:13 AM
Subject: driver not found ?


Hi,
I search to connect with Sun Odbc driver to  my Datasource configured in
tomcat
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver
What is wrong ?
Thanks
Philippe
server.xml
 ResourceParams name=jdbc/Agi
 parameter
  namedriverClassName/name
  valuesun.jdbc.odbc.JdbcOdbc/value
 /parameter
 parameter
  nameurl/name
  valuejdbc:odbc://localhost/AGI/value
 /parameter

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


driver not found ?

2005-03-13 Thread Philippe Couas
Hi, 
 
I search to connect with Sun Odbc driver to  my Datasource configured in
tomcat 
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver
What is wrong ?
 
Thanks
Philippe
 
 
server.xml
  ResourceParams name=jdbc/Agi  
  parameter  
   namedriverClassName/name
   valuesun.jdbc.odbc.JdbcOdbc/value   
  /parameter 
   
  parameter  
   nameurl/name
   valuejdbc:odbc://localhost/AGI/value
  /parameter 


Re: driver not found ?

2005-03-13 Thread Parsons Technical Services
Tomcat version?
Post complete relevant sections helps.
Doug
- Original Message - 
From: Philippe Couas [EMAIL PROTECTED]
To: tomcat-user@jakarta.apache.org
Sent: Sunday, March 13, 2005 11:16 AM
Subject: driver not found ?


Hi, 

I search to connect with Sun Odbc driver to  my Datasource configured in
tomcat 
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver
What is wrong ?

Thanks
Philippe
server.xml
 ResourceParams name=jdbc/Agi  
 parameter  
  namedriverClassName/name
  valuesun.jdbc.odbc.JdbcOdbc/value   
 /parameter 
  
 parameter  
  nameurl/name
  valuejdbc:odbc://localhost/AGI/value
 /parameter 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Oracle jdbc driver not found

2002-10-18 Thread Eddie Liang
 

 

Hello,

  I have a problem for creating a simple database connection with JSP,
tomcat 4.0.4, jdk1.4. I set the oracle jdbc driver ( class111,zip,
class12.zip, ojdbc14.jar) in the classpath.  Tomcat still complaint the
driver is not found. Here is the error that I got. Does anybody know I need
to configure something in the tomcat?

 

Thank you

 

org.apache.jasper.JasperException: Unable to compile class for JSPNote:
sun.tools.javac.Main has been deprecated.
 
 
An error occurred between lines: 35 and 58 in the jsp file:
/JSP/com/imedge/admin/test.jsp
 
Generated servlet error:
C:\Tomcat
4.0\work\Standalone\localhost\_\JSP\com\imedge\admin\test$jsp.java:101:
Class oracle.jdbc.driver.OracleDriver not found.
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
   ^
1 error, 1 warning
 
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:176)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:188)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 
Here is my source code:
 

!-- Developed and Documented by Krishna Veeramachaneni --

html

 

head

titleIMEDGE Content Management Services Administrator/title

link href=/JSP/com/imedge/admin/style.css rel=stylesheet
type=text/css 

script language=JavaScript
src=/JSP/com/imedge/admin/validation.js/script

script language=JavaScript
src=/JSP/com/imedge/admin/CascadeMenu.js/script

script language = JavaScript

 

!-- hide me

 

 

// show me --

 

/script

/head

% 

   

  /* Java code to retrieve family name and description if any */

  

 

  

%

body  link=#99 vlink=#00 alink=#00  

ID=Bdy leftmargin=0 rightmargin=0 topmargin=0 bgcolor=beige 

 

% include file=/JSP/com/imedge/admin/Banner.jsp %

% include file=/JSP/com/imedge/admin/FamilyMenu.jsp%

 

% page import=javax.servlet.* %

% page import=java.sql.* %

 

 

% 

   

  /* Java code to retrieve family name and description if any */

 

// Load the Oracle JDBC driver

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

 

Connection conn =

  DriverManager.getConnection (jdbc:oracle:thin:sunlab2:1521:chcity,

   xyzz, xyzxc);

 

// Create a Statement

Statement stmt = conn.createStatement ();

 

// Select the ENAME column from the EMP table

ResultSet rset = stmt.executeQuery (select table_name from
user_tables);

 

// Iterate through the result and print the employee names

while (rset.next ())

  System.out.println (rset.getString (1));

  

 

  

%



 

/body

 

/html

 

 

Eddie Liang




RE: Oracle jdbc driver not found

2002-10-18 Thread Wagoner, Mark
Tomcat does not use the classpath and, since you are using JDK 1.4, you only
need ojdbc14.jar (the zip files are for older versions of Java).  Put the
jar file in the WEB-INF/lib directory of your web app.  Tomcat will
automatically load it from there.

-Original Message-
From: Eddie Liang [mailto:eliang;edge.com]
Sent: Friday, October 18, 2002 11:58 AM
To: 'Tomcat Users List'
Subject: Oracle jdbc driver not found


 

 

Hello,

  I have a problem for creating a simple database connection with JSP,
tomcat 4.0.4, jdk1.4. I set the oracle jdbc driver ( class111,zip,
class12.zip, ojdbc14.jar) in the classpath.  Tomcat still complaint the
driver is not found. Here is the error that I got. Does anybody know I need
to configure something in the tomcat?

 

Thank you

 

org.apache.jasper.JasperException: Unable to compile class for JSPNote:
sun.tools.javac.Main has been deprecated.
 
 
An error occurred between lines: 35 and 58 in the jsp file:
/JSP/com/imedge/admin/test.jsp
 
Generated servlet error:
C:\Tomcat
4.0\work\Standalone\localhost\_\JSP\com\imedge\admin\test$jsp.java:101:
Class oracle.jdbc.driver.OracleDriver not found.
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
   ^
1 error, 1 warning
 
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:176)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:188)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 
Here is my source code:
 

!-- Developed and Documented by Krishna Veeramachaneni --

html

 

head

titleIMEDGE Content Management Services Administrator/title

link href=/JSP/com/imedge/admin/style.css rel=stylesheet
type=text/css 

script language=JavaScript
src=/JSP/com/imedge/admin/validation.js/script

script language=JavaScript
src=/JSP/com/imedge/admin/CascadeMenu.js/script

script language = JavaScript

 

!-- hide me

 

 

// show me --

 

/script

/head

% 

   

  /* Java code to retrieve family name and description if any */

  

 

  

%

body  link=#99 vlink=#00 alink=#00  

ID=Bdy leftmargin=0 rightmargin=0 topmargin=0 bgcolor=beige 

 

% include file=/JSP/com/imedge/admin/Banner.jsp %

% include file=/JSP/com/imedge/admin/FamilyMenu.jsp%

 

% page import=javax.servlet.* %

% page import=java.sql.* %

 

 

% 

   

  /* Java code to retrieve family name and description if any */

 

// Load the Oracle JDBC driver

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

 

Connection conn =

  DriverManager.getConnection (jdbc:oracle:thin:sunlab2:1521:chcity,

   xyzz, xyzxc);

 

// Create a Statement

Statement stmt = conn.createStatement ();

 

// Select the ENAME column from the EMP table

ResultSet rset = stmt.executeQuery (select table_name from
user_tables);

 

// Iterate through the result and print the employee names

while (rset.next ())

  System.out.println (rset.getString (1));

  

 

  

%



 

/body

 

/html

 

 

Eddie Liang


--
To unsubscribe, e-mail:   mailto:tomcat-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org




RE: Oracle jdbc driver not found

2002-10-18 Thread Eddie Liang
Mark,
Thanks for the quick reply. When you said WEB-INF/lib directory, is
that mean %catalina_home%\webapps\ROOT\WEB-INF\lib? If there is not lib
subdirectory under %catalina_home%\webapps\ROOT\WEB-INF\, could I create
one and put ojdbc14.jar in it?

Thank you

Eddie Liang
Database Architect
Phone: 630-810-9669 x253


-Original Message-
From: Wagoner, Mark [mailto:MWagoner;wild-flavors.com] 
Sent: Friday, October 18, 2002 11:03 AM
To: 'Tomcat Users List'
Subject: RE: Oracle jdbc driver not found

Tomcat does not use the classpath and, since you are using JDK 1.4, you only
need ojdbc14.jar (the zip files are for older versions of Java).  Put the
jar file in the WEB-INF/lib directory of your web app.  Tomcat will
automatically load it from there.

-Original Message-
From: Eddie Liang [mailto:eliang;edge.com]
Sent: Friday, October 18, 2002 11:58 AM
To: 'Tomcat Users List'
Subject: Oracle jdbc driver not found


 

 

Hello,

  I have a problem for creating a simple database connection with JSP,
tomcat 4.0.4, jdk1.4. I set the oracle jdbc driver ( class111,zip,
class12.zip, ojdbc14.jar) in the classpath.  Tomcat still complaint the
driver is not found. Here is the error that I got. Does anybody know I need
to configure something in the tomcat?

 

Thank you

 

org.apache.jasper.JasperException: Unable to compile class for JSPNote:
sun.tools.javac.Main has been deprecated.
 
 
An error occurred between lines: 35 and 58 in the jsp file:
/JSP/com/imedge/admin/test.jsp
 
Generated servlet error:
C:\Tomcat
4.0\work\Standalone\localhost\_\JSP\com\imedge\admin\test$jsp.java:101:
Class oracle.jdbc.driver.OracleDriver not found.
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
   ^
1 error, 1 warning
 
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:176)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:188)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 
Here is my source code:
 

!-- Developed and Documented by Krishna Veeramachaneni --

html

 

head

titleIMEDGE Content Management Services Administrator/title

link href=/JSP/com/imedge/admin/style.css rel=stylesheet
type=text/css 

script language=JavaScript
src=/JSP/com/imedge/admin/validation.js/script

script language=JavaScript
src=/JSP/com/imedge/admin/CascadeMenu.js/script

script language = JavaScript

 

!-- hide me

 

 

// show me --

 

/script

/head

% 

   

  /* Java code to retrieve family name and description if any */

  

 

  

%

body  link=#99 vlink=#00 alink=#00  

ID=Bdy leftmargin=0 rightmargin=0 topmargin=0 bgcolor=beige 

 

% include file=/JSP/com/imedge/admin/Banner.jsp %

% include file=/JSP/com/imedge/admin/FamilyMenu.jsp%

 

% page import=javax.servlet.* %

% page import=java.sql.* %

 

 

% 

   

  /* Java code to retrieve family name and description if any */

 

// Load the Oracle JDBC driver

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

 

Connection conn =

  DriverManager.getConnection (jdbc:oracle:thin:sunlab2:1521:chcity,

   xyzz, xyzxc);

 

// Create a Statement

Statement stmt = conn.createStatement ();

 

// Select the ENAME column from the EMP table

ResultSet rset = stmt.executeQuery (select table_name from
user_tables);

 

// Iterate through the result and print the employee names

while (rset.next ())

  System.out.println (rset.getString (1));

  

 

  

%



 

/body

 

/html

 

 

Eddie Liang


--
To unsubscribe, e-mail:
mailto:tomcat-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail:
mailto:tomcat-user-help;jakarta.apache.org

--
To unsubscribe, e-mail:   mailto:tomcat-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org




RE: Oracle jdbc driver not found

2002-10-18 Thread Wagoner, Mark
If you are using the ROOT context for your app then, yes.  If you don't know
what I mean by ROOT context then you probably are so the answer is still
yes.  ;o)

There should be a classes and a lib directory there by default.  If not, go
ahead and create one.

-Original Message-
From: Eddie Liang [mailto:eliang;edge.com]
Sent: Friday, October 18, 2002 12:13 PM
To: 'Tomcat Users List'
Subject: RE: Oracle jdbc driver not found


Mark,
Thanks for the quick reply. When you said WEB-INF/lib directory, is
that mean %catalina_home%\webapps\ROOT\WEB-INF\lib? If there is not lib
subdirectory under %catalina_home%\webapps\ROOT\WEB-INF\, could I create
one and put ojdbc14.jar in it?

Thank you

Eddie Liang
Database Architect
Phone: 630-810-9669 x253


-Original Message-
From: Wagoner, Mark [mailto:MWagoner;wild-flavors.com] 
Sent: Friday, October 18, 2002 11:03 AM
To: 'Tomcat Users List'
Subject: RE: Oracle jdbc driver not found

Tomcat does not use the classpath and, since you are using JDK 1.4, you only
need ojdbc14.jar (the zip files are for older versions of Java).  Put the
jar file in the WEB-INF/lib directory of your web app.  Tomcat will
automatically load it from there.

-Original Message-
From: Eddie Liang [mailto:eliang;edge.com]
Sent: Friday, October 18, 2002 11:58 AM
To: 'Tomcat Users List'
Subject: Oracle jdbc driver not found


 

 

Hello,

  I have a problem for creating a simple database connection with JSP,
tomcat 4.0.4, jdk1.4. I set the oracle jdbc driver ( class111,zip,
class12.zip, ojdbc14.jar) in the classpath.  Tomcat still complaint the
driver is not found. Here is the error that I got. Does anybody know I need
to configure something in the tomcat?

 

Thank you

 

org.apache.jasper.JasperException: Unable to compile class for JSPNote:
sun.tools.javac.Main has been deprecated.
 
 
An error occurred between lines: 35 and 58 in the jsp file:
/JSP/com/imedge/admin/test.jsp
 
Generated servlet error:
C:\Tomcat
4.0\work\Standalone\localhost\_\JSP\com\imedge\admin\test$jsp.java:101:
Class oracle.jdbc.driver.OracleDriver not found.
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
   ^
1 error, 1 warning
 
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:176)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:188)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 
Here is my source code:
 

!-- Developed and Documented by Krishna Veeramachaneni --

html

 

head

titleIMEDGE Content Management Services Administrator/title

link href=/JSP/com/imedge/admin/style.css rel=stylesheet
type=text/css 

script language=JavaScript
src=/JSP/com/imedge/admin/validation.js/script

script language=JavaScript
src=/JSP/com/imedge/admin/CascadeMenu.js/script

script language = JavaScript

 

!-- hide me

 

 

// show me --

 

/script

/head

% 

   

  /* Java code to retrieve family name and description if any */

  

 

  

%

body  link=#99 vlink=#00 alink=#00  

ID=Bdy leftmargin=0 rightmargin=0 topmargin=0 bgcolor=beige 

 

% include file=/JSP/com/imedge/admin/Banner.jsp %

% include file=/JSP/com/imedge/admin/FamilyMenu.jsp%

 

% page import=javax.servlet.* %

% page import=java.sql.* %

 

 

% 

   

  /* Java code to retrieve family name and description if any */

 

// Load the Oracle JDBC driver

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

 

Connection conn =

  DriverManager.getConnection (jdbc:oracle:thin:sunlab2:1521:chcity,

   xyzz, xyzxc);

 

// Create a Statement

Statement stmt = conn.createStatement ();

 

// Select the ENAME column from the EMP table

ResultSet rset = stmt.executeQuery (select table_name from
user_tables);

 

// Iterate through the result and print the employee names

while (rset.next ())

  System.out.println (rset.getString (1));

  

 

  

%



 

/body

 

/html

 

 

Eddie Liang


--
To unsubscribe, e-mail:
mailto:tomcat-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail:
mailto:tomcat-user-help;jakarta.apache.org

--
To unsubscribe, e-mail:
mailto:tomcat-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail:
mailto:tomcat-user-help;jakarta.apache.org

--
To unsubscribe, e-mail:   mailto:tomcat-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org




RE: Oracle jdbc driver not found

2002-10-18 Thread Eddie Liang
Mark,
 It works!   

Thank you very much

Eddie Liang
Database Architect
Phone: 630-810-9669 x253


-Original Message-
From: Wagoner, Mark [mailto:MWagoner;wild-flavors.com] 
Sent: Friday, October 18, 2002 11:22 AM
To: 'Tomcat Users List'
Subject: RE: Oracle jdbc driver not found

If you are using the ROOT context for your app then, yes.  If you don't know
what I mean by ROOT context then you probably are so the answer is still
yes.  ;o)

There should be a classes and a lib directory there by default.  If not, go
ahead and create one.

-Original Message-
From: Eddie Liang [mailto:eliang;edge.com]
Sent: Friday, October 18, 2002 12:13 PM
To: 'Tomcat Users List'
Subject: RE: Oracle jdbc driver not found


Mark,
Thanks for the quick reply. When you said WEB-INF/lib directory, is
that mean %catalina_home%\webapps\ROOT\WEB-INF\lib? If there is not lib
subdirectory under %catalina_home%\webapps\ROOT\WEB-INF\, could I create
one and put ojdbc14.jar in it?

Thank you

Eddie Liang
Database Architect
Phone: 630-810-9669 x253


-Original Message-
From: Wagoner, Mark [mailto:MWagoner;wild-flavors.com] 
Sent: Friday, October 18, 2002 11:03 AM
To: 'Tomcat Users List'
Subject: RE: Oracle jdbc driver not found

Tomcat does not use the classpath and, since you are using JDK 1.4, you only
need ojdbc14.jar (the zip files are for older versions of Java).  Put the
jar file in the WEB-INF/lib directory of your web app.  Tomcat will
automatically load it from there.

-Original Message-
From: Eddie Liang [mailto:eliang;edge.com]
Sent: Friday, October 18, 2002 11:58 AM
To: 'Tomcat Users List'
Subject: Oracle jdbc driver not found


 

 

Hello,

  I have a problem for creating a simple database connection with JSP,
tomcat 4.0.4, jdk1.4. I set the oracle jdbc driver ( class111,zip,
class12.zip, ojdbc14.jar) in the classpath.  Tomcat still complaint the
driver is not found. Here is the error that I got. Does anybody know I need
to configure something in the tomcat?

 

Thank you

 

org.apache.jasper.JasperException: Unable to compile class for JSPNote:
sun.tools.javac.Main has been deprecated.
 
 
An error occurred between lines: 35 and 58 in the jsp file:
/JSP/com/imedge/admin/test.jsp
 
Generated servlet error:
C:\Tomcat
4.0\work\Standalone\localhost\_\JSP\com\imedge\admin\test$jsp.java:101:
Class oracle.jdbc.driver.OracleDriver not found.
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
   ^
1 error, 1 warning
 
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:176)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:188)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 
Here is my source code:
 

!-- Developed and Documented by Krishna Veeramachaneni --

html

 

head

titleIMEDGE Content Management Services Administrator/title

link href=/JSP/com/imedge/admin/style.css rel=stylesheet
type=text/css 

script language=JavaScript
src=/JSP/com/imedge/admin/validation.js/script

script language=JavaScript
src=/JSP/com/imedge/admin/CascadeMenu.js/script

script language = JavaScript

 

!-- hide me

 

 

// show me --

 

/script

/head

% 

   

  /* Java code to retrieve family name and description if any */

  

 

  

%

body  link=#99 vlink=#00 alink=#00  

ID=Bdy leftmargin=0 rightmargin=0 topmargin=0 bgcolor=beige 

 

% include file=/JSP/com/imedge/admin/Banner.jsp %

% include file=/JSP/com/imedge/admin/FamilyMenu.jsp%

 

% page import=javax.servlet.* %

% page import=java.sql.* %

 

 

% 

   

  /* Java code to retrieve family name and description if any */

 

// Load the Oracle JDBC driver

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

 

Connection conn =

  DriverManager.getConnection (jdbc:oracle:thin:sunlab2:1521:chcity,

   xyzz, xyzxc);

 

// Create a Statement

Statement stmt = conn.createStatement ();

 

// Select the ENAME column from the EMP table

ResultSet rset = stmt.executeQuery (select table_name from
user_tables);

 

// Iterate through the result and print the employee names

while (rset.next ())

  System.out.println (rset.getString (1));

  

 

  

%



 

/body

 

/html

 

 

Eddie Liang


--
To unsubscribe, e-mail:
mailto:tomcat-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail:
mailto:tomcat-user-help;jakarta.apache.org

--
To unsubscribe, e-mail

Oracle jdbc driver not found

2002-07-02 Thread Carlton Lo

I'm using Tomcat 4.0.4 tyring to access Oracle 8.1.7 via oci driver.

I've tried many different approaches, they are
1. save classes12.zip into TOMCAT HOME\common\lib and changed the extension to .jar
2. save classes12.zip into TOMCAT HOME\lib and changed the extension to .jar
3. save classes12.zip into TOMCAT HOME\server\lib and changed the extension to .jar
4. unzip all contents of classes12.zip into TOMCAT HOME\classes

non of these works, I was able to connection to the same database in Tomcat 4.0.2, but 
not 4.0.4

here is the error that I got
javax.servlet.ServletException: no ocijdbc8 in java.library.path
at 
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at 
org.apache.jsp.cmp_0005fcampaign_0005finfo$jsp._jspService(cmp_0005fcampaign_0005finfo$jsp.java:544)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at 
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at 
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at 
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:536)
root cause 
java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1403)
at java.lang.Runtime.loadLibrary0(Runtime.java:788)
at java.lang.System.loadLibrary(System.java:832)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:228)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:249)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at 
org.apache.jsp.cmp_0005fcampaign_0005finfo$jsp._jspService(cmp_0005fcampaign_0005finfo$jsp.java:131)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 

Re: Oracle jdbc driver not found

2002-07-02 Thread Larry Meadors

When using the oci driver, you need to have
ocijdbc8.dll (on windows) somewhere on the
system path.

Larry

 [EMAIL PROTECTED] 07/02/02 10:18 AM 
I'm using Tomcat 4.0.4 tyring to access Oracle 8.1.7
via oci driver.

here is the error that I got
javax.servlet.ServletException: no ocijdbc8 in java.library.path


--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]