Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version

2012-10-12 Thread Justin Deoliveira
Ahh cool. Good to know.

I will probably still parameterize the version at some point though so we
can run unit tests against postgres 8 and 9 easily.

-Justin

On Fri, Oct 12, 2012 at 7:30 AM,  wrote:

> Hi Justin
>
> I found another solution:
>
> If you use a postgres driver lower than version 9 you can prepare your
> database
> with
>
> ALTER DATABASE dbname SET bytea_output TO 'escape';
>
> I will kick out my  tag, prepare my test database and add this
> info to the user guide. I think this is the cleanest solution.
>
>
> Zitat von Justin Deoliveira :
>
>
>  I would use a property to make this configurable. Indeed I ran into this
>> same problem when trying to run postgis tests against a postgresql 9.1
>> database. The protocol for blobs has changed which caused those tests to
>> fail. Since we want to support both major versions of postgresql it makes
>> sense that this version is configurable.
>>
>> Anyways, what you can do is this.
>>
>> 1. Define a property in the root pom, with the default being the current
>> postgresql jdbc driver version.
>>
>> 
>>   8.4-**701.jdbc3
>> 
>>
>> 2.  Update the dependency management entry.
>>
>>  
>> postgresql
>> postgresql
>> ${postgresql.jdbc.**version}
>>   
>>
>> 3. In imagemosaic-jdbc/pom.xml simply override the property.
>>
>> 
>>   9.1-**901-1.jdbc4
>> 
>>
>> -Justin
>>
>> On Fri, Oct 12, 2012 at 2:57 AM,  wrote:
>>
>>  Long story for short. The postgis raster online test was broken and
>>> the fix is to update the postgres driver version. The module  will not
>>> work with 8.x postgres drivers.
>>>
>>> The global pom contains
>>>
>>>
>>>  postgresql
>>>  postgresql
>>>  8.4-701.jdbc3
>>>
>>>
>>> The imagemosaic-jdbc pom has to specify its own version.
>>>
>>>  
>>>postgresql
>>>postgresql
>>>
>>>9.1-901-1.jdbc4
>>>test
>>>  
>>>
>>> Perhaps we should update the version in the global POM ?.
>>> Btw, our postgis jdbc driver is also not up to date.
>>>
>>> Cheers
>>> Christian
>>>
>>>
>>>
>>> --**--**
>>> This message was sent using IMP, the Internet Messaging Program.
>>>
>>>
>>>
>>>
>>> --**--**
>>> --
>>> Don't let slow site performance ruin your business. Deploy New Relic APM
>>> Deploy New Relic app performance management and know exactly
>>> what is happening inside your Ruby, Python, PHP, Java, and .NET app
>>> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
>>> http://p.sf.net/sfu/newrelic-**dev2dev
>>> __**_
>>> GeoTools-Devel mailing list
>>> GeoTools-Devel@lists.**sourceforge.net
>>> https://lists.sourceforge.net/**lists/listinfo/geotools-devel
>>>
>>>
>>
>>
>> --
>> Justin Deoliveira
>> OpenGeo - http://opengeo.org
>> Enterprise support for open source geospatial.
>>
>>
>
>
> --**--**
> This message was sent using IMP, the Internet Messaging Program.
>
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version

2012-10-12 Thread christian . mueller
Hi Justin

I found another solution:

If you use a postgres driver lower than version 9 you can prepare your  
database
with

ALTER DATABASE dbname SET bytea_output TO 'escape';

I will kick out my  tag, prepare my test database and add  
this info to the user guide. I think this is the cleanest solution.


Zitat von Justin Deoliveira :

