tags:

views:

396

answers:

1
Q: 

jdbcTemplate and Oracle 10

trying to do an insert, i have: jdbcTemplate.update("insert into....", new Object[]{foo.getId(), foo.getName()}) foo.getId() returns a long, and getName() a String. i have "NUMBER" as the id type in Oracle, and varchar2 for the name field.

i'm getting SQLtype unknown problem. the update method has a version where i do not have to put in the SQL types, but do i have to, and if so, how?

Thanks!

A: 
Ken Gentle  2008-11-18 22:56:39

related questions

How to truncate a table with Spring JdbcTemplate?
How to make a thread try to reconnect to the Database x times using JDBCTemplate
Open JdbcTemplate connection in read only mode (Spring framework)?
Using Spring's KeyHolder with programmatically-generated primary keys
jdbctemplate query() vs entityManager createQuery()
Jdbc Template and MySql interaction for Frequently Changing Queries
Spring JdbcTemplate - Insert blob and return generated key
Firebird query is crashing with org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544364. request synchronization error
How exactly JdbcTemplate with TransactionManager works together?
simpleJdbcTemplate. - insert and retrieve ID
Spring's JDBCTemplate IllegalArgumentException: datasource required
Spring JdbcTemplate returns empty result when there should be a valid result
How to update a postgresql array column with spring JdbcTemplate?
SpringFramework JdbcTemplate RowMapper
identity from sql insert via jdbctemplate
Java Programming - Spring and JDBCTemplate - Use query, queryForList or queryForRowSet?
Use NamedParameterJdbcTemplate to update array field
JdbcTemplate batch update in postgresql - date loses time?
Ensuring uniquness of a MySQL key
Using JDBCTemplate with a Hibernate SessionFactory?
How to execute IN() SQL queries with Spring's JDBCTemplate effectivly?
How do I setQueryTimeout on SimpleJdbcTemplate?
How can I cancel a long-running query using Spring and JDBCTemplate?
Spring JDBCTemplate Table Locking with MySQL