Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread Derrick.Wong
Hey Andrea, That's a very nifty example. When I did this previously, I had my class doing SELECT statements from one DB, storing the data as java objects and then inserting it into another DB table. It was so messy. ;) Derrick Wong Software Engineer | ASRDC (Australian Spatial Research Data C

Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread v...@csiro
I was thinking somewhere along the line of: String sql = "select id, st_asbinary(shape) as shape from geology.table "; ResultSet p = postgis.createStatement().executeQuery(sql); PreparedStatement s = oracle.prepareStatement("update table set shape=SDO_GEOMETRY(?) where id=

Re: [Geotools-devel] 2.7-M1 available for download

2010-06-21 Thread Jody Garnett
The 2.7-M1 artefacts should be available for download shortly (they are uploading now) The release went smoothly; two small issues: - intensive tests are failing for image pyramid - I think demo depends on process; and process is not in the build since it is an unsupported module - so I expect t

[Geotools-devel] 2.7-M1 deployed

2010-06-21 Thread Jody Garnett
For some reason deploying was amazingly slow today [INFO] [INFO] BUILD SUCCESSFUL [INFO] [INFO] Total time: 154 minutes 22 seconds [INFO] Finished a

Re: [Geotools-devel] Updating DBCP to version 1.3

2010-06-21 Thread Jody Garnett
+1 for upgrading. Are we going to have trouble with the difference between 1.3 and 1.4; or do we need a java5 and java 6 profile (auto enabled) to contribute the appropriate dependency? Jody On 21/06/2010, at 2:20 AM, Andrea Aime wrote: > Hi, > commons DBCP 1.3 and 1.4 have been recently rele

[Geotools-devel] [jira] Created: (GEOT-3154) Plotting geometry objects with jfreechart

2010-06-21 Thread Justin Deoliveira (JIRA)
Plotting geometry objects with jfreechart - Key: GEOT-3154 URL: http://jira.codehaus.org/browse/GEOT-3154 Project: GeoTools Issue Type: New Feature Reporter: Justin Deoliveira A

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Andrea Aime
Andrea Aime ha scritto: > Andrea Aime ha scritto: >> Andrea Aime ha scritto: >>> christian.muel...@nvoe.at ha scritto: Some thoughts from my side. 1) Using a regexp to avoid sql injection is a nice idea. But I think most developers are not familiar with regexps and thus, the re

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Andrea Aime
Andrea Aime ha scritto: > Andrea Aime ha scritto: >> christian.muel...@nvoe.at ha scritto: >>> Some thoughts from my side. >>> >>> 1) Using a regexp to avoid sql injection is a nice idea. But I think >>> most developers are not familiar with regexps and thus, the regexp >>> mostly used will be "

Re: [Geotools-devel] GML srsName OGC compatibility

2010-06-21 Thread Bastian Schäffer
Hi Jody, we will try to do that. Regards, Bastian Am 20.06.2010 03:30, schrieb Jody Garnett: > Bastian to proceed could you make a jira and supply a patch/test case for the > CRS method for generating an srsName? > Jody > > On 20/06/2010, at 11:28 AM, Jody Garnett wrote: > >> Depending on the

Re: [Geotools-devel] Updating DBCP to version 1.3

2010-06-21 Thread christian . mueller
Tested with DB2, anything works fine, +1 Quoting Andrea Aime : > Hi, > commons DBCP 1.3 and 1.4 have been recently released. > > 1.3 and 1.4 are actually sharing the same source, but 1.4 > is compatible with JDBC 4 (JDK 6) whilst 1.3 is compatible > with JDBC 3 (JDK 1.5). > > This release fixes a

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Andrea Aime
Andrea Aime ha scritto: > christian.muel...@nvoe.at ha scritto: >> Some thoughts from my side. >> >> 1) Using a regexp to avoid sql injection is a nice idea. But I think >> most developers are not familiar with regexps and thus, the regexp >> mostly used will be ".*" opening the door for all kin

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Andrea Aime
christian.muel...@nvoe.at ha scritto: > Some thoughts from my side. > > 1) Using a regexp to avoid sql injection is a nice idea. But I think > most developers are not familiar with regexps and thus, the regexp > mostly used will be ".*" opening the door for all kind of sql injection > attacks.