> I would use a property to make this configurable. Indeed I ran into this
> same problem when trying to run postgis tests against a postgresql 9.1
> database. The protocol for blobs has changed which caused those tests to
> fail. Since we want to support both major versions of postgresql it makes
> sense that this version is configurable.
>
> Anyways, what you can do is this.
>
> 1. Define a property in the root pom, with the default being the current
> postgresql jdbc driver version.
>
> 
>   8.4-701.jdbc3
> 
>
> 2.  Update the dependency management entry.
>
>  
> postgresql
> postgresql
> ${postgresql.jdbc.version}
>   
>
> 3. In imagemosaic-jdbc/pom.xml simply override the property.
>
> 
>   9.1-901-1.jdbc4
> 
>
> -Justin
>
> On Fri, Oct 12, 2012 at 2:57 AM,  wrote:
>
>> Long story for short. The postgis raster online test was broken and
>> the fix is to update the postgres driver version. The module  will not
>> work with 8.x postgres drivers.
>>
>> The global pom contains
>>
>>
>>  postgresql
>>  postgresql
>>  8.4-701.jdbc3
>>
>>
>> The imagemosaic-jdbc pom has to specify its own version.
>>
>>  
>>postgresql
>>postgresql
>>
>>9.1-901-1.jdbc4
>>test
>>  
>>
>> Perhaps we should update the version in the global POM ?.
>> Btw, our postgis jdbc driver is also not up to date.
>>
>> Cheers
>> Christian
>>
>>
>>
>> 
>> This message was sent using IMP, the Internet Messaging Program.
>>
>>
>>
>>
>> --
>> Don't let slow site performance ruin your business. Deploy New Relic APM
>> Deploy New Relic app performance management and know exactly
>> what is happening inside your Ruby, Python, PHP, Java, and .NET app
>> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
>> http://p.sf.net/sfu/newrelic-dev2dev
>> ___
>> GeoTools-Devel mailing list
>> GeoTools-Devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>>
>
>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>




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



--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version

2012-10-12 Thread Justin Deoliveira
I would use a property to make this configurable. Indeed I ran into this
same problem when trying to run postgis tests against a postgresql 9.1
database. The protocol for blobs has changed which caused those tests to
fail. Since we want to support both major versions of postgresql it makes
sense that this version is configurable.

Anyways, what you can do is this.

1. Define a property in the root pom, with the default being the current
postgresql jdbc driver version.


  8.4-701.jdbc3


2.  Update the dependency management entry.

 
postgresql
postgresql
${postgresql.jdbc.version}
  

3. In imagemosaic-jdbc/pom.xml simply override the property.


  9.1-901-1.jdbc4


-Justin

On Fri, Oct 12, 2012 at 2:57 AM,  wrote:

> Long story for short. The postgis raster online test was broken and
> the fix is to update the postgres driver version. The module  will not
> work with 8.x postgres drivers.
>
> The global pom contains
>
>
>  postgresql
>  postgresql
>  8.4-701.jdbc3
>
>
> The imagemosaic-jdbc pom has to specify its own version.
>
>  
>postgresql
>postgresql
>
>9.1-901-1.jdbc4
>test
>  
>
> Perhaps we should update the version in the global POM ?.
> Btw, our postgis jdbc driver is also not up to date.
>
> Cheers
> Christian
>
>
>
> 
> This message was sent using IMP, the Internet Messaging Program.
>
>
>
>
> --
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> ___
> GeoTools-Devel mailing list
> GeoTools-Devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>



-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


Re: [Geotools-devel] improving support for spatialite

2012-10-12 Thread Justin Deoliveira
On Fri, Oct 12, 2012 at 1:09 AM, andrea antonello <
andrea.antone...@gmail.com> wrote:

> Sorry for coming back late.
>
> I just tried to add the -d32 flag to my eclipse VM args and it doesn't
> recognise it. I will investigate further.
> Anyways if that then forces me to less than 1 gig of ram that is not an
> option for me.
>
> Yeah, i was just curious if that was how i made it work. So yeah... i
can't really comment while i am able to use it on 64 bit windows.

One thing that might help is to use a DLL dependency analyzer to figure out
what dll dependencies are not being met or invalid. Basically the
equivalent ldd. I believe i have used this one before with some success.

http://dependencywalker.com


> As a sidenote it looks like somone is working on JNI bindings, apparently
> to have it very fast.
>
> https://groups.google.com/forum/?fromgroups=#!topic/spatialite-users/ytEZieh7iEE
>
> Interesting.

