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.* *

Oracle Community | 672962 | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Problems creating physical data service to relational table

    Oracle Community | 8 years ago | 672962
    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.* *
  2. 0

    JMS probs during startup

    Google Groups | 1 decade ago | Eric Homer
    java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Invalid object name 'weblogicJMSState'.
  3. 0

    JMS probs during startup

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Invalid object name 'weblogicJMSState'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    mssql prepare insert statement

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]String or binary d ata would be truncated.
  6. 0

    MS SQL Server error

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'PF_PORTLET_DEFINITION' with unique index 'AX1_PORTLET_DEF'.

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. weblogic.jdbc.base
      BaseExceptions.getException
      1. weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
      2. weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
      2 frames
    3. weblogic.jdbc.sqlserver
      SQLServerImplStatement.getNextResultType
      1. weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
      2. weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
      3. weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
      4. weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
      5. weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
      5 frames
    4. weblogic.jdbc.base
      BasePreparedStatement.executeUpdate
      1. weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
      2. weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
      3. weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
      4. weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
      5. weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
      6. weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
      6 frames
    5. weblogic.jdbc.wrapper
      PreparedStatement.executeUpdate
      1. weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:125)
      1 frame
    6. com.bea.dsp
      ExecuteSQLRuntimeBase.fetchNext
      1. com.bea.dsp.wrappers.rdb.runtime.DBSession.executeUpdate(DBSession.java:144)
      2. com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLInsertInternal.executeSQL(ExecuteSQLInsertInternal.java:110)
      3. com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170)
      4. com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLModificationBase.prepareAndExecuteQuery(ExecuteSQLModificationBase.java:77)
      5. com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95)
      5 frames
    7. weblogic.xml.query
      XQSEStatementImpl.execute
      1. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)
      2. weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)
      3. weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)
      4. weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)
      5. weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)
      6. weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)
      7. weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)
      8. weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)
      9. weblogic.xml.query.update.runtime.ExecuteRelational.fetchNext(ExecuteRelational.java:52)
      10. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)
      11. weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)
      12. weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)
      13. weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)
      14. weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)
      15. weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)
      16. weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)
      17. weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)
      18. weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:54)
      19. weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:33)
      20. weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:100)
      20 frames
    8. com.bea.ld
      Server_ydm4ie_EOImpl_WLSkel.invoke
      1. com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:731)
      2. com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:611)
      3. com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:466)
      4. com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:308)
      5. com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)
      6. com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)
      7. com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)
      7 frames
    9. weblogic.rmi.internal
      BasicServerRef.invoke
      1. weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
      1 frame
    10. weblogic.rmi.cluster
      ClusterableServerRef.invoke
      1. weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)
      1 frame
    11. weblogic.rmi.internal
      BasicServerRef$1.run
      1. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)
      1 frame
    12. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      1 frame
    13. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
      1 frame
    14. weblogic.rmi.internal
      BasicServerRef$BasicExecuteRequest.run
      1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)
      2. weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)
      3. weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)
      3 frames
    15. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
      2 frames