Hi,
I've been playing with Castor for the past few days, looking
through the code when I've run into errors. I've finally
got my mapping.xml, database.xml, and java classes all "working"...
Now when I execute an OQL statement it returns the following
error:
org.exolab.castor.jdo.PersistenceException: Nested error: java.sql.SQLException:
ERROR: No such attribute or function 'eventID'
while executing SELECT
"events"."eventID","events"."eventUei","events"."nodeID","events"."eventTime","events"."eventHost","events"."ipAddr","events"."eventDpName","events"."eventSnmpHost","events"."serviceID","events"."eventSnmp","events"."eventParms","events"."eventCreateTime","events"."eventDescr","events"."eventLoggroup","events"."eventLogmsg","events"."eventSeverity","events"."eventPathOutage","events"."eventCorrelation","events"."eventSuppressedCount","events"."eventOperInstruct","events"."eventAutoAction","events"."eventOperAction","events"."eventOperActionMenuText","events"."eventNotification","events"."eventTticket","events"."eventTticketState","events"."eventForward","events"."eventMouseOverText","events"."eventLog","events"."eventDisplay","events"."eventAckUser","events"."eventAckTime"
FROM "events"
java.sql.SQLException: ERROR: No such attribute or function 'eventID'
at org.postgresql.Connection.ExecSQL(Connection.java:533)
at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59)
at
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:108)
at org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.execute(SQLEngine.java:1576)
at
org.exolab.castor.persist.TransactionContext.query(TransactionContext.java:616)
at org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:457)
at org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:404)
at org.opennms.netmgt.db.Test.run(Test.java:73)
at org.opennms.netmgt.db.Test.main(Test.java:33)
I took the 'SELECT ... FROM "events"' and feed that into
pgsql. It didn't like it, but if I stripped out the double
quotes from the entire statement it worked fine...
How do I disable the quoting around each element in castor. I'm working
with the latest CVS tree.
Weave
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
