objectbridge-developers

[OJB-developers] MySQL question with OJB

[David F. <dw...@la...>]

My application runs fine with hsqldb under ojb-.0.8.400
When I try using mysql, I get the error message:

[ojb.broker.accesslayer.RsIterator] ERROR: null

in every query.

In addition, I see in some cases an 
[ojb.broker.singlevm.PersistenceBrokerImpl] ERROR: expected interface 
gov.lanl.COAS.ObservationValue_

and there is an ojb.brokerPersistentBrokerSQLException thrown in 
materializeObject.

the class listed above is in a ReferenceDescriptor for a polymorphic object.

I don't see any observable errors when I load the database.

I don't understand why mysql should behave differently from hsqldb.
Is something else needed for ojb with mysql to be able to handle 
polymorphic objects?

Thanks,

Dave

Re: [OJB-developers] MySQL question with OJB

[David F. <dw...@la...>]

I should attach a log and traceback that might prove useful:

[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: getIteratorFromQuery 
class gov.lanl.COAS.ObservationData_, Query from class 
gov.lanl.COAS.ObservationData_ where ( ( personId LIKE  ? )  AND  (code=? ) 
)  AND  (( startTime>= ? )  AND  (startTime<= ? )  OR ( stopTime<= ? 
)  AND  (stopTime>= ? ) )
[ojb.broker.accesslayer.RsIterator] DEBUG: RsIterator(Query from class 
gov.lanl.COAS.ObservationData_ where ( ( personId LIKE  ? )  AND  (code= ? 
) )  AND  (( startTime>= ? )  AND  (startTime<= ? )  OR ( stopTime<= ? 
)  AND  (stopTime>= ? ) ) , table:            ObservationData_
FieldDescriptions:      [Lojb.broker.metadata.FieldDescriptor;@8d7ace)
[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: getObjectByIdentity 
gov.lanl.COAS.ObservationValue_{0}
[ojb.broker.singlevm.PersistenceBrokerImpl] ERROR: expected type: interface 
gov.lanl.COAS.ObservationValue_
[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: getObjectByIdentity 
gov.lanl.COAS.ObservationValue_{0}
[ojb.broker.accesslayer.RsIterator] ERROR: null
ojb.broker.PersistenceBrokerSQLException
         at 
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:352)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.java:1074)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBrokerImpl.java:1169)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(PersistenceBrokerImpl.java:744)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceBrokerImpl.java:519)
         at 
ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:269)
         at ojb.broker.accesslayer.RsIterator.next(RsIterator.java:153)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:888)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:954)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1042)
         at 
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1029)
         at 
gov.lanl.Database.OJBDatabaseMgr.retrieveElements(OJBDatabaseMgr.java:429)
         at 
gov.lanl.COAS.QueryAccessImpl.retrieveObservations(QueryAccessImpl.java:1030)
         at 
gov.lanl.COAS.QueryAccessImpl.getObservationsWithPolicy(QueryAccessImpl.java:812)
         at 
gov.lanl.COAS.QueryAccessImpl.get_observations_by_time(QueryAccessImpl.java:403)
         at 
org.omg.DsObservationAccess.QueryAccessPOA._OB_op_get_observations_by_time(QueryAccessPOA.java:430)
         at 
org.omg.DsObservationAccess.QueryAccessPOA._invoke(QueryAccessPOA.java:138)
         at 
com.ooc.OBPortableServer.ServantDispatcher.dispatch(ServantDispatcher.java:211)
         at com.ooc.OBPortableServer.POA_impl._OB_dispatch(POA_impl.java:1734)
         at 
com.ooc.OB.DispatchRequest_impl.invoke(DispatchRequest_impl.java:52)
         at 
com.ooc.OB.DispatchSameThread_impl.dispatch(DispatchStrategyFactory_impl.java:46)
         at com.ooc.OB.Upcall.invoke(Upcall.java:426)
         at 
com.ooc.OB.GIOPServerWorkerThreaded.receiverRun(GIOPServerWorkerThreaded.java:528)
         at 
com.ooc.OB.GIOPServerWorkerThreaded$ReceiverThread.run(GIOPServerWorkerThreaded.java:70)
Caused by: java.sql.SQLException: No value specified for parameter 2
         at org.gjt.mm.mysql.PreparedStatement.executeQuery(Unknown Source)
         at 
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:327)
         ... 23 more

The hsqldb version looks almost the same up to the error.   It gives a 
warning about a defining
a public constructor for gov.lanl.COAS.String_ which is in instance of the 
gov.lanl.COAS.ObservationValue_ interface
and proceeds to get the object.

Suggestions would be appreciated.

Dave
At 04:21 PM 6/3/2002 -0600, David Forslund wrote:
>My application runs fine with hsqldb under ojb-.0.8.400
>When I try using mysql, I get the error message:
>
>[ojb.broker.accesslayer.RsIterator] ERROR: null
>
>in every query.
>
>In addition, I see in some cases an 
>[ojb.broker.singlevm.PersistenceBrokerImpl] ERROR: expected interface 
>gov.lanl.COAS.ObservationValue_
>
>and there is an ojb.brokerPersistentBrokerSQLException thrown in 
>materializeObject.
>
>the class listed above is in a ReferenceDescriptor for a polymorphic object.
>
>I don't see any observable errors when I load the database.
>
>I don't understand why mysql should behave differently from hsqldb.
>Is something else needed for ojb with mysql to be able to handle 
>polymorphic objects?
>
>Thanks,
>
>Dave
>
>
>_______________________________________________________________
>
>Don't miss the 2002 Sprint PCS Application Developer's Conference
>August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
>_______________________________________________
>Objectbridge-developers mailing list
>Obj...@li...
>https://lists.sourceforge.net/lists/listinfo/objectbridge-developers