jdbctemplate

jdbctemplate query() vs entityManager createQuery()

Hi. What is essential difference between these methods? query() of JdbcTemplate and createQuery() of EntityManager? As I understand, both execute query? ...

Using Spring's KeyHolder with programmatically-generated primary keys

Hello, 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 to me. I am using Spring's KeyHolder implementation like this: KeyHolder key = new GeneratedKeyHolder(); jdbcTemplate.update(Constan...

Open JdbcTemplate connection in read only mode (Spring framework)?

Hi, is it possible to open a JdbcTemplate connection in read only mode, so that I can't perform any changes to the underlying data source? ...

How to make a thread try to reconnect to the Database x times using JDBCTemplate

Hi, I have a single thread trying to connect to a database using JDBCTemplate as follows: JDBCTemplate jdbcTemplate = new JdbcTemplate(dataSource); try{ jdbcTemplate.execute(new CallableStatementCreator() { @Override public CallableStatement createCallableStatement(Connection con) throws SQLException { ...

How to truncate a table with Spring JdbcTemplate?

I'm trying to truncate a table with Spring: jdbcTemplate.execute("TRUNCATE TABLE " + table); Get the error: Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [TRUNCATE TABLE RESULT_ACCOUNT]; nested exception is java.sql.SQLException: Unexpected token: TRUNCATE in statement ...

jdbctemplate and optimistic locking

In the project I'm in Hibernate and Spring jdbctemplate are mixed. I added optimistic locking. Hibernate works great with versioning but now I have to tansform all this jdbctemplate code to use versioning too. Is there something like LockingJdbcTemplate (like SimpleJdbcTemplate)? I was thinking I could implement a generic update metho...

Are multiple DAOs with jdbctemplate constructor injection a multi-threading risk?

I've got a large multi-threaded webapp in which I am passing in jdbcTemplates into DAO classes via constructor injection. Is this a multi-threading risk? Should I be passing in just the datasource instead? ...

Using prepared statements with JDBCTemplate

Hi. I'm using the Jdbc template and want to read from the database using prepared statements. I iterate over many lines in a csv file and on every line I execute some sql select queries with it's values. Now I want to speed up my reading from the database but I just can't get the Jdbc template to work with prepared statements. Actually...

using JdcbTemplate standalone

Hi We are looking into using the JdbcTemplate for accessing the DB - but we have many different DB-connections, that each class could use, so injecting the jdbcTemplate is not an option atm. So if we do a jdbcTemplate = new JdbcTemplate(dataSource); what will the transaction policy be? Auto-commit is off in the DB. ...

msql table name with $ sign

I have tables in Mysql 5 db with names prefixed with a dollar sign '$' ie tablename $MYTABLE I am using Spring 3.0 JdbcTemplate to do my select query but couldn't get it to work. ie String tablename = "$AAPL"; private static final String STOCK_SELECT = "select symbol, open, high, low, close, vol, ev from ?"; jdbcTem...

JdbcTemplate and inet data type

One of my table has the column type as inet. And when I try to perform insert operation using String as the type for inet column, it's saying "column "ip" is of type inet but expression is of type character varying:", which is perfectly valid exception. Now, my question is how do I instruct jdbcTemplate to use inet type instead of Strin...

Instantiating a JdbcTemplate from a java.sql.Connection

Hi! I want to obtain a JdbcTemplate in my Java code. I've already got a working java.sql.Connection. To create a new JdbcTemplate it would normally need an instance of the javax.sql.DataSource interface. Is it somehow possible to obtain a new JdbcTemplatefrom an existing java.sql.Connection? ...

Inserting multiple rows using JdbcTemplate

How can I execute the following SQL in a scalable way using JdbcTemplate running on mySQL. In this case, scalable means: Only one SQL statement is executed on the server it works for any number of rows. Here's the statement: INSERT INTO myTable (foo, bar) VALUES ("asdf", "asdf"), ("qwer", "qwer") Assume that I have a list of POJO'...

spring JDBCTempate and batchUpdate

hi, i have a batchUpdate which is only working on every second attempt. The batchUpdate method takes an Update string update t_table set updated_by=lower(?), updated_date=sysdate, a= ?, b= ? where c= ? and d = ? "; and a number of parameters - some of the parameters will be repeated so it is possible that the same update string is g...

Java JdbcTemplate

Hi, What's the difference between a JdbcTemplate object and a SimpleJdbcTemplate? Thanks, P. ...

Spring JDBC vs JDBC

I have been trying to use spring 3.0 SimpleJdbcTemplate and it takes 5 mins to insert 1500 records, whereas it take me a few secs. to insert using straight JDBC. Not sure what I am doing wrong. ...

jdbctemplate concept and c#

Is there something similar with spring jdbctemplate for c# ? I am not seeking for jdbctemplate for c# but something that works very similar like jdbctemplate. I am familiar with ado net and linq to entities, but I like the concept of jdbctemplate. ...

How can I limit memory usage when generating a CSV from a large resultset?

I have a web application in Spring that has a functional requirement for generating a CSV/Excel spreadsheet from a result set coming from a large Oracle database. The expected rows are in the 300,000 - 1,000,000 range. Time to process is not as large of an issue as keeping the application stable -- and right now, very large result sets c...

Sort DB records with JdbcTemplate

Hello. How to Sort DB records in DB table with JdbcTemplate? What is the best solution, should execute method be used? ...

spring simplejdbctemplate batch update - array of strings

Hey StackOverflow, could please anybody help me out with an example of batch update of an array of strings into one column ? This is an example of batch update of an array of objects having getters public int[] batchUpdate(final List<Actor> actors) { SqlParameterSource[] batch = SqlParameterSourceUtils.createBatch(actors.toArra...