Обсуждение: JDBC Driver -- getImportedKeys
Hello all!,
I'm relatively new to the mailing list, but am indeed having a serious problem with a particular method when using the
postgreSQLJDBC driver.
I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign keys
withina table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when using
thegetImportedKeys() 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
Thanks!
Candis
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
thepostgreSQL JDBC driver.
>
> I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign keys
withina table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when using
thegetImportedKeys() 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
>
> Thanks!
>
> Candis
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
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@ejurka.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
thepostgreSQL JDBC driver.
>
> I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign keys
withina table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when using
thegetImportedKeys() 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
>
> Thanks!
>
> Candis
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
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@ejurka.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
thepostgreSQL JDBC driver.
> >
> > I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign keys
withina table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when using
thegetImportedKeys() 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
> >
> > Thanks!
> >
> > Candis
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
>
These are the results from DatabaseMetaData.getDriverVersion():
The driver version is: PostgreSQL 7.3 JDBC3 jdbc driver build 106
-----Original Message-----
From: Kris Jurka [mailto:books@ejurka.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@ejurka.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
thepostgreSQL JDBC driver.
> >
> > I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign keys
withina table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when using
thegetImportedKeys() 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
> >
> > Thanks!
> >
> > Candis
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
>
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@ejurka.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@ejurka.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
thepostgreSQL JDBC driver.
> >
> > I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign keys
withina table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when using
thegetImportedKeys() 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
> >
> > Thanks!
> >
> > Candis
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
>
I'm not clear on what results you're getting and what results you want
because you've really only shown what your application is doing. What
would be interesting would be
1) the SQL used to create the various tables.
2) the results of
printResultSet(conn.getMetaData().getImportedKeys(null,null,"<table>");
where printResultSet is defined as below
3) what you'd like the results to be.
Kris Jurka
public static void printResultSet(ResultSet rs) throws SQLException {
ResultSetMetaData rsmd = rs.getMetaData();
for (int i=1; i<=rsmd.getColumnCount(); i++) {
if (i != 1) {
System.out.print(", ");
}
System.out.print(rsmd.getColumnName(i));
}
System.out.println();
while (rs.next()) {
for (int i=1; i<=rsmd.getColumnCount(); i++) {
if (i != 1) {
System.out.print(", ");
}
System.out.print(rs.getString(i));
}
System.out.println();
}
}
On Tue, 7 Jan 2003, Candis Thomas wrote:
> 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@ejurka.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@ejurka.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
usingthe postgreSQL JDBC driver.
> > >
> > > I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign
keyswithin a table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when
usingthe getImportedKeys() method. The code below attempts to determine whether or not a particular column is a
foreignkey.
> > >
> > > 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
> > >
> > > Thanks!
> > >
> > > Candis
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the unregister command
> > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> > >
> >
>
i managed to fix my problem. thanks guys!
Candis L.
-----Original Message-----
From: Kris Jurka [mailto:books@ejurka.com]
Sent: Tuesday, January 07, 2003 5:01 PM
To: Candis Thomas
Cc: PostgreSQL JDBC List
Subject: RE: [JDBC] JDBC Driver -- getImportedKeys
I'm not clear on what results you're getting and what results you want
because you've really only shown what your application is doing. What
would be interesting would be
1) the SQL used to create the various tables.
2) the results of
printResultSet(conn.getMetaData().getImportedKeys(null,null,"<table>");
where printResultSet is defined as below
3) what you'd like the results to be.
Kris Jurka
public static void printResultSet(ResultSet rs) throws SQLException {
ResultSetMetaData rsmd = rs.getMetaData();
for (int i=1; i<=rsmd.getColumnCount(); i++) {
if (i != 1) {
System.out.print(", ");
}
System.out.print(rsmd.getColumnName(i));
}
System.out.println();
while (rs.next()) {
for (int i=1; i<=rsmd.getColumnCount(); i++) {
if (i != 1) {
System.out.print(", ");
}
System.out.print(rs.getString(i));
}
System.out.println();
}
}
On Tue, 7 Jan 2003, Candis Thomas wrote:
> 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@ejurka.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@ejurka.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
usingthe postgreSQL JDBC driver.
> > >
> > > I am attempting to obtain metadata about the columns within a table, more specifically the primary and foreign
keyswithin a table. Though the DataBaseMetaData method getPrimaryKeys() executes splendidly, I am getting errors when
usingthe getImportedKeys() method. The code below attempts to determine whether or not a particular column is a
foreignkey.
> > >
> > > 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/postgreSQLjdbc driver that I should use? I'm really stumped by this issue and welcome any feedback that anyone
mayhave.
> > >
> > > Thanks!
> > >
> > > Candis
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the unregister command
> > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> > >
> >
>