jdbc Archives - IT Nursery

Java, Programming

IT Nursery

How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?

I was wondering if there is a more elegant way to do IN() queries with Spring’s JDBCTemplate. Currently I do something like that: ...

June 4, 2022
0 Comments

Java, Programming

IT Nursery

Is it possible to specify the schema when connecting to postgres with JDBC?

Is it possible? Can i specify it on the connection URL? How to do that? 8 Answers 8

June 2, 2022
0 Comments

oracle, Programming

IT Nursery

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then ...

June 2, 2022
0 Comments

Java, Programming

IT Nursery

Using “like” wildcard in prepared statement

I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on a keyword of ...

June 1, 2022
0 Comments

Difference between Statement and PreparedStatement

The Prepared Statement is a slightly more powerful version of a Statement, and should always be at least as quick and easy to ...

May 24, 2022
0 Comments

Solving a “communications link failure” with JDBC and MySQL [duplicate]

This question already has answers here: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure (47 answers) Closed 5 years ago. I’m trying to connect to the local ...

May 23, 2022
0 Comments

Retrieve column names from java.sql.ResultSet

With java.sql.ResultSet is there a way to get a column’s name as a String by using the column’s index? I had a look ...

May 22, 2022
0 Comments

How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, ...

May 19, 2022
0 Comments

Must JDBC Resultsets and Statements be closed separately although the Connection is closed afterwards?

It is said to be a good habit to close all JDBC resources after usage. But if I have the following code, is ...

May 18, 2022
0 Comments

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I’m working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using ...

May 18, 2022
0 Comments