Results 1 to 2 of 2

Thread: After update from 3.0.6 to 3.1.3, getting unexplained "Invalid column type"

  1. #1
    Join Date
    Jan 2006
    Location
    Seattle, Washington
    Posts
    467

    Default After update from 3.0.6 to 3.1.3, getting unexplained "Invalid column type"

    I have an app that was working fine with 3.0.6. I'm upgrading to 3.1.3. I noticed that SimpleJdbcDaoSupport is now deprecated. I use named parameters, so I changed it to NamedParameterJdbcDaoSupport. Now my queries are all failing with "Invalid column type". That's all it's giving me. I can get the SQL it's using. I've stared at the parameter map I'm producing. I don't see what might be wrong, and the error message isn't helping me. I tried stepping into the "query" code (like "org.springframework.jdbc.core.JdbcTemplate.execut e(PreparedStatementCreator, PreparedStatementCallback<T>)", but it's still not giving me any useful information.

    What can I do to narrow this down?

  2. #2
    Join Date
    Jan 2006
    Location
    Seattle, Washington
    Posts
    467

    Default

    I figured this out. I was fooled by the fact that when moving from SimpleJdbcDaoSupport to NamedParameterJdbcDaoSupport, the order of the "rowmapper" and "paramsmap" arguments were reversed, but the reverse order ended up being syntactically valid, just extremely invalid semantically. It was trying to insert a Map object as a prepared statement parameter.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •