Re: JDBC Driver -- getImportedKeys

I should note that I am no longer getting the exception, but I'm not getting the expected results. These are the results:
Resut not null, therefore there are imported keys
The driver version is: PostgreSQL 7.3 JDBC3 jdbc driver build 106
Column name is appliance_id
Column type is 4

Candis L.

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com]
Sent: Tuesday, January 07, 2003 4:18 PM
To: Candis Thomas
Cc: PostgreSQL JDBC List
Subject: RE: [JDBC] JDBC Driver -- getImportedKeys

This is not a stack trace from a 7.3 or 7.3.1 driver. The
org.postgresql.jdbc2.DatabaseMetaData class was removed between the 7.2
and 7.3 series. Even then I can't find reference to an importLoop method
in older drivers (7.1.3 or 7.2.3).

Please check your driver, classpath settings, or
DatabaseMetaData.getDriverVersion().

Kris Jurka

On Tue, 7 Jan 2003, Candis Thomas wrote:

> The stack trace is as follows:
>
> java.lang.StringIndexOutOfBoundsException: String index out of range: -3
> at java.lang.String.substring(String.java:1520)
> at java.lang.String.substring(String.java:1487)
> at org.postgresql.jdbc2.DatabaseMetaData.importLoop(DatabaseMetaData.java:2263)
> at org.postgresql.jdbc2.DatabaseMetaData.getImportedKeys(DatabaseMetaData.java:2408)
> at com.nubridges.shared.util.Column.setColumnInfo(Column.java:369)
> at com.nubridges.shared.util.Column.main(Column.java:426)
>
> Candis.
>
> -----Original Message-----
> From: Kris Jurka [mailto:books(at)ejurka(dot)com]
> Sent: Tuesday, January 07, 2003 3:07 PM
> To: Candis Thomas
> Cc: PostgreSQL JDBC List
> Subject: Re: [JDBC] JDBC Driver -- getImportedKeys
>
>
>
> Do you have a stack trace of the StringIndexOutOfBoundsException ?
>
> Kris Jurka
>
> On Tue, 7 Jan 2003, Candis Thomas wrote:
>
> > Hello all!,
> >
> > I'm relatively new to the mailing list, but am indeed having a serious problem with a particular method when using the postgreSQL JDBC driver.
> >
> > I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign keys within a table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when using the getImportedKeys() method. The code below attempts to determine whether or not a particular column is a foreign key.
> >
> > The code that I am using is as follows:
> > rs = getMetaData().getImportedKeys(null, null, getTableName());
> > boolean keepLooking = false;
> > if(rs != null){
> > System.out.println("Resut not null, therefore there are imported keys");
> > while(rs.next() && keepLooking){
> > System.out.println("Inside 'rs.next()'");
> > //Check to see if a particular column is a foreign key
> > if(rs.getString("FKCOLUMN_NAME").equalsIgnoreCase(getColumnName())){
> > setForeignKey(true);
> > keepLooking = false;
> > }
> > }//end while
> > }//if result set isn't null
> >
> >
> > The errors that I receive are detailed below (note the listed drivers were added to my classpath):
> > postgreSQL driver 7.3.1 - java.lang.StringIndexOutOfBoundsException: String index out of range: -3
> > postgreSQL jdbc driver 7.3.0 (jdbc 3.0) - java.lang.StringIndexOutOfBoundsException: String index out of range: -3
> >
> > I am attempting to retrieve information on the following table with the following columns:
> > APPLIANCE
> > Keyname Unique Primary Field
> > ======= ====== ======= =====
> > app_mac_address Yes No app_mac_address_net
> > app_mac_address_net_idx No No app_mac_address_net
> > appliance_company_id_idx No No company_id
> > appliance_pkey Yes Yes appliance_id
> >
> > Does anyone have any ideas about what the problem could be? Is this the most recent combination of postgreSQL driver/postgreSQL jdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone may have.
> >
> > Thanks!
> >
> > Candis
> >
> > ---------------------------(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)
> >
>