java.sql.BatchUpdateException: ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 2839955, 1 year ago
ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000)
java.sql.BatchUpdateException: ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1335)
at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3753)
at oracle.jdbc.driver.OraclePreparedStatement.alwaysOnClose(OraclePreparedStatement.java:10342)
at oracle.jdbc.driver.OracleStatement.hardClose(OracleStatement.java:1633)
at oracle.jdbc.driver.OracleStatement.hardClose(OracleStatement.java:1622)
at oracle.jdbc.driver.OraclePreparedStatement.hardClose(OraclePreparedStatement.java:10300)
at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1612)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1541)
at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:77)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:78)
at oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.GeneratePreparedStatement.cleanUp(GeneratePreparedStatement.java:244)
at oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.MetadataFileParser.cleanUp(MetadataFileParser.java:290)
at oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.MetadataFileParser.loadData(MetadataFileParser.java:245)
at oracle.dbtools.migration.workbench.plugin.SQLServer2000DoOfflineCaptureLoad.populateSourceModel(SQLServer2000DoOfflineCaptureLoad.java:264)
at oracle.dbtools.migration.workbench.plugin.SQLServer2000DoOfflineCaptureLoad.loadSourceModel(SQLServer2000DoOfflineCaptureLoad.java:142)
at oracle.dbtools.migration.workbench.plugin.SQLServer2000OfflineCapturer.captureInitializeImpl(SQLServer2000OfflineCapturer.java:178)
at oracle.dbtools.migration.capture.AbstractOfflineCapturer.captureInitialize(AbstractOfflineCapturer.java:49)
at oracle.dbtools.migration.workbench.core.WorkbenchController.doOfflineCapture(WorkbenchController.java:241)
at oracle.dbtools.migration.workbench.core.WorkbenchController.processOfflineOutput(WorkbenchController.java:209)
at oracle.dbtools.migration.workbench.core.WorkbenchController.handleEvent(WorkbenchController.java:116)
at oracle.ide.controller.IdeAction.performAction(IdeAction.java:524)
at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:855)
at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:496)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.