?
Solved

JDBC: Metadata about column

Posted on 2002-05-08
4
Medium Priority
?
296 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:MirecXP
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 16

Accepted Solution

by:
heyhey_ earned 800 total points
ID: 6998246
I think that there isn't database independent solution.
0
 
LVL 1

Author Comment

by:MirecXP
ID: 6998327
When YOU say so, it's bad.

I silently guessed that too.

0
 
LVL 35

Expert Comment

by:girionis
ID: 8741029
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
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
This video teaches viewers about errors in exception handling.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question