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