[JPP-Devel] Maven release build fails
Hi, I can build with the snapshot profile by following the instructions from http://ojwiki.soldin.de/index.php?title=Creating_an_OJ_release_version. However, when I tried the release command mvn package -P release -D version.number=1.5.1 -D version.release=4000 the build fails with the following error [ERROR] Failed to execute goal org.apache.maven.plugins:maven-assembly-plugin:2. 2-beta-5:single (release core) on project OpenJUMP: Failed to create assembly: Error adding file to archive: C:\data\oj_trunk\core\trunk\target\nolang\OpenJUMP- 1.5.1-r${version.revision}-nosrc.jar isn't a file. - [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecution Exception There may be something to correct in the pom.xml, but what? -Jukka Rahkonen- -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
Re: [JPP-Devel] Commit access to SVN
+1 :) On 04/22/2015 11:35 AM, Giuseppe Aruta wrote: I will be glad to have you on board, Jukka, as developer. Peppe 2015-04-22 16:08 GMT+02:00 Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi mailto:jukka.rahko...@maanmittauslaitos.fi: Hi developers, I would like to ask if you could trust me enough for granting me a commit access to OpenJUMP SVN. For me it would be OK to generate patches and let others to merge them but Ede said that at least he rather wouldn’t do that. I have managed to build a modified Spatialite plugin with ant and a whole OpenJUMP snapshot version with maven so I think I know now how to test my changes locally before committing. I do not have plans to touch the core Java code but there is something in the Spatialite plugin that I know I can improve. -Jukka Rahkonen- -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net mailto:Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] VM out of memory error
Hello. I am running JUMP 1.8.0 rev. 4164 on Windows 8.1. I am adding shapefiles to a project. Most work fine, but one throws this error: Requested array size exceeds VM limit (Out of memory error). This shapefile is not that big. Any ideas how to get it to work? Lawrence -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] Enhanced RasterColorEditor
Hi all, I made some small enhancements to RasterColorEditor panel (accessible through *Sextante Raster layer popup menuChange Raster Layer propertiesRaster Color Editor tab*) to manage Color models for single banded images. These are the enhancements: - the color editor is activated only for single banded images. - added some other color ramps. - optimized color ramps display - added option to invert the applied color model - added option to set cell values outside a chosen ramp (minvaluesmax) to transparent The original plugin (RasterColorEditorPlugin.class) is still available through *RasterRaster Color Editor* menu. It will be deactivated before next official OJ real., if everybody agree. I added also a couple of language codes. I wrote a minimal help page here: http://ojwiki.soldin.de/index.php?title=Single_band_raster_layer_symbology_%28Sextante%29 Any comment is welcome. @Alberto. I revert a bug that inadvertently was introduced with your previous modifications: color range was strictly set to raster cell min/max values even if user could modified min/max values in the fields. I came across your Raster Style plugin, which is for shore better than the one embedded into OJ. I wonder if you still have the idea to embed it into OJ. In this case I can give you an help. Please, consider also the last 2 options I added to this plugin (invert color and transparency) best regards Giuseppe Aruta -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] SVN: [4403] core/trunk
Revision: 4403 http://sourceforge.net/p/jump-pilot/code/4403 Author: ma15569 Date: 2015-04-22 12:52:14 + (Wed, 22 Apr 2015) Log Message: --- 2015-04-12 Giuseppe Aruta giuseppe_ar...@yahoo.it * Raster Color Editor Panel. Added an option to invert color range and an option to set values outside choosen range to transparent. Optimized color ramp. Added more color ramps Modified Paths: -- core/trunk/ChangeLog core/trunk/src/language/jump.properties core/trunk/src/language/jump_cz.properties core/trunk/src/language/jump_de.properties core/trunk/src/language/jump_es.properties core/trunk/src/language/jump_fi.properties core/trunk/src/language/jump_fr.properties core/trunk/src/language/jump_hu.properties core/trunk/src/language/jump_it.properties core/trunk/src/language/jump_ja_JP.properties core/trunk/src/language/jump_ml.properties core/trunk/src/language/jump_pt.properties core/trunk/src/language/jump_pt_BR.properties core/trunk/src/language/jump_ta_IN.properties core/trunk/src/language/jump_te.properties core/trunk/src/language/jump_zh_CN.properties core/trunk/src/language/jump_zh_HK.properties core/trunk/src/org/openjump/core/ui/plugin/layer/pirolraster/panel/RasterColorEditorPanel.java Modified: core/trunk/ChangeLog === --- core/trunk/ChangeLog2015-04-21 04:54:25 UTC (rev 4402) +++ core/trunk/ChangeLog2015-04-22 12:52:14 UTC (rev 4403) @@ -1,4 +1,7 @@ # for display continuity sake please use 2 spaces instead of tabs +2015-04-12 Giuseppe Aruta giuseppe_ar...@yahoo.it + * Raster Color Editor Panel. Added an option to invert color range and an option to set +values outside choosen range to transparent. Optimized color ramp. Added more color ramps 2015-04-18 mmichaud m.michael.mich...@orange.fr * FR #220 : add an option to snap on feature being edited. Indeed, the new snap Modified: core/trunk/src/language/jump.properties === --- core/trunk/src/language/jump.properties 2015-04-21 04:54:25 UTC (rev 4402) +++ core/trunk/src/language/jump.properties 2015-04-22 12:52:14 UTC (rev 4403) @@ -1117,6 +1117,8 @@ org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.Toggle-transparency-for-no-data-values = Toggle transparency for no-data values. org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.change = change org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.no-data-value-color = no-data value color +org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.Invert-colors= Invert colors +org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.Set-values-outside-transparent=Set values outside the range to transparent org.openjump.core.ui.plugin.style.ImportArcMapStylePlugIn.Must-Select-Location-Of-SLD = The next step is to select the SLD that was\n\ \tgenerated by ArcMap2SLD. org.openjump.core.ui.plugin.style.ImportArcMapStylePlugIn.Must-Select-Location-Of-Tool = To be able to use the external program ArcMap2SLD,\n\ Modified: core/trunk/src/language/jump_cz.properties === --- core/trunk/src/language/jump_cz.properties 2015-04-21 04:54:25 UTC (rev 4402) +++ core/trunk/src/language/jump_cz.properties 2015-04-22 12:52:14 UTC (rev 4403) @@ -1089,6 +1089,8 @@ org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.Toggle-transparency-for-no-data-values = Zapnout pr\u016Fhlednost pro bu\u0148ky bez hodnoty. org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.change = zm\u011Bnit org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.no-data-value-color = barva pro bu\u0148ky bez hodnoty +org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.Invert-colors= \#T\:Invert colors +org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.Set-values-outside-transparent=\#T\:Set values outside the range to transparent org.openjump.core.ui.plugin.style.ImportArcMapStylePlugIn.Must-Select-Location-Of-SLD = N\u00E1sleduj\u00EDc\u00ED krok je vybrat SLD kter\u00E9 bylo\n\ \tvygenerov\u00E1no s pomoc\u00ED ArcMap2SLD. org.openjump.core.ui.plugin.style.ImportArcMapStylePlugIn.Must-Select-Location-Of-Tool = Aby bylo mo\u017Eno vyu\u017E\u00EDvat extern\u00ED program ArcMap2SLD,\n\ Modified: core/trunk/src/language/jump_de.properties === --- core/trunk/src/language/jump_de.properties 2015-04-21 04:54:25 UTC (rev 4402) +++ core/trunk/src/language/jump_de.properties 2015-04-22 12:52:14 UTC (rev 4403) @@ -1090,6 +1090,8 @@ org.openjump.core.ui.plugin.raster.color.RasterColorEditorPlugIn.Toggle-transparency-for-no-data-values = Transparenz f\u00fcr no-data Werte.
Re: [JPP-Devel] VM out of memory error
Hi, Best way to get as much memory as possible for OpenJUMP is to run it with 64-bit jre. You can find which jre version is in use through the Info menu. If it shows that 32-bit jre is in use edit the oj_windows.bat file and point it to 64-bit jre. Don't care about the version 1.5/1.6 hint, OJ works fine with 1.7 and 1.8. rem -- uncomment to manually set java home -- rem set JAVA_HOME=G:\path\to\a\specific\jre|jdk-1.5|6 Tell us if this does not help or if you can't install 64-bit jre. -Jukka Rahkonen- LawrenceGmail wrote: Hello. I am running JUMP 1.8.0 rev. 4164 on Windows 8.1. I am adding shapefiles to a project. Most work fine, but one throws this error: Requested array size exceeds VM limit (Out of memory error). This shapefile is not that big. Any ideas how to get it to work? Lawrence -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] SVN: [4405] core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils .java
Revision: 4405 http://sourceforge.net/p/jump-pilot/code/4405 Author: ma15569 Date: 2015-04-22 15:09:20 + (Wed, 22 Apr 2015) Log Message: --- Modified Paths: -- core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java Modified: core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java === --- core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java 2015-04-22 15:08:50 UTC (rev 4404) +++ core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java 2015-04-22 15:09:20 UTC (rev 4405) @@ -471,9 +471,6 @@ *. Plugin Context * @param rLayer *. Selected Raster Image Layer (RasterImageLayer.class) - * @param band - *. Number of band to save (O=1st band (red), 1=2nd band - *(green), 2=3rd band (blue), etc) * @throws IOException */ -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] SVN: [4404] core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils .java
Revision: 4404 http://sourceforge.net/p/jump-pilot/code/4404 Author: ma15569 Date: 2015-04-22 15:08:50 + (Wed, 22 Apr 2015) Log Message: --- (Giuseppe Aruta) xtend to all band Export selected raster to XYZ table. If the file is a multi banded raster each band is extracted to a proper band named band1, band2, etc. Modified Paths: -- core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java Modified: core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java === --- core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java 2015-04-22 12:52:14 UTC (rev 4403) +++ core/trunk/src/org/openjump/core/rasterimage/RasterImageIOUtils.java 2015-04-22 15:08:50 UTC (rev 4404) @@ -462,7 +462,8 @@ } /** - * Export selected raster to XYZ table + * Export selected raster to XYZ table. If the file is a multi banded raster + * each band is extracted to a proper band named band1, band2, etc * * @param file *file to save es D:/Openjump/test.xyz @@ -477,12 +478,12 @@ */ public static void saveXYZ(File outfile, PlugInContext context, -RasterImageLayer rLayer, int band) throws IOException { +RasterImageLayer rLayer) throws IOException { OutputStream out = null; try { OpenJUMPSextanteRasterLayer rstLayer = new OpenJUMPSextanteRasterLayer(); rstLayer.create(rLayer); - +int numBands = rLayer.getNumBands(); out = new FileOutputStream(outfile); cellFormat = NumberFormat.getNumberInstance(); cellFormat.setMaximumFractionDigits(3); @@ -499,7 +500,12 @@ } PrintStream po = new PrintStream(out); -po.println(x\ty\tz); +po.append(coordinateX\tcoordinateY); +for (int b = 0; b numBands; b++) { +int n = b + 1; +po.append(\tband + n); +} +po.append(\n); GridWrapperNotInterpolated gwrapper = new GridWrapperNotInterpolated( rstLayer, rstLayer.getLayerGridExtent()); int nx = rstLayer.getLayerGridExtent().getNX(); @@ -507,21 +513,32 @@ for (int y = 0; y ny; y++) { StringBuffer b = new StringBuffer(); for (int x = 0; x nx; x++) { -double value = gwrapper.getCellValueAsDouble(x, y, band); +double value0 = gwrapper.getCellValueAsDouble(x, y, 0); +double value1 = gwrapper.getCellValueAsDouble(x, y, 1); +double value2 = gwrapper.getCellValueAsDouble(x, y, 2); Point2D pt = rstLayer.getLayerGridExtent() .getWorldCoordsFromGridCoords(x, y); double Xf = pt.getX(); double Yf = pt.getY(); -if (Double.isNaN(value)) { -value = defaultNoData; +if (Double.isNaN(value0) || Double.isNaN(value1) +|| Double.isNaN(value2)) { +value0 = defaultNoData; +value1 = defaultNoData; +value2 = defaultNoData; } -if (Math.floor(value) == value) -b.append(Xf + \t + Yf + \t + (int) value + \n); +if (Math.floor(value0) == value0 +|| Math.floor(value1) == value1 +|| Math.floor(value2) == value2) +b.append(Xf + \t + Yf + \t + (double) value0 + \t ++ (double) value1 + \t + (double) value2 ++ \n); else { -b.append(Xf + \t + Yf + \t + value + \n); +b.append(Xf + \t + Yf + \t + value0 + value1 ++ value2 + \n); } + } po.println(b); } @@ -535,7 +552,7 @@ context.getWorkbenchFrame() .getOutputFrame() .addText( -SaveImageToRasterPlugIn Exception:Export Part of FLT/ASC or modify raster to XYZ not yet implemented. Please Use Sextante Plugin); +Save To Raster Exception:Export image with no datasource to FLT/ASC/GRD/XYZ not yet implemented. Please Use Sextante Plugin); } finally { if (out != null) out.close(); -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM
Re: [JPP-Devel] Commit access to SVN
I will be glad to have you on board, Jukka, as developer. Peppe 2015-04-22 16:08 GMT+02:00 Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi: Hi developers, I would like to ask if you could trust me enough for granting me a commit access to OpenJUMP SVN. For me it would be OK to generate patches and let others to merge them but Ede said that at least he rather wouldn’t do that. I have managed to build a modified Spatialite plugin with ant and a whole OpenJUMP snapshot version with maven so I think I know now how to test my changes locally before committing. I do not have plans to touch the core Java code but there is something in the Spatialite plugin that I know I can improve. -Jukka Rahkonen- -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
Re: [JPP-Devel] Maven release build fails
Hi Michaël, I was testing how it feels to build OpenJUMP with maven just out of curiosity and for testing if the documentation is up-to-date. I have already managed to build a working spatialite plugin with ant but packaging into jar failed so until now I have just zipped the target folders and renamed the archive. -Jukka- Michaël Michaud wrote: Hi Jukka, You're welcome to contribute as a programmer after so many contributions as an expert. I just added you in the developper list. Why do you need to build OpenJUMP ? I'm sure Ede can give you more valuable inputs than I about building with maven, but I'll tell you how I manage plugins with ant. I have generally a small ant build file in the plugin project, with a target containing a jar instruction. Just after, I add a copy instruction to copy the jar to my current OpenJUMP installation directory. target name=my-plugin id=my-plugin depends=compile-all jar basedir=${build} jarfile=${dist}/my-plugin-${my-plugin-version}.jar / copy file=${dist}/my-plugin-${my-plugin-version}.jar todir=D:/PATH/TO/OpenJUMP-20150328-r4357-PLUS/lib/ext / /target That way, every time I run my jar ant task, I can test the new jar in my current OpenJUMP installation. May be it will also suit your needs for Spatialite improvements. Let me know if you have any problem. Michaël Le 22/04/2015 18:30, Rahkonen Jukka (MML) a écrit : Hi, I can build with the snapshot profile by following the instructions from http://ojwiki.soldin.de/index.php?title=Creating_an_OJ_release_version. However, when I tried the release command mvn package -P release -D version.number=1.5.1 -D version.release=4000 the build fails with the following error [ERROR] Failed to execute goal org.apache.maven.plugins:maven-assembly-plugin:2. 2-beta-5:single (release core) on project OpenJUMP: Failed to create assembly: Error adding file to archive: C:\data\oj_trunk\core\trunk\target\nolang\OpenJUMP- 1.5.1-r${version.revision}-nosrc.jar isn't a file. - [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecution Exception There may be something to correct in the pom.xml, but what? -Jukka Rahkonen- -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.netmailto:Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
Re: [JPP-Devel] DB Query Plugin, SpatiaLite, GPKG and DATE data type
From the doc (https://www.sqlite.org/datatype3.html), sqlite datatype system seems to be very different from other databases. A date may be stored as a String, a Integer or a Double, even if it is declared as a date. If it is stored as a String, I think that getTimestamp will not recognize the format, hence the error. You may have to use SimpleDateFormat sdf = new SimpleDateFormat(-MM-dd HH:mm:ss.sss) then sdf.parse(string) - Date or the FlexibleDateParser of OpenJUMP which will recognize more formats Michaël Le 22/04/2015 23:46, Rahkonen Jukka (MML) a écrit : Hi, The SQLite/Spatialite/GeoPackage driver of the DB Query Plugin is reading data from a column that is recognized as a DATE with this code that comes from http://sourceforge.net/p/jumpdbqplugin/code/ci/default/tree/src/main/java/org/freevoice/jumpdbqueryextension/spatialite/JumpSpatialiteDbQuery.java (line 252) else if (AttributeType.DATE.equals(attributeType)) { returnObject = new Date(results.getTimestamp(dbColumnIndex).getTime()); } I found that the code gives an error if dates in the database are encoded into ISO text format, like 2015-04-23. After some experiments I started to think that results.getTimestamp(dbColumnIndex).getTime() awaits a number, perhaps an integer number, maybe UNIX seconds. It would be better to consider that all times in those databases (DATE, TIME, TIMESTAMP, DATETIME) are ISO strings. If date is not a valid ISO data string they it could be skipped and converted into NULL for OpenJUMP. That would be more user friendly than to stop parsing and quit. More details about times in SQLite based databases in gdal-dev thread http://thread.gmane.org/gmane.comp.gis.gdal.devel/40172 -Jukka Rahkonen- -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] Commit access to SVN
Hi developers, I would like to ask if you could trust me enough for granting me a commit access to OpenJUMP SVN. For me it would be OK to generate patches and let others to merge them but Ede said that at least he rather wouldn't do that. I have managed to build a modified Spatialite plugin with ant and a whole OpenJUMP snapshot version with maven so I think I know now how to test my changes locally before committing. I do not have plans to touch the core Java code but there is something in the Spatialite plugin that I know I can improve. -Jukka Rahkonen- -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel