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
