Errores instalando Jira 3.9 con mysql 4.1

De Wikillano

t org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listene
rname) VALUES (?, ?, ?) (Duplicate entry '71214255735046400' for key 1)
       at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:375)
       at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)
       at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)

2007-10-24 11:08:52,193 main ERROR [atlassian.jira.event.DefaultListenerManager] Could not create listener named: sian.jira.event.listeners.
cache.IssueCacheListener�Issue Cache ListenerENTITY_NAME
                                                        ENTITY_NAME^L!ý�ýH�
com.atlassian.jira.event.ListenerException: Could not find class: ';com.atla
        at com.atlassian.jira.event.ListenerFactory.getListener(ListenerFactory.java:37)

This appears to be an Ubuntu/Debian packaging problem:

http://www.ubuntuforums.org/showthread.php?t=86294&highlight=mysql_stmt_execute

http://forums.mysql.com/read.php?39,49989,49989#msg-49989

A workaround is to use 'useServerPrepStmts=false' in your JDBC URL, eg:

jdbc:mysql://localhost/jiradb?useServerPrepStmts=false