Sorry for reposting my question. But I haven't found any information in the
documentation or on the mailinglist.
Can anybody tell me what SQL statement (CALL SQL ...) is equivalent to the
OQL statement "SELECT p FROM myapp.Product p"?
have a look at my old mail below.
thanks.
Joel Gautschi
> hi,
>
> I'm evaluating castor for a project. It has to meet the
> criteria that the
> framework is able to pass through SQL statements. According to the
> documentation castor is able to do that.
>
> if I try to run the following code:
> ---
> oql = db.getOQLQuery( "CALL SQL SELECT id, name, price,
> group_id FROM prod AS
> myapp.Product" );
> result = oql.execute();
> while ( result.hasMore() )
> {
> // do something
> }
> ---
> i get this error:
> ---
> javax.servlet.ServletException:
> org.exolab.castor.jdo.PersistenceException:
> Nested error: java.sql.SQLException: Column Index out of
> range ( 5 > 4).
> ---
>
> can someone tell me what I'm doing wrong?
>
> more information:
> - if I use "oql = db.getOQLQuery( "SELECT p FROM myapp.Product p" );"
> everything works.
> - myapp.Product is the class from castor-0.9.3.9\src\examples\myapp
> - I use castor 0.9.3
> - I use mm.mysql-2.0.11 as JDBC 2.0 driver
> (class-name="org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource")
>
>
> thanks in advance for your help!
>
> Joel Gautschi
--------------------------------------------
MySign AG, Switzerland
Web: http://www.mysign.ch
--------------------------------------------
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
