Score of -1

0 answers

62 views

Using DbSchema Salesforce JDBC drivers with DataGrip

How can I use the DbSchema open source JDBC drivers with the JetBrains DataGrip DB IDE? I cannot work out how to add the collection of JAR files in the downloadable zip to DataGrip and then how to get ...

Score of 1

1 answer

158 views

Delete Query working in SQLYog, but not in Java [closed]

@Override public String getDeleteQuery() { return "DELETE FROM prod_evidencija WHERE idProdavac = ? AND idProdavnica = ? AND datum = ?"; } @Override public void ...

Score of 0

1 answer

103 views

Client does not support Authentication Protocol

Im running the Java file in vs code I'm getting exception like java.sql.SQLException: Client does not support authentication protocol requested by server, consider upgrading MySQL client. Im using ...

Score of 2

1 answer

126 views

Is it possible to run an Oracle package to create a table via JDBC

I am trying to move a database creation process from SQL plus to JDBC. I need to run a bunch of processes attached to Oracle packages. BEGIN ddl.column('table_name', 'column_name', 'type') END I ...

Score of 0

1 answer

101 views

How can I apply a streaming parameter from Java into an Oracle BLOB?

I want to search an Oracle table by a Blob using streaming. This example runs well in DB2, SQL Server, PostgreSQL, and MySQL, but it fails with an error in Oracle. I have the following table: create ...

Score of 0

4 answers

181 views

Oracle, PL/SQL and Java

I’m a PL/SQL developer with strong Oracle experience, interviewing for a role in a Java-based team. They’re happy with my database skills but want me to learn few Java skills before the next round. ...

Score of 6

2 answers

140 views

Cross-vendor BYTEA / BLOB fetch

PSQLException gets thrown when calling resultSet.getBlob(String) (with NumberFormatException as the cause). The column is of type BYTEA since there are no Blobs in Postgres. Bad value for type long : ...