yeee!! It works fine!
Thank you very much Charles and all of you.
Sylvain
-----Message d'origine-----
De: Charles Anthony [mailto:[EMAIL PROTECTED]]
Date: jeudi, 12. septembre 2002 10:25
À: 'OJB Users List'
Objet: RE: Needs help for retrieving data with OJB
Excellent ! Had me a bit baffled...
The output is the standard java "toString" method on your objects.
If you want to dump some more interesting data to the console you could
either
a) override toString on the wocconfigdb400.data.OjbTestTable class or
b) change your System.println(iter.next()) to
OjbTestTable entry = (OjbTestTable) iter.next;
String info = entry.getField1() + "," + entry.getField2()
(where Field1 and Field2 are getter methods on your object)
This is just standard java stuff, nothing to do with OJB
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: 12 September 2002 09:21
>To: [EMAIL PROTECTED]
>Subject: RE: Needs help for retrieving data with OJB
>
>
>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/works
pace/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/works
pace/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.AbstractPoolableConnectionFa
>ctory] 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]>
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]>
