Thread: Feature enquiry in pgsql driver.
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.
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)
Thanks Dave, I did the mapping/definition manually, and happy to find that the code, which I wrote and genrated by the Maptool both are identical ;0). Nevertheless the utility is much more useful when the relations are more complex and large in numbers. -anil. > -----Original Message----- > From: Dave Cramer [mailto:Dave@micro-automation.net] > Sent: Tuesday, January 08, 2002 5:58 PM > To: 'Anil Jangam'; pgsql-jdbc@postgresql.org > Subject: RE: [JDBC] 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)