The question is, how would you read an org.postgis.Point object through JDBC? Would you use ResultSet.getObject() (i.e. does the Postgres JDBC driver provide you with a Point), or would you use ResultSet.getString() and deserialise the Point yourself. In the first case, you'd have to convert Object to Point and vice versa. In the latter case, you'd have to convert String to Point and vice versa. In principle, code generation using converters should work. Could you please post your generator configuration XML?
Could you also provide me with some DDL and further instructions, such that I can experiment with PostGIS myself? It'll be easier to give you directions that way... Cheers Lukas 2012/10/24 <[email protected]>: > Hello, > > thanks for your quick reply. > > I have already tried to make a Converter. > But the classes from the generatorTool didn't seam to make use of it. > This field doesn't work (in BuildingTable): > public final org.jooq.TableField<BuildingtableRecord, org.postgis.Point> > GEOMETRY = createField("geometry", > org.jooq.util.postgres.PostgresDataType.getDefaultDataType("USER-DEFINED"), > this); > > As far as I understand the Converter's purpose, it converts from a datatype > it can actually read from the database. But that's the problem here. > I would like to create the sql statements for the Postgis.Point myself. But > I don't know which classes I must extend so that the whole thing works with > the Records. Is that possible by overriding the CustomField class ? > The only other solution I see is to abandon the created Records and do the > reading and writing myself for my entities. But I would really like to use > Record.storeUsing and so on. > > Greetings > > Mike
