Oracle uses the Oracle client to connect. Make sure you have your database
set up in the tnsnames.ora file for the client on the machine where you are
running you webserver (or on a network drive with the Oracle client bin
folder in your webserver's path statement.) The syntax I'm using (and this
appears to be a different driver but...) is jdbc:oracle:oci8:@[tnsnames
entry]
I connect to both 8.1.6 and 8.1.7 databases with the above, using the driver
that comes with Oracle.
-----Original Message-----
From: Frank Mancini [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 10:32 AM
To: [EMAIL PROTECTED]
Subject: jdbc url string: java.sql.SQLException Error
Thanks Atilio....
Does anyone out there have any example JDBC URL Strings to connect to Oracle
8.1.6???
I'm using JDBC to connect to Oracle and I think my URL String might be
formatted wrong...
jdbc:oracle:thin:@machinename:1521:SChema
Is this right?
>From: Atilio Ranzuglia <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
>reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: java.sql.SQLException Error
>Date: Wed, 20 Jun 2001 09:57:36 -0700
>
>Frank:
>the exception is telling you that the JDBC driver
>cannot connect to your database.
>The message 'Failed ... socket' comes from your JDBC
>driver.
>You have to check if the user, pass and url for the
>connection are correct. If so check if the database is
>up and running. And don't forget to check the network
>status (is the database server recheable?)
>
>Hope this helps
>Atilio
>
>
>--- Frank Mancini <[EMAIL PROTECTED]> wrote:
> > java.sql.SQLException:
> > Failed to connect to database
> > no more data to read from socket
> >
> > Can someone tell me what this error is?
> >
>_________________________________________________________________
> > Get your FREE download of MSN Explorer at
> > http://explorer.msn.com
> >
> >
>===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body:
> > "set JSP-INTEREST DIGEST".
> > 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
>
>
>=====
>
>---------------------------------
>Ingeniero Atilio Ranzuglia Buteler
>[EMAIL PROTECTED]
>---------------------------------
>
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>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 FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
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
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
