Thread: Feature enquiry in pgsql driver.

Feature enquiry in pgsql driver.

From
Anil Jangam
Date:
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.

Re: Feature enquiry in pgsql driver.

From
"Dave Cramer"
Date:
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)



Re: Feature enquiry in pgsql driver.

From
Anil Jangam
Date:
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)