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#DBGenerationO
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.