>
> [...]
>
>> *Visual Studio Express 2012 for Windows Desktop*
>>> *Allows development of conventional Windows desktop applications in C#,
>>> VB.NET and C++, targeting Windows client technologies such as Windows
>>> Presentation Foundation (WPF), Windows Forms, and the Win32 API. Unlike
>>> previous Express editions, it also has in-built support for compiling
>>> 64-bit binaries though the IDE.[27].*
>>>
>>> [1] http://en.wikipedia.org/wiki/Microsoft_Visual_Studio_Express
>>>
>>> Nice!
>>
>
> Does that mean that there is a chance for 64 bit ? :)
>
> Thanks,
> Andrea
>
>
>
>
>
>>
>>> --
>>> Jody Garnett
>>>
>>> On Thursday, 11 October 2012 at 11:57 PM, Justin Deoliveira wrote:
>>>
>>>
>>>
>>> On Thu, Oct 11, 2012 at 7:16 AM, Jody Garnett wrote:
>>>
>>>  Right. So, the story was that i wasn't able to figure out how to
>>> compile for windows 64 bit. I didn't want to buy vistual studio
>>> professional and i couldn't for the life of me get mingw-64 to work so i
>>> more or less gave up.
>>>
>>> Microsoft relented on the visual studio thing in an effort to have more
>>> Windows 8 developers:
>>> http://arstechnica.com/information-technology/2012/09/visual-studio-2012-free-desktop-development-tool-out-today-first-update-outlined/
>>>
>>> Right, afaik there has been an express version of VS available but my
>>> latest round of research let me to believe that the express version didn't
>>> include the 64 bit compiler.
>>>
>>>  Adding to that I couldn't find a 64 bit windows build of spatialite.
>>> Although I think my research in this area is out of date... doing a quick
>>> search looks like 64 bit builds for windows are now available.
>>>
>>> That said, i was able to use the 32 bit libs on a 64 bit windows 7
>>> machine and it worked ok. I can't remember if i had to run the jvm in 32
>>> bit mode... (-d32 flag). If so we should update that doc.
>>>
>>> Hope that helps. I am eager to have someone verify this work :)
>>>
>>> I think Andrea is trying to run in -d64 mode (in order to work with more
>>> data).
>>>
>>>
>>> RIght, which would certainly be the default for a 64 bit jvm on a 64 bit
>>> os. What i can't remember is if i had to enable the -d32 switch to make
>>> this work. If Andrea could confirm it still doesn't doesn't work when
>>> adding the flag then something else is up.
>>>
>>>
>>> Jody
>>>
>>>
>>>
>>>
>>> --
>>> Justin Deoliveira
>>> OpenGeo - http://opengeo.org
>>> Enterprise support for open source geospatial.
>>>
>>>
>>>
>>
>>
>> --
>> Justin Deoliveira
>> OpenGeo - http://opengeo.org
>> Enterprise support for open source geospatial.
>>
>>
>
>
> --
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> ___
> GeoTools-Devel mailing list
> GeoTools-Devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


Re: [Geotools-devel] WMS client QA run for 1.3.0

2012-10-12 Thread Justin Deoliveira
On Thu, Oct 11, 2012 at 11:59 PM, Andrea Aime
wrote:

> On Fri, Oct 12, 2012 at 3:22 AM, Jody Garnett wrote:
>
>>  Jody, I see you are making pull requests which involve changes to the
>> referencing module
>> and merge them before getting any feedback from the maintainer (ah hem,
>> me).
>>
>> Would it be possible to work on a branch so that you can reach your
>> deliverable, and
>> allow some time for the reviews of the modules you're not maintainer of?
>>
>> I have a branch going on, but am doing this changes hand in glove with
>> uDig master. On the "bright" side I have chased
>> the remaining issues over into the deegree project, and thus have bought
>> "more time" before this pull request is needed
>> contract wise.
>>
>> I was however hoping to issue a uDig 1.3.3-SNAPSHOT allowing ows9
>> participants to test the correct functionality.
>>
>> Err... you could have a branch both sides
>
>> I'll have a look at the changes you made this weekend (and may have to
>> modify
>> changes, hopefully not to revert any...)
>>
>> Fair enough, mostly trying to get the toString methods to report back
>> what is going on.
>>
>> I am away next week and will not be in the geotools meeting; feel free to
>> roast me for accepting my own pull requests.
>>
>>
> It's not about accepting your own pull request, what worries me most is
> changes in the referencing module
> which seem to be directed mostly by the haste of the moment than by a good
> understanding of what
> needs fixing and how.
> Commits are also not directly related to the jiras being opened, for
> example it's hard to tell what
> happened with https://jira.codehaus.org/browse/GEOT-4286, has it been
> reverted?
> One final worry bit is that the changes to referencing do not seem to be
> covered by their own tests
>
> +1. Seems like a faux paux to me to apply these pull requests without
review from the module maintainer. Especially a module as core as
referencing.

Cheers
> Andrea
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39  339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>
>
>
> --
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> ___
> GeoTools-Devel mailing list
> GeoTools-Devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


Re: [Geotools-devel] WMS client QA run for 1.3.0

2012-10-12 Thread Jody Garnett
> It's not about accepting your own pull request, what worries me most is 
> changes in the referencing module
> which seem to be directed mostly by the haste of the moment than by a good 
> understanding of what
> needs fixing and how. 

 The only changes in referencing are to the various Envelope toString 
representations.
> Commits are also not directly related to the jiras being opened, for example 
> it's hard to tell what 
> happened with https://jira.codehaus.org/browse/GEOT-4286, has it been 
> reverted?
> 

Yes. 
> One final worry bit is that the changes to referencing do not seem to be 
> covered by their own tests
> 

Yes they are generally covered by CRSTest. And others (found that image-moasic 
had some tests depending on the AbstractEnvelope toString implementation 
output).
 
Jody 
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


[Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version

2012-10-12 Thread christian . mueller
Long story for short. The postgis raster online test was broken and  
the fix is to update the postgres driver version. The module  will not  
work with 8.x postgres drivers.

The global pom contains

   
 postgresql
 postgresql
 8.4-701.jdbc3
   

The imagemosaic-jdbc pom has to specify its own version.

 
   postgresql
   postgresql
   
   9.1-901-1.jdbc4
   test
 

Perhaps we should update the version in the global POM ?.
Btw, our postgis jdbc driver is also not up to date.

Cheers
Christian




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



--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


Re: [Geotools-devel] improving support for spatialite

2012-10-12 Thread andrea antonello
Sorry for coming back late.

I just tried to add the -d32 flag to my eclipse VM args and it doesn't
recognise it. I will investigate further.
Anyways if that then forces me to less than 1 gig of ram that is not an
option for me.

As a sidenote it looks like somone is working on JNI bindings, apparently
to have it very fast.
https://groups.google.com/forum/?fromgroups=#!topic/spatialite-users/ytEZieh7iEE


[...]

> *Visual Studio Express 2012 for Windows Desktop*
>> *Allows development of conventional Windows desktop applications in C#,
>> VB.NET and C++, targeting Windows client technologies such as Windows
>> Presentation Foundation (WPF), Windows Forms, and the Win32 API. Unlike
>> previous Express editions, it also has in-built support for compiling
>> 64-bit binaries though the IDE.[27].*
>>
>> [1] http://en.wikipedia.org/wiki/Microsoft_Visual_Studio_Express
>>
>> Nice!
>

Does that mean that there is a chance for 64 bit ? :)

Thanks,
Andrea





>
>> --
>> Jody Garnett
>>
>> On Thursday, 11 October 2012 at 11:57 PM, Justin Deoliveira wrote:
>>
>>
>>
>> On Thu, Oct 11, 2012 at 7:16 AM, Jody Garnett wrote:
>>
>>  Right. So, the story was that i wasn't able to figure out how to
>> compile for windows 64 bit. I didn't want to buy vistual studio
>> professional and i couldn't for the life of me get mingw-64 to work so i
>> more or less gave up.
>>
>> Microsoft relented on the visual studio thing in an effort to have more
>> Windows 8 developers:
>> http://arstechnica.com/information-technology/2012/09/visual-studio-2012-free-desktop-development-tool-out-today-first-update-outlined/
>>
>> Right, afaik there has been an express version of VS available but my
>> latest round of research let me to believe that the express version didn't
>> include the 64 bit compiler.
>>
>>  Adding to that I couldn't find a 64 bit windows build of spatialite.
>> Although I think my research in this area is out of date... doing a quick
>> search looks like 64 bit builds for windows are now available.
>>
>> That said, i was able to use the 32 bit libs on a 64 bit windows 7
>> machine and it worked ok. I can't remember if i had to run the jvm in 32
>> bit mode... (-d32 flag). If so we should update that doc.
>>
>> Hope that helps. I am eager to have someone verify this work :)
>>
>> I think Andrea is trying to run in -d64 mode (in order to work with more
>> data).
>>
>>
>> RIght, which would certainly be the default for a 64 bit jvm on a 64 bit
>> os. What i can't remember is if i had to enable the -d32 switch to make
>> this work. If Andrea could confirm it still doesn't doesn't work when
>> adding the flag then something else is up.
>>
>>
>> Jody
>>
>>
>>
>>
>> --
>> Justin Deoliveira
>> OpenGeo - http://opengeo.org
>> Enterprise support for open source geospatial.
>>
>>
>>
>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>
>
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel