Maybe I should know this, but I am a bit puzzled about which is the true Unique reporter ID in BASE2. When you import reporters in BASE2 you have 2 columns for identification: Name (which becomes hyper linked) and External ID. Should both fields be unique? which is the difference? which of the 2 is used for reporter update?? is this the same later linked to the array designs?
Another question is deleting reporters. I am trying to do this and I obtain the following message:
Version BASE 2.2.1 (build #0; schema #29)
Web server Apache Tomcat/6.0.9
Database Dialect org.hibernate.dialect.MySQLInnoDBDialect
JDBC Driver com.mysql.jdbc.Driver (version 5.0)
Java runtime Java(TM) 2 Runtime Environment, Standard Edition (1.5.0_11-b03), Sun Microsystems Inc.
Operating system Linux i386 2.6.18-1.2798.fc6
Memory Total: 26.4 MB
Free: 6.10 MB
Max: 63.6 MB
Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
Error message Cannot delete or update a parent row: a foreign key constraint fails (`base2/Features`, CONSTRAINT `FKF287485DEAB01E4E` FOREIGN KEY (`reporter_id`) REFERENCES `Reporters` (`id`))
Stack trace
...at BasicBatcher.flushDelete(BasicBatcher.java:477) ...at BasicBatcher.flush(BasicBatcher.java:221) ...at AbstractBatcher.close(AbstractBatcher.java:117) ...at org.apache.jsp.views.reporters.index_jsp._jspService(index_jsp.java:221) ...at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) ...at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) ...at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384) ...at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
Where can I think my reporter is linked to?. I have now raw data and I deleted the array designs from the system...
Thanks
Ana
@@@ O @@ O @ Centro de Genómica
@ O @@@@ O @ Instituto Valenciano de Investigaciones Agrarias (IVIA)
@@@ O @@@@ Carretera Moncada - Naquera, Km. 4,5
@@@@ O @ 46113 Moncada (Valencia) SPAIN
|| Tel. +34 963424000 ext.70161; Fax. +34 963424001
|| email: [EMAIL PROTECTED]
------------------------------------------------------------------------- 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]
