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
Solved

JDBC: Metadata about column

Posted on 2002-05-08
4
280 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
4 Comments
 
LVL 16

Accepted Solution

by:
heyhey_ earned 200 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySqlDump not dumping triggers 1 43
hibernate example using maven 12 56
runtime exception 2 41
jsp login check 12 42
After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

789 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