java.sql.SQLException

[BEA][SQLServer JDBC Driver][SQLServer]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.* *

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web15973

  • via Oracle Community by 672962, 10 months ago
    [BEA][SQLServer JDBC Driver][SQLServer]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.* *
  • via Oracle Community by 400266, 1 year ago
    [oias][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'PERSON_ID', table 'fw.dbo.PERSON_NAMES'; column does not allow nulls. INSERT fails. ERROR CODE: 515
  • [BEA][Oracle JDBC Driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column
  • Stack trace

    • java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.* * at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source) at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source) at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source) at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source) at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source) at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:125) at com.bea.dsp.wrappers.rdb.runtime.DBSession.executeUpdate(DBSession.java:144) at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLInsertInternal.executeSQL(ExecuteSQLInsertInternal.java:110) at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170) at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLModificationBase.prepareAndExecuteQuery(ExecuteSQLModificationBase.java:77) at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95) at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114) at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85) at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135) at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296) at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436) at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297) at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125) at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134) at weblogic.xml.query.update.runtime.ExecuteRelational.fetchNext(ExecuteRelational.java:52) at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114) at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85) at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135) at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296) at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436) at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297) at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125) at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134) at weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:54) at weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:33) at weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:100) at com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:731) at com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:611) at com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:466) at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:308) at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84) at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354) at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589) at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(Unknown Source) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475) at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59) at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200) at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago