Base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language
Questions tagged [jdbc]
90 questions
0
votes
2 answers
JDBC CLASSPATH Not Working
I'm setting up a simple JDBC connection to my working MySQL database on my server. I'm using the Connector-J provided by MySQL. According to their documentation, I'm suppose to create the CLASSPATH variable to point to the directory where the…
AeroDroid
- 101
- 1
0
votes
1 answer
JDBC not seeing updated table structure
I am using Coldfusion 8 which is connecting to SQL Server 2008, the problem is I have updated a table adding a new column in SSMS, but the JDBC connection is still 'seeing' the table prior to the change. How can I essentially 'refresh' the JDBC…
cas06d
- 125
- 1
- 5
0
votes
3 answers
JDBC Communication link failure. iptable setup
I have a java application that runs on my work machine, but wont connect on the production server.
Heres the connection code:
String db = "jdbc:mysql://localhost:3306/"+database+
"?zeroDateTimeBehavior=convertToNull";
connect =…
DrDipshit
- 101
- 3
0
votes
1 answer
How to set JBOSS/JDBSC to cach the MySQL server settings?
Is it possible to set JBOSS/JDBC's MySQL connector to cache the server's settings so that I won't get a big bunch of "show variables" connection all the time?
I think there is a similar settings under Glassfish called CacheServerConfiguration but I…
blacklotus
- 85
- 6
0
votes
1 answer
Does MySQL/JBOSS/Tomcat/JDBC have a 20 process limit?
Reason for asking this is that, I have been firing around 200 concurrent connections via SOAP to a web service, and in MySQL, I have never seen more than 20 connections being processed at a time.
My MySQL settings are as…
blacklotus
- 85
- 6
0
votes
1 answer
how to connect and select data from a JDBC over RMI database in perl?
I have a 3rd party application that exposes in-memory data structures via a JDBC api over RMI.
How can I get data out of that database api without having to run squirrel or similar GUI application?
Perl solution preferred, but java solution…
ericslaw
- 1,562
- 2
- 13
- 15
0
votes
5 answers
How to connect to oracle server in java?
I am trying to connect to my friends Oracle server. But while connection I am getting error please help.....
JDBC…
Hariharbalaji
- 103
- 1
- 1
- 3
0
votes
0 answers
SQL Server JDBC Drivers installation on JBoss EAP 7.3
are the commands below correct? if no what is the correct way to install the module properly
module add --name=com.mssql--resources=[PATH]…
Loksy
- 1
0
votes
1 answer
connect Crystal Reports with JDBC to PostgreSQL
I want to connect Crystal Reports (2016, Support Pack 8, version 14.2.8.3426) to a PostgreSQL 12 database. Using JDBC. The database is on my local computer, on port 5433. My database name: ogc which is in public schema.
I have downloaded the…
Maas
- 1
0
votes
2 answers
Building a jar with MySQL jdbc on solaris
Im building a java application that uses JDBC to connect to MySQL. I have an ant script that compiles my code and then packages it, along with log4j, junit, libshout-java and the mysql jdbc driver into one executable jar. This all works fine on…
Mark
- 553
- 6
- 14
0
votes
0 answers
JDBC performances using AWS RDS instance / Tomcat
I'm using RDS MySQL database for both preproduction and production environment but I'm facing performance issues on the production server while accessing RDS instance through JDBC (db.m5.large) with a Tomcat server (Apache Tomcat/9.0.26).
Here is…
tiamat
- 103
- 4
-1
votes
1 answer
MySQL JDBC compression in transit
Good morning,
I am looking to set my application connection to MySQL to compress data in transit.
I read MySQL doc. but it's not cleat to me if I need to do something on the client side, on the server side, or if even it's possible. I know that…
yield
- 731
- 1
- 8
- 24
-1
votes
1 answer
MySql benchmark written in Java
I want to compare the performance of two MySql servers.
Since we are accessing the database using Java/JDBC, the benchmark should be written in Java.
It does not have to be MySql specififc, any compatible JDBC program will do.
Oh, and it should be…
user27451
- 1,151
- 2
- 10
- 14
-2
votes
1 answer
Can't get jmeter-server to work correctly with jdbc:mysql driver
I am running jmeter-server on a remote database host (Centos, sun-java 1.6). I dropped the MySQL java jar in $JMETER_HOME/lib per the install instructions. When I try to run a job on my local system (OS X Lion), I get the following error on the…
Cesar
- 173
- 6
-2
votes
1 answer
Alfresco couldn't start. Why?
I have alfresco on my VM. When I try to start alfresco I got an error "postgresql could not be started" such as following :
/opt/alfresco/postgresql/scripts/ctl.sh : postgresql could not be started
Using CATALINA_BASE: /opt/alfresco/tomcat
Using…
Muhammad Sholihin
- 144
- 2
- 8