MirecXP
asked on
JDBC: Metadata about column
Hi.
I'm trying to recreate table definition from any DBMS.
Does anybody know how to dynamically detect if column definition has to contain any parameters ?
example:
column of type VARCHAR2 in Oracle DBMS must have parameter "max.length", but column of type INT in MS SQL Server is parameterless..
I've tried to use DatabaseMetaData.getTypeIn fo. It returns CREATE_PARAMS info about data type, but it seems it's not working as I think it would.
I do not have detailed description of MetaData functions except API, but there it isn't described in detail.
Regards.
I'm trying to recreate table definition from any DBMS.
Does anybody know how to dynamically detect if column definition has to contain any parameters ?
example:
column of type VARCHAR2 in Oracle DBMS must have parameter "max.length", but column of type INT in MS SQL Server is parameterless..
I've tried to use DatabaseMetaData.getTypeIn
I do not have detailed description of MetaData functions except API, but there it isn't described in detail.
Regards.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- points to heyhey_
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
girionis
Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
- points to heyhey_
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
girionis
Cleanup Volunteer
ASKER
I silently guessed that too.