Setting the REMARKS
From: Bill Dennis (wjdennis_at_rmi.net)
Date: 04/27/04
- Previous message: Bush will disarm all workers next: "Applet ocijdbc9 error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 27 Apr 2004 11:23:33 -0700
Is it possible to programmatically set the column description
(REMARKS) of a Microsoft Acess table column from Java? On DB2, for
example, we use COMMENT ON (SOMECOLUMN IS 'SomeText'), but in
Microsoft Access, this throws an SQLException.
Our real goal in this is trying to determine if a column is nullable
or not. Unfortunately, neither the IS_NULLABLE nor NULLABLE columns
from the DatabaseMetaData.getColumns() method is valid: they ALWAYS
say a column is nullable, whether it is or not.
To get around the problem, we've started coding a REMARKS of
"<Required>" on the columns that aren't nullable. This actually works
fine. But our problem now is that we sometimes have to create a table
programatically and want to set the comments from within the Java
program.
Any help would be appreciated.
Bill Dennis
- Previous message: Bush will disarm all workers next: "Applet ocijdbc9 error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
