nick
I'm new here

Oracle 17157

Jump to solution

We are using Oracle with ojdbc14-10.1.0.5. Trying to insert data of size greater than 32766 characters into a CMS_INPUT_DOM field (which is mapped to CLOB column) results in the following exception:

Client Version: 4.2.446.45868

Java Version: 1.7.0 Oracle Corporation

FSVersion=4.2.446.45868#2115;JDK=1.7.0 32bit Oracle Corporation;OS=Windows 7 6.1 x86;Date=05.10.2011 10:27:12

de.espirit.or.ORException: Error code: 17157, state: null

          at de.espirit.or.impl.AbstractUpdateStatement.fillParameters(AbstractUpdateStatement.java:148)

          at de.espirit.or.impl.InsertStatement.fillParameters(InsertStatement.java:29)

          at de.espirit.or.impl.AbstractUpdateStatement.execute(AbstractUpdateStatement.java:167)

          at de.espirit.or.impl.AbstractUpdateStatement.executeUpdate(AbstractUpdateStatement.java:73)

          at de.espirit.or.impl.TemporalCommandHandler.handle(TemporalCommandHandler.java:77)

          at de.espirit.or.impl.CreateCommand.accept(CreateCommand.java:49)

          at de.espirit.or.impl.AbstractSessionHandler.commit(AbstractSessionHandler.java:628)

          at de.espirit.or.impl.AbstractSessionHandler.commit(AbstractSessionHandler.java:75)

          at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.commit(ContentManagerImpl.java:1207)

          at de.espirit.firstspirit.content.ContentManagerImpl.commit(ContentManagerImpl.java:630)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          at java.lang.reflect.Method.invoke(Method.java:597)

          at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:62)

          at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:91)

          at de.espirit.firstspirit.server.io.handler.ManagerCall.handle(ManagerCall.java:67)

          at de.espirit.firstspirit.server.io.ManagerCallWorker.run(ManagerCallWorker.java:108)

          at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:553)

          at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:520)

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

          at java.util.concurrent.FutureTask.run(FutureTask.java:138)

          at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:419)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

          at java.util.concurrent.FutureTask.run(FutureTask.java:138)

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

          at java.lang.Thread.run(Thread.java:662)

          at de.espirit.common.util.SuspendableThread.run(SuspendableThread.java:36)

