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

learn more… | top users | synonyms

0
votes
0answers
18 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
23 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
13 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 ...
4
votes
1answer
40 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
0answers
62 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 ...
0
votes
0answers
7 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 ...
1
vote
1answer
48 views

Can sequential queries result in concurrent transactions?

I'm using PostgreSQL 9.4.4 and the default configuration. I use a JDBC connection to run multiple queries in succession. Only one Java thread is using the connection and before a new query is executed ...
2
votes
1answer
127 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 ...
3
votes
1answer
36 views

Replacing a large object in PostgreSQL

What should one do when one wishes to replace a large object with a new large object. An example would be to update an uploaded file with a new version. One way would presumably be to create a new ...
0
votes
0answers
330 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
0answers
254 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
1answer
138 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 ...
0
votes
2answers
46 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" ...
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 ...
4
votes
1answer
915 views

Connection Reset by Peer: Socket Write Error

We have a vendor working on Java (JDBC) application saying they are getting the error Connection Reset by Peer: Socket Write Error They are insisting that the SQL Server (SQL Server 2012) is ...
2
votes
1answer
352 views

Oracle instant client

What is the difference between instant client and the original Oracle client? The Oracle client is almost 800MB and the instant client is not so much. I need to install oracle client, ODBC drivers and ...
0
votes
1answer
88 views

What is the best way to take backup for Remote DB Server

I am building a software, which will supports multiple database like MySQL, Oracle and PostgreSQL. These databases are installed on remote machines. i wanted to use java technology in a non-database ...
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 ...
2
votes
2answers
140 views

Weblogic Error: Connection test failed [closed]

I am trying to create a SQL Server 2014 data source in weblogic through admin console. When I click on test configuration, I get the following error: Message icon - Error Connection test failed. ...
2
votes
1answer
40 views

Accurate PG database size for comparing representations

I have a Java/JDBC program that takes a sample file and imports the data into the database, shredding it across multiple relations. The program does this multiple times for several different ...
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 ...
1
vote
1answer
64 views

JDBC prepared statement - make a token null

So, I have an insert statement in a Java program I'm writing. Under some conditions, I want it to insert some values as null. However, before I can execute the statement, I have to set all of the ...
1
vote
1answer
498 views

Syntax error using preparedstatements with postgresql

