All Questions
7,395
questions
0
votes
0
answers
25
views
Unable to insert Mirth logs in MySql DB using log4j 2.17.2 JDBC appender
I'm using Mirth Connect, which uses log4j 2.17.2. I have tried to insert Mirth logs in a MySql DB using the log4j2 JDBC appender but failed to do so. Mirth Connect runs and logs to the dashboard and ...
0
votes
0
answers
20
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: ...
-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 ...
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 ...
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....
0
votes
0
answers
45
views
Issue: java.sql.SQLException: Column 'y0_' not found During High Database Load
I'm encountering an issue where the error java.sql.SQLException: Column 'y0_' not found appears, especially under increased database load. This error is intermittent and seems to correlate with high ...
-1
votes
1
answer
27
views
shardingDataSource bean not being created
When I was using spring2.5, my setup was as follows:
To read configurations:
@Configuration
@PropertySource({ "file:/etc/appconf/project/sharding/app-rule.properties"})
public class ...
-1
votes
1
answer
38
views
How do I connect to my database from Java/JSP when upgrading to Jakarta?
I am trying to migrate code that I wrote 15 years ago to a new server.
One of the changes is the javax.* package naming changed to jakarta.* naming as part of Oracle transferring Java EE to the ...
0
votes
0
answers
26
views
How can I solve my error involving JDBC when I try to login?
I am trying to implement the login functionality as follows:
<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@taglib prefix="t" tagdir=&...
0
votes
0
answers
32
views
Using CONCAT function in Java ComboBox problem
I'm currently developing a Car Rental System (just for fun and practice) and my problem is when I choose a car in my "Add Transaction" feature, it should be adding the transaction to the ...
1
vote
2
answers
119
views
How to programmatically interact with both a MySQL 5 database and a MySQL 8 database from a single project?
My goal is to periodically sync data between two databases. One is a "new" database which runs MySQL 8, the other is an "old" database that hasn't been fully decommissioned yet ...
0
votes
1
answer
71
views
How to setup Utf-8 for MySql on Ubuntu?
I have the next table:
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+----------------------...
0
votes
1
answer
43
views
In MySQL, how can I create a stored procedure to create the database itself and then call this procedure from Java using JDBC?
I'm developing a Java application and need to write a separate stored procedure in MySQL to create a database itself by query:
CREATE DATABASE IF NOT EXISTS db_name;
I tried this one:
DELIMITER //
...
1
vote
0
answers
23
views
Tomcat Connection pool to Forge MySQL
My Database happens to be hosted on https://forge.laravel.com/ They appear to be using MySQL8 if that makes a difference. I'm writing a Tomcat application from which I would like to connect to this ...