Re: [basedb-devel] object attributes missing when API used from tomcat servlet

2007-10-26 Thread Bob MacCallum
Thanks for getting back to us. Problem solved... Nicklas Nordborg writes: > This seems really strange. The only thing I can think of is that the > data is coming from different databases. Are you really sure that both > base.config files are the same? yes the config files are the same: di

Re: [basedb-devel] object attributes missing when API used from tomcat servlet

2007-10-26 Thread Nicklas Nordborg
Bob MacCallum wrote: > Only in ../../apache-tomcat-6.0.14/webapps/GEWebapp/WEB-INF/lib: > biojava-ensembl.jar biojava.jar bytecode.jar commons-collections-2.1.jar > commons-dbcp-1.1.jar commons-pool-1.1.jar gesol.jar GEWebapp.jar jstl.jar > mysql-connector-java-3.0.10-stable-bin.jar standard.jar

[basedb-devel] number of unique reporters on an array

2007-10-26 Thread Bob MacCallum
Hi BASE coders, I can't seem to be able to count the number of distinct reporters on a particular array through the API, although it seems efficient enough with raw MySQL: select count(distinct r.external_id) as count from Reporters r left join Features f on (r.id = f.reporter_id) left join Arra