This question is locked. New answers and comments are not allowed.
Hi,
When I try to insert a null value in a CLOB field, I have the following error. the error only occurs for null. can someone help me ?
Thanks
{"Error setting parameters on PreparedStatement for insert of '2087813165-0':\nTelerik.OpenAccess.RT.sql.SQLException: SQL: Type #2005 not nullable!\r\n at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.RelationalUtils.setNull(PreparedStatement ps, Int32 index, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalUtils.set_Renamed(PreparedStatement ps, Int32 index, Object val, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalGenericState.setParams(PreparedStatement ps, Int32[] stateFieldNos, Int32 firstFieldNo, Int32 lastFieldNo, Int32 firstParam, PersistGraph pGraph, Int32 tableNo)\r\n at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)\nINSERT INTO \"CAPTAGE_PROD\".\"Int_Contact\" (\"Date_Naissance\", \"ID_Contact\", \"ID_Service\", \"ID_Civilite\", \"Nom\", \"Note\", \"Photo\", \"Prenom\", \"Sexe\") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n(set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: SQL: Type #2005 not nullable!\r\n at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.RelationalUtils.setNull(PreparedStatement ps, Int32 index, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalUtils.set_Renamed(PreparedStatement ps, Int32 index, Object val, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalGenericState.setParams(PreparedStatement ps, Int32[] stateFieldNos, Int32 firstFieldNo, Int32 lastFieldNo, Int32 firstParam, PersistGraph pGraph, Int32 tableNo)\r\n at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)"}
When I try to insert a null value in a CLOB field, I have the following error. the error only occurs for null. can someone help me ?
Thanks
{"Error setting parameters on PreparedStatement for insert of '2087813165-0':\nTelerik.OpenAccess.RT.sql.SQLException: SQL: Type #2005 not nullable!\r\n at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.RelationalUtils.setNull(PreparedStatement ps, Int32 index, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalUtils.set_Renamed(PreparedStatement ps, Int32 index, Object val, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalGenericState.setParams(PreparedStatement ps, Int32[] stateFieldNos, Int32 firstFieldNo, Int32 lastFieldNo, Int32 firstParam, PersistGraph pGraph, Int32 tableNo)\r\n at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)\nINSERT INTO \"CAPTAGE_PROD\".\"Int_Contact\" (\"Date_Naissance\", \"ID_Contact\", \"ID_Service\", \"ID_Civilite\", \"Nom\", \"Note\", \"Photo\", \"Prenom\", \"Sexe\") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n(set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: SQL: Type #2005 not nullable!\r\n at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.setNull(Int32 parameterIndex, Int32 sqlType, Int32 length, Int32 scale, Boolean isUnicode)\r\n at OpenAccessRuntime.Relational.RelationalUtils.setNull(PreparedStatement ps, Int32 index, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalUtils.set_Renamed(PreparedStatement ps, Int32 index, Object val, Int32 javaTypeCode, Int32 jdbcType, RelationalColumn col)\r\n at OpenAccessRuntime.Relational.RelationalGenericState.setParams(PreparedStatement ps, Int32[] stateFieldNos, Int32 firstFieldNo, Int32 lastFieldNo, Int32 firstParam, PersistGraph pGraph, Int32 tableNo)\r\n at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)"}