Peter,
Is your class org.grimoire.beans.Card mapped? It has to be mapped and I
think the order of the select columns has to match the order in the mapping.
Steve
----- Original Message -----
From: "McEvoy, Peter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 12:14 PM
Subject: [castor-dev] NullPointerException using CALL SQL
> Folks,
> I have a complicated bean that contains a number of collections as well as
properties (simple and complex). I have got all this working fine and dandy
and mapped to my DB schema.
>
> However, I do not use lazy loading, as I have found that within my struts
based webapp, where beans are queried and populated in an ActionClass, and
then referenced in a JSP, that I get "Transaction is closed" error messages
in the JSP pages.
>
> This is fine, I'm not too pushed if individual beans are lazy loaded or
not for most of the time. However there is one case where I would like to
lazy load - and that is usually when I am dealing with large collections of
these beans: my db has about 4/5K rows, and there are times that an OQL
query can bring back that many results - within a webapp, that can take some
time to execute - my performance increases dramatically if I implment lazy
loading....
>
> Now I thought that I would use a pass-through SQL query instead of the OQL
query to populate the highlevel beans, only I am getting
NullPointerExceptions:
>
> java.lang.NullPointerException
> at
org.exolab.castor.jdo.engine.SQLEngine.createCall(SQLEngine.java:430)
> at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:513)
> at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:488)
> ...
>
> What is the correct way to use pass-through SQL - I've looked at the FAQ,
but am none the wiser...
>
> My OQL looks like this:
>
> oql = db.getOQLQuery("CALL SQL SELECT cardid id, name, colour, type, '',
convertedmanacost, costid FROM cards AS org.grimoire.beans.Card");
>
> Thanks for reading,
> Pete
>
> -----------------------------------------------------------
> 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
