Top "Jdbctemplate" questions

The JdbcTemplate class is a key part of the Spring Framework JDBC abstraction.

Jdbctemplate query for string: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

I am using Jdbctemplate to retrieve a single String value from the db. Here is my method. public String test() { …

java spring jdbctemplate
Spring JDBC Template for calling Stored Procedures

What is the correct way to invoke stored procedures using modern day (circa 2012) Spring JDBC Template? Say, I have a …

java spring spring-jdbc jdbctemplate
How to execute IN() SQL queries with Spring's JDBCTemplate effectivly?

I was wondering if there is a more elegant way to do IN() queries with Spring's JDBCTemplate. Currently I do …

java sql spring jdbc jdbctemplate
Return Type for jdbcTemplate.queryForList(sql, object, classType)

I'm executing a named query using jdbcTemplate.queryForList in the following manner: List<Conversation> conversations = jdbcTemplate.queryForList( SELECT_…

java spring-ws jdbctemplate
Using prepared statements with JDBCTemplate

I'm using the JDBC template and want to read from a database using prepared statements. I iterate over many lines …

java spring jdbc prepared-statement jdbctemplate
How to set up datasource with Spring for HikariCP?

Hi I'm trying to use HikariCP with Spring for connection pool. I'm using jdbcTempLate and JdbcdaoSupport. This is my spring …

spring jdbc spring-jdbc jdbctemplate hikaricp
SQL state [99999]; error code [17004]; Invalid column type: 1111 With Spring SimpleJdbcCall

Hi All I am using spring simple JDBC template to call the oracle procedure the below are my code. The …

java oracle spring jdbctemplate
How to get Map data using JDBCTemplate.queryForMap

How to load data from JDBCTemplate.queryForMap() and it returns the Map Interface.How the maintained the query data internally …

java spring jdbctemplate
How to execute INSERT statement using JdbcTemplate class from Spring Framework

In Spring, how can I insert data in table using JdbcTemplate. Can anyone please provide me a code sample for …

java spring jdbctemplate
how to query for a list<String> in jdbctemplate

I'm using springs jdbctemplate and running a query like below: SELECT COLNAME FROM TABLEA GROUP BY COLNAME There are no …

java jdbc jdbctemplate spring-jdbc