Hi: Thanks! It works.
I wondering why OJB does not support BOOLEAN, since it is a valid type for JDBC 3.0. 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]
