You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Stefan Riß <st...@mediawave.de> on 2001/07/04 17:45:34 UTC
Need Help: Which JDBC-Driver to use to connect to Oracle 8i (8.1.7)
Hi.
We have problem's connecting to the above oracle database. We can tell that
it has to be a JDBC-Driver problem.
Oracle support tells us that there isn't a JDBC driver for 8i that runs
under JDK1.3+ which we need to run Turbine.
Are there any known Oracle 8i and JDK1.3/Turbuine combinations using a
native JDBC driver??
Any help or hint greatly appreciated.
Thanx,
Stefan
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Need Help: Which JDBC-Driver to use to connect to Oracle 8i (8.1.7)
Posted by Berin Loritsch <bl...@apache.org>.
Stefan Riß wrote:
>
> Hi.
>
> We have problem's connecting to the above oracle database. We can tell that
> it has to be a JDBC-Driver problem.
> Oracle support tells us that there isn't a JDBC driver for 8i that runs
> under JDK1.3+ which we need to run Turbine.
> Are there any known Oracle 8i and JDK1.3/Turbuine combinations using a
> native JDBC driver??
I have used the Oracle Thin driver for JDK 1.2, and it works under the
JDK 1.3+. I just rename the classes12.zip file to oracle.jar for ease
of use. Note: Oracle has yet to come out of the dark ages in their Java
support. They are not JDBC 2.0 compliant in regards to BLOB handling,
and they have better support for JDK 1.1.7 than for JDK 1.2+.
Re: Need Help: Which JDBC-Driver to use to connect to Oracle 8i (8.1.7)
Posted by "Andres G. Portillo D." <an...@veratech.com.mx>.
What parameters are you using to access the Oracle DB?. I've found similar
problems before and they were
b/c the Oracle driver is picky about the format of the parameters. I do not
remember them right now, but you should look specially at the JDBC URL.
andres
Stefan Riß wrote:
> Hi again
>
> > What are the exact problems you are having ?
>
> we ran another bunch of tests and the problem is that the jdbc-driver throws
> an
> "error: network adapter could not establish a connection to the
> <myOracleServer>"
> This error even occurs with the most simple oracle/jdbc samples bundled with
> the oracle db. We also downloaded the latest driver from the oracle site and
> searched the forums there. what we found is that a lot of people ran into a
> similar problem - but nobody seems to have found a solution yet.
>
> what i tried till now is:
> - connecting to the database with oracle tools like studio works.
> - the service listener is up and running
> - we changed the connection pooling from shared to dedicated (hint from
> oracle forum)
> - db-ping is ok
> - i also tried different versions of jdk and the oracle driver, but the
> problem persists
>
> i know this problem is a little bit off topic here, but if anybody has
> experienced and solved this problem any hint would be appreciated.
>
> greetings with a burning head,
> stefan
>
> >
> > I have run different Turbine apps on JDK 1.3.0 and 1.3.1 using
> > the Oracle 8.1.7 and 8.1.6 JDBC drivers to
> > connect to Oracle 8.1.7/8.1.6/8.0.5 without any problems for the
> > last 6 months (win2k/nt4/linux). I would say
> > the JDK-driver combination is definitely not the problem.
> at least there is some hope :-)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
=============================================
Andres G. Portillo D.
Software Engineer
Veratech (www.veratech.com.mx)
=============================================
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Need Help: Which JDBC-Driver to use to connect to Oracle 8i (8.1.7)
Posted by Age Mooy <am...@home.nl>.
What is the value of <myOracleServer> ? An ip address ? An Oracle SID name ?
How have you configured your database properties in the Turbine Resources properties ? Mine look like this
database.default.driver=oracle.jdbc.driver.OracleDriver
database.default.url=jdbc:oracle:thin:@192.168.0.250:1521:ORCL
database.default.username=something
database.default.password=whatever
database.adaptor=DBOracle
database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
It sounds like your jdbc driver tries to connect to the wrong server or port because it specifically mentions
your network adaptor. If it wasn't for the fact that your non-jdbc connections do work I'd say you had
routing/firewall issues
I'm sorry I can't be of more help but, again, I've never had any JDBC trouble with Oracle7 or 8 before.
Age
> Hi again
>
> > What are the exact problems you are having ?
>
> we ran another bunch of tests and the problem is that the jdbc-driver throws
> an
> "error: network adapter could not establish a connection to the
> <myOracleServer>"
> This error even occurs with the most simple oracle/jdbc samples bundled with
> the oracle db. We also downloaded the latest driver from the oracle site and
> searched the forums there. what we found is that a lot of people ran into a
> similar problem - but nobody seems to have found a solution yet.
>
> what i tried till now is:
> - connecting to the database with oracle tools like studio works.
> - the service listener is up and running
> - we changed the connection pooling from shared to dedicated (hint from
> oracle forum)
> - db-ping is ok
> - i also tried different versions of jdk and the oracle driver, but the
> problem persists
>
> i know this problem is a little bit off topic here, but if anybody has
> experienced and solved this problem any hint would be appreciated.
>
> greetings with a burning head,
> stefan
>
> >
> > I have run different Turbine apps on JDK 1.3.0 and 1.3.1 using
> > the Oracle 8.1.7 and 8.1.6 JDBC drivers to
> > connect to Oracle 8.1.7/8.1.6/8.0.5 without any problems for the
> > last 6 months (win2k/nt4/linux). I would say
> > the JDK-driver combination is definitely not the problem.
> at least there is some hope :-)
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Need Help: Which JDBC-Driver to use to connect to Oracle 8i (8.1.7)
Posted by Stefan Riß <st...@mediawave.de>.
Hi again
> What are the exact problems you are having ?
we ran another bunch of tests and the problem is that the jdbc-driver throws
an
"error: network adapter could not establish a connection to the
<myOracleServer>"
This error even occurs with the most simple oracle/jdbc samples bundled with
the oracle db. We also downloaded the latest driver from the oracle site and
searched the forums there. what we found is that a lot of people ran into a
similar problem - but nobody seems to have found a solution yet.
what i tried till now is:
- connecting to the database with oracle tools like studio works.
- the service listener is up and running
- we changed the connection pooling from shared to dedicated (hint from
oracle forum)
- db-ping is ok
- i also tried different versions of jdk and the oracle driver, but the
problem persists
i know this problem is a little bit off topic here, but if anybody has
experienced and solved this problem any hint would be appreciated.
greetings with a burning head,
stefan
>
> I have run different Turbine apps on JDK 1.3.0 and 1.3.1 using
> the Oracle 8.1.7 and 8.1.6 JDBC drivers to
> connect to Oracle 8.1.7/8.1.6/8.0.5 without any problems for the
> last 6 months (win2k/nt4/linux). I would say
> the JDK-driver combination is definitely not the problem.
at least there is some hope :-)
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Need Help: Which JDBC-Driver to use to connect to Oracle 8i (8.1.7)
Posted by Age Mooy <am...@home.nl>.
I have run different Turbine apps on JDK 1.3.0 and 1.3.1 using the Oracle 8.1.7 and 8.1.6 JDBC drivers to
connect to Oracle 8.1.7/8.1.6/8.0.5 without any problems for the last 6 months (win2k/nt4/linux). I would say
the JDK-driver combination is definitely not the problem.
What are the exact problems you are having ?
Age
> -----Original Message-----
> From: Stefan Riß [mailto:stefan.riss@mediawave.de]
> Sent: Wednesday, July 04, 2001 17:46
> To: turbine-user@jakarta.apache.org
> Subject: Need Help: Which JDBC-Driver to use to connect to Oracle 8i
> (8.1.7)
>
>
> Hi.
>
> We have problem's connecting to the above oracle database. We can tell that
> it has to be a JDBC-Driver problem.
> Oracle support tells us that there isn't a JDBC driver for 8i that runs
> under JDK1.3+ which we need to run Turbine.
> Are there any known Oracle 8i and JDK1.3/Turbuine combinations using a
> native JDBC driver??
>
> Any help or hint greatly appreciated.
>
> Thanx,
> Stefan
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org