Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    java.sql.SQLException: Invalid column type: getDATE

    Switching from 06-06-2011 to 12-06-06-2011

    Deployment results in a stacktrace when executing a fetch operation with criterias:

    Code:
    java.sql.SQLException: Invalid column type: getDATE
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
            at oracle.jdbc.driver.ScrollableResultSet.getDATE(ScrollableResultSet.java:1035)
            at oracle.jdbc.driver.ScrollableResultSet.getTimestamp(ScrollableResultSet.java:928)
            at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_ScrollableResultSet.getTimestamp(Unknown Source)
            at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:548)
            at com.isomorphic.sql.SQLTransform.toAttributeMap(SQLTransform.java:202)
            at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:593)
            at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:412)
            at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1655)
            at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1285)
            at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:280)
            at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:224)
            at com.isomorphic.datasource.DataSource.execute(DataSource.java:1154)
            at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
            at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
            at com.isomorphic.application.AppBase.execute(AppBase.java:491)
            at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1633)
            at com.wirecard.gwt.wep.server.common.dmi.BasicSearchDmiInterceptor.fetch(BasicSearchDmiInterceptor.java:48)
            at 
    
    ...
    
    weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

    Do you have any idea, where this can come from,
    with 06-06-2011 release it is fine for us.

    #2
    hi,

    can u explain more clearly how you manipulate data and when u got error.

    Comment

    Working...
    X