I'm curious, is it test code or core code that is not working with DB2?
Could it be reworked to follow strictly what the JDBC specification allows
for?
Cheers
Andrea
On Wed, Jan 25, 2017 at 12:27 PM, Christian Mueller <
christian.muel...@os-solutions.at> wrote:
> Hi David
>
> I had the same problem in the past. DB2 does an "autoclose" for a non
> scroll-able cursor. The JDBC specification allows this behavior but it
> seems that DB2 is the only database using it.
>
> AFAIK I solved the problems for the tests by rewriting the tests, the
> problem itself is not solved.
>
> Cheers
> Christian
>
>
> On Tue, Jan 24, 2017 at 11:25 PM, David Adler <dad...@adtechgeospatial.com
> > wrote:
>
>> A number of tests are failing which I suspect is due to the way
>> retrieval sets are handled in DB2 vs other databases like PostGIS.
>>
>> For example in JDBCDataStoreOnlineTest::testCreateSchemaWithConstraints,
>> there is logic
>>
>> //grab a writer
>> try(FeatureWriter<SimpleFeatureType, SimpleFeature> w =
>> dataStore.getFeatureWriter(
>> tname("ft2"),Transaction.AUTO_COMMIT)) {
>> w.hasNext();
>>
>> SimpleFeature f = w.next();
>> f.setAttribute( 1, new Integer(0));
>> f.setAttribute( 2, "hello");
>> w.write();
>>
>> This fails on w.next() with
>>
>> java.io.IOException: com.ibm.db2.jcc.am.SqlException:
>> [jcc][t4][10120][10898][3.66.46] Invalid operation: result set is
>> closed. ERRORCODE=-4470, SQLSTATE=null
>>
>> which results from:
>> ResultSetFeature rsf = getOrCreateRSF();
>>
>> which tried to get the metadata from the result set. DB2 closes the
>> result set when the end of the data is reached and fails when attempting
>> to get the metadata on a closed result set. From what I can tell,
>> PostGIS still can get the metadata on result set.
>>
>> I haven't found an obvious way to have DBMS specific behavior for
>> FeatureWriter::getOrCreateRSF();
>>
>> Any suggestions?
>>
>> It seems that in some of the tests the use of FeatureWriter could be
>> replaced with dataStore.addFeatures().
>>
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>> _______________________________________________
>> GeoTools-GT2-Users mailing list
>> GeoTools-GT2-Users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>
>
>
>
> --
> DI Christian Mueller MSc (GIS), MSc (IT-Security)
> OSS Open Source Solutions GmbH
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> GeoTools-GT2-Users mailing list
> GeoTools-GT2-Users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
>
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.
-------------------------------------------------------
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
