Hi, -----Ursprungligt meddelande----- Från: Armin Waibel [mailto:[EMAIL PROTECTED] Skickat: den 17 januari 2006 12:03 Till: OJB Users List Ämne: Re: [Fwd: SV: possible newbie Question; Wrong Long id when fetching..]
Hi, > > Im using, db-obj-1.0.3.jar > > metadata mapping: > <class-descriptor class="AdvertisementType" table="ADVERTISEMENTTYPE"> > <field-descriptor > name="id" > column="ID" > jdbc-type="BIGINT" > nullable="false" > primarykey="true" > autoincrement="true"/> > > <field-descriptor name="name" nullable="false" column="NAME" > jdbc-type="VARCHAR"/> > </class-descriptor> > In your previous post you said "mysql db with autoincrement the database", so does it mean you are using database identity columns (and SequenceManagerNativeImpl) or do you use sequence id's generated by OJB (e.g. SequenceManagerHighLowImpl)? Seems to me that im using, SequenceManagerHighLowImpl, the strange is that i have exactly the same type of objects with no problems what so ever, the only differecne is the java class name, identical metamappings, and java execution code... below my repository_database.xml. <jdbc-connection-descriptor jcd-alias="default" default-connection="true" platform="MySQL" jdbc-level="3.0" driver="org.gjt.mm.mysql.Driver" protocol="jdbc" subprotocol="mysql" dbalias="//localhost:3306/scms?useUnicode=true" username="*****" password="******" batch-mode="false" useAutoCommit="1" ignoreAutoCommitExceptions="false"> <!-- alternative cache implementations, see docs section "Caching" --> <object-cache class="org.apache.ojb.broker.cache.ObjectCacheTwoLevelImpl"> <!-- meaning of attributes, please see docs section "Caching" --> <!-- common attributes --> <attribute attribute-name="cacheExcludes" attribute-value=""/> <!-- ObjectCacheTwoLevelImpl attributes --> <attribute attribute-name="applicationCache" attribute-value="org.apache.ojb.broker.cache.ObjectCacheDefaultImpl"/> <attribute attribute-name="copyStrategy" attribute-value="org.apache.ojb.broker.cache.ObjectCacheTwoLevelImpl$CopyStrategyImpl"/> <!-- ObjectCacheDefaultImpl attributes --> <attribute attribute-name="timeout" attribute-value="900"/> <attribute attribute-name="autoSync" attribute-value="true"/> <attribute attribute-name="cachingKeyType" attribute-value="0"/> <attribute attribute-name="useSoftReferences" attribute-value="true"/> </object-cache> <connection-pool maxActive="30" validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="false" logAbandoned="true" whenExhaustedAction="0" removeAbandoned="true" removeAbandonedTimeout="100" /> <!-- alternative sequence manager implementations, see docs section "Sequence Manager" --> <sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl"> <!-- meaning of attributes, please see docs section "Sequence Manager" --> <attribute attribute-name="grabSize" attribute-value="20"/> <attribute attribute-name="autoNaming" attribute-value="true"/> <attribute attribute-name="sequenceStart" attribute-value="0"/> <attribute attribute-name="globalSequenceId" attribute-value="false"/> </sequence-manager> </jdbc-connection-descriptor> > Generated sql > SQL:SELECT A0.ID,A0.NAME FROM ADVERTISEMENTTYPE A0 ORDER BY 1 > > However, noticed now that im using, the deprecated method > crit.addOrderBy(orderBy, sortAscending); Could that be the problem? I don't think so. regards, Armin > Strange that it works for other objects with exact same fields and > metadata mappings, the AdvertisementType used to be named only Type, > changed it for possible collitions... > > thanks, > > christian vejrich. > > > > -----Ursprungligt meddelande----- > Från: Armin Waibel [mailto:[EMAIL PROTECTED] > Skickat: den 17 januari 2006 10:57 > Till: OJB Users List > Ämne: Re: possible newbie Question; Wrong Long id when fetching.. > > Hi Christian, > > Christian Vejrich wrote: > >> When inserting a new object, mysql db with autoincrement the database >> stores the object correct and sets an correct id, but when fetching all >> the stored objects( ojb does a select *) , the ids in the objects >> returned from ojb are completly different ones? Any ideas? >> > > Could you please post more details. Version of OJB? Code snippet, > metadata mapping? Generated sql, expected sql,.... > > regards, > Armin > > >> thanks, >> >> -c. >> >> --------------------------------------------------------------------- >> 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]