Re: Can't get all Imported Keys from dmd

David,

Try the development driver, this has been fixed in the latest sources

Dave
On Tue, 2002-06-25 at 12:15, David A. Bartmess wrote:
> The following code SHOULD (according to the JDK1.4 docs) get all the
> primary keys related to a table's foreign keys, if I read the docs
> right. But I get back a ResultSet only containing one (1) key, not two,
> as in my table.
> 
> Can someone explain this to me? Why won't it return all the keys in the
> ResultSet?
> 
> Thanks!
> 
> ResultSet fkpk = dmd.getImportedKeys("", "", "login");
> 
> while (fkpk.next())
> {
>       System.out.println("PK: " + fkpk.getString("PKTABLE_NAME"));
>       System.out.println("\t" + fkpk.getString("PKCOLUMN_NAME"));
>       System.out.println("FK: " + fkpk.getString("FKTABLE_NAME"));
>       System.out.println("\t" + fkpk.getString("FKCOLUMN_NAME"));
> }
> 
> System.out.println(" ");
> **********************************
> Table creation script:
> 
> drop table login;
> drop sequence login_id_seq;
> 
> create table login(
>       id                      serial primary key,
>       memberid                int references members(id),
>       userid                  varchar(15) not null,
>       password                varchar(15) not null,
>       verification            char(20),
>       verifydatesent          date,
>       verifydaterecd          date,
>       accesslevel             int references accesslevels(id),
>       remoteip                varchar(16),
>       reminderquestion        varchar(80),
>       reminderanswer          varchar(25)
> );
> create index idxloginid on login(id);
> create index idxlogin_memberid on members(id);
> 
> 
> **********************************
> Test results:
> 
> PK: accesslevels
>         id
> FK: login
>         accesslevel
>  
> 
> 
> -- 
> David A. Bartmess
> Software Configuration Manager / Sr. Software Developer
> eDingo Enterprises
> http://edingo.net
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> 
> 






---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly