Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [jdbc]

Base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language

92 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,572
  • 2
  • 13
  • 15
0
votes
1 answer

JDBC To DB2 for i is Slow when host server is Windows 2019 or 2022

This is a strange issue. I am trying to get a server upgraded from Windows Server 2016 Data Center to anything newer. We have tried 2019, and 2022. This server is an ETL server for running Talend Open Studio, it is a connection between MS Sql Server…
jmarkmurphy
  • 171
  • 7
0
votes
0 answers

Denodo/VQL ISO_WEEK

In Denodo, I wanted to work with iso week. There were no functions or calculations that I could find. I wanted to use the following code: GETWEEK("ISO WEEK", ADDWEEK(CURRENT DATE(), 1)) returns the current week. There is, of course, no ISO WEEK…
hemanth4
  • 1
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
1 answer

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
  • 11
  • 2
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
  • 573
  • 6
  • 15
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
  • 1
  • 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
  • 771
  • 1
  • 9
  • 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,161
  • 2
  • 11
  • 14
1 2 3 4 5
6
7