[Opensource] eContent and the JDBC executor

[Peter A. J. Pilgrim]

Hi Mike R


Whenever I go into ecContent / Edit Resources / Nursery Flowers / *

I get a multiple emails and the stack trace appears to show JDBC executor is at fault.

When I looked at the source code. I cannot see the SQL (null) that is being generated
or attempted. At first, I thought it was econtent was trying to insert data into
the RESOURCELOG, but I did a DELETE FROM RESOURCELOG, and still get this error.


2002-12-10 23:35:24,550 ERROR [Thread-13] jdbc.JDBCExecutor (JDBCExecutor.java:314) - 
com.jcorporate.expresso.core.dataobjects.jdbc.JDBCExecutor.add(DataObject) error
com.jcorporate.expresso.core.db.DBException: Unable to execute statement: 
null(com.jcorporate.expresso.core.dataobjects.jdbc.JDBCExecutor, db/context 'default'):Error 
during query: Unexpected Exception: java.sql.SQLException message given: Invalid argument value: 
Duplicate entry 'Summary-3' for key 1
         at com.jcorporate.expresso.core.db.DBConnection.executeUpdate(DBConnection.java:943)
         at com.jcorporate.expresso.core.dataobjects.jdbc.JDBCExecutor.add(JDBCExecutor.java:298)
         at com.jcorporate.expresso.core.dbobj.DBObject.add(DBObject.java:632)
         at com.jcorporate.expresso.core.dbobj.SecuredDBObject.add(SecuredDBObject.java:342)
         at com.jcorporate.econtent.dbobj.ResourceLog.add(ResourceLog.java:112)
         at com.jcorporate.econtent.util.ResourceLogHandler.checkQueue(ResourceLogHandler.java:114)
         at com.jcorporate.econtent.util.ResourceLogHandler.run(ResourceLogHandler.java:161)
Stopping service Tomcat-Standalone

-- 
Peter Pilgrim
ServerSide Java Specialist

My on-line resume and for interview videos about myself, J2EE
Open Source, Struts and Expresso.
    ||
    \\===>  `` http://www.xenonsoft.demon.co.uk/no-it-striker.html ''