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]

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

-1
votes
0answers
8 views

JDBC: pooled connection not seeing new row

The problem here is easy to reproduce: 1) First a request creates a row. The front-end receives the row-ID. 2) Then another request is sent to read the row's data using the ID (like 200 ms ...
0
votes
1answer
34 views

executing SQL query with temp tables using 1.6jdk

I created a batch to run a query that has temp tables as the below example IF OBJECT_ID ('tempdb..#TEMP1') IS NOT NULL DROP TABLE #TEMP1 select * into #TEMP1 from cutomer IF OBJECT_ID ('tempdb..#...
-1
votes
1answer
36 views

Incorrect string value: '\xF0\x9F\xA4\x96<b…' for column 'body' at row 1 [closed]

I've set the column type to utf8mb4 and the collation to utf8mb4_bin. The table defaults are also utf8mb4 and utf8mb4_bin. When I use SequelPro to add the emoji "🤖" to the database manually, it ...
0
votes
1answer
73 views

Query is slow with JDBC parameters, fast with concatenated SQL

I have an application that can be run with either mysql or SQL Server. There is a query that runs in a reasonable time on mysql, but is very slow on SQL Server. My application uses hibernate, but this ...
1
vote
0answers
31 views

SQL JDBC upgrade from v6.0 to v7.2 causes java.lang.NullPointerException in *some* stored procedure returned recordsets

I am developing a java application onWindows 10 using Eclipse Oxygen and SQL JDBC v7.2 and java 1.8 update 202. My code runs fine when I use SQL JDBC v6.0 (sqljdbc42.jar Jan 2017 and java 8), but ...
0
votes
2answers
36 views

Can any database table name support double quotes "?

I need to know whether any database supports double quotes as a part of their table name. I am especially interested in JDBC compliant databases. And if they do, can I please know how?
1
vote
0answers
105 views

Improve parallel running of bulk copy insert and stored procedures

I have a Java message listener, which upon receiving a message starts bulk inserting thousands of records into a table. After that it calls a few stored procedures sequentially that make some updates ...
0
votes
1answer
287 views

Keep H2 in-memory database between connections

I create and use a H2 database in-memory (no writing to storage) for demos and quick tests using this code in Java: Connection conn = DriverManager.getConnection( "jdbc:h2:mem:example_db" ) ; This ...
0
votes
1answer
50 views

Are the MariaDB and MySql drivers interchangeable when connecting to a MySQL backend Aurora cluster?

I saw a similar question asked before but I didn't get enough supporting information Does anyone know any new information on this? Can MariaDB connector (driver) be used instead of the MySQL ...
0
votes
0answers
17 views

Oracle Advanced Connection Security SQL

I am looking for a way to check the encryption and integrity protection level in effect for the current session. Is there a system view where I can get those details? It would also be good if the ...
1
vote
1answer
165 views

Can the new “SCRAM-SHA-256” password authentication mechanism in Postgres 10 and later work with any JDBC drivers?

Postgres 10 added support for a new password authentication mechanism, Salted Challenge Response Authentication Mechanism (SCRAM-SHA-256, see RFC 7677). Discussed by Michael Paquier. ➥ Can this ...
1
vote
0answers
34 views

How do Master / Slave JDBC URL handle broken MySQL Slave?

I own the following classical MySQL 5.7 set-up : one master server one slave server The master => slave link is done though GTID. I'm monitoring the link by querying show slave status on the slave ...
1
vote
0answers
229 views

How to connect to Postgres on localhost with URL: “jdbc:postgresql://database:5432/db123”

I am able to connect to a postgres 10 instance on my local Win10 machine with pgAdmin 4 and "localhost" as a hostname, but when I change the hostname to "database" I cannot connect. How to fix it? I'...
0
votes
0answers
60 views

Oracle - Is it possible for the results of a transaction not to be visible to a subsequent transaction?

We're having a strange problem with a flaky integration test. This is using Java/JDBC against an Oracle 12 database. The test does this, in pseudocode: transaction 1 { insert into order (id, ...
1
vote
1answer
287 views

timestamp with timezone issue with TZR vs TZH:TZM

I have a Hibernate with Oracle JDBC based application inserting/updating into the following column; COLUMN_A TIMESTAMP WITH TIME ZONE DEFAULT systimestamp NOT NULL but while it automatically appends ...
3
votes
2answers
969 views

Check Java Driver version in clients from Db2 server

I have a Db2 database that is being used by many applications in different servers. I want to check from the Db2 server if the Java driver used in the different client applications is up-to-date. Is ...
0
votes
1answer
57 views

