Unfortunately, you're using the OCI driver, where as Atilio is using the
Thin driver. They are configured differently, since the Thin driver doesn't
require the Oracle Client to be installed on the machine.
(*Chris*)
----- Original Message -----
From: "Margaret Fisk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 10:27 AM
Subject: Re: [JSP-INTEREST] jdbc url string: java.sql.SQLException Error
> 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://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