I have a Java application connecting to a PostgreSQL database. Using straightforward code like: ps = con.prepareStatement(sql); if (dataTypes != null && dataTypes.size() ...
1
vote
1answer
220 views

Dealing with single quotes in a dynamic query [closed]

I'm building a query as a string in my application layer to be executed over jdbc. The string is constructed as follows: "SELECT COUNT(DISTINCT ROOT_ID) as rows1 FROM DANIEL.UNIQUE_PHYSICIAN " ...
1
vote
2answers
38 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 ...
1
vote
0answers
47 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
2answers
94 views

How to populate another column with a sequence value generated for an identity column?

I have a table that has a column that is determined by a sequence using the identity column thing, so after a record is inserted (or during, I'm not sure how it works behind the scenes, only that it ...
1
vote
1answer
75 views

Driver properties for db2jcc in Squirrell and MON_GET_CONNECTION table function

I'm trying to set driver properties like: clientAccountingInformation clientApplicationInformation clientProgramId clientProgramName in Squirrell 3.6 (http://squirrel-sql.sourceforge.net/). See ...
0
votes
1answer
53 views

Access operator added by extension inside a schema

I am writing an application that uses postgres. Each microservice uses its own schema inside the database. So connect to the database schema I use this jdbc string: ...
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. ...
1
vote
2answers
1k views

JDBC local MSSQL Server connection string

I have installed open source database management tool "dbeaver" and want to use it instead of Sql Server Management Studio. But there is a problem. I searched from the internet but somehow I could not ...
0
votes
2answers
596 views

No suitable driver found Orientdb jdbc driver

I have some problems with Orientdb driver for jdbc. i´m using Netbeans, i have include the library JDBC+OrientDB libraries (orientdb-jdbc-2.0.8-all.jar) in the directory and in netbeans, i have also ...
5
votes
1answer
396 views

MySQL overhead of calling a Stored Procedure

Within Java, we access MySQL (v5.5.40) via JDBC -- a prepare statement, setting parameters then calling the stored procedure. It appears that every execute() has the overhead of 4 meta-calls (per ...
0
votes
0answers
19 views

Tool for browsing JavaDB

I have bought a Java web based application which uses a JavaDB to store data. In the application files, there are 2 .db files named ff.h2.db and ff.trace.db where "FF" being the abbreviation of the ...
0
votes
1answer
224 views

jdbc connection string ORACLE , integrated security

we are trying to configure Spotfire to use JDBC connection to ORACLE. We would like it to use integrated security (I call it Active Directory, TIBCO seems to like integrated security). Here is the ...
0
votes
0answers
116 views

HSQLDB like datasource to JAVAEE APP on JBOSS 7 FAIL

I am having problems while starting a sample app on JBoss server 7.0. Below follow piece of start log: 12:19:10,156 ERROR [org.jboss.as] (MSC service thread 1-7) JBoss AS 7.0.0.Final "Lightning" ...
0
votes
0answers
180 views

Thousands of the same weird syntax error after 9.4 upgrade

We moved our production database from 9.1 to 9.4.1 and started seeing the following errors all throughout the logs: ERROR: syntax error at or near "''" at character 1 STATEMENT: '' LOG: statement: ...
1
vote
0answers
402 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
104 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 ...
2
votes
1answer
116 views

how can optimize this sql query for being faster than superman

this my sql query: SELECT * FROM (SELECT * FROM ClassifiedAd WHERE city_id = :city AND currency = :currency AND price > 100) UNION DISTINCT (SELECT c.* ...
2
votes
2answers
413 views

Database-agnostic stored procedure call passing array of name/value pairs

Background Looking to pass a set of name/value pairs into a stored procedure in a database-agnostic way, using JDBC. A database structure is defined as follows: CREATE TYPE array_parameters AS ( ...
0
votes
0answers
33 views

Getting exception in Servlet due to ODBC

I am getting exception which is as follow - Exception[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedjava.sql.SQLException: [Microsoft][ODBC Driver ...
1
vote
1answer
580 views

JDBC connection error for SQL Server Database

I have a SQL server names as MS8AT09\AT09. I am able to login to the server through Microsoft SQL server Management studio. While trying to login to same server through JDBC I am facing the error as ...
0
votes
1answer
1k views

Can't find sun.jdbc.odbc package in Java version 8 [closed]

I am trying to connect a database query to my class while I compile the package name sun.jdbc.odbc package but it is not found in Java version 8.
1
vote
1answer
172 views

What do these parameters mean at the beginning of my SQL Server query plan?

I'm looking at query plan in SQL Server Mgmt Studio and I see something like this: (@P0 nvarchar(4000), @P1 nvarchar(4000)) Update... What does the type mean beside the parameters? For this example ...
1
vote
1answer
7k 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
0answers
265 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 ...
2
votes
3answers
312 views

Transaction Isolation level different threads massive number of Writes

I have a lot of threads that writing to DB some data in two tables. tbl_raw_data and tbl_parsed_data where tbl_parsed_data have foreign key to tbl_raw_data. I also need the writing to be superfast. ...
2
votes
2answers
3k views

Configuring sqlnet.ora and tnsnames.ora on the client side

I have an application server talking to an Oracle database, using the Oracle instant client. We are troubleshooting a specific bug, and it was asked if I could add the following flags to to my ...
1
vote
2answers
518 views

SET ROLE via parameterized query

In the very helpful response I received to a previous question, I am trying to write some JDBC code that first sets the role to a specific user before executing subsequent queries. On the safe side I ...