Caused by: java.sql.SQLException: setString can only process strings of less than 32766 chararacters

          at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

          at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)

          at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)

          at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4746)

          at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:7594)

          at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7546)

          at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8157)

          at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8140)

          at de.espirit.or.impl.AbstractUpdateStatement.fillParameters(AbstractUpdateStatement.java:138)

          at de.espirit.or.impl.InsertStatement.fillParameters(InsertStatement.java:29)

          at de.espirit.or.impl.AbstractUpdateStatement.execute(AbstractUpdateStatement.java:167)

          at de.espirit.or.impl.AbstractUpdateStatement.executeUpdate(AbstractUpdateStatement.java:73)

          at de.espirit.or.impl.TemporalCommandHandler.handle(TemporalCommandHandler.java:77)

          at de.espirit.or.impl.CreateCommand.accept(CreateCommand.java:49)

          at de.espirit.or.impl.AbstractSessionHandler.commit(AbstractSessionHandler.java:628)

          at de.espirit.or.impl.AbstractSessionHandler.commit(AbstractSessionHandler.java:75)

          at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.commit(ContentManagerImpl.java:1207)

          at de.espirit.firstspirit.content.ContentManagerImpl.commit(ContentManagerImpl.java:630)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          at java.lang.reflect.Method.invoke(Method.java:597)

          at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:62)

          at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:91)

          at de.espirit.firstspirit.server.io.handler.ManagerCall.handle(ManagerCall.java:67)

          at de.espirit.firstspirit.server.io.ManagerCallWorker.run(ManagerCallWorker.java:108)

          at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:553)

          at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:520)

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

          at java.util.concurrent.FutureTask.run(FutureTask.java:138)

          at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:419)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

          at java.util.concurrent.FutureTask.run(FutureTask.java:138)

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

          at de.espirit.firstspirit.client.io.ServerCaller.callManager(ServerCaller.java:372)

          at de.espirit.firstspirit.io.DefaultClientHandler.callManager(DefaultClientHandler.java:49)

          at de.espirit.firstspirit.client.io.RemoteManagerCaller.invoke(RemoteManagerCaller.java:52)

          at de.espirit.firstspirit.server.$Proxy96.commit(Unknown Source)

          at de.espirit.firstspirit.store.access.templatestore.SessionHandlerImpl.commit(SessionHandlerImpl.java:113)

          at de.espirit.or.impl.SessionImpl.doCommit(SessionImpl.java:191)

          at de.espirit.or.impl.AbstractSession.commit(AbstractSession.java:525)

          at de.espirit.firstspirit.store.access.contentstore.DatasetImpl.save(DatasetImpl.java:928)

          at de.espirit.firstspirit.client.gui.tree.store.contentstore.AbstractGuiXmlPanel.save(AbstractGuiXmlPanel.java:460)

          at de.espirit.firstspirit.client.gui.tree.store.contentstore.ContentGuiXmlPanel.persist(ContentGuiXmlPanel.java:392)

          at de.espirit.firstspirit.client.gui.tree.store.contentstore.ContentGuiXmlPanel.persist(ContentGuiXmlPanel.java:362)

          at de.espirit.firstspirit.client.gui.tree.store.contentstore.ContentGuiXmlPanel.save(ContentGuiXmlPanel.java:357)

          at de.espirit.firstspirit.client.gui.tree.store.contentstore.ContentGuiXmlPanel$GuiXmlToolbar$2.actionPerformed(ContentGuiXmlPanel.java:547)

          at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

          at de.espirit.firstspirit.common.gui.FsButton.fireActionPerformed(FsButton.java:86)

          at de.espirit.firstspirit.common.gui.StoreHoverButton.fireActionPerformed(StoreHoverButton.java:97)

          at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

          at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

          at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

          at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

          at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)

          at java.awt.Component.processMouseEvent(Unknown Source)

          at javax.swing.JComponent.processMouseEvent(Unknown Source)

          at java.awt.Component.processEvent(Unknown Source)

          at java.awt.Container.processEvent(Unknown Source)

          at java.awt.Component.dispatchEventImpl(Unknown Source)

          at java.awt.Container.dispatchEventImpl(Unknown Source)

          at java.awt.Component.dispatchEvent(Unknown Source)

          at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

          at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

          at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

          at java.awt.Container.dispatchEventImpl(Unknown Source)

          at java.awt.Window.dispatchEventImpl(Unknown Source)

          at java.awt.Component.dispatchEvent(Unknown Source)

          at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

          at java.awt.EventQueue.access$000(Unknown Source)

          at java.awt.EventQueue$3.run(Unknown Source)

          at java.awt.EventQueue$3.run(Unknown Source)

          at java.security.AccessController.doPrivileged(Native Method)

          at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

          at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

          at java.awt.EventQueue$4.run(Unknown Source)

          at java.awt.EventQueue$4.run(Unknown Source)

          at java.security.AccessController.doPrivileged(Native Method)

          at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

          at java.awt.EventQueue.dispatchEvent(Unknown Source)

          at de.espirit.firstspirit.client.AWTDispatchingEventQueue.defaultDispatchEvent(AWTDispatchingEventQueue.java:130)

          at de.espirit.firstspirit.client.AWTDispatchingEventQueue._dispatchEvent(AWTDispatchingEventQueue.java:115)

          at de.espirit.firstspirit.client.AWTDispatchingEventQueue.dispatchEvent(AWTDispatchingEventQueue.java:108)

          at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

          at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

          at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

          at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

          at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

I tried to set the Oracle specific property SetBigStringTryClob as a JDBC connection parameter like:

    jdbc.property.oracle.jdbc.SetBigStringTryClob=true

But this doesn't seem to have an effect.

Any ideas?

0 Kudos
1 Solution

Accepted Solutions

The correct property seems to be just

jdbc.property.SetBigStringTryClob=true

Then, after restarting the server, it's working fine.

View solution in original post

0 Kudos
2 Replies
feddersen
Community Manager

Have you restarted the FirstSpirit server after applying the change?

The correct property seems to be just

jdbc.property.SetBigStringTryClob=true

Then, after restarting the server, it's working fine.

0 Kudos