I have used:
CREATE TABLE T1 (A VARCHAR(10) NOT NULL DEFAULT 'abc');
after I have used:
DatabaseMetaData md = connection.getMetaData();
ResultSet rs = dbmd.getColumns(null, null, tableName, null);
while(rs.next()){
Syste.out.println("name ="+rs.getString("COLUMN_NAME"));
Syste.out.println("def ="+rs.getString("COLUMN_DEF"));
Syste.out.println("nullable ="+rs.getString("IS_NULLABLE"));
}
out:
name =A
def =null
nullable =YES
Where is the error?
How I can to use the NOT NULL and DEFAULT ?
|
>How I can to use the NOT NULL and DEFAULT ?
In old package, DEFAULT was supported, but NOT NULL wan't. Both of them weren't showed in DatabaseMetaData.The latest package has supported NOT NULL and DEFAULT for DatabaseMetaData.getColumn. You can download it after 24 hours.
|
ok,
but with my password i can not go in download area.
This is my Order number: 91601415
and this is my register email:
ezio.defilippis@dataprocess.it.
Thank you
Ezio
|
A new password should have sent to your mailbox.
|
"A new password should have sent to your mailbox."
Thank you.
But I have not recived the new password
ezio.defilippis@dataprocess.it or
eziodef@libero.it
|