Stack Overflow
Stack Overflow

Questions tagged [ojdbc]

OJDBC is the Oracle JDBC driver.

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

666 questions
40
votes
12 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,268
  • 9
  • 26
  • 48
26
votes
11 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,581
  • 14
  • 66
  • 104
22
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,521
  • 3
  • 25
  • 32
20
votes
9 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
  • 303
  • 1
  • 2
  • 5
16
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
  • 11,140
  • 10
  • 85
  • 154
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
  • 435
  • 1
  • 5
  • 20
15
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,633
  • 4
  • 19
  • 38
14
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
  • 141
  • 1
  • 1
  • 6
13
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
  • 10,577
  • 10
  • 57
  • 99
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
  • 11,050
  • 7
  • 45
  • 69
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
  • 844
  • 7
  • 20
11
votes
1 answer

Changed behaviour of java.sql.Date after OJBC client upgrade

After an upgrade of the OJDBC client from version 11.2.0 to 12.1.0, I experience a different behavior in binding a java.sql.Date object to a PreparedStatement. In the prepared statement, a host variable "f.plan_date = ?" should be binded with the…
Wouter
  • 241
  • 2
  • 8
11
votes
2 answers

Is there a way to extract primary key(or ROWID) using NamedParameterJdbcTemplate and GeneratedKeyHolder?

I am trying to extract ROWID or the primary key using Spring's NamedParameterJdbcTemplate and GeneratedKeyHolder. I am trying to do something like this. MapSqlParameterSource parameters = new MapSqlParameterSource() …
darwinbaisa
  • 688
  • 2
  • 8
  • 13
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
  • 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?
ROMANIA_engineer
  • 54,432
  • 29
  • 203
  • 199
1
2 3
…
44 45