RE: I need help in tomcat configuration with Oracle 8.1.7
Tobias, Here is an example that should help: http://www.thejspbook.com/solaris-oracle-howto.html Mike. -- Mike Braden [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Internet Total Solutions LLC - Customer Liaisons Department - [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 6:37 AM To: [EMAIL PROTECTED] Subject: I need help in tomcat configuration with Oracle 8.1.7 Hello, I would like to know whether anyone is able to give me a hint towards solving the following scenario. If anyone is available on consultation basis, it is fine too. I have developed website personalization engine in java that comes with it's own kind of application server to handle the client access requests to the oracle 8.1.7 db through the use of tomcat 3.1 I am using the oracle thin driver and classes111.zip in order to handle the requests through the jdbc. However tomcat giving me serious errors and my client application can't login to the database. Would anyone be able to help me on that matter? Thanks Tobias Hansen
Re: I need help in tomcat configuration with Oracle 8.1.7
As long as you have the classes111.zip in your
classpath, you should not have a problem. I just
created a simple form that allowed a user to enter
information and login. You could also hardcode these
values and they would work. Here's a little snippet of
code that works fine. You have catch the exceptions,
but the connection will work for you.
private String url;
private String user;
private String password;
private Connection conn;
private boolean conn_s;
private boolean hasClosed;
public void init(ServletConfig config) throws
ServletException {
super.init(config);
conn_s=false;
hasClosed=true;
}
/**Process the HTTP Get request*/
public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException
{
url="jdbc:oracle:thin:@"+request.getParameter("hostString");
user=request.getParameter("userName");
password=request.getParameter("password");
try
{
System.out.println("Current connection status:
"+hasClosed);
DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver());
conn=DriverManager.getConnection(url,user,password);
conn_s=true;
System.out.println("Connection made
succesfully");
}
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
RE: I need help in tomcat configuration with Oracle 8.1.7
Firstly ... post in text, not HTML! What sort of errors are you getting from Tomcat? Have you checked your JDBC URL using Oracle's CheckJDBC class? Eoin. -Original Message- From: Internet Total Solutions LLC - Customer Liaisons Department - [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 3:37 AM To: [EMAIL PROTECTED] Subject: I need help in tomcat configuration with Oracle 8.1.7 Hello, I would like to know whether anyone is able to give me a hint towards solving the following scenario. If anyone is available on consultation basis, it is fine too. I have developed website personalization engine in java that comes with it's own kind of application server to handle the client access requests to the oracle 8.1.7 db through the use of tomcat 3.1 I am using the oracle thin driver and classes111.zip in order to handle the requests through the jdbc. However tomcat giving me serious errors and my client application can't login to the database. Would anyone be able to help me on that matter? Thanks Tobias Hansen
Re: I need help in tomcat configuration with Oracle 8.1.7
Hello Guys, thanks for so much advises from all of you, I will try now to incorporate certain ideas to see whether I get it to work. Thanks Tobias - Original Message - From: Sam Newman To: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 5:43 PM Subject: Re: I need help in tomcat configuration with Oracle 8.1.7 I don't know anything too specific about use with Oracle, but I've certainly used servlets/JSP's to access DB's via JDBC in the past (read: maintained code which did it, not developed it!), so its certainly possible. Firstly, could you give the exact error you are getting from tomcat? Also, you might want to try using 3.2.2, which is the current stable release and might contain fixes to your problems already. sam - Original Message - From: Internet Total Solutions LLC - Customer Liaisons Department - To: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 11:37 AM Subject: I need help in tomcat configuration with Oracle 8.1.7 Hello, I would like to know whether anyone is able to give me a hint towards solving the following scenario. If anyone is available on consultation basis, it is fine too. I have developed website personalization engine in java that comes with it's own kind of application server to handle the client access requests to the oracle 8.1.7 db through the use of tomcat 3.1 I am using the oracle thin driver and classes111.zip in order to handle the requests through the jdbc. However tomcat giving me serious errors and my client application can't login to the database. Would anyone be able to help me on that matter? Thanks Tobias Hansen
Re: I need help in tomcat configuration with Oracle 8.1.7
Hi, If I remember correctly, you have to be using at least jdk1.2 in order to run Tomcat, but the classes111.zip file is intended for use with jdk1.1. You might have better luck if you used classes12.zip (which you can get from technet.oracle.com). Brendan : Hello, : : I would like to know whether anyone is able to give me a hint towards = : solving the following scenario. If anyone is available on consultation = : basis, it is fine too. : : I have developed website personalization engine in java that comes with = : it's own kind of application server to handle the client access requests = : to the oracle 8.1.7 db through the use of tomcat 3.1 I am using the = : oracle thin driver and classes111.zip in order to handle the requests = : through the jdbc. However tomcat giving me serious errors and my client = : application can't login to the database. Would anyone be able to help me = : on that matter?=20 : : Thanks : : Tobias Hansen : : : : : : : : : : : Hello, : : I would like to know whether anyone is able to give me a : hint towards solving the following scenario. If anyone is available on : consultation basis, it is fine too. : : I have developed website personalization engine in : java that comes with it's own kind of application server to handle the : client access requests to the oracle 8.1.7 db through the use of tomcat 3.1 I am : using the oracle thin driver and classes111.zip in order to handle the requests : through the jdbc. However tomcat giving me serious errors and my client : application can't login to the database. Would anyone be able to help me on that : matter? : : Thanks : : Tobias Hansen : : -- Brendan McKennaEmail: [EMAIL PROTECTED] Development Strategist Phone: +353-61-338177 Taringold Ltd. Fax: +353-61-338065
RE: I need help in tomcat configuration with Oracle 8.1.7
I am not sure that I understand the problem exactly but I do know that there are a number of problems that can occur with connecting to a JDBC driver, the most common of which is that classes111.zip needs to be placed in TOMCAT_HOME/lib/ and renamed to classes111.jar so that Tomcat can detect it and put it on the classpath. See if this helps. Tim. Tim Hughes Cap Gemini Ernst & Young Addr.: Sandbrugt. 5-7, Postboks 3950, Dreggen, 5835 Bergen, Norway Tel: +47 55 90 66 24 / +47 48 10 06 38 Email: [EMAIL PROTECTED] Web: http://no.cgey.com -Original Message-From: Internet Total Solutions LLC - Customer Liaisons Department - [mailto:[EMAIL PROTECTED]]Sent: 3. juli 2001 12:37To: [EMAIL PROTECTED]Subject: I need help in tomcat configuration with Oracle 8.1.7 Hello, I would like to know whether anyone is able to give me a hint towards solving the following scenario. If anyone is available on consultation basis, it is fine too. I have developed website personalization engine in java that comes with it's own kind of application server to handle the client access requests to the oracle 8.1.7 db through the use of tomcat 3.1 I am using the oracle thin driver and classes111.zip in order to handle the requests through the jdbc. However tomcat giving me serious errors and my client application can't login to the database. Would anyone be able to help me on that matter? Thanks Tobias Hansen This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
Re: I need help in tomcat configuration with Oracle 8.1.7
'Serious Errors'? you'll have to be a bit more specific than that. Exactly what errors is tomcat giving you? - Segmentation faults? NullPointerExceptions? NoClassDefFoundException? Also, be aware that Tomcat 3.2.2 is the latest stable version, and it has fixes for a number of problems with versions prior to it. This may have nothing to do with1 your problems, but it is advisable to upgrade to 3.2.2, unless you have a particular reason to stick with 3.1 -Pete > Hello, > > > > I would like to know whether anyone is able to give me a hint towards > solving the following scenario. If anyone is available on consultation > basis, it is fine too. > > > > I have developed website personalization engine in java that comes > with it's own kind of application server to handle the client access > requests to the oracle 8.1.7 db through the use of tomcat 3.1 I am > using the oracle thin driver and classes111.zip in order to handle the > requests through the jdbc. However tomcat giving me serious errors and > my client application can't login to the database. Would anyone be > able to help me on that matter? > > > > Thanks > > > > Tobias Hansen > > >
Re: I need help in tomcat configuration with Oracle 8.1.7
I don't know anything too specific about use with Oracle, but I've certainly used servlets/JSP's to access DB's via JDBC in the past (read: maintained code which did it, not developed it!), so its certainly possible. Firstly, could you give the exact error you are getting from tomcat? Also, you might want to try using 3.2.2, which is the current stable release and might contain fixes to your problems already. sam - Original Message - From: Internet Total Solutions LLC - Customer Liaisons Department - To: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 11:37 AM Subject: I need help in tomcat configuration with Oracle 8.1.7 Hello, I would like to know whether anyone is able to give me a hint towards solving the following scenario. If anyone is available on consultation basis, it is fine too. I have developed website personalization engine in java that comes with it's own kind of application server to handle the client access requests to the oracle 8.1.7 db through the use of tomcat 3.1 I am using the oracle thin driver and classes111.zip in order to handle the requests through the jdbc. However tomcat giving me serious errors and my client application can't login to the database. Would anyone be able to help me on that matter? Thanks Tobias Hansen
