Hi, Yes, I have had this happen too after giving it the wrong path. Sadly the only way to get rid of the duplicate entry seems to be to delete directly in the database. You need to find it in the data of the PluginDefinitions table and delete the entry, but be aware that it will keep refusing to delete it until all the dependent entries in other tables have also been deleted.
I am not sure whether this is something that specific to this plugin or whether it affects all other plugins the same way. Perhaps the dev team could comment here. If it is a general issue we should perhaps add it to Trac as a bug. Cheers Micha ================================== Dr Micha M Bayer Bioinformatics Specialist Genetics Programme The Scottish Crop Research Institute Invergowrie Dundee DD2 5DA Scotland, UK Telephone +44(0)1382 562731 ext. 2309 Fax +44(0)1382 562426 http://www.scri.sari.ac.uk/MichaBayer.htm ============================= > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:basedb-users- > [EMAIL PROTECTED] On Behalf Of Jeremy Davis-Turak > Sent: 09 March 2007 19:38 > To: BASE ML > Subject: Re: [base] batch importer plugin is available for testing now > > Hi, > > I am trying to install the batch data importer but I get the following > error: > "Duplicate entry 'sbrn.base.BatchDataImporter' for key 2" > (I tried doing it once but I typed the wrong path; now that I do it > again I get this error). > Below is the stack trace. Please help! > > Thanks, > > Jeremy > > > Version BASE 2.1.1 (build #2996; schema #20) > Web server Apache Tomcat/5.5.17 > Database Dialect org.hibernate.dialect.MySQLInnoDBDialect > JDBC Driver com.mysql.jdbc.Driver (version 3.1) > Java runtime Java(TM) 2 Runtime Environment, Standard Edition > (1.5.0_07-b03), Sun Microsystems Inc. > Operating system Linux i386 2.6.18-1.2257.fc5smp > Memory Total: 162.7 MB > Free: 120.9 MB > Max: 481.5 MB > Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) > Gecko/20070219 Firefox/2.0.0.2 > Error message Duplicate entry 'sbrn.base.BatchDataImporter' for key 2 > Stack trace > > ...at HibernateUtil.saveData(HibernateUtil.java:963) > ...at DbControl.commit(DbControl.java:362) > ...at > org.apache.jsp.admin.plugindefinitions.index_jsp._jspService(index_jsp.j av > a:223) > ...at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) > ...at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > ...at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va > :332) > ...at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) > ...at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) > > ...at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > ...at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica ti > onFilterChain.java:252) > ...at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt er > Chain.java:173) > ...at > net.sf.basedb.clients.web.servlet.CharacterEncodingFilter.doFilter(Chara ct > erEncodingFilter.java:71) > ...at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica ti > onFilterChain.java:202) > ...at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt er > Chain.java:173) > ...at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e. > java:213) > ...at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e. > java:178) > ...at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :1 > 26) > ...at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :1 > 05) > ...at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. ja > va:107) > ...at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48 > ) > ...at > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) > ...at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) > ...at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) > ...at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java: 68 > 4) > ...at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket. ja > va:876) > ...at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .j > ava:684) > ...at java.lang.Thread.run(Thread.java:595) > > Caused by: java.sql.SQLException > ...at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) > ...at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) > ...at > com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState me > nt.java:1125) > ...at > com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta te > ment.java:677) > ...at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:13 57 > ) > ...at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:12 74 > ) > ...at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:12 59 > ) > ...at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProx yP > reparedStatement.java:105) > ...at > org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndEx tr > act(IdentityGenerator.java:73) > ...at > org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstract Re > turningDelegate.java:33) > ...at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn ti > tyPersister.java:2050) > ...at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn ti > tyPersister.java:2515) > ...at > org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityIn se > rtAction.java:47) > ...at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) > ...at > org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate (A > bstractSaveEventListener.java:290) > ...at > org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSa ve > EventListener.java:180) > ...at > org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(Ab st > ractSaveEventListener.java:108) > ...at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGenerat ed > OrRequestedId(DefaultSaveOrUpdateEventListener.java:186) > ...at > org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequ es > tedId(DefaultSaveEventListener.java:33) > ...at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransie nt > (DefaultSaveOrUpdateEventListener.java:175) > ...at > org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(Def au > ltSaveEventListener.java:27) > ...at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate( De > faultSaveOrUpdateEventListener.java:70) > ...at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535) > ...at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523) > ...at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519) > ...at HibernateUtil.saveData(HibernateUtil.java:958) > ...at DbControl.commit(DbControl.java:362) > ...at > org.apache.jsp.admin.plugindefinitions.index_jsp._jspService(index_jsp.j av > a:223) > ...at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) > ...at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > ...at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va > :332) > ...at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) > ...at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) > ...at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > ...at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica ti > onFilterChain.java:252) > ...at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt er > Chain.java:173) > ...at > net.sf.basedb.clients.web.servlet.CharacterEncodingFilter.doFilter(Chara ct > erEncodingFilter.java:71) > ...at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica ti > onFilterChain.java:202) > ...at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt er > Chain.java:173) > ...at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e. > java:213) > ...at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e. > java:178) > ...at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :1 > 26) > ...at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :1 > 05) > ...at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. ja > va:107) > ...at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48 > ) > ...at > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) > ...at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) > ...at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) > ...at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java: 68 > 4) > ...at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket. ja > va:876) > ...at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .j > ava:684) > ...at java.lang.Thread.run(Thread.java:595) > > ------------------------------------------------------------------------ - > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE V > _______________________________________________ > The BASE general discussion mailing list > basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > [EMAIL PROTECTED] _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ SCRI, Invergowrie, Dundee, DD2 5DA. The Scottish Crop Research Institute is a charitable company limited by guarantee. Registered in Scotland No: SC 29367. Recognised by the Inland Revenue as a Scottish Charity No: SC 006662. DISCLAIMER: This email is from the Scottish Crop Research Institute, but the views expressed by the sender are not necessarily the views of SCRI and its subsidiaries. This email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee. If you are not the intended recipient you are requested to preserve this confidentiality and you must not use, disclose, copy, print or rely on this e-mail in any way. Please notify [EMAIL PROTECTED] quoting the name of the sender and delete the email from your system. Although SCRI has taken reasonable precautions to ensure no viruses are present in this email, neither the Institute nor the sender accepts any responsibility for any viruses, and it is your responsibility to scan the email and the attachments (if any). ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
