We have a Spring Boot application, using HikariCP as connection pool to an Oracle 12.2 database. If there is an issue and the database becomes unavailable, we get this exception, as expected: java....

I am trying to develop a Java EE application that connect to an Oracle database from eb service class but I encounter a SQLException: No suitable driver found for jdbc:oracle:thin:@//localhost:15...

I need to test sql queries on Oracle SQL Developer. These queries contain timestamp literals in the format {ts 'yyyy-mm-dd hh:mm:ss.fff'} Oracle SQL Developer does not seem to accept this syntax,...

I am using Eclipse Luna and working on a maven project. When I add the entry for ojdbc jar in pom.xml , it is giving error in the xml. I can't find any reason for the issue as groupId, artifactId...

I'm new with Gradle projects and I have one question. I've searched in Internet but I couldn't find what I need or maybe I couldn't know how to search it. First I'm going to tell you my case. I hav...

I am getting the "Protocol Violation". I have an application running on RedHat Linux.The database and the application are co-resident on the machine. Oracle version used: Oracle 11g R2 (11.2.0.3.0...

Oracle ojdbc8 12.2.0.1 Forbidden by Maven since December 2017, before that worked well. What configuration has changed on the Oracle repository (setting.xml)? Maven project: https://github.com/sgr...

I have deployed java application on wildfly-15.0.1.FINAl server.I am using OJDBC 12.1.0.2.0 driver. <datasource jndi-name="java:/DS_APP" pool-name="APP" enabled="true" use-java-context="true"&g...

I have imported a Maven Project in Eclipse (EE Developer) and I have in my pom.xml file the following error, “Missing artifact com.oracle:ojdbc7:jar:12.1.0.2″ in this code: <dependency> &lt...

I wanted to know the ojdbc version which supports java8 and Tomcat 8.5. Currently I am using ojdbc14_g.jar which gives a version compatibility issue when I start the application. This works with To...

We have migrated our Oracle database to 12c from 11g. We have a legacy application running in Java 1.5 and using ojdbc14.jar. Our application is not able to create connection to database error say...

I am trying to add dependency for ojdbc14 in pom.xml. Steps I followed for adding ojdbc14.jar in local repository of maven: Create a new project move to that particular folder where is pom.xml f...

I need to set some specific Oracle JDBC connection properties in order to speed up batch INSERTs (defaultBatchValue) and mass SELECTs (defaultRowPrefetch). I got suggestions how to achieve this wit...

Will ojdbc6.jar work for JDK 1.7 and Oracle 12c? Should I use ojdbc7.jar? Thank you in advance.

I've developed a project in Java 8 and I've installed the ojdbc jar in maven when I developed the project using java 8. Now I'm converting the project into java 7. While doing so, I'm facing ...

I downloaded SQuirreL SQL and I want to use it as an Oracle client, but when I go to Drivers tab, the following jars are missing: Oracle OCI Driver Oracle Thin Driver How can I fix this probl...

I am currently working on cloud migration activities. We have installed a new “Apache Tomcat/8.0.43” in cloud server and transferred the war files from local to cloud. while starting the tomcat ser...

I've been trying to switch from the Oracle OCI driver to the thin driver, I got the thin driver to pickup my tnsnames.ora by adding -Doracle.net.tns_admin=/path to the command line. However, our t...

This question is related to this but this specific question focuses on the why. So no, this isn't a duplicate. Quoting the answer: The problem is that Java Date objects don't store a time zone....

Before upgrading from Java 1.6 to Java 1.8, we were able to log into the web application. After the upgrade, we could not log into one of the web applications, but I could log into the other. They ...

I have an issue using Hibernate javax.persistence.SequenceGenerator.allocationSize() property. When it is set to 1 I face performance issues when inserting a lot of records to database. Otherwise w...

Object deserialization is failing for BLOB datatype in our application, after upgrading jdbc driver for Oracle database. In our application, we have been using the ojdbc14 for the last couple of y...

There are times closing connections takes a lot of time, like more than 10 minutes upto 1 hour, or worse, even for indefinite time, depending on how heavy or slow the query was. In a situation whe...

I am trying to connect to an Oracle 11g XE databse using Oracle SQL Developer. However, I am getting the following exception: java.lang.SecurityException: sealing violation: package oracle.jdbc.dr...

I know this question has been asked several times.Even i have successfully done this in WINDOWS.But installed ubuntu OS and all set up is done except this. Here are the following things i did.I Ha...