Good idea, Tim!

But no SELECT gets to the server... apparently only some preparations:

SELECT @@MAX_PRECISION SET TRANSACTION ISOLATION LEVEL READ COMMITTED SET IMPLICIT_TRANSACTIONS OFF SET QUOTED_IDENTIFIER ON SET TEXTSIZE 2147483647

Cheers, Jörg

-----Ursprüngliche Nachricht----- Von: Tim Robertson [mailto:trobertson@gbif.org] Gesendet: Mittwoch, 18. März 2009 11:06 An: =?ISO-8859-1?Q?=22Holetschek@ns.gbif.org; Holetschek, Jörg Cc: "Markus Döring (GBIF)"; ipt@lists.gbif.org Betreff: Re: [IPT] SQL datasource upload

Hi Jörg

I've looked through the code and it is not possible to switch on the SQL logging through configuration. I will change this for the next release so that the SQL is logged prior to execution for easier debug.

Could you please check the SQLServer logs and report if the query reaches the DB?

Cheers,

Tim

On 18 Mar 2009, at 10:48, Holetschek, Jörg wrote:

Hi Markus,

I've tried to upload data from our SQL server database, after creating one datasource and 11 mappings. The upload takes only a second and ends up with 0 records uploaded, even though I can't find an error in the logs... Is there something I need to do first?

INFO pool-1-thread-1-OccUploadTask.call(105) | Import preparation took 78 ms INFO pool-1-thread-1-OccUploadTask.uploadCore(225) | Starting upload of core records for resource Desmids INFO pool-1-thread-1-DarwinCoreManagerHibernate.removeAll(41) | Removed 0 DarwinCores bound to resource Desmids INFO pool-1-thread-1- DarwinCoreManagerHibernate.flagAllAsDeleted(109) | 0 org.gbif.provider.model.DarwinCore records of resource were flagged as deleted. INFO pool-1-thread-1-OccStatManagerHibernate.removeAll(41) | Removed 0 OccStatByRegionAndTaxons bound to resource Desmids INFO pool-1-thread-1-TreeNodeSupportHibernate.removeAll(85) | Removed 0 taxons bound to resource Desmids INFO pool-1-thread-1-TreeNodeSupportHibernate.removeAll(85) | Removed 0 regions bound to resource Desmids INFO pool-1-thread-1-AnnotationManagerHibernate.removeAll(133) | Removed 2 annotations bound to resource Desmids

Cheers, Jörg _______________________________________________ IPT mailing list IPT@lists.gbif.org http://lists.gbif.org/mailman/listinfo/ipt