Questions tagged [ojdbc]

OJDBC is the Oracle JDBC driver.

OJDBC is the JDBC driver provided by Oracle, see Oracle JDBC page

585 questions
38
votes
11 answers

Missing artifact com.oracle:ojdbc6:jar:11.2.0 in pom.xml

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 and version are correct. How can I fix the problem?
soumitra chatterjee
  • 2,108
  • 6
  • 24
  • 44
25
votes
10 answers

SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

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:1521/orcl I have the ojdbc6.jar in the class path and…
nicholas
  • 2,180
  • 10
  • 53
  • 88
19
votes
8 answers

How to use Oracle JDBC driver in Gradle project

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 have a Gradle project and I would like to execute…
javitxu
  • 193
  • 1
  • 1
  • 5
16
votes
3 answers

What is the difference between ojdbc6.jar and ojdbc7.jar?

Will ojdbc6.jar work for JDK 1.7 and Oracle 12c? Should I use ojdbc7.jar? Thank you in advance.
Brooke
  • 415
  • 1
  • 5
  • 13
15
votes
2 answers

Displaying the hex value of a string from a oracle varchar2?

We are having problems with text that is encoded in some different ways but kept in a single column in a table. Long story. On MySQL, I can do "select hex(str) from table where" and I see the bytes of the string exactly as I set them. On Oracle, I…
Ray Kiddy
  • 3,003
  • 2
  • 20
  • 29
14
votes
5 answers

Missing artifact com.oracle:ojdbc7 in eclipse

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: com.oracle
Masih
  • 1,495
  • 4
  • 16
  • 35
12
votes
4 answers

How to set custom connection properties on DataSource in Spring Boot 1.3.x with default Tomcat connection pool

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 with DBCP (Thanks to M. Deinum) but I would like…
Marged
  • 9,123
  • 9
  • 45
  • 87
12
votes
7 answers

SQLException: Protocol Violation in oracle

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) JDBC Driver used: 12.1.0.1 Java used: jdk1.7.0.65 …
Saurav
  • 121
  • 1
  • 1
  • 6
11
votes
1 answer

Declaring multiple identical service in tnsnames.ora supported by oracle thin driver

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 tnsnames.ora contains lines where multiple services…
LordOfThePigs
  • 10,378
  • 5
  • 41
  • 64
11
votes
1 answer

Unable to get db connection after Java 8 upgrade

I have recently upgraded an application from java 1.7 to 1.8. Rest of the libraries versions remains unchanged. I am getting the following error after the upgrade: DEBUG 2015-11-12 09:55:12 BasicResourcePool An exception occurred while…
Uday Shankar
  • 794
  • 5
  • 20
10
votes
2 answers

sealing violation: package oracle.net.ns is sealed

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.driver is sealed I have searched for an answer on the…
Vinci A De Paul
  • 101
  • 1
  • 3
10
votes
2 answers

Oracle OCI and Thin drivers are missing in SQuirreL SQL

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 problem?
Elrond_EGLDer
  • 47,430
  • 25
  • 189
  • 180
10
votes
0 answers

Glassfish Runtime Exception on JDBC Connection Pools

I have just finished installing my oracle jar to glassfish library and successfully connect by ping and JDBC Pool to my database with the right property values. Then I chose it for my JDBC Resources right after that, I ping the pool again and the…
name me
  • 378
  • 1
  • 2
  • 17
9
votes
2 answers

Unable to log in to web app after upgrading from Jav 6 to Java 8 when oraclepki, osdt_cert, and osdt_core are on the classpath

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 are using the same Spring-Security, OJDBC, and…
ScrappyDev
  • 1,583
  • 8
  • 28
  • 46
9
votes
9 answers

Oracle ojdbc8 12.2.0.1 Forbidden by Maven

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/sgrillon14/MavenSampleOracleJdbc Full trace:…
Stéphane GRILLON
  • 8,567
  • 5
  • 60
  • 106
1
2 3
38 39