Questions tagged [jdbc]
Base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language
92
questions
1
vote
2
answers
619
views
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 ...
3
votes
1
answer
4k
views
ORA-12705: invalid or unknown NLS parameter value specified
I have a J2EE application hosted on JBoss on Linux.
When I try to access the application, I see following error in the server.log file.
ORA-12705: invalid or unknown NLS parameter value specified
...
2
votes
1
answer
10k
views
Weblogic JDBC connection pool keeps in suspended state when DB is back to normal
We have a JDBC connection pool on a weblogic 12c. When the backend database goes to offline, the pool goes into suspended state, and when the db is back online after a short period of time (say 5 min),...
0
votes
1
answer
110
views
Getting below error on ActiveMQ "Classic" message broker log. I'm looking for some solution to find the root cause and fix for this issue
Getting below error on ActiveMQ "Classic" message broker log. I'm looking for some solution to find the root cause and fix for this issue.
Sep 6 16:10:46 SERVER activemq_db8159[1168628]: ...
2
votes
2
answers
3k
views
On a system with fapolicyd enabled, how do I permit Java to run sqlitejdbc.so, which has a unique filename at each start?
My issue is fairly similar to this one: I have a Java application running on Rhel 8 that relies on an sqlite-jdcb driver. Unlike in that issue, my issue isn't with my filesystem being mounted with ...
0
votes
1
answer
521
views
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] --dependencies=javax.api,javax.transaction.api
/subsystem=...
0
votes
1
answer
2k
views
Solr: Using multiple SQL server data sources results in error: "...\sqljdbc_auth.dll already loaded in another classloader"
I have one Solr instance running in Jetty with JRE 8 with 3 collections (same as cores, yes?) and more to come. I am indexing data from SQL Server, connecting using NTLM as the identity of the Java ...
0
votes
1
answer
2k
views
PostgreSQL + JDBC: parse too slow on first query
I use Aqua Data Studio in OS X to make queries in a PostgreSQL server, but the first query of the day runs too slow.
It not depends on the SQL, a simple SELECT current_timestamp will parse and ...
0
votes
1
answer
2k
views
FileMaker Server not listening on Port 2399 for ODBC/JDBC
I am trying to create a ODBC connection from an OSX machine to a Filemaker server 10 using a DataDirect SeQuel Link 5.5 JDBC drive. I have ODBC/JDBC enabled on the server and I followed all of the ...
0
votes
1
answer
1k
views
Install Apache Derby on CentOS 6.4
I'm not a Java developer, my knowledge is very limited to this topic. I want to deploy a .war webservice on my Tomcat server, which fails most likely because of its Derby dependency (just a guess from ...
-1
votes
1
answer
601
views
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 ...
1
vote
0
answers
68
views
Getting the connection pool properties
I have set up a connection pool in tomcat's server.xml and context.xml.
I am using the below code to establish a connection.
DataSource ds = (DataSource) context.lookup("jdbc/TestDB");
ds....
1
vote
1
answer
3k
views
How to use JDBC Connection Pooling without JNDI DataSource? (in Apache Tomcat)
I have an Apache Tomcat 7 server. I have a quite complex Java Servlet application running on it which needs some MySQL queries per POST. Thus I need a MySQL Database connection to do the query. ...
0
votes
1
answer
2k
views
Gather WebSphere Thread Pool Utilization Data In A Text File
I am running a WebSphere 8.x cluster and would like to be able to more closely monitor my JDBC connection pool utilization. All I basically want to do is run a script every couple of minutes that ...
0
votes
1
answer
1k
views
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 ...
2
votes
2
answers
2k
views
Can't connect to Amazon RDS MySQL
I'm trying to connect to RDS MySQL from linux machine. When I test the connection with telnet, the telnet session succeeds but when I'm trying to connect to the db with the next command
mysql -h ...
1
vote
2
answers
13k
views
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'springbootdb.users'
I have a VM running an MsSQL database. I was previously using an Oracle database. My app injects some sample data on startup and I get this error:
Caused by: com.microsoft.sqlserver.jdbc....
0
votes
0
answers
736
views
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 ...
1
vote
1
answer
2k
views
Tomcat - how to store sessions in DB immediately?
I'm experimenting with tomcat JDBCStore-based session persistence and wonder whether there is a way to make tomcat store sessions in DB as soon as possible?
I've tried to play with minIdleSwap and ...
0
votes
1
answer
761
views
Connecting to RDS Postgres via jdbc & c3p0 unable to acquire from the underlying database
Trying to connect from an application using C3P0 and the latest Postgresql JDBC driver 9.4.1211.
We want the connection string to be SSL and have an MD5 hash password on the user account:
c3p0 {
...
1
vote
1
answer
326
views
Database Connections Persist After Security Group Change
We've set up a system to send a message to a queue in SQS when there's an outage on a dependency. In order to simulate an outage and test the system, I blocked the outbound port to a database on the ...
0
votes
2
answers
3k
views
How to make a JDBC connect to Crystal Reports with Postgres
I want to create a new report using Crystal Reports. I downloaded the Postgres driver but when I want to create the connection, it shows an error "JDBC Driver not found"
How can I solve it?
Thanks :)...
15
votes
2
answers
8k
views
Is there a way to monitor /dev/random?
We're investigating some JDBC issues, and one of the possible problems is /dev/random being exhausted. The workaround is to switch the JVM to using /dev/urandom, but I wan't to try and determine ...
0
votes
2
answers
8k
views
SQL Server 2014 enabling TLS 1.1 along with TLS 1.2
I have a Windows Server 2012 R2 which is a DC with SQL Server 2014 (Express) updated to the latest SP2 with CU10 12.2.5571.0 (testing environment).
I disabled all protocols except TLS1.1 and TLS1.2 by ...
0
votes
3
answers
7k
views
Cannot connect to mysql database remotely using jdbc
I am trying to connect to my database which is hosted on 000webhost. I am connecting from SmartFoxServer, and they allow database connections. All you have to do is change some of the settings in the ...
1
vote
1
answer
565
views
JDBC Oracle 12 allow jdbc outgoing traffic in firewalld
I'm installing an application which needs an Oracle DB on my server.
The DB is hosted on another dedicated server.
The application is using JDBC to connect to the DB.
I have tested the connection ...
0
votes
0
answers
37
views
encypted pasword for Tomcat server.xml JDBC Datasource
I have certain JDBC resources configured in my Tomcat server.xml file. Using those, I can connect remote databases.
For example
<Resource name="jdbc/hox" auth="Container" type="javax.sql....
0
votes
2
answers
31k
views
Name [ ] is not bound in this Context. Unable to find [jdbc] Tomcat Issues
I just created a fresh Oracle Linux 7 VM with Tomcat 7 and Java 8_40. I've created several servers with Apache and Tomcat before, but never connecting to databases before. SELinux and firewalld are ...
0
votes
2
answers
437
views
mysql, java, and MySQLTimeoutException
I've moved the mysql server on different machine in LAN, 16 core, 8GB RAM, and the same dreaaded result. During a load test, all is going well until around 300 seconds. There are 15 persistent ...
0
votes
0
answers
1k
views
MySQL Communications link failure periodically every 61 minutes
Interesting, strange problem.
Have a production system running an application distributed across multiple servers, which all read and write to a, separate, MySQL Server.
MySQL Server version 5.6.31
...
1
vote
0
answers
842
views
Create new MySQL connections when read-only status is detected - AWS RDS failover
Apache Tomcat/7, CentOS, AWS RDS Aurora 5.6.10a
AWS provides a cluster CNAME that at any time points to the writer instance of the cluster. e.g. dbname-cluster.cluster-id.us-west-2.rds.amazonaws.com
...
0
votes
1
answer
197
views
Oracle 8.x what combination of JDBC driver, Hibernate and Spring? [closed]
I'm working to a small project which must run on Tomcat6.
It's a small web application, that will use an old DB server which run HP-UX and Oracle8.
Now, after several combining config, I'm stuck at ...
10
votes
1
answer
44k
views
Does an SQL Server instance allow both secure and non-secure connections at the same time?
we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links:
How to enable SSL encryption for an ...
0
votes
1
answer
305
views
DB replication using BinLog
I am using mysql-binlog-connector to listen to any binlog event and then perform replication on the slave DB. My problem is that, the binlog registers event right after the execution and before commit,...
1
vote
1
answer
8k
views
ORA-12505, TNS:listener does not currently know of SID after changing port number
I am trying to change oracle tnslsnr port number from default to some other port. After I change port number for tnslsnr from 1521 to 2000 I start geting
ORA-12505, TNS:listener does not currently ...
2
votes
3
answers
5k
views
Configuring jdbc-pool (tomcat 7)
i'm having some problems with tomcat 7 for configuring jdbc-pool : i`ve tried to follow this example: http://www.tomcatexpert.com/blog/2010/04/01/configuring-jdbc-pool-high-concurrency
so i have:
...
5
votes
1
answer
22k
views
terminating connection because of crash of another server process
I have a java scraper that spawns around 1,500-2,100 threads, each of which connects to the same database via jdbc and makes inserts. These threads insert quite frequently.
It seems like the db ...
3
votes
1
answer
8k
views
MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client
I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string:
jdbc:sqlserver://<<db server name>>:...
3
votes
1
answer
2k
views
Impact on SQL 2000 performance of JDBC selectMethod=cursor
(Posted first on SO, but its not getting any answers there. Cross-posting to reach a larger audience, since it is cross-discipline.)
In the process of trying to help out an app dev team with some ...
0
votes
1
answer
174
views
WLS: Identifying the managed server where a DB session originates from
We are using WLS servers, on which we configure data sources (DS) and managed servers.
For failover reasons, our main application is depolyed on two separate managed servers (lets call them app_1 and ...
0
votes
5
answers
11k
views
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 code
Class.forName(oracle.jdbc.driver.OracleDriver).newInstance();
conn=...
0
votes
1
answer
971
views
Elasticsearch River JDBC - Avoiding 'SELECT *'
I'd like to syncronize some MySQL tables to an ElasticSearch index, you know, for search.
But almost every examples I can find show a big bad fat "SELECT * FROM", it's OK for an example, but I'm in ...
0
votes
2
answers
3k
views
JDBC Connection Pool details on Glassfish
In the context of configuring Session Beans for Entity Classes, I can get some basic information from Glassfish v4 on Ubuntu about the JDBC connection pool from the CLI with asadmin, but would like to ...
1
vote
1
answer
2k
views
Can't get Glassfish 3.1.2.2 to use anything other than jdbc/__TimerService for the EJB Timer Service
I am trying to set up a Glassfish cluster (1 DAS with a cluster that has an instance running on an ssh-node).
This is where I am:
DAS running
Cluster created
asadmin create-cluster cluster
Node ...
0
votes
2
answers
258
views
Configure MSSQL 2008 to use kerberos authentication
I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment .
The windows station is in a workgroup and I would like to avoid ...
1
vote
1
answer
2k
views
Monitor Tomcat-JDBC connections
The company that I work for sells a java web application that runs in Tomcat. The primary problems we have are that the tomcat containers become unresponsive and need to be restarted and that the ...
0
votes
1
answer
600
views
Connection to Amazon AWS highly unreliable [closed]
I have a Java application that connects to MySQL on an Amazon EC2 (USA east region) instance with JDBC (using official latest Oracle drivers, location specified by IP). It also connects to S3 using ...
0
votes
1
answer
928
views
Tomcat - JDBC Data Access Exception
My company has a web application that allows users as part of their business process to upload large documents (10+ MBs) into the application. For fast connections it works great with the document ...
0
votes
1
answer
2k
views
Is weblogic 10.3.6 data source connection pool maximum capacity per domain or server?
My WLS server is connecting to an Oracle DB that has a maximum concurrent connection limit of 3.
I have created a data source in WebLogic and set the "Maximum Capacity" value to 3.
Is this value ...
22
votes
9
answers
283k
views
Unable to connect to mysql through JDBC connector through Tomcat or externally
I've installed a stock mysql 5.5 installation, and while I can connect to the mysql service via the mysql command, and the service seems to be running, I cannot connect to it through spring+tomcat or ...