Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-user@db.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
  b=i7+mcMiVArBxFLQxpnDtjqYikM77OXXJGoHCvTY7S4/N6LP+7ub7fPCp9TEglRs5bJLGe7LuDyb52N+FCy9qY7H7ztbXCNCCsScOL2t6Tv2yx3PqMrndT2u+fdh06hiTdQs2A5gOOk97lnGaOQdV2F9VD4bp5kXnSj+cwAu5ZAc=;
Date: Thu, 20 Dec 2007 11:47:04 -0800 (PST)
From: tyju tiui <jckdnk111@yahoo.com>
Subject: Re: Can't delete rows from DynaBean
To: ddlutils-user@db.apache.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-193378714-1198180024=:97846"
Message-ID: <702885.97846.qm@web51406.mail.re2.yahoo.com>

--0-193378714-1198180024=:97846
Content-Type: text/plain; charset=us-ascii

I found out why this was happening ... I'm testing with PostgreSQL which aparently doesn't handle resultSetMetadata  very well.

Luckily the creators of DdlUtils thought of this and wrote in the ability to pass in "query hints" which is essentially just an array of Table objects which DdlUtils uses to lookup columns and match them back to their respective tables when the resultSetMetadata fails to offer-up this info ... brilliant!

Now I pass in my "query hints" and everything works blissfully.

Ty

----- Original Message ----
From: tyju tiui <jckdnk111@yahoo.com>
To: ddlutils-user@db.apache.org
Sent: Wednesday, December 19, 2007 1:11:30 PM
Subject: Can't delete rows from DynaBean


Hi,

I'm trying to delete some records using DynaBeans returned from a 'platform.fetch()' call.
The List returned is full of perfectly fine DynaBeans (as far as I can tell) but when I issue a 'platform.delete()' DdlUtils throws the following error:

org.apache.ddlutils.dynabean.SqlDynaException: The dyna bean is not an instance of a SqlDynaClass
        at org.apache.ddlutils.dynabean.DynaClassCache.getDynaClass(DynaClassCache.java:135)
        at org.apache.ddlutils.model.Database.getDynaClassFor(Database.java:551)
        at org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:1923)
        at
 org.apache.ddlutils.platform.PlatformImplBase.delete(PlatformImplBase.java:1906)

I looked at the code and I'm unsure how to properly get an instance of SqlDynaClass from a 'fetch' or 'query'?

Any help would be appreciated.

Thanks,

Ty


      Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

--0-193378714-1198180024=:97846--