[IPT] SQL datasource upload

["Holetschek, Jörg"]

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 at gbif.org]
Gesendet: Mittwoch, 18. März 2009 11:06
An: =?ISO-8859-1?Q?=22Holetschek at ns.gbif.org; Holetschek, Jörg
Cc: "Markus Döring (GBIF)"; ipt at 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 at lists.gbif.org
> http://lists.gbif.org/mailman/listinfo/ipt
>