Re: [GeoNetwork-devel] validationQuery "select 1" breaks Db2 and Oracle support

[<chr...@nv...>]

Btw, since I am not knowing your internal procedures, I want to ask a  
question.
Some times ago, we patched a document on trunk concerning installing  
databases. I can see the commitment here

https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/trunk/docs/eng/users/source/quickstartguide/installing/index.rst


But if I look here I see nothing about sql databases
http://geonetwork-opensource.org/manuals/trunk/users/quickstartguide/installing/index.html

Is this wanted ?



Zitat von Francois Prunayre <fx....@gm...>:

> 2011/8/26 Francois Prunayre <fx....@gm...>:
>> Hello Christian
>>
>> 2011/8/25  <chr...@nv...>:
>>>
>>> AFAIK Sqlserver, postgres and mysql are fine with the validation query
>>> "select 1".
>>>
>>> For Oracle, I think it has to be "select 1 from dual".
>>>
>>> For DB2, it has to be
>>> "SELECT 1 FROM SYSIBM.SYSDUMMY1 WHERE 0=1"
>>>
>>> Even worse, using the correct query on db2 results in an SQLException
>>> because the sql connection is closed during an open transaction. I
>>> cannot investigate further since I could not find a source jar for
>>> dbcp-6.0.29.jar.
>>>
>>> IMHO, a manageable way is to add a xml element <validationQuery> to
>>> config.xml. If the element is not present for a db, no validation
>>> query is used.
>>>
>>> Should I provide a patch for this ?.
>> Sure if you could that would be great as Simon is off for a few days
>> now (I think).
>> Open a ticket and add your patch if you could, I'll try to find time
>> to commit it.
> Thanks for the patch Christian.
>
> Added to trunk : http://trac.osgeo.org/geonetwork/ticket/591
>
> Francois
>
>> Thanks a lot.
>>
>> Francois
>>
>>
>>
>>> Cheers
>>> Christian
>>>
>>> ----------------------------------------------------------------
>>> This message was sent using IMP, the Internet Messaging Program.
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> EMC VNX: the world's simplest storage, starting under $10K
>>> The only unified storage solution that offers unified management
>>> Up to 160% more powerful than alternatives and 25% more efficient.
>>> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
>>> _______________________________________________
>>> GeoNetwork-devel mailing list
>>> Geo...@li...
>>> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
>>> GeoNetwork OpenSource is maintained at   
>>> http://sourceforge.net/projects/geonetwork
>>>
>>
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.