Antonio Gallardo wrote:
Hi:
Thanks! It works.
I wondering why OJB does not support BOOLEAN, since it is a valid type for JDBC 3.0.
No special reason. Only laziness ;-)
cu, Thomas
Best Regards,
Antonio Gallardo
Gelhar, Wallace Joseph dijo:
Hi Antonio,
Try using BIT as the type.
Wally Gelhar
-----Original Message----- From: Antonio Gallardo Sent: Saturday, November 08, 2003 6:01 AM To: [EMAIL PROTECTED] Subject: o.a.ojb.broker.PersistenceBrokerSQLException: Unknown Types value
Hi:
I am trying to insert the following class into a PostgreSQL DB using JDO. I got an Exception:
org.apache.ojb.broker.PersistenceBrokerSQLException: Unknown Types value.
I noted OJB correctly got the nextVal of the sequence. But then it throw the exception.
Questions:
Is supported the BOOLEAN datatype?
Or if there is other problem, please help.
Best Regards,
Antonio Gallardo
<class-descriptor class="test.Auth_role" table="AUTH_ROLE"> <field-descriptor name="rol_id" primarykey="true" nullable="false" autoincrement="true" sequence-name="auth_rol_rol_id_seq" column="ROL_ID" jdbc-type="INTEGER"/> <field-descriptor name="rol_name" nullable="false" column="ROL_NAME" jdbc-type="VARCHAR"/> <field-descriptor name="rol_enable" column="ROL_ENABLE" jdbc-type="BOOLEAN"/> <collection-descriptor name="auth_user_roleList" element-class-ref="test.Auth_user_role" auto-update="false" auto-delete="false"> <inverse-foreignkey field-ref="rol_id"/> </collection-descriptor> <collection-descriptor name="auth_permissionList" element-class-ref="test.Auth_permission" auto-update="false" auto-delete="false"> <inverse-foreignkey field-ref="rol_id"/> </collection-descriptor> </class-descriptor>
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException during the execution of the insert (for a test.Auth_role): Unknown Types value. Unknown Types value. Unknown Types value. at org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1State ment.java:1423) at org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1State ment.java:1429) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen t(Unknown Source) at org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForState ment(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.jdori.sql.OjbStoreManager.insert(Unknown Source) at com.sun.jdori.common.state.PersistentNew.flush(Unknown Source) at com.sun.jdori.common.state.StateManagerImpl.flush(Unknown Source) at org.apache.ojb.jdori.sql.OjbStoreManager.flush(Unknown Source) at com.sun.jdori.common.CacheManagerImpl.flushInstances(Unknown Source) at com.sun.jdori.common.PersistenceManagerImpl.flushInstances(Unknown Source) at com.sun.jdori.common.TransactionImpl.flushInstances(Unknown Source) at com.sun.jdori.common.TransactionImpl.prepareFlush(Unknown Source) at com.sun.jdori.common.TransactionImpl.commit(Unknown Source) at ni.gob.mific.ait.forms.Auth_roleHandler.insert(Auth_roleHandler.java:35) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:230) at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1244) at org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(C ontinuationInterpreter.java:1105) at org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(C ontinuationInterpreter.java:190) at org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(C ontinuationInterpreter.java:138) at org.mozilla.javascript.continuations.InterpretedFunctionImpl.call(Interp retedFunctionImpl.java:121) at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1244) at org.mozilla.javascript.ScriptableObject.callMethod(ScriptableObject.java :1591) at org.apache.cocoon.components.flow.javascript.fom.FOM_JavaScriptInterpret er.handleContinuation(FOM_JavaScriptInterpreter.java:606) at org.apache.cocoon.components.treeprocessor.sitemap.CallFunctionNode.invo ke(CallFunctionNode.java:165) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode. invokeNodes(AbstractParentProcessingNode.java:84) at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.i nvoke(PreparableMatchNode.java:164) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode. invokeNodes(AbstractParentProcessingNode.java:108) at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(P ipelineNode.java:163) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode. invokeNodes(AbstractParentProcessingNode.java:108) at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke( PipelinesNode.java:152) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro cessor.java:354) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro cessor.java:307) at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(Moun tNode.java:132) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode. invokeNodes(AbstractParentProcessingNode.java:84) at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.i nvoke(PreparableMatchNode.java:164) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode. invokeNodes(AbstractParentProcessingNode.java:108) at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(P ipelineNode.java:163) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode. invokeNodes(AbstractParentProcessingNode.java:108) at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke( PipelinesNode.java:152) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro cessor.java:354) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro cessor.java:307) at org.apache.cocoon.Cocoon.process(Cocoon.java:656) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1112) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241 7) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:78 1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:58 9) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:666) at java.lang.Thread.run(Thread.java:534) [JDO] DEBUG: OjbStoreConnector.rollback [ERROR] - org.apache.ojb.jdori.sql.OjbStoreFatalInternalException: org.apache.ojb.jdori.sql.OjbStoreManager.insert NestedThrowables: org.apache.ojb.broker.PersistenceBrokerSQLException: Unknown Types value.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
