Playing around with bytea_output doesn't seem to help :-( -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Knut Aksnes-NOR Sent: 20. august 2012 11:59 To: PostGIS Users Discussion Subject: [postgis-users] Postgis 9.0.1 and JDBC problems.
I am trying to use postgis geography thru Eclipselink using postgres-jdbc and have had a few problems at least at least one of them is still holding me up. First problem is that I had to build the driver myself: I have had no luck in finding it in any publically available maven repository. Second problem: PGgeometry is broken; More specifically it implements Serializable, but contains a nonserializable non transient member: BinaryParser bp = new BinaryParser(); This is easily fixed by changing it to: transient BinaryParser bp = new BinaryParser(); The third problem is that there seems to be something wrong related to endianness as I get this message when I try to flush my changes to EclipseLink. Internal Exception: org.postgresql.util.PSQLException: ERROR: Invalid endian flag value encountered. Some extra information: I do insert postgis dependencies using this piece of code: final org.postgresql.PGConnection connection = (PGConnection) ((EntityManagerImpl) em) .unwrap(java.sql.Connection.class); connection.addDataType("geometry", Class.forName("org.postgis.PGgeometry")); connection.addDataType("geography", Class.forName("org.postgis.PGgeometry")); connection.addDataType("box3d", Class.forName("org.postgis.PGbox3d")); The JPA attribute definition is shown here: @Basic(optional = true, fetch = LAZY) @Column(columnDefinition = "GEOGRAPHY(MULTIPOLYGON,4326)", insertable = true, updatable = true, nullable = true) private PGgeometry coverageArea; For postgis I am using the postgis 9.0.1 jdbc4 driver Even inserting nulls seems to create this endian flag value exception. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users