How to discern a reference column from within java??

Поиск
Список
Период
Сортировка
Искать

How to discern a reference column from within java??

От:
"David A. Bartmess" <dingodave@edingo.net>
Дата:

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

Re: How to discern a reference column from within java??

От:
Dave Cramer <Dave@micro-automation.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
> 
>

Re: How to discern a reference column from within java??

От:
"David A. Bartmess" <dingodave@edingo.net>
Дата:
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
FAQ