File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes column default value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "column default value" Watch "column default value" New topic
Author

column default value

shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
hi,
I want to get all the columns' default value of a table.How do i proceed?I tried using DatabaseMetaData.getColumns(), but the column in the result set returned i.e. COLUMN_DEF is not to be found. An SQL exception is being thrown saying column not found.
Could anyone explain the parametes to be passed, i tried using all possible combinations, but still could not get COLUMN_DEF.
a code example will help a lot.This is very urgent for me.
Thanx in advance.
shanks.
shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
no replies yet
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: column default value
 
Similar Threads
Selected columns
MetaData Incomplete?
How to get XMLType column value from Oracle using JDBC ?
reading default value of a column
Hibernate parent/child and foreign key relationships mapping