Thread: How to discern a reference column from within java??
I am trying to figure out how to discern a reference column (as shown below) inside a java object containing the various columns in a specific row of a table. The table looks like: CREATE TABLE TempTbl AS ( id serial, type int references TypesTbl ); But I cannot find a way inside the jdbc API to figure out if a particular column is a reference to another table's row. Such as: // These are examples of possible code TempTbl tmptbl = new TempTbl(); tmptbl.connect(); tmptbl.readRow(); ... if (tmptbl.getColumn("type").isReference()) { TypesTbl typestbl = new TypesTbl(); tmptbl.setColumn("type", typestbl.getRowRef(tmptbl.getColumn("type")); } Am I missing something in the API? Thanks for any help! -- David A. Bartmess Software Configuration Manager / Sr. Software Developer eDingo Enterprises http://edingo.net
David, Have a look at the getImported, getExported in the databasemetadata class Dave On Sun, 2002-06-09 at 13:51, David A. Bartmess wrote: > > I am trying to figure out how to discern a reference column (as shown > below) inside a java object containing the various columns in a specific > row of a table. > > The table looks like: > > CREATE TABLE TempTbl AS > ( > id serial, > type int references TypesTbl > ); > > But I cannot find a way inside the jdbc API to figure out if a > particular column is a reference to another table's row. Such as: > > // These are examples of possible code > TempTbl tmptbl = new TempTbl(); > tmptbl.connect(); > tmptbl.readRow(); > > ... > if (tmptbl.getColumn("type").isReference()) > { > TypesTbl typestbl = new TypesTbl(); > tmptbl.setColumn("type", > typestbl.getRowRef(tmptbl.getColumn("type")); > } > > Am I missing something in the API? > > Thanks for any help! > -- > David A. Bartmess > Software Configuration Manager / Sr. Software Developer > eDingo Enterprises > http://edingo.net > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > >
Thanks, I'll check it out! On Sun, 2002-06-09 at 21:18, Dave Cramer wrote: > David, > > Have a look at the getImported, getExported in the databasemetadata > class > > Dave > On Sun, 2002-06-09 at 13:51, David A. Bartmess wrote: > > > > I am trying to figure out how to discern a reference column (as shown > > below) inside a java object containing the various columns in a specific > > row of a table. > > > > The table looks like: > > > > CREATE TABLE TempTbl AS > > ( > > id serial, > > type int references TypesTbl > > ); > > > > But I cannot find a way inside the jdbc API to figure out if a > > particular column is a reference to another table's row. Such as: > > > > // These are examples of possible code > > TempTbl tmptbl = new TempTbl(); > > tmptbl.connect(); > > tmptbl.readRow(); > > > > ... > > if (tmptbl.getColumn("type").isReference()) > > { > > TypesTbl typestbl = new TypesTbl(); > > tmptbl.setColumn("type", > > typestbl.getRowRef(tmptbl.getColumn("type")); > > } > > > > Am I missing something in the API? > > > > Thanks for any help! > > -- > > David A. Bartmess > > Software Configuration Manager / Sr. Software Developer > > eDingo Enterprises > > http://edingo.net > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > > > > > -- David A. Bartmess Software Configuration Manager / Sr. Software Developer eDingo Enterprises http://edingo.net