All Questions
22,656
questions
0
votes
0
answers
27
views
How to catch the PSQLException exception? [closed]
How to catch the **PSQLException ** exception? I am using Spring boot JDBCTemplate and it can throw a PSQLException exception. Using try-catch, I get this message from IDEA: "Exception 'org....
0
votes
0
answers
36
views
Unable to Connect to Azure SQL Server Database Using JDBC Driver in Android App
I'm developing an Android app and trying to connect to an Azure SQL Server database using the JDBC driver. I'm encountering a java.lang.AssertionError related to SSL/TLS communication. Below is the ...
0
votes
0
answers
36
views
Call PL/SQL from JDBC has different behaviour with OracleConnection and Connection
I need to change package variable using JDBC and get new value back.
Oracle package:
create or replace package test_pkg
as
test_num number := 10;
end;
When I do it via java.sql....
-1
votes
1
answer
23
views
Issue with Changing @Table Annotation to "users" in JPA Entity Class Using H2 Database
I'm encountering an issue with my Java application where changing the @Table name in my entity class causes the application to fail during tests and runtime. Here are the details:
Originally, my ...
0
votes
0
answers
23
views
Error with MSAL4J in RJDBC with ActiveDirectoryMSI
I am trying to establish a connection in Mac via the company portal with R. I am basically trying to copy a connection that actually works with DBeaver, using RJDBC.
It returns this error:
Failed to ...
-1
votes
0
answers
55
views
Java SQL Exception: No suitable driver found for jdbc:mysql [closed]
I am making a Object Detection app which uses YOLOv8 for Detection and Java for the GUI. This is being made as a college project and I was just told that I need to add a database into it but due to ...
0
votes
1
answer
41
views
Java type in JDBS PreparedStatements for Postgresql ltree[] (Array of ltree elements)
I have a JDBC Prepared Statement that take a parameter of ltree[], the hierarchical tree-like data type in Postgres.
My goal is to query multiple entries from my_table, where the path is ltree type ...
0
votes
1
answer
44
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 ...
-1
votes
0
answers
31
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 ...
1
vote
0
answers
59
views
No suitable driver found for jdbc:mysql://localhost:3306/ and ClassNotFoundException [duplicate]
I'm trying in Java to establish a connection to mysql. When I run my program I get an error that No suitable driver found for jdbc:mysql://localhost:3306/bot. I've searched on the internet and found a ...
-2
votes
0
answers
25
views
Ho to connect to MySQL database in net beans using Java [duplicate]
Below is a block of code I wrote to connect:
public class JavaDBConnect {
private static final String DB_URL = "jdbc:mysql://localhost:3306/employeeinfo";
private static final String DB_USER ...
0
votes
0
answers
34
views
Delete DB entry for type text[] from PreparedStatement
our postgres DB define entry column as data type text[]
Some DB entries are as below
And now we want to delete DB entry based on Provider and Content
Provider
Content
A
{abcd}
B
{abcde}
SQL ...
0
votes
1
answer
48
views
Unable to (re)connect to Informix DB: Failed to get Connection.Connector(NOT CONNECTED: Driver=NO_JDBCDRIVER_PROVIDED;))
I hope someone can shed some light on this pretty old informix DB connection problem running on a very outdated Cisco Call manager 6.1 server (the PUB machine with one functional SUB machine). After ...
2
votes
0
answers
64
views
How do you cancel a long-running MySQL query via JDBC?
I have a long-running query that I run against a MySQL 8 database via JDBC. My goal is to be able to exit this query on some trigger (e.g. external signal, data processing error, etc.) and have the ...
0
votes
0
answers
21
views
ORM connection behaves differently for two different codes
I had two different codes and I needed to make an ORM connection and create a table out of the given code:
code 1:
package com.scm.entities;
import jakarta.persistence.Column;
import jakarta....