Franky,
Hi! I did work out how to use thin driver. My problem is that I can't get
oci driver to work. I installed the client and able to connect it with
database, but oci8 driver always give memory access violation error.
Or, Oracle8i 8.1.6.0.1 JDBC oci driver doesn't work well with my Oracle 8i
8.1.5??? Any idea what's wrong? Thanks.
-Meng
> -----Original Message-----
> From: Franky Silaen [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 24, 2000 10:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: JDBC OCI getConnection problem
>
> Dear,
>
> As described in the documentation of JDBC, you use getConnection() as
> follows:
> Connection
> conn=DriverManager.getConnection("jdbc:oracle:thin@**1**:**1a**:**1b**",
> "**2**", "**3**");
>
> **1** is the IP number or the name of the machine that hosts the database.
> Try using the IP number as much as possible as it much faster compared to
> using the host/machine name. Using the machine name will make your
> program
> look for the IP number of the machine. So in the end, you might as well
> use
> the IP address.
>
> **1a** is the port number that you use to connect to the database server.
> You're using the wrong port. The default port for any Oracle
> database connection is 1521.
>
> **1b** is the name of the database.
>
> **2** is the username that you use to connect to the database. The
> database
> must recognize the username. In other words, the username must be created
> in
> the database. There are other alternatives for the username...you can use
> your NT username...but for that to happen, you need to learn more Oracle
> administration.
>
> **3** is the password related to the above username.
>
> Information on this is available in the JDBC docs and Oracle docs (how to
> make
> a JDBC connection).
>
> Best regards,
> Franky
>
> -----Original Message-----
> From: Yu, Meng [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 25, 2000 1:44 AM
> To: [EMAIL PROTECTED]
> Subject: JDBC OCI getConnection problem
>
>
> Hi,
>
> I want to use oci8 to connect my servlet to the database . My database is
> Oracle 8i 8.1.5. The java vm is jdk1.2.2. And I downloaded Oracle8i
> 8.1.6.0.1 JDBC Drivers for use with JDK 1.2.x from oracle tech net.
> Compiles
> ok. When running a test programm, register driver is ok, but getConnection
> has following exception.
> Exception: access violation (0xc0000005), Address: 0x6ee0fb83
>
> I have spent a lot time on this. Anyone with oci experience please help. I
> did install oracle client on servlet machine and it has no problem
> connecting to dababase machine. thin driver works fine, sqlplus works
> fine.
> I set path and classpath properly according to spec. Listner is running
> well
> on database machine. Besides, I also open up all java security permission.
> What else did I miss?
>
> Thank you in advance for any of your advice.
>
> -Meng
>
> __________________________________________________________________________
> _
> 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
>
> __________________________________________________________________________
> _
> 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
___________________________________________________________________________
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
