Java Database Connectivity (JDBC) is a Java standard that provides the interface for connecting from Java to relational databases.

learn more… | top users | synonyms

3
votes
1answer
419 views

How to separate out individual sql statements from Oracle SQL script for execution from java code

I have Oracle DB 11g Enterprise Edition and I want to execute sql script from my java code. I am reading this sql script from a .sql file and the script contains statements such as create table, ...
2
votes
0answers
241 views

Insert Speeds for large batches

In my application, my INSERTs seem to be taking a major chunk of the time. I have a large number of objects in memory (~40-50,000) which i want to insert into a table. Lets take a sample table ...
2
votes
0answers
357 views

To what extent is MariaDB Java client a perfect replacement for MySQL JDBC (Connector/J)?

Premise: I ship a Java application which will make a JDBC connection to a MySQL database. (At the time of this writing it could be 5.1 or 5.5, but hopefully the question and answer don't rely heavily ...
2
votes
0answers
80 views

Wanted: Android versions of JDBC drivers for common RDMBSes

I've got a Java-based application library I'm trying to port to Android. The package presently supports: Oracle Informix DB2 Postgres Sybase ...And can easily be configured to use any other SQL92 ...
1
vote
0answers
43 views

Is there a way to detect if there is an uncommitted transaction in H2?

I am using an H2 database with JDBC to create a connection with setAutoCommit(false). I am currently programatically checking whether or not there is an uncommitted transaction, but I was wondering ...
0
votes
0answers
10 views

Does mariadb provide a Type 2 driver?

I could not find any details about mariadb type 2 driver. Does db support type 2 driver? I'm asking this for learning purposes.
0
votes
0answers
94 views

ORA-12516 but max_utilization not reaching limit

Our app began to raise ORA-12516, TNS:listener could not find available handler with matching protocol stack errors, and I'm trying to diagnose why. The workload has not changed, so I think we might ...
0
votes
0answers
117 views

Is it possible for JDBC thin client connection to use DNS autodiscovery to identify LDAP server?

I've set up an OpenLDAP server for Oracle Net Service Name resolution. This is working well for both Oracle client connections, as well as JDBC thin client connections. In the case of Oracle client ...
0
votes
0answers
25 views

How Oracle DB maintains client identification

I know in 'dedicated server' mode we have one user process for each client and pool of user process in 'shared server' mode. in either case How oracle maintains the client identification ? Please ...
0
votes
0answers
188 views

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure when executing Large queries

i am using hibernate 3.0 in my web application and using Mysql as the database. everything is working fine in normal circumstances, but the problem arises when i am trying to execute a large query ...
0
votes
0answers
200 views

SSPI handshake failed with error code 0x80090308 connection to Sql Server 2008 R2

I have a cross domain situation where the SQL Server 2008 R2 server sits in one domain and the client in another. There is a one-way trust between the domains. The SQL Server runs on a domain account. ...
0
votes
0answers
112 views

How to enable SSL in MySQL on Windows?

I'm a student doing a project which uses JDBC and MySQL (on Windows). I have an application with connects to a MySQL server on a remote host. To have a secure connection, I found this : ...