Hello everybody,
Finally I have found my problem! It was so stupid!!
I wrote:
While (iter.hasNext());
{
System.out.Println(iter.next());
}
and the ";" at the end of the "While" isn't very recommended!!
Sorry, I'm so stupid!!
Thank to all of you for your help.
Now I can retrieve data from database but these are in this format:
wocconfigdb400.data.OjbTestTable@168e23
wocconfigdb400.data.OjbTestTable@4da8f4
What does it mean?
Thank you
Sylvain
-----Message d'origine-----
De: Matthew Baird [mailto:[EMAIL PROTECTED]]
Date: mercredi, 11. septembre 2002 17:58
À: OJB Users List
Objet: RE: Needs help for retrieving data with OJB
you are using db2, set jdbc level to 1.0. OJB optimizes some parts at runtime
dependent on jdbc level. The "error" you see is really a information statement and the
code will degrade nicely in that part, but I'm not sure about other parts of the code.
Best bet is to set jdbc level to 1.0
The current jdbc drivers for db2 are sketchy. Surprising, considering IBM's
committement to java.
m
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wed 9/11/2002 4:17 AM
To: [EMAIL PROTECTED]
Cc:
Subject: RE: Needs help for retrieving data with OJB
Here you are:
OJB test:
[BOOT] INFO: OJB.properties:
file:/C:/documents/download/eclipse/eclipse-SDK-2.0-win32/workspace/WocConfigDB400/OJB.properties
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Already created
persistence broker instances: 0
[DEFAULT] INFO: OJB Descriptor Repository:
file:/C:/documents/download/eclipse/eclipse-SDK-2.0-win32/workspace/WocConfigDB400/repository.xml
[DEFAULT] INFO: ...Finished parsing
[org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use sequence
manager class: class org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl
The list of all Entries:
[org.apache.ojb.broker.accesslayer.AbstractPoolableConnectionFactory] INFO: # Create
connection pool for JdbcDescriptorKey -1253692131 #
[org.apache.ojb.broker.accesslayer.AbstractConnectionFactory] INFO: # Already created
connections: 1 returning : com.microsoft.jdbc.sqlserver.SQLServerConnection@31aa65
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: getCollectionByQuery
(class org.apache.ojb.broker.util.collections.ManageableVector, class
wocconfigdb400.data.OjbTestTable, Query from class wocconfigdb400.data.OjbTestTable
where null)
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: getIteratorFromQuery
class wocconfigdb400.data.OjbTestTable, Query from class
wocconfigdb400.data.OjbTestTable where null
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: RsIterator(Query from class
wocconfigdb400.data.OjbTestTable where null, table: ojbtest_table
FieldDescriptions: [Lorg.apache.ojb.broker.metadata.FieldDescriptor;@617189)
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class
wocconfigdb400.data.OjbTestTable where null
[org.apache.ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT
A0.APPL_USAGE_FLAG_FRENCH,A0.APPL_COMMENT,A0.APPL_FULL_NAME,A0.APPL_VERSION,A0.APPL_ID,A0.APPL_DHCP
FROM ojbtest_table A0
[org.apache.ojb.broker.accesslayer.RsIterator] INFO: Your driver does not support
advanced JDBC Functionality, you cannot call size()
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> true
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> false
-----Message d'origine-----
De: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]]
Date: mercredi, 11. septembre 2002 12:32
À: OJB Users List
Objet: RE: Needs help for retrieving data with OJB
hi sylvain,
could you please enable logging in ojb.properties so we can see where it
comes to a halt.
jakob
> I add broker.beginTransaction() before Query query = new
> QueryByCriteria .... and broker.commitTransaction() at the end but NO
> DIFFERENCE!!
>
> Thank you
> Sylvain
>
> -----Message d'origine-----
> De: Armin Waibel [ mailto:[EMAIL PROTECTED]]
> Date: mercredi, 11. septembre 2002 10:08
> À: OJB Users List
> Objet: Re: Needs help for retrieving data with OJB
>
>
> Try this out please.
>
> Armin
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, September 11, 2002 10:01 AM
> Subject: RE: Needs help for retrieving data with OJB
>
>
> No, I don't use it.
>
> Sylvain
>
> -----Message d'origine-----
> De: Armin Waibel [ mailto:[EMAIL PROTECTED]]
> Date: mercredi, 11. septembre 2002 09:54
> À: OJB Users List
> Objet: Re: Needs help for retrieving data with OJB
>
>
> Did you use the transaction demarcation of the PB-api in your code?
> broker.beginTransaction
> broker.commitTransaction
>
> Armin
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 11, 2002 9:33 AM
> Subject: RE: Needs help for retrieving data with OJB
>
>
> Hi Charles,
>
> Yes I have done! With no errors!
>
>
> Sylvain
>
> -----Message d'origine-----
> De: Charles Anthony [ mailto:[EMAIL PROTECTED]]
> Date: mercredi, 11. septembre 2002 09:30
> À: 'OJB Users List'
> Objet: RE: Needs help for retrieving data with OJB
>
>
> Hi Sylvain,
>
> On my way into work this morning something struck me; have you run the
> JUNIT
> test bed agains SQL Server ?
>
> See http://jakarta.apache.org/ojb/platforms.html for how to do this.
> This
> would tell you if there are any major problems with your environment
> (like
> not being able to read data !)
>
> Cheers,
>
> Charles.
>
> >-----Original Message-----
> >From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]]
> >Sent: 11 September 2002 08:28
> >To: [EMAIL PROTECTED]
> >Subject: Needs help for retrieving data with OJB
> >
> >
> >Hello everybody,
> >
> >I'm new in OJB world and I try to start a project with this
> >persistence layer tool.
> >
> >I'm trying to start with the PersistenceBroker API. I use the
> >Tutorial 1 examples.
> >
> >If I had no problem to store or delete objects with this API,
> >it's aboslutely impossible for me to retrieve something from
> >the database. My program waits for something and I have no
> >idea what's happen.
> >
> >I have already posted some tips (thank you Charles and Frank)
> >but no chance. That's not work!!
> >
> >Is there other method to retrieve objects from the database
> >with this API?
> >
> >Maybe someone could send me a simple piece of code which work
> >and I could test it and be sure there are other problems (with
> >the JDBC driver or the MS SQL Server database)?
> >
> >Any suggestions will be very appreciated.
> >
> >Thank you
> >Sylvain
> >
> >--
> >To unsubscribe, e-mail:
> < mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> < mailto:[EMAIL PROTECTED]>
>
>
> This email and any attachments are strictly confidential and are
> intended
> solely for the addressee. If you are not the intended recipient you must
> not disclose, forward, copy or take any action in reliance on this
> message
> or its attachments. If you have received this email in error please
> notify
> the sender as soon as possible and delete it from your computer systems.
> Any views or opinions presented are solely those of the author and do
> not
> necessarily reflect those of HPD Software Limited or its affiliates.
>
> At present the integrity of email across the internet cannot be
> guaranteed
> and messages sent via this medium are potentially at risk. All
> liability
> is excluded to the extent permitted by law for any claims arising as a
> re-
> sult of the use of this medium to transmit information by or to
> HPD Software Limited or its affiliates.
>
>
>
> --
> To unsubscribe, e-mail:
> < mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> < mailto:[EMAIL PROTECTED]>
>
>
> --
> To unsubscribe, e-mail:
> < mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> < mailto:[EMAIL PROTECTED]>
>
>
>
>
>
> --
> To unsubscribe, e-mail:
> < mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> < mailto:[EMAIL PROTECTED]>
>
>
> --
> To unsubscribe, e-mail:
> < mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> < mailto:[EMAIL PROTECTED]>
>
>
>
>
>
> --
> To unsubscribe, e-mail:
> < mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> < mailto:[EMAIL PROTECTED]>
>
>
> --
> To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: < mailto:[EMAIL PROTECTED]>
>
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
--
To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: < mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: < mailto:[EMAIL PROTECTED]>
