SOLVED WaitingDatabase.connect(WaitingDatabase.java:17) (Sorry for bad english.) I have to connect my oracle database, so I downloaded oracle jdbc driver and added in my dependencies. It connected well when I run at intellij, so I built executable jar file with gradle. However, it couldn’t connect to my…
Tag: oracle
how to configue a dbeaver proxy connection to a private maven repository
I am using an internal maven/artifactory repository on my network. I am trying to intialize an Oracle Connection with DBeaver 7.1.0. (not the eclipse plugin, the standalone program) Each time it initializes, it fails to download the drivers. with the error I’m assuming this is because the proxy is block…
CSV file from HDFS to Oracle BLOB using Spark
I’m working on Java app that uses Spark 2.3.1 to load data from Oracle to HDFS and vice versa. I want to create CSV file in HDFS and then load it to Oracle (12.2) BLOB. The code.. I’m new to Spark.. so any ideas please how to convert JavaRDD to BufferedInputStream, or get rid of mess above and put…
ORA-00905: missing keyword in case statement
I am getting ORA-00905: missing keyword in case statement in my when clause. Below is the query. Answer You can’t have a boolean value as a selectable something in a query in oracle, you can only make boolean expressions in e.g. the WHERE/ON clauses etc i.e. this is invalid: This is valid: You could lat…
Oracle 19c compatibility with jdk7
I would like to know if oracle 19c is compatible with jdk 7. I have found out 2 drivers for oracle 19c ojdbc8 : for jdk8, jdk9 and jdk11 ojdbc10 : for jdk10 and jdk11 I would like to know if there is a way to have oracle 19c with a jdk7, and if yes what is the driver that
Can’t connect to Oracle 19.3 with 19.3 JDBC driver
We have a project running with an Oracle 19.3 database, and a Java application using the Oracle 19.3 JDBC driver (which is available on Maven Central). On Windows with JRE 1.8, everything is fine, but when I run either on our build server or in WSL Ubuntu with OpenJDK 11.0.3 it refuses to connect to the datab…
JPA and 1000 ID use in Oracle IN Operator
I use NamedNativeQuery for delete rows, and it’s somthing like this: But How i can use more that 1000 userIds with IN Operator at Oracle where clues? P.S: I’m looking for a solution to handle it in one commit; Answer Working around the IN limit is inefficient and JPA is not always the right tool f…
Java Entities Dates fields and Oracle TIMESTAMP data types
In my entities classes I use to define the temporal fields as follows: In my oracle DB the columns mapped by those fields are of type TIMESTAMP. What are the implications of this configurations: Are my dates implicitily UTC dates ? Does it mean I have to be careful on handling by myself Daylight saving time i…
java.sql.SQLException: ORA-01005: null password given; logon denied
I’m getting the follwing exception while trying to connect to a database: here the method used to get the connection: But even when the params (url, password..) are hardcoded, I still get the exception. Could you tell me how to fix this problem ? thanks Answer it appears the problem is linked to the …
Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found
I work with Spring and Hibernate and I used Oracle 11g as database and I used JBoss 5. I have a problem to re-establish the connection automatically I used c3p0-0.9.1.1.jar This my config in my application : But I have this error : my application works correctly using the previous database configuration but m…