jdbc:oracle:oci8:DBuser/password@instance
In \Oracle\iSuites\network\admin\tnsnames.ora you need an entry like:
SIDName =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = IPAddressOrHostName)(Port =
1521))
)
(CONNECT_DATA =
(SID = SIDName)
)
)
Best Regards
Bob Jones
Senior Analyst Programmer - FRC MSATS Project
MMS Information Technology
NEMMCO
02 8845 8616
pallav
<pallav_grigo@HOTMAIL To: [EMAIL PROTECTED]
.COM> cc:
Sent by: "A mailing Subject: Connecting to Oracle
database
list for discussion
about Sun
Microsystem's Java
Servlet API
Technology."
<SERVLET-INTEREST@JAV
A.SUN.COM>
26/02/2002 15:19
Please respond to "A
mailing list for
discussion about Sun
Microsystem's Java
Servlet API
Technology."
Hi..I have a servlet which needs to access an Oracle Database using JDBC..i
installed the driver for it...and it works for local applications...my url
string is jdbc:oracle:oci8:@
if i use that in the servlet i dont get any connection...what url should i
use? i'm using oracle Personal Edition 8.1.7..do i need to setup some kind
of listener from oracle??
thanx for any help..
pallav.
------------------------------------------
This e-mail is confidential. If you are not the intended recipient, any use,
disclosure or copying of this document is unauthorised and prohibited. If you have
received this document in error, please delete the email and notify me by return email
or by phoning the NEMMCO Helpdesk on 1300 300 295.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
