oracle jdbc thin client hangs bastian server

Update ojdbc7.jar to Oracle client version 12.1.0.2 (the last one which has an ojdbc7.jar available).

Please remove the ojdbc14.jar completely (it was built with Java 1.4) and use (replace it with) ojdbc7.jar (which was built with JVM 7).

And if it turns out to be the driver specifically I’d be very interested in learning the details of how such a problem would result in “connection refused.” It is likely a very simple issue that does not have to do with the driver version. If the driver was the issue, I would think the error message would be different and likely indicate a version/impedence mismatch.Ĭheck connectivity from SQL Developer or TOAD or other tool to confirm the DB. So either the DB changed from using the default port on the same server, or the updated DB is on a different server.

It is saying that nothing is listening on port 1521. As we’ve all experienced over the years – trust the error message. Given the update of the DB server, this seems like a good opportunity to update the driver since testing will likely be performed due to the DB update.īut IMO, this is not likely the root cause of the error. This is similar to batch job concept.I agree that using a newer driver is preferable. both the Java/JDBC and Oracle database run on Linux OS. (2) Java/JDBC application runs on the same physical server where the database software is located, i.e. This is similar to N-tier on-line application concept. For example, Windows App Server with Java/JDBC and Oracle 11g R2 database server on Linux. (1) Java/JDBC application runs on separate (application) server to the database server. Which JDBC solution is recommened for the latest versions of Java and Oracle - to use Thin driver or use OCI-based driver? And why so?

I did a search on this forum regarding which Oracle JDBC driver to use (from the application servers) - the OCI-based or Thin JDBC and the topic has been covered a number of time but the answers were several years old (most recent in ~2008?) so I would like to resurrect this topic again, for the later versions of Java (1.7 or at least 1.6, using ojdbc6.jar or later) and using the latest version of Oracle 11g R2 (11.2.0.3) database and latest OCI 11g R2 client software.

Oracle jdbc thin client hangs bastian server