Having multiple ResultSets in parallel on same connection.. Will it cause any problem? [Mysql/Postgres] [closed]

I have tried out the following in my local machine using jdbc/mysql: step 1: conn = getNewConnection step 2: stmt1 = "new statement" using connection 'conn' step 3: stmt2 = "new statement" using ...
1
vote
1answer
99 views

“Error while processing statement” running a query finding unique values with multiple values in other rows

Is there anything wrong in the syntax of this query finding unique values with multiple values in other rows? Select Distinct Ss.`cd`, Ss.`cd` From nit.assrr As Ss Join ( Select `cd` ...
0
votes
1answer
51 views

What if a connection closes in the middle of a commit?

I have a few large CSV files to upload to an instance of SQL Server.(Nope, can't use SSMS) I'm using JDBC to read the CSVs line by line and insert the lines in a table in batches. Supposing my code is ...
1
vote
1answer
418 views

sql server query execution plan via jdbc driver

is there a way to fetch the XML generated by the "Actual Execution Plan" in SQL server 2012 - 2014, but via JDBC driver for Java -- sqljdbc_6.0.8112.100_enu? (preferable forward compatible with 2016) ...
0
votes
0answers
2k views

org.postgresql.util.PSQLException: This connection has been closed. error for long running transactions

We are getting "org.postgresql.util.PSQLException: This connection has been closed." on one of our deployments for only long running transactions (more than a few minutes): Caused by: org.hibernate....
0
votes
1answer
310 views

Polling SQL Databases [closed]

Is there any way to poll for MySQL database changes using JDBC? I need exactly which changes happened (not a simple yes/no). I tried using a thread which executes every 15 seconds to check whether my ...
0
votes
0answers
1k views

Installing postgres jdbc driver on ubuntu 16.04

Ok I want to write a apache-spark dataframe to a postgresql database. For this I have to install the postgres jdbc driver. The spark master and the database are on the same machine I'm running java 1....
1
vote
1answer
83 views

How do I run a database heavy query over jdbc without timing out (Oracle)?

For one of our applications (Pentaho Data Integration), we need to run queries through the oracle jdbc. Some of these queries are computation expensive and can take an hour or more to return any rows ...
0
votes
0answers
174 views

Disconnections in SQL Server

I'm looking for some suggestions regarding a disconnection issue, I'm basically looking for a way to track why the connections are getting dropped that suddenly. The application is using tomcat and ...
1
vote
1answer
748 views

The server's DateStyle parameter was changed to ISO. The JDBC driver requires DateStyle to begin with ISO for correct operation

I use PostgreSQL 9.6.6 on CentOS Linux 7.4 and after upgrading the postgresql-jdbc package - # sudo yum update Failed to set locale, defaulting to C Loaded plugins: fastestmirror Loading mirror ...
2
votes
1answer
2k views

Validation query

By default for Oracle Databases validation query is "select 1 from dual". Tomcat says: ValidationQuery - If specified, this query MUST be an SQL SELECT statement that returns at least one row. ...
1
vote
1answer
684 views

Is there a JDBC Driver for Microsoft SSAS Tabular Databases?

Is there a JDBC Driver for Microsoft SSAS Tabular Databases? Is so where can they be downloaded?
1
vote
1answer
3k views

How do I use the `COPY` command with JDBC

So I've been working with postgre databases and I noticed that it throws an error sometimes when I try to read a csv file and copy to a table remotely. It works perfectly when I use a buffered reader ...
1
vote
0answers
807 views

Oracle APEX 5.1 connect to remote db using JDBC and query data

I have only used db links to get access to remote db so far. Now I have to find a way to use JDBC to connect to remote db and get data. Can someone guide me what all things would I need to ask the ...
0
votes
1answer
266 views

What is the new JDBC 4.3 Connection Request feature with `beginRequest` & `endRequest` methods?

The JDBC 4.3 update arrived with Java 9 2017-10. Amongst its few changes is the new feature on Connection where the beginRequest and endRequest methods signals… Hints to the driver that a request, ...
1
vote
1answer
1k views

Compression function in Postgres

Using Java & JDBC I am storing Strings into a JSONB column in Postgres. When inserting this works great. When retrieving values, I am running low on memory in Java because I am retrieving ...
0
votes
1answer
4k views

Database Wrapper Design issue: No operator matches the given name and argument type(s)

I'm building a wrapper for DB access using AWS' Lambda functions Java, the issue I'm having is that Lambda parameters are JSON, thus typeless, so all incoming params are de-JSON'd into Strings, and ...
1
vote
1answer
9k views

IO Error: Got minus one from a read call [closed]

I am very new with Oracle, I have installed 11g 64 bit on my Windows 10. And only started the oracle database using emctl start dbconsole. I have the following code to be connected to my database, ...
0
votes
2answers
744 views

JDBC Connection on Current Primary Database After Switchover: ORA-01033 encountered

We are using Oracle Data Guard and currently testing Disaster Recovery scenarios, which is starting the application after switching over from the Primary Database to the Secondary Database. I am ...
1
vote
1answer
1k views

java.sql.SQLRecoverableException: No more data to read from socket

When I use java code to insert data to oracle,the following information appeared: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine....
0
votes
1answer
67 views

Disallowing MariaDB query cache except from webserver (JDBC)

I have an application server (Play Framework), webserver (Caddy), and database server (MariaDB with InnoDB) that are running on a single machine for now. The database is used in two ways: client ...
3
votes
1answer
1k views

Can I set PostgreSQL “stringtype=unspecified” behavior as default?

I am trying to get Hibernate to save Java enum fields as enum columns in PostgreSQL 9.6. If I map the fields as @Enumerated(STRING), Hibernate naively uses the enum name as the column contents. This ...
0
votes
1answer
2k views

oracle 11g Grant on dbms_lock not persisting [closed]

I am using oewizard from swingbench to create an order-entry like schema on oracle 11g. When I run the wizard I get the following errors: ORA-01031: Cannot grant execute on dbms_lock to soe: ...
0
votes
1answer
4k views

how to solve Invalid usage of the option NEXT in the FETCH statement [duplicate]

I am using jtds 1.2.2 driver with SQL Server 2008. Below is the query I tried to execute SELECT * from AM_API FETCH NEXT 10 ROWS ONLY Anyway after executing above query I got below error Caused ...
5
votes
2answers
2k views

datetime fractional seconds

I am reading the description of the datetime datatype from Sybase ASE 15.7 documentation: datetime columns hold dates between January 1, 1753 and December 31, 9999. datetime values are accurate to ...
3
votes
3answers
561 views

How do I cast varchar to macaddr without changing client code

I have a dedicated DB Server with Debian Jessie and Postgresql 9.4 Client: A is a Tomcat Java app which use torque with a JDBC driver connecting to the DB Server. Issue: on Updating a row with a new ...
0
votes
1answer
59 views

Restrict executeQuery in Java from data manipulation in an Oracle database

I am developing a query browser in Java where I want to restrict users from manipulating data. So I am using executeQuery as I searched many questions and all are answered as executeQuery is used to ...
1
vote
1answer
146 views

How to achieve federation using JDBC?

I want to achieve federation using following commands through JDBC. connect to SIGCAP_M user db2sigcp using db2sigcp ; drop wrapper drda; create wrapper drda ; UNCATALOG NODE XYZ; CATALOG TCPIP ...
0
votes
0answers
96 views

Jdbc3SimpleDataSource vs. PGSimpleDataSource. What's the difference?

PostgreSQL's JDBC 4.2 driver includes classes PGSimpleDataSource and Jdbc3SimpleDataSource. The latter extends the former, but there's no difference in their APIs. And I find that both provide the ...
3
votes
1answer
1k views

Postgresql on AWS RDS JDBC Connection Refused, psql connection succeeeds

I have an Amazon RDS Postgres instance running. I can see the data from my local machine (whitelist office IP) and our web app can connect (running on EC2 instance). On that EC2 instance, these ...
1
vote
0answers
619 views

Set table name to variable in postgresql

I am trying to set the tablename dynamically in a postgresql query executed through a jdbc connection. Here is my code: PreparedStatement query1 = null; Connection conn = null; //...
3
votes
1answer
844 views

Why would a query return oracle.sql.NUMBER@[hex value] in place of a numeric value?

I'm seeing some odd behavior in an Oracle 11gR2 database. When I select from a particular table, using SQL Developer, certain rows of the result set include non-numeric results in a NUMBER column (...
0
votes
1answer
44 views

Need a better way to insert non-existent values in referenced table during insert/update in referencing one

I'm looking for the best way to insert data into MariaDB with JDBC. Please take a look at the following schema CREATE TABLE color ( id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, name VARCHAR(...
1
vote
0answers
889 views

LISTEN/NOTIFY pgconnection goes down java?

I am using PostgreSQL DB and applying it's LISTEN/NOTIFY functionality. So my listener is at my AS (Application Server) and I have triggers configured on my DB such that when CRUD operations are ...