Re: Feature enquiry in pgsql driver.

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(at)micro-automation(dot)net]
> Sent: Tuesday, January 08, 2002 5:58 PM
> To: 'Anil Jangam'; pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Anil Jangam
> Sent: Monday, January 07, 2002 11:39 PM
> To: pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org)