My Clob values are showing in the UI as "weblogic.jdbc.wrapper.Clob_oracle_sql_CLOB@46c". When I try modify a value or add a new row I get this exception on commit:
<RichExceptionHandler> <_logUnhandledException> ADF_FACES-60098:Faces lifecycle receives unhandled exceptions in phase INVOKE_APPLICATION 5
javax.faces.el.EvaluationException: oracle.jbo.JboException: [oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Update": SQL Statement "null".]
at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:58)
at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1545)
at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183)
In my EO the column Type is set to ClobDomain. I created the ClobConverter class in my View project (com.mtg.fwd.view.converter.ClobConverter) as discussed in this thread (). I added this code to faces-config.xml:
<converter>
<description>convert clob to string and back</description>
<converter-id>convert.Clob</converter-id>
<converter-class>com.mtg.fwd.view.converter.ClobConverter</converter-class>
</converter>
In the jsff I set the converter attribute to convert.Clob for the column. I originally had this set to oracle.ordDomain and that did not work which is why I am trying the method.
<af:inputText value="#{bindings.Gvsql.inputValue}"
label="SQL Statement"
required="#{bindings.Gvsql.hints.mandatory}"
columns="100"
maximumLength="#{bindings.Gvsql.hints.precision}"
shortDesc="#{bindings.Gvsql.hints.tooltip}"
id="it7"
rows="10"
converter="convert.Clob">
<f:validator binding="#{bindings.Gvsql.validator}"/>
</af:inputText>
What should I look at next?
Using JDev 11.1.2.4.0
Thank you
Rudy