how about in 1.4.0.2, when the ubuntu/sextante solution is explained? ..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
