• Post Reply Bookmark Topic Watch Topic
  • New Topic

Invalid Column Name  RSS feed

Ranch Hand
Posts: 303
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am giving the following exception when i call this

2011/06/05 16:43:29 ERROR exceptionOccured(Slf4jSpyLogDelegator.java:103) - 3. ResultSet.getString(BRCD_CMPN_NO)
java.sql.SQLException: Invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6348)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1549)
at net.sf.log4jdbc.ResultSetSpy.getString(ResultSetSpy.java:1773)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
at org.hibernate.type.StringType.get(StringType.java:41)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)

Please tell me where i am wrong.
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

As per exception "java.sql.SQLException: Invalid column name", as of now i can suggest please verify the name of the databased fields available in the mapping file with database and pojo class.

I believe field name is mismatching some where in the mapping file/pojo with DB.

Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!