Questions tagged [jdbc]
JDBC (Java DataBase Connectivity) is the base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language.
33,421
questions
0
votes
0
answers
5
views
SSL error: "Connection reset" when connecting to a database in RazorSQL
Seemingly sporadically, I am receiving the following error when attempting to connect to a database in to RazorSQL:
`ERROR: An error occurred while trying to make a connection to
the database:
JDBC ...
-1
votes
0
answers
24
views
Executing an Oracle function which returns Cursor in JDBC
I have here an Oracle DataWarehouse and have to execute the following function:
function getUserSelection(
p_userID in number,
p_userDate in date,
p_userCompany in string,
p_mode in number ...
0
votes
0
answers
19
views
getting different boolean values while connecting to sql server
DatabaseConnection.kt
import java.sql.Connection
import java.sql.DriverManager
import java.sql.PreparedStatement
import java.sql.ResultSet
class DatabaseConnection {
fun validateUser(username: ...
0
votes
0
answers
21
views
Trying to update table using PreparadStatement, But parameters are generated inside a Parentheses
Using JDBC connection in Java framework, Am updating column values my lfvadd table.
this is my sample code :
PreparedStatement pst = null;
String sql = ("UPDATE lfvadd SET recipe_name = ? WHERE ...
0
votes
0
answers
27
views
oracle throws exception with message "Caused by: oracle.jdbc.OracleDatabaseException: ORA-06503: PL/SQL: Function returned without value"
I have code that call Oracle funqtion:
public Map<String, Object> canRefuse(int val) {
SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(jdbcTemplate)
.withSchemaName("...
0
votes
0
answers
27
views
GraphDB JDBC - from python?
I'm trying to setup a way to execute SQL queries on GraphDB pre-configured JDBC tables. I got it to work using a SQL engine like SQuirrel SQL Client, but so far I have not been successful in Python. I ...
0
votes
0
answers
15
views
I can't connect dBASE to pentaho. I have task to connect dBase database to pentaho to do ETL but i have this error while connect
When I connect to dBASE on petaho, this error keep coming
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Driver class 'sun.jdbc.odbc.JdbcOdbcDriver' could not be found, make sure ...
2
votes
1
answer
39
views
Issue with JDBC_PING after I updated keycloak version from 19 to 25
I'm using JDBC-PING discovery for distributed caching in my Keycloak container in AWS ECS. Recently I have updated the Keycloak version from 19 to 25. All the things are working perfectly, except for ...
0
votes
1
answer
16
views
Databricks & JdbcTemplate query error when parameter is a boolean
On Java 17, latest databricks-jdbc dependency, Spring 5.3.20
When I use JdbcTemplate to query a table and one of the parameters is a boolean, I get an error message:
Query: SELECT rowkey, sendReminder ...
-1
votes
0
answers
29
views
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver in Eclipse dynamic web project [duplicate]
creating simple dynamic web project. I am facing the exception class not found in my servlet, even after I added my jar file.
the project works fine earlier, but after deleting my server and adding it ...
0
votes
1
answer
17
views
How to connect and query Neo4j Database on Apache Drill?
I am using Apache Drill and Neo4j Database for a project. The database needs to be connected to Drill and I should be able to query the data from Apache Drill.
I have copied and pasted neo4j-driver-4....
0
votes
0
answers
39
views
JDBC passing connection or opening a new one [closed]
Its going to be a newbie question, but I haven't found any satisfying answer on the internet. I work with JDBC and db2. How do I know, when to reuse the connection (pass it as parameter in method), ...
-2
votes
0
answers
21
views
Docker(Not able to Connect mysql databse to docker file) [closed]
I am working on a project where I need to connect my root.war web application to a MySQL database using Docker. I have already created the Docker images but am unsure how to connect the MySQL database ...
0
votes
0
answers
35
views
How to execute SQL statements against on premise Oracle DB in AWS Glue
I am trying to update a table in my Oracle DB using AWS Glue. I know that PySpark is not really meant for updating tables or inserting. More for reading. Though, I am trying to update all rows for a ...
0
votes
0
answers
32
views
JDBC : UTF-8 Characters not getting stored in SQL table in right format
I am trying to write a dataframe in SQL table which is having some extended ASCII characters like 'em-dash', pound symbol. But same is not getting written in DB table, showing some junk characters ...