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
