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: … Read more
jdbc
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
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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, … Read more
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 … Read more
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 … Read more