Re: Feature enquiry in pgsql driver.

Anil,

The current driver 7.2dev which you can download from
jdbc.postgresql.org has these features.

http://jdbc.postgresql.org/download/jdbc7.2dev-1.2.jar

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Anil Jangam
Sent: Monday, January 07, 2002 11:39 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Feature enquiry in pgsql driver.
Importance: High


Hi,

I am facing the follwoing problem while using the postgreSQL database
with the VBSF maptool. This tool needs the information about the FK and
PK relationships defined in the databse so that it can be mapped to the
corresponding object (class attributes).

While converting the java code from the relation data schema, the
relational information is not being converted to the corresponding
object relations. I have checked it with the maptool developer mailing
list, and have received the follwoing response.

**********************************

REFERENCE and REFERENCE COLLECTION attributes are generated if the
'Generate REFERENCE attributes' and 'Generate REFERENCE COLLECTION
attributes' options are checked in the configuration 'DB Generation
Options panel'. For details please see:

http://www.objectmatter.com/vbsf/docs/maptool/toolconfigs.html#DBGenerat
ionO
ptionsPanel

If these options are checked and no REFERENCE and REFERENCE COLLECTION
attributes are generated, then your JDBC driver is not able to provide
the required information to the mapping tool. More specifically, your
JDBC driver should return the appropriate information from the following
JDBC
calls:

DatabaseMetaData.getExportedKeys(catalogName, schemaName, tableName)
DatabaseMetaData.getImportedKeys(catalogName, schemaName, tableName)

Please check with the driver manufacturer.

**********************************

Kindly update me wether the current driver version (jdbc7.1-1.2)
supports this features??

regds,
-anil.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)