Hi,
When I try to execute a select using this statement:
OQLQuery oql = db.getOQLQuery( "SELECT * FROM Message" );
I get this exception:
org.exolab.castor.jdo.oql.OQLSyntaxException: An inapropriate token (20) was
encountered in an expression.
(Note: Hex 20 is a space)
And when I execute a create:
try{
db.begin();
db.create(message);
db.commit();
}catch(Exception e){
db.rollback();
throw new Exception(e.getMessage());
}
I get this exception:
java.sql.SQLException: Syntax error or access violation: You have an error
in your SQL syntax near 'SELECT MAX(t1.id) FROM message t1)' at line 1.
(Note the extra parenthesis at the end of the statement)
Here is my mapping.xml statement:
<!-- Mapping for Message -->
<class name="com.workzen.app.velocityCastor.om.Message" identity="id"
key-generator="MAX">
<map-to table="message" xml="message"/>
<field name="id" type="integer" >
<sql name="id" type="integer"/>
<xml node="attribute"/>
</field>
<field name="subject" type="string">
<sql name="subject" type="char" dirty="check" />
<xml node="text" />
</field>
<field name="name" type="string">
<sql name="name" type="char" dirty="check" />
<xml node="text" />
</field>
<field name="email" type="string">
<sql name="email" type="char" dirty="check" />
<xml node="text" />
</field>
<field name="contents" type="string">
<sql name="contents" type="char" dirty="check" />
<xml node="text" />
</field>
<field name="submitted" type="string">
<sql name="submitted" type="char" dirty="check" />
<xml node="text" />
</field>
</class>
What am I doing wrong???
Any help would be greatly appreciated,
Brad
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
