Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [jdbc]

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

0
votes
0answers
14 views

jdbc connection to Mysql outside of VPN

This is a replica of my SO question I have a public accessible Mysql instance and i am trying to access it behind a clients VPN. So, on the VPN I was granted access to the DB, so by doing mysql -h ...
1
vote
1answer
22 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
2answers
3k 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 ...
1
vote
1answer
239 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
0answers
14 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....
1
vote
1answer
4k 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
0answers
538 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 ...
0
votes
1answer
320 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
0answers
497 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
1answer
122 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 ...
0
votes
2answers
13k 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
1answer
155 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,...
3
votes
1answer
10k 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 ...
0
votes
1answer
1k 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 ...
1
vote
1answer
5k 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 ...
0
votes
1answer
6k 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
1answer
952 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
2answers
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 ...
0
votes
1answer
123 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
1answer
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 ...
6
votes
1answer
22k 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
1answer
1k 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
2answers
212 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
1answer
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
1answer
547 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
1answer
711 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
1answer
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 ...
3
votes
1answer
7k 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>>:...
0
votes
1answer
349 views

WebLogic JDBC - Profile Harvest Frequency Seconds

In the company I'm providing consulting services, when the database is updated by a process outside Weblogic Web Application, the updated data is not refreshed at once. Googling a bit I've found the ...
7
votes
2answers
3k 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
1answer
360 views

Installed JDBC drivers into Solr

I am running Solr4 on Jetty9 and I am trying to include the JDBC drivers for both MySQL and PostgreSQL. I'm a little confused about how I do this. I believe these to be the two files I need: http:/...
1
vote
1answer
412 views

Solr list all records but fq matching records first

I’m using solr 4.0 with DIH jdbc connector. I have a field named code with multiple values separated by semicolon(;). I am trying to list the search results which matches the field query(fq) to be ...
0
votes
2answers
560 views

Set up JDBC DataSource in LDAP

How do I create a JDBC DataSource in an OpenLDAP server? The problem is that jdbc/something is not a valid DN or RDN. But that is the format of the name that you are supposed to use for JDBC ...
-2
votes
1answer
641 views

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 (...
2
votes
0answers
1k views

mysql client can't read query result?

So I have this machine running an XMPP server which connects to its MySQL database. When I start load-testing it, all goes fine up until after about 500s when I notice: Caused by: com.mysql.jdbc....
0
votes
2answers
349 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
3answers
5k 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
1answer
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 ...
-2
votes
1answer
2k views

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 ...
1
vote
1answer
455 views

GlassFish cluster-targeted jdbc is not enabled

I have a GlassFish cluster. When I tried to add node and a instance, DAS saids a bunch of error messages telling Resource [ jdbc/xxxx ] of type [ jdbc ] is not enabled [#|2012-11-14T12:07:04.318+...
7
votes
1answer
5k views

HAProxy, client timeouts when connecting from JDBC pool

I have a webapp (Tomcat/Hibernate/DBCP 1.4) that runs queries against MySQL, and this works fine for a certain load, say 50 queries a second. When I route the same moderate load through HAProxy (still ...
0
votes
2answers
170 views

ColdFusion8 FusionReactor JDBC wrapper - bad driver jars?

I'm having trouble getting the JDBC wrapper tool to wrap my ODBC connections. Before the version that came out today, it wouldn't even run due to a compatibility issue with CF8. Now it's saying ...
4
votes
1answer
2k views

What is the best JDBC connection URI for AWS RDS instances?

When using an Amazon Web Services RDS instance from a Java application, what is the best JDBC connection string? It should tolerate the instance falling over to the standby. AWS handles flipping the ...
1
vote
1answer
2k 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. ...
1
vote
2answers
540 views

What's needed to enable JDBC or ODBC to MySQL database?

I have a MySQL server on my Scientific Linux 6.2 system. Right now I know how to create a new database, and set up users. I need to setup LibreOffice Base to connect to the MySQL server, via either ...
0
votes
1answer
1k views

Setting up MySQL server on LAN to be used with JDBC

I'm creating an application with client-server architecture in java. What I'm trying to achieve is a simple client-server architecture connected via LAN with an ethernet switch, the server is having a ...
2
votes
1answer
3k views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
1
vote
1answer
938 views

Performance factors in remote database access

I have a Java application which accesses a database. I tested it on my local machine with local database and it works just fine. But when I test it in our test environment where the application server ...
0
votes
1answer
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 ...
1
vote
0answers
853 views

Intermittent java.sql.SQLException: ORA-03120: two-taskconversion routine: integer overflow exception

I get the following error intermittently when my spring app starts up. I am using oracle with dbcp pooling as my datasource bean in spring. Caused by: org.apache.commons.dbcp.SQLNestedException: ...