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
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
  • 2,307
  • 8
  • 40
  • 60
9
votes
2 answers

What does Connection.isValid(time) actually do to check if connection if valid?

Using OJDBC process does the isValid method use to check if the the connection is still alive? I'm trying to figure out what impact it could have on the database and how heavy this process is. e.g. does it request a column, or just ping the db with…
Ian
  • 354
  • 4
  • 13
9
votes
2 answers

Supported JDBC, JDK versions for Oracle 11g

We are upgrading our DB from oracle 10g to 11g. I hope our current JDK1.6 will support this. What will be ideal JDBC versions for Oracle 11g ? Currently we are using ojdbc.14.jar , will it support for 11g ? Please confirm me
Siva Moorthy
  • 131
  • 1
  • 2
  • 4
9
votes
6 answers

Missing artifact com.oracle:ojdbc14:jar:10.2.0.1.0

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 file was located in command prompt. execute the…
beji dhia
  • 111
  • 1
  • 1
  • 7
9
votes
2 answers

Oracle JDBC charset and 4000 char limit

We are trying to store an UTF-16 encoded String into an AL32UTF8 Oracle database. Our program works perfectly on a database that uses WE8MSWIN1252 as charset. When we try to run it on a database that uses AL32UTF8 it gets to a java.sql.SQLException:…
Arolition
  • 145
  • 1
  • 2
  • 6
7
votes
1 answer

Why does JDBC adjust the time to default timezone when it is saving a date?

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. The value is always in UTC, and is parsed and…
supertonsky
  • 2,563
  • 6
  • 38
  • 68
6
votes
1 answer

How to fix " No managed connections available within configured blocking timeout (60000 [ms]) "

I have deployed java application on wildfly-15.0.1.FINAl server.I am using OJDBC 12.1.0.2.0 driver. …
Gog1nA
  • 376
  • 1
  • 8
  • 30
6
votes
3 answers

Issue with ojdbc jar in Maven

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 issue with ojdbc.jar dependency in pom.xml. Its showing:…
Charan
  • 143
  • 1
  • 3
  • 8
6
votes
4 answers

Timestamp literal in Oracle SQL Developer

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, the symbol { causes error ORA-00911: invalid…
barney..gumble
  • 71
  • 2
  • 5
6
votes
1 answer

Temporary tablespace of CLOB not freed

I have the Problem that my Java-Application is exporting a larger amount of clobs from a database, but always runs out of temporary tablespace as the old clobs are not freed. A simplified code example how I do it would be: public void…
Simon M
  • 61
  • 1
  • 4
6
votes
3 answers

How to access Excel as Database using Java 8

I am using Java 8. When i am trying to access Excel data(basically this is my test data) through jdbc-odbc, i am getting "java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver" And also i am trying to access data as non DSN. I surfed net…
Uday
  • 1,433
  • 10
  • 36
  • 57
6
votes
1 answer

Oracle JDBC Types Mapped to Java Object Types by getObject() - wrong document?

this is the document link: "Mapping SQL and Java Types" let's see 8.9.3 JDBC Types Mapped to Java Object Types at row: TIMESTAMP - java.sql.Timestamp but when I use getObject() with oracle database on a TIMESTAMP column, the return type is…
yelliver
  • 5,648
  • 5
  • 34
  • 65
5
votes
0 answers

com.oracle.ojdbc:ojdbc8 vs com.oracle.database.jdbc:ojdbc8 - what's the difference?

Using both in different modules of the application we faced the FAN issue: ERROR: attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out We're going to resolve it with the well-known…
Aleksey Panin
  • 65
  • 6
5
votes
1 answer

Creating an ssl connection to oracle db with Java

I'm trying to connect to an Oracle DB using Java and SSL. For now I have the Java program on the server with the database. I'm getting this error when I try to run it (full error in comment): java.sql.SQLRecoverableException: IO Error: Inbound…
Kehaar
  • 119
  • 2
  • 8
1
2
3
…
44 45