File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

column default value

shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
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.
shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
no replies yet
I agree. Here's the link:
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