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

learn more… | top users | synonyms

4
votes
2answers
2k 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, ...
1
vote
2answers
41 views

Causing ORA errors in a program using JDBC. How can I find what's causing them?

So I'm building a java app to interface with the company's database. Whenever it causes an ORA error, it just prints something like the following to system output: ORA-00911: invalid character Is ...
0
votes
2answers
70 views

What is wrong in my jdbc config pool?

I am using clearDB with max_connections plan being 40. This is my jdbc pool configuration: <bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource" destroy-method="close" ...
5
votes
1answer
80 views

Measure Performance for INSERT, UPDATE and DELETE commands on DB2

I have a DB2 database with a table for daily transactions, which is cleared to a history table at the end of the day, every day. I insert rows to this table via java-JDBC INSERT commands and they ...
4
votes
1answer
102 views

Using SELECT to call a function in a jdbc migration

I'm looking to set up some Postgres/PostGIS migrations with clojure/jdbc. running side-effect functions with SELECT is proving to be an issue, with most migration libs eventually throwing the A ...
2
votes
1answer
247 views

How to connect DB2 with eclipse on mac?

I tried to connect the DB2 Express-C Version 10.1 to Eclipse Mars but it returns an exception when I tried to run the program. com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: Error ...
1
vote
1answer
9k views

JDBC pooling Oracle driver Socket read timed out

I run Java EE application on Glassfish server v3 together with Oracle 12 DB on the same machine under Windows Server 2012 64bit. I use latest ojdbc7 driver. Connection pool config: ...
0
votes
1answer
609 views

Tomcat7 JDBC connection pool -> Connection has been abandoned

I have the following configuration for the JDBC connection pool initialSize="2" minIdle="10" maxIdle="50" maxActive="100" maxWait="15000" ...
0
votes
1answer
218 views

JDBC Exception JZ0BE: BatchUpdateException: A user with System Administrator (SA) role must reconfigure the system to enable Java

I am using Sybase JDBC JConnect3 driver to insert large data in a table using Batch Insert feature of JDBC. I am preparing a batch of 100 inserts and executing the batch. But it is throwing below ...
3
votes
0answers
193 views

Unable to Update on SQL Server 2008 R2

This is a bit strange so bear with me please. After installing a new SQL Server 2008 R2 on a new server (Windows 2012 Standard) just like the production one, I tried to connect my web aplication ...
2
votes
0answers
180 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 ...
2
votes
0answers
130 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
29 views

MySQL/JDBC: Can a commit on server get missed on client?

I am wondering about when conducting a transaction of one or two updates/inserts from a JDBC client to MySQL Server over the network... In the event of losing the network during the commit, can I get ...
1
vote
0answers
8 views

JDBC - maximum allowable cursors - how do I see my open statements?

I've got some resource leaking and I'm trying to find what's causing them. I think I have some statements or resultsets that aren't being closed properly. Is there any way to see all of the cursors ...
1
vote
0answers
52 views

oracle DB connection - hostdef extension doesn't exist

I am trying to connect to an Oracle DB through ERwin, yet I keep getting this error message: I know that the DB exists, as my coworkers are accessing it. The Username and Password are also correct, ...
1
vote
0answers
516 views

MySQL SSL using MariaDB JDBC Driver

We have the following setup: Ec2 instance running a jboss server with mariadb (1.1.7) datasources setup to connect to an rds instance running MySQL 5.6.21. We would like to turn on SSL on for this ...
0
votes
0answers
8 views

JDBC Statement vs. Prepared Statement SQL Injection

as far as I understand a "normal" JDBC Statement which is created via conn.createStatement() is prone to SQL-Injection. A prepared statement protects from such attacks. So why/when should I use a ...
0
votes
0answers
39 views

Mariadb Prepared Statements stopped working, they were OK last week, I need help locating the issue

I have a number of stored procedures that were working perfectly well last week, but this week are causing me problems. The first problem is I seem to be getting the following: Mariadb SQL ...
0
votes
0answers
52 views

SQL Server doesn't send intermediate SSL certificates

I am connecting to SQL Server (2008 R2) over open Internet and properly encrypting the connection is essential. I have COMODO certificate with two intermediate certificates between root CA and server ...
0
votes
0answers
168 views

Postgres Public Synonym Issue

PostgreSQL ver 9.4.5. Linux OS. Application: Web Based Platform: App Server (java) --> jdbc call --> Database Server (PostgreSQL) I do know that PostgreSQL does not support the public ...
0
votes
0answers
17 views

how to disable a mysql database for specific time

In my application there was an exception on run time when due to some network issue database connection not created and application closed. To trace this in my application at runtime I need to disable ...
0
votes
0answers
15 views

Oracle Database keeps JDBC pooled connections on DRCP configured port as dedicated

Our developers have had an application in java that connects to the database and JDBC was controlling their connection pools. To comply with pooling requirements for our PHP developers, we enabled ...
0
votes
0answers
404 views

JDBC Connection Reset Error

I'm trying to connect to my database from my application server using regular JDBC connection string and while connections are happening most of the times, say 10 times but the 11th time it hangs and ...
0
votes
0answers
14 views

sqoop dir not found in hortronworks virtualbox

when trying to copy sqljdbc driver to /usr/lib/sqoop/lib it gives error cannot create regular file 'usr/lib/sqoop/lib/' No such File or Directory exist any idea what is missing? downloaded ...
0
votes
0answers
15 views

JDBC - accessing a query, then querying that query

Sorry if the way I phrased that is confusing. I'm writing a program that acts kind of like a filter - it retrieves an answer to a query, counts the rows, then I want to do a slightly more narrow ...
0
votes
0answers
27 views

PostgreSQL updates hang when two servers involved

I have an update statement that works fine when only a single server is involved, but never completes when it comes from two servers. I'm connecting with JDBC 9.1-902 to a 9.3 database on CentOS 6.6. ...
0
votes
0answers
153 views

sql taking < 1 sec to run in sql developer, 37 on the application side

As the title says, we have a big discrepency between a sql query we're running from our java application (jdbc thin client) and the same query run in sql developer. I clear the cache of the query ...
0
votes
0answers
364 views

How do I connect to oracle apex server through JDBC ?

I have got a workspace in apex.oracle.com , Now , I want to connect to that database through JDBC from ubuntu-14.04 machine. please explain the steps , From where should I download the drivers and ...
0
votes
0answers
471 views

Install JDBC driver 4.0 for SQL Server

How can I confirm that JDBC is running and properly configured/registered in the system? I followed the installation instructions but I believe there has to be more to it than what the instructions ...
0
votes
0answers
202 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
535 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
441 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 : ...