Hi Gilles,
First, I'd like to see the Castor log where the full SQL statements
are seen.
Second, I'd like to see your mapping.xml
Oleg
gilles dodinet wrote:
> hi oleg,
> thanks for your help, it works better now : no probs when loading clients
> ("select c from Client c") ; but i got another exception when trying to get
> the products ("select c from Produit c"). i can't retrieve the exact sql
> error ("PersistenceException nested error : [..]"). here's the StackTrace :
> java.sql.SQLException: Syntax error or access violation: You have an error
> in your SQL syntax near 'null promo_prod ON
> produit_promotionnel.id=promo_prod.promo_id,produit WHERE pro' at line 1
> at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
> at
> org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java:288)
> at org.exolab.castor.jdo.engine.SQLEngine.load(SQLEngine.java:1008)
> at org.exolab.castor.persist.ClassMolder.load(ClassMolder.java:646)
> at org.exolab.castor.persist.LockEngine.load(LockEngine.java:361)
> at
> org.exolab.castor.persist.TransactionContext.load(TransactionContext.java:545)
> at
> org.exolab.castor.persist.TransactionContext.load(TransactionContext.java:479)
> at org.exolab.castor.persist.ClassMolder.load(ClassMolder.java:742)
> at org.exolab.castor.persist.LockEngine.load(LockEngine.java:361)
> at
> org.exolab.castor.persist.TransactionContext.load(TransactionContext.java:545)
> at org.exolab.castor.persist.QueryResults.fetch(QueryResults.java:229)
> at
>
>org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:573)
> at
>
>org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:556)
> at estore.EstoreMain.oqlQueryTest(EstoreMain.java:24)
> at estore.EstoreMain.goGoGo(EstoreMain.java:214)other ex..
> org.exolab.castor.jdo.TransactionAbortedException: Nested error:
> org.exolab.castor.jdo.PersistenceException: Object, estore.Produit/321,
> isn't loaded in the persistence storage!
> at estore.EstoreMain.main(EstoreMain.java:193)
> org.exolab.castor.jdo.PersistenceException: Object, estore.Produit/321,
> isn't loaded in the persistence storage!
> at org.exolab.castor.persist.ClassMolder.preStore(ClassMolder.java:1106)
> at org.exolab.castor.persist.LockEngine.preStore(LockEngine.java:710)
> at
> org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java:1146)
> at org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:498)
> at estore.EstoreMain.oqlQueryTest(EstoreMain.java:48)
> at estore.EstoreMain.goGoGo(EstoreMain.java:214)
> at estore.EstoreMain.main(EstoreMain.java:193
> thx.
> --
> gilles
>>From: Oleg Nitz <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: [EMAIL PROTECTED]
>>Subject: Re: [castor-dev] Simple OQL ... ?
>>Date: Sat, 4 Aug 2001 00:29:40 +0300
>>
>>Hi Gilles,
>>
>>I guess you use "generic" driver, which is set in database.xml
>>
>><database name="..." engine="generic" >
>>
>>Should be
>>
>><database name="..." engine="mysql" >
>>
>>MySQL driver doesn't generate "{oj" at all.
>>
>>Oleg
>>
>>On Wednesday 01 August 2001 10:43, gilles dodinet wrote:
>> > hi..
>> >
>> > m always in trouble with generation of bad sql queries... i've posted
>>this
>> > mess several days ago but got no answer.. could someone gimme a clue..
>> > thanks.. below the previous post (no change - same error :()
>> >
>> > (i use mysql 3.23)
>> >
>> > Castor generates this sql query below (resulting of oql query "select p
>> > from estore.Produit p") :
>> >
>> > SELECT
>> >
>>produit.id,produit.description,produit.prix,promo_prod.promo_id,ligne_de_co
>> >mmande.id FROM
>> > {oj produit LEFT OUTER JOIN promo_prod ON
>> > produit.id=promo_prod.produit_id
>> > LEFT OUTER JOIN ligne_de_commande ON
>> > produit.id=ligne_de_commande.prd_id};
>> >
>> > that throws an SqlException. it think it would have generated this one
>> > rather that don't produce sql error :
>> >
>> > SELECT
>> >
>>produit.id,produit.description,produit.prix,promo_prod.promo_id,ligne_de_co
>> >mmande.id FROM { oj
>> > {oj produit LEFT OUTER JOIN promo_prod ON
>> > produit.id=promo_prod.produit_id }
>> > LEFT OUTER JOIN ligne_de_commande ON
>> > produit.id=ligne_de_commande.prd_id};
>> >
>> > does this problem come from a mapping error or is this a bug in castor??
>> > (below portions of mapping files)
>> >
>> > -------------------- MAPPING -------------
>> > in produit.xml (class Produit and inherited classes) :
>> >
>> > <field name="ldc" type="estore.LigneDeCommande" required="false"
>> > collection="vector">
>> > <sql many-key="prd_id"/>
>> > </field>
>> >
>> > in commande.xml (class Commande and LigneDeCommande ) :
>> >
>> > <field name="prd" type="estore.Produit">
>> > <sql name="prd_id" />
>> > </field>
>> > -----------------------------END MAPPING ---------------------
>> >
>> > thx for your replies.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > _________________________________________________________________
>> > T�l�chargez MSN Explorer gratuitement � l'adresse
>> > http://explorer.msn.fr/intl.asp
>> >
>> > -----------------------------------------------------------
>> > If you wish to unsubscribe from this mailing, send mail to
>> > [EMAIL PROTECTED] with a subject of:
>> > unsubscribe castor-dev
>>
>>-----------------------------------------------------------
>>If you wish to unsubscribe from this mailing, send mail to
>>[EMAIL PROTECTED] with a subject of:
>> unsubscribe castor-dev
>>
> _________________________________________________________________
> T�l�chargez MSN Explorer gratuitement � l'adresse
> http://explorer.msn.fr/intl.asp
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
