jdbctemplate Questions
6
Solved
I have an issue passing a null value to NamedParameterJdbcTemplate using MapSqlParameterSource of the spring framework. Anyone knows how to do this?
Currently my code is :
String sql = "update pe...
Mcallister asked 15/2, 2012 at 2:1
4
Solved
I had a working RowMapper code that maps database table row in to a java object. I wanted to change the implementation using lambda expression. However, I am always getting error; Code snippet as f...
Frederick asked 29/1, 2017 at 16:46
2
Solved
I created a stored procedure which returns result rows and two output parameters.
I am unable to find any thing in spring from which i can get ResultSet and outPutParameters.
I want to achieve some...
Ricercare asked 15/2, 2018 at 10:29
1
I am looking for a way to intercept the connection that JDBCTemplate creates internally i.e. the connection that is created when the function getConnection() is called by JDBCTemplate.
ex: if I u...
Gleiwitz asked 23/6, 2017 at 5:16
1
Solved
I have the following method that I use with Spring JDBC
public String getState() {
String stateLink = template.queryForObject(
"select state_url from state_scrape_queue where in_use = false ORDE...
Relieve asked 28/5, 2019 at 22:28
3
Solved
I am using the JdbcTemplate.query(sql, args, rowMapper) method call to return a list of objects. There are some cases where I want to skip a row and not add it to the list that I return. In these c...
Nickienicklaus asked 2/7, 2013 at 20:9
4
Solved
I need to set some specific Oracle JDBC connection properties in order to speed up batch INSERTs (defaultBatchValue) and mass SELECTs (defaultRowPrefetch).
I got suggestions how to achieve this wit...
Mender asked 18/1, 2016 at 14:14
7
I'm using Spring JdbcTemplate, and I'm stuck at the point where I have a query that updates a column that is actually an array of int. The database is postgres 8.3.7.
This is the code I'm using :
...
Irregularity asked 11/11, 2009 at 14:58
5
Solved
I'm executing a named query using jdbcTemplate.queryForList in the following manner:
List<Conversation> conversations = jdbcTemplate.queryForList(
SELECT_ALL_CONVERSATIONS_SQL_FULL,
new Ob...
Ontario asked 2/8, 2011 at 20:3
2
I am new to Spring 3.0 . For DAO access i have choosen SpringJDBC. SpringJDBC provides JDBC Template and SimpleJDBCTemplate . Which one is best. I read in some of the forum SimpleJDBCTemplate going...
Evieevil asked 25/4, 2012 at 11:24
5
Solved
I am using Spring's NamedParameterJdbcTemplate to perform an insert into a table. The table uses a NEXTVAL on a sequence to obtain the primary key. I then want this generated ID to be passed back t...
Czarra asked 12/5, 2010 at 14:5
4
Solved
I'm using Spring JdbcTemplate interface for fetching data from a MS SqlServer DB.
In the documentation I see there is the setMaxRows() method to set a limit for all the queries, but what if I want ...
Benniebenning asked 30/3, 2012 at 10:45
3
Solved
Why code from "Spring in action 5" don't work (keyHolder.getKey() return null, but entity is saved in DB)?
private long savePizzaInfo(Pizza pizza) {
pizza.setCreatedAt(new Date());
PreparedState...
Knecht asked 6/12, 2018 at 16:25
1
Solved
I'm using a Spring JdbcTemplate without a "transactionManager" since I have mostly select to do.
When I try to call select queries from JUnit, it works, but when I try to call an "update", it free...
Octangular asked 23/10, 2018 at 17:34
8
I'm putting the data into database with simpleJdbcTemplate.
simpleJdbcTemplate.update("insert into TABLE values(default)");
I dont want to put any data because i dont need it for my unit test pu...
Scauper asked 10/2, 2010 at 8:25
1
Solved
I have a Spring Boot micro service that connects to several databases through a JDBC connection using JDBCTemplate:
@Bean(name = "mysqlJdbcTemplate")
public JdbcTemplate jdbcTemplate(@Qualifier("...
Aviva asked 9/10, 2018 at 12:14
2
I have a stored procedure which has body like :-
PROCEDURE PROC_NAME(param1 in varchar2,param2 in varchar2,results_cursor OUT CURSOR_TYPE);
Each row of result is equivalent to an instance of a ce...
Gamekeeper asked 27/3, 2017 at 11:22
5
Solved
I'm trying to connect to a database in Java, using jdbcTemplate and I'm gettin the error below. I have Googled for a long time and all solutions I found didn't solve my problem. I tried several dif...
Yuzik asked 13/5, 2013 at 17:44
3
Solved
I'm a bit exasperated with this issue. Lets check if someone has implemented something similar.
I have a java 8 web application with 8 WS implemented. Some of this WS, make inserts and updates th...
Nordau asked 2/8, 2018 at 13:20
2
I would like to know how to properly use jdbc in my case.
The saveLinkHistory column is a bit(1) type in mysql.
public boolean getIsSavedLinkHistory(String name) {
String sql = "select saveLinkH...
Falchion asked 28/3, 2017 at 9:50
4
Solved
In our project we have to decide between Spring JDBCTemplate and Hibernate.
I want to know which is better in terms of performance and implementation and design. and how?
Pamphlet asked 3/8, 2012 at 7:24
1
Solved
I have a SpringBoot app, where I use jdbcTemplate to insert a row to a mssql
int numOfRowsAffected = remoteJdbcTemplate.update("insert into dbo.[ELCOR Resource Time Registr_] "
+ "( [Entry No_], ...
Rybinsk asked 24/5, 2018 at 10:47
2
Solved
The question is pretty much summed up in the title. What will JdbcTemplate.queryForList() return when the query returns no results. Will it return an empty List or null value? I couldn't find a def...
Selfhypnosis asked 17/7, 2014 at 7:51
6
Solved
The queryforInt/queryforLong methods in JdbcTemplate are deprecated in Spring 3.2. I can't find out why or what is considered the best practice to replace existing code using these methods.
A typi...
Guarantor asked 27/3, 2013 at 14:24
10
Solved
From the Spring JDBC documentation, I know how to insert a blob using JdbcTemplate
final File blobIn = new File("spring2004.jpg");
final InputStream blobIs = new FileInputStream(blobIn);
jdbcTempl...
Soler asked 5/5, 2010 at 5:43
© 2022 - 2024 — McMap. All rights reserved.