Link to home
Start Free TrialLog in
Avatar of MirecXP
MirecXPFlag for Slovakia

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.getTypeInfo. 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.
ASKER CERTIFIED SOLUTION
Avatar of heyhey_
heyhey_

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MirecXP

ASKER

When YOU say so, it's bad.

I silently guessed that too.

Avatar of girionis
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