[Opensource] Re: eContent and the JDBC executor

[Peter A. J. Pilgrim]

Peter A. J. Pilgrim wrote:
> 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
> 

Hi Mike R

Blast it! I see that JDBCExecutor.java at around 298 will never execute
any sort of prepared statement. It is ALWAYS going to be `null'!

                                }
                                 myConnection.executeUpdate(null);
                                 myConnection.clearPreparedStatement();

                         } else {
                                 myConnection.executeUpdate(theSqlCommand);
                         }

What can I do?

-- 
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 ''