[Geotools-devel] [jira] Created: (GEOT-3153) The FAQ should be more visible and contain more answers

2010-06-21 Thread Ian Turton (JIRA)
The FAQ should be more visible and contain more answers --- Key: GEOT-3153 URL: http://jira.codehaus.org/browse/GEOT-3153 Project: GeoTools Issue Type: Improvement Components: doc

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread christian . mueller
Some thoughts from my side. 1) Using a regexp to avoid sql injection is a nice idea. But I think most developers are not familiar with regexps and thus, the regexp mostly used will be ".*" opening the door for all kind of sql injection attacks. Why not use prepared (callable) statements ?.

Re: [Geotools-devel] Updating DBCP to version 1.3

2010-06-21 Thread Justin Deoliveira
+1 On 10-06-20 10:20 AM, Andrea Aime wrote: > Hi, > commons DBCP 1.3 and 1.4 have been recently released. > > 1.3 and 1.4 are actually sharing the same source, but 1.4 > is compatible with JDBC 4 (JDK 6) whilst 1.3 is compatible > with JDBC 3 (JDK 1.5). > > This release fixes a number of issues an

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Jody Garnett
Thanks Andrea that helped; that is actually a match with with BIRT does in their various query builders; indeed your work would ease integration greatly. Jody On 21/06/2010, at 11:18 PM, Andrea Aime wrote: > Jody Garnett ha scritto: >> Hi Andera: >> This is exciting; I am still sorting out the

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Andrea Aime
Jody Garnett ha scritto: > Hi Andera: > > This is exciting; I am still sorting out the context of how this is > to be used at the end of the day. Is this something like the WFS 2.0 > "predefined queries" (I always thought those were more for prepared > statements but setting up something in the mi

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Jody Garnett
Hi Andera: This is exciting; I am still sorting out the context of how this is to be used at the end of the day. Is this something like the WFS 2.0 "predefined queries" (I always thought those were more for prepared statements but setting up something in the middleware is more sane actually) O

[Geotools-devel] [jira] Created: (GEOT-3152) Make the renderer DPI parameter act on symbol sizes as well

2010-06-21 Thread Andrea Aime (JIRA)
Make the renderer DPI parameter act on symbol sizes as well --- Key: GEOT-3152 URL: http://jira.codehaus.org/browse/GEOT-3152 Project: GeoTools Issue Type: Improvement Compone

[Geotools-devel] [jira] Created: (GEOT-3151) Deegree 3 reports WFS-T seriously broken

2010-06-21 Thread Jody Garnett (JIRA)
Deegree 3 reports WFS-T seriously broken Key: GEOT-3151 URL: http://jira.codehaus.org/browse/GEOT-3151 Project: GeoTools Issue Type: Bug Components: data wfs Reporter: Jody Garne

Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread Andrea Aime
v...@csiro ha scritto: > Hi, can someone kindly advice me on this. > > I have a geometry column on postgis and would like to move that data into > oracle spatial. > > Can someone advice the best/easiest way of doing this? > > I have tried moving data out of postgis as wkt and insert into oracl

Re: [Geotools-devel] [ExternalEmail] postgis st_asbinary(shape)

2010-06-21 Thread Derrick.Wong
Victor, Have a look at OGR2OGR. Derrick Wong Software Engineer | ASRDC (Australian Spatial Research Data Commons) Project | CSIRO Phone: +61 8 6436 8945 derrick.w...@csiro.au | www.csiro.au Address: ARRC (Australian Resources Research Centre), 26 Dick Perry Avenue, Kensington WA 6151, Austral

[Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread v...@csiro
Hi, can someone kindly advice me on this. I have a geometry column on postgis and would like to move that data into oracle spatial. Can someone advice the best/easiest way of doing this? I have tried moving data out of postgis as wkt and insert into oracle sdo_geometry(wkt) but some of the wk

[Geotools-devel] Parametric SQL views, this time for good

2010-06-21 Thread Andrea Aime
Hi, some time ago I've sent this message to the mailing list, and only Michael answered. I'm quite likely to get funding to implement it, so please, if you have feedback, speak :-) --- Hi, as you all probably know thanks to Michael work we