SmartClient Version: v12.1p_2022-02-13/Enterprise Deployment (built 2022-02-13)
Oracle (ver. Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0)
Hello, I've got a SQLDataSource with a field defined as:
This column is a varchar2(4000).
When updating this field:
I get this error:
If I remove the length or the customUpdateExpression (one of them or both), then it works.
Oracle (ver. Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0)
Hello, I've got a SQLDataSource with a field defined as:
Code:
<field name="DESCRIZIONE_PAG_SECONDA" length="4000" type="text" customUpdateExpression="#if ($values.INCLUDI_SECONDA_PARTE) #if ($values.DESCRIZIONE_PAG_SECONDA) $values.DESCRIZIONE_PAG_SECONDA #else null #end #else null #end"/>
When updating this field:
Code:
RICHIESTE_CLIENTE.updateData({ PK:1, DESCRIZIONE_PAG_SECONDA:null })
Code:
2022-02-15T13:58:10,102 [claudio.bosticco@juventus.com 1644927759000] INFO SQLDriver Executing SQL query on 'dbEleven': UPDATE DBELEVEN.RICHIESTE_CLIENTE SET DESCRIZIONE_PAG_SECONDA= null WHERE (RICHIESTE_CLIENTE.ID_REC=2368980) 2022-02-15T13:58:10,104 [claudio.bosticco@juventus.com 1644927759000] DEBUG DSRequest freeOnExecute is false for request of type update on DataSource RICHIESTE_CLIENTE - not freeing resources! 2022-02-15T13:58:10,104 [claudio.bosticco@juventus.com 1644927759000] DEBUG DataSourceDMI Invocation threw exception java.sql.SQLException: invalid column index at oracle.jdbc.driver.OraclePreparedStatement.setFormOfUseInternal(OraclePreparedStatement.java:10470) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.setFormOfUseInternal(OraclePreparedStatement.java:10451) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5240) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:255) ~[ojdbc8.jar:12.2.0.1.0] at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:142) ~[tomcat-dbcp.jar:8.5.23] at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:142) ~[tomcat-dbcp.jar:8.5.23] at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:1415) ~[isomorphic-sql-12.1-p20220213.jar:?] at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:1336) ~[isomorphic-sql-12.1-p20220213.jar:?] at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:1511) ~[isomorphic-sql-12.1-p20220213.jar:?] at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:606) ~[isomorphic-sql-12.1-p20220213.jar:?] at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1931) ~[isomorphic-sql-12.1-p20220213.jar:?] at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:449) ~[isomorphic-sql-12.1-p20220213.jar:?] at com.isomorphic.sql.SQLDataSource.executeUpdate(SQLDataSource.java:398) ~[isomorphic-sql-12.1-p20220213.jar:?] at com.isomorphic.datasource.DataSource.execute(DataSource.java:2574) ~[isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3093) ~[isomorphic-core-rpc-12.1-p20220213.jar:?] at com.juve.eleven.richieste.UpdateRichiestaClienteDMI.update(UpdateRichiestaClienteDMI.java:239) ~[classes/:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_252] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_252] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_252] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_252] at com.isomorphic.base.Reflection._invokeMethod(Reflection.java:581) ~[isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:896) ~[isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:434) [isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) [isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3088) [isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic-core-rpc-12.1-p20220213.jar:?] at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-12.1-p20220213.jar:?]
Comment