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
5
votes
1 answer

Why doesn't OJDBC 7 map the CHAR data type to a Java String?

One of the jobs of OJDBC is to map Oracle data types to Java types. However, we noticed that if we give a CHAR data type, it is not mapped to java.lang.String. The versions showing this behavior are: OJDBC7 v12.1.0.2 and OJDBC6 v12.1.0.1. The older…
DolphinJava
  • 2,682
  • 1
  • 23
  • 37
5
votes
8 answers

ORA-28040: No matching authentication protocol : Oracle 12c Upgrade

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 saying : java.sql.SQLException: ORA-28040: No matching…
Tushar
  • 1,450
  • 6
  • 18
  • 30
5
votes
5 answers

SQL execution time much slower in a Tomcat Servlet than in a normal Java program

For inexplicable reasons however, this morning the performance increased for two of my Queries that used to be slow. I have no idea why. I have no authority over the server, maybe someone changed something. The problem is no more. In a…
Tim
  • 3,910
  • 8
  • 45
  • 80
5
votes
1 answer

Hibernate saves stale data with hibernate.jdbc.batch_versioned_data

Environment Hibernate 4.2 ojdbc6 - Oracle 11.2.0.3.0 JDBC 4.0 Oracle Database 11g The issue We followed many recommendations to configure our Hibernate batching the following way: 100
Dragan Bozanovic
  • 23,102
  • 5
  • 43
  • 110
5
votes
1 answer

Where to set mapDateToTimestamp in Websphere server 7

I am using ojdbc6.jar to connect Oracle 10g database. but i am getting Unparsable date error. So i searched on various oracle and found out that we have to set Oracle suggestion link and Suggestion link2 mapDateToTimestamp = false But nowhere…
blackberry dev
  • 371
  • 2
  • 5
  • 16
5
votes
1 answer

Java - Oracle Database Change Notification

I am trying to implement a event listener which can identify DATABASE CHANGE NOTIFICATION (Oracle). According to the reference website, it said that event will triggle and print ROW_ID when something change in EXAMPLE table. I want this project…
Adrian
  • 836
  • 7
  • 20
  • 44
5
votes
2 answers

Why large number changes value when saved into Oracle DB

During a software project we stumbled upon a bug, where we inserted a large number (17 digits) from Java into Oracle DB procedure. The number changed it's value sometimes +1 or -1. Sometimes stayed the same. We checked the oracle DB driver debug log…
Joosep Simm
  • 462
  • 1
  • 5
  • 13
5
votes
1 answer

Oracle Clob Reader issue: Protocol violation

I'm Using java7, jboss7, ojdbc7,hibernate 4. Table has a CLOB column and in domain class the code is something like this: @Lob private String MyClob; I'm getting this strange error while querying and this is not consistent. Caused by:…
Amit Yatagiri
  • 425
  • 1
  • 4
  • 16
5
votes
2 answers

SQLSyntaxErrorException when using LIKE with ojdbc7.jar

I have the following statement : PreparedStatement prpStat = conn .prepareStatement("SELECT * FROM natperson WHERE name LIKE ?"); prpStat.setString(1, "A"); ParameterMetaData pmd =…
yck
  • 113
  • 1
  • 1
  • 7
5
votes
2 answers

Why shouldn't i turn on "antiJARLocking" in production environment?

I'm running web-apps on a Tomcat7 server and having trouble undeploying them. It seems that windows keeps a lock on a particular JAR file in the application folder. I've found that there is a context attribute called "antiJARLocking" that i can set…
MathieuB
  • 88
  • 2
  • 7
5
votes
2 answers

jdbc prepared statement with oracle NUMBER type

I have a java application which sets up a jdbc connection to an Orcale database. I am attempting to insert data into the database but am confused when it comes to the oracle NUMBER type. I have three columns in my table which are of these types…
medium
  • 4,136
  • 16
  • 55
  • 66
5
votes
1 answer

Difference between oracle.sql.BLOB.DURATION_CALL vs oracle.sql.BLOB.DURATION_SESSION

oracle.sql.BLOB.DURATION_CALL vs oracle.sql.BLOB.DURATION_SESSION What is the difference between the two? It is used to create a temporary LOB by calling the BLOB.createTemporary(connection, true, flag). I have the following scenario: All…
sameer59
  • 97
  • 11
4
votes
0 answers

Why doesn't HikariCP reconnect to the database?

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.sql.SQLTransientConnectionException: HikariPool-1 -…
AJPerez
  • 3,435
  • 10
  • 61
  • 91
4
votes
1 answer

How can I log UPDATE statements using the Oracle driver's logging in a reasonable way?

I'd like to log all the SQL that my application is issuing, so I know EXACTLY what it's doing. I've setup Java Util Logging for Oracle according to this answer, to try to capture things at the lowest level I can. My application is using Hibernate…
Kaypro II
  • 3,210
  • 8
  • 30
  • 41
4
votes
1 answer

"java.sql.SQLException: Missing IN or OUT parameter at index:: 1" when calling function

While calling SimpleJdbcCall.withFunctionName I get java.sql.SQLException: Missing IN or OUT parameter at index:: 1 SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(myDataSource) .withCatalogName("package_name") .withFunctionName("x"); String res…
user435421
  • 859
  • 2
  • 13
  • 31
1 2
3
…
44 45