Hi Steve, Not sure what's gone wrong there -- I have added the plugin to installations of both 2.1.1 and 2.2.1 and it worked fine. It also seems to have worked okay for the other people who have tried it out so far, so I am not sure what's happening.
As far as I know the only thing you can do now is to get rid of the existing entry (entries?) for this plugin in the database manually and try again. The entry is held in the PluginDefinitions table but there are dependencies on other entries which you will also have to delete (it will tell you what they are). Have you tried clearing the filter when you look at the list view of the PluginDefinitions in the web client (go to view/presets -> Clear Filter)? And are you sure this is not a permissions issue? You would get into scenarios like yours if you e.g. installed the plugin as root, forgot to share it, then logged in as someone else and tried to add it again. Has anyone else had a similar problem? If yes, please let me know. 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 Steve Taylor > Sent: 23 February 2007 12:12 > To: BASEDBUSERS > Subject: [base] batchimporter > > Hi, > > I just tried adding batchdataimporter to BASE 2.1.1 (build #2996; schema > #20) using the instructions on > http://lev.thep.lu.se/trac/baseplugins/browser/trunk/uk/ac/scri/batchimp or > ter/README.txt but the > plug-in does not show up in the Plugins list. > > I tried to add it again (just in case I had done something wrong) and it > looks like the plug-in has been imported but is not visible (see below). > Any suggestions? > > Thanks, > > Steve > ------------------------------------------------------------------ > Medical Sciences Division > Weatherall Institute of Molecular Medicine/Sir William Dunn School > Oxford University > > > 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_09- > b03), Sun Microsystems Inc. > Operating system Linux amd64 2.6.19-1.2895.fc6 > Memory Total: 97.3 MB > Free: 59.1 MB > Max: 444.5 MB > Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.1) > Gecko/20061204 Firefox/2.0.0.1 > 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.coyote.http11.Http11Processor.process(Http11Processor.java:86 9) > ...at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc es > sConnection(Http11BaseProtocol.java:664) > ...at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .j > ava:527) > ...at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow er > WorkerThread.java:80) > ...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.coyote.http11.Http11Processor.process(Http11Processor.java:86 9) > ...at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc es > sConnection(Http11BaseProtocol.java:664) > ...at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .j > ava:527) > ...at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow er > WorkerThread.java:80) > ...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]
