Re: Problems Connecting Oracle database XSQL and/or JSP via apache

From: dmz17 <dmz17_at_nospam.nowhere.com>
Date: Thu, 24 Oct 2002 17:22:44 +0200
Message-ID: <pan.2002.10.24.15.22.42.343003@nospam.nowhere.com>

On Thu, 24 Oct 2002 02:39:42 +0000, Mark Starmer wrote:

>> Sounds as if you attempt to connect using OCI whithout having installed
>> OCI.
>> 
>> What does your connect string in Java look like?
>> 
>> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
>> Connection conn =
>> DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:your_sid",
>>                                          "scott", "tiger");
>> 
>> Cheers,
>> 
>> dmz17

>
> My JAVA connection string should be fine, as I'm using the examples
> that come with Oracle (I'm using version 9i Home on Windows XP Pro,
> the version that downloads onto CD). I also have Apache 2 running with
> MySQL and PHP, and Apache Tomcat 4.xxx running as a JSP service on the
> same machine. There are no conflicts with port configutations of which
> I'm aware of.
>
> Does anybody know of any other sevrices that use port 1521? I have
> also set up an additional listener on 1522 to see if that works but it
> didn't....
>
> By the way, whats the OCI?
>
> Best Regards,
>
> Mark Starmer

OCI is the c language bases JDBC driver from Oracle. It assumes you installed the client software. If you did not, you need to use the thin driver. It is a Java implementation of SQLNet.

The connect string therefore might not be OK, after all.

Cheers,

dmz17 Received on Thu Oct 24 2002 - 10:22:44 CDT