Le 31/10/2010 16:43, edgar.sol...@web.de a écrit : > how about in 1.4.0.2, when the ubuntu/sextante solution is explained? That's what I hope ;-)
I think there is a third small distribution problem. OpenJUMP + sextante bundle seems to be java5 compatible except the CSV Pirol's plugin which throws a class version error I get the sources from Pirol website. I'll try to compile it with java5 if I have a moment. After 1.4.0.x series, I'll stop to check java5 compatibility. Promised Michaël > ..ede > > On 31.10.2010 16:30, Michaël Michaud wrote: >> Hi again, >> >> This one is also for other developpers, >>> If you have opportunity to connect to a PostgreSQL 8.x database with your >>> new 9.0 compatible driver, please tell me if it works. >>> It would be nice if we could drop the old driver and put the new one in the >>> distro. >>> Otherwise, I'll test myself with the new driver. >> Just did a quick test with postgresql-9.0-801.jdbc3.jar and PostgreSQL 8.4. >> It seems to work. >> It's a good new as it means we can ship the new driver with the new >> distribution instead of the postgresql-8.3-603.jdbc3.jar. >> It would avoid other users to have the same problem. >> >> More tests are welcome. >> >> Michaël >> >>> Another tip you should know : >>> If your data has z values (you can upload data with z from a 3D shapefile >>> for example), you must use ST_AsEWKB(geom) instead of ST_AsBinary(geom) to >>> get z values. >>> Only few people know that. I'll add that to the wiki too. >>> >>> If you want to contribute yourself to the wiki, I can see it it's possible >>> to give yo write access. >>> >>> Michaël >>>> Ravi Kumar >>>> >>>> 2010/10/30 Michaël >>>> Michaud<michael.mich...@free.fr<mailto:michael.mich...@free.fr>> >>>> >>>> Hi, >>>> >>>>> Am using Windows Vista >>>> and me too >>>> >>>>> This is an excerpt from 'PostGIS in Action'. >>>>> "In order to display geometries with the plain vanilla OpenJump >>>>> install, you need to use the ST_AsBinary function to convert the PostGIS >>>>> geometry to an OGC standard binary format" >>>> right, this is the normal way, >>>> >>>>> Can try this, but how.. where should I drp this JAR file..9.0-801 >>>>> JDBC 4<http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc3.jar> >>>> Just follow the link I gave you : >>>> >>>> http://jdbc.postgresql.org/download.html >>>> >>>> Michaël >>>> >>>> >>>>> Ravi Kumar >>>>> >>>>> 2010/10/30 Michaël >>>>> Michaud<michael.mich...@free.fr<mailto:michael.mich...@free.fr>> >>>>> >>>>> Hi, >>>>> >>>>> I don't have yet installed PostgreSQL9.0, but I think it needs a >>>>> new jdbc driver. >>>>> >>>>> Please, go to http://jdbc.postgresql.org/download.html >>>>> >>>>> and try 9.0-801 JDBC >>>>> 3<http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc3.jar> or >>>>> 9.0-801 JDBC >>>>> 4<http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc3.jar> >>>>> >>>>> Michaël >>>>> >>>>> Le 30/10/2010 01:43, Ravi Vundavalli a écrit : >>>>>> Michael >>>>>> Am further probing this. >>>>>> I have loaded OJ1.2 to see if it works. >>>>>> Same error there also. >>>>>> >>>>>> A table can be loaded through >>>>>> Open -> PostGIS Table >>>>>> But Not >>>>>> From Run datastore query >>>>>> >>>>>> Am using Pgadmin 1.12.1 with postgis-pg90-setup-1.5.2-3 >>>>>> Trying the Ebook PostGIS in Action, and stumbled on these >>>>>> problems. >>>>>> >>>>>> Ravi Kumar >>>>>> >>>>>> 2010/10/30 Michaël >>>>>> Michaud<michael.mich...@free.fr<mailto:michael.mich...@free.fr>> >>>>>> >>>>>> Hi, >>>>>> >>>>>>> Michael, >>>>>>> Am using OJ 1.4 >>>>>>> Can send you a small shape file, If you wish to test. >>>>>> I'm not sure a shapefile will help to test. >>>>>> Can you connect to your database with pgadmin ? >>>>>> Can you tell me if your tables are listed in the >>>>>> geometry_columns table >>>>>> Can you tell me what you get in the geom column when you >>>>>> simple do >>>>>> select * from yourtable limit 1 >>>>>> in pgadmin (is your geom in text format or in binary format >>>>>> ?) >>>>>> Can you try with ST_AsBinary(ff.geom::geometry) >>>>>> instead of ST_AsBinary(ff.geom) >>>>>> >>>>>> Michaël >>>>>> >>>>>>> Ravi >>>>>>> >>>>>>> >>>>>>> >>>>>>> 2010/10/29 Michaël >>>>>>> Michaud<michael.mich...@free.fr<mailto:michael.mich...@free.fr>> >>>>>>> >>>>>>> Hi Ravi, >>>>>>> >>>>>>> From my OJ1.4 installation on a windows box, I can >>>>>>> load data >>>>>>> - From Postgis Plugin >>>>>>> - From Open -> DataStoreLayer >>>>>>> - From Run datastore query >>>>>>> >>>>>>> My geometry is stored on postgis in wkb format >>>>>>> >>>>>>> Michaël >>>>>>> >>>>>>> Le 29/10/2010 23:22, Ravi Vundavalli a écrit : >>>>>>>> Found two situations giving error in OJ using PostGIS >>>>>>>> 1. A postGIS table is loaded properly using Open-> >>>>>>>> PostGIS Table >>>>>>>> >>>>>>>> But the same table gives an error trying to load >>>>>>>> through Open -> Data Store Layer >>>>>>>> Error: com.vividsolutions.jts.io.parse >>>>>>>> exception:unknown WKB type 48 (run time exception) >>>>>>>> >>>>>>>> 2. Have been browsing, 'PostGIS in Action' and trying >>>>>>>> to use some code in OpenJUMP, 'Run datastore query' >>>>>>>> >>>>>>>> Code: >>>>>>>> SELECT >>>>>>>> ST_AsBinary(ff.geom) As wkb >>>>>>>> FROM ch01.fastfoods As ff >>>>>>>> WHERE EXISTS(SELECT r.gid >>>>>>>> FROM ch01.roads As r >>>>>>>> WHERE ST_DWithin(ff.geom, r.geom, 1609*10) >>>>>>>> AND r.name<http://r.name> = 'US Route 1' AND r.state >>>>>>>> = 'MD' AND ff.franchise = 'h'); >>>>>>>> >>>>>>>> Error: com.vividsolutions.jts.io.ParseException: >>>>>>>> Unknown WKB type 48 >>>>>>>> >>>>>>>> >>>>>>>> Ravi Kumar >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >> >> >> ------------------------------------------------------------------------------ >> Nokia and AT&T present the 2010 Calling All Innovators-North America contest >> Create new apps& games for the Nokia N8 for consumers in U.S. and Canada >> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing >> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store >> http://p.sf.net/sfu/nokia-dev2dev >> >> >> >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ > Nokia and AT&T present the 2010 Calling All Innovators-North America contest > Create new apps& games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
