Look at the sequel statement and there check the syntax.I had a nightmarinsh
experience with JWS and Oracle driver due to a small syntax error.If you
have the correct catch block with print statements there it will neatly
print the exact error number ORA-- error.That helped me to identify where
the lapse is.
Hope this is useful to you.
Srinivas
>From: Visakh Menon <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: [Re: DB connection problem with NES/Jrun]- new issue
>Date: Tue, 25 Apr 2000 19:13:21 GMT
>
>Thanks for the response though your answer didn't help me much. It started
>working after I put oracle.jar file under classpath in jrun's
>jsm.properties
>file. But now I have another issue. I'm able to run servlets, access
>database, read and write from database. but in one particular servlet,
>netscape is throwing the infamous 'Document contains no data' error. I
>thought It would be some database connection problem. but since my other
>servlets are running perfectly (using the same DB connection classes) it
>can't be JDBC problem, right ? When all we usually get this 'Document
>contains no data' error ? Any help appreciated.
>
>Vis..
>
>
>>From: mahesh bapu <[EMAIL PROTECTED]>
>>Reply-To: A mailing list about Java Server Pages specification and
>> reference <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: Re: [Re: DB connection problem with NES/Jrun]
>>Date: Tue, 25 Apr 2000 12:59:44 MDT
>>
>>No need.It takes the default classpath.
>>
>>hope this will work
>>
>>
>>Visakh Menon <[EMAIL PROTECTED]> wrote:
>>I'm using NT. I've set class path the driver in my NT setting. Do I have
>>to
>>do it again in NES or Jrun ? If so where do I do it ?
>>
>> >From: "Cogley, Jonathan" <[EMAIL PROTECTED]>
>> >Reply-To: A mailing list about Java Server Pages specification and
>> > reference <[EMAIL PROTECTED]>
>> >To: [EMAIL PROTECTED]
>> >Subject: Re: DB connection problem with NES/Jrun
>> >Date: Mon, 24 Apr 2000 15:53:26 -0400
>> >
>> >Visakh,
>> >
>> >The user that you have the web server running as probably does not have
>>the
>> >CLASSPATH set correctly else it would be able to find the jdbc drivers.
>> >
>> >Regards,
>> >Jonathan
>> >
>> >BTW - You didn't mention what platform you are on (NT/Unix?) ...
>> >
>> >
>> >-----Original Message-----
>> >From: Visakh Menon [mailto:[EMAIL PROTECTED]]
>> >Sent: 24 April, 2000 12:16 PM
>> >To: [EMAIL PROTECTED]
>> >Subject: DB connection problem with NES/Jrun
>> >
>> >
>> >Hi folks
>> >
>> >I'm using NES 3.6 webserver and Jrun 2.3.3 servlet engine.
>> >I'm trying to connect to a oracle database in a remote machine
>> >using JDBC (using Oracle thin driver). I can connect if I run the
>> >program from command prompt. but If I try to run as a servlet
>> >I get an error.
>> >
>> >java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
>> >[oracle.jdbc.driver.OracleDriver] java.sql.SQLException: No suitable
>>driver
>> >
>> >Code :
>> >Class.forName ("oracle.jdbc.driver.OracleDriver");
>> >DriverManager.getConnection ("jdbc:oracle:thin:@server-ip:1521:orcl",
>> >"username", "pwd");
>> >
>> >I have set oracle.jar (driver) file in my Class path.
>> >
>> >Do I need to make some changes in NES/Jrun setup for accessing Oracle
>>DB?
>> >
>> >Thanks
>> >
>> >Vis..
>> >
>>________________________________________________________________________
>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>>
>>===========================================================================
>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>>JSP-INTEREST".
>>Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>>
>>
>>____________________________________________________________________
>>Get free email and a permanent address at http://www.netaddress.com/?N=1
>>
>>===========================================================================
>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>>JSP-INTEREST".
>>Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
>http://java.sun.com/products/jsp/faq.html
>http://www.esperanto.org.nz/jsp/jspfaq.html
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
