Solved

JDBC: Metadata about column

Posted on 2002-05-08
4
277 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
topping3 challenge 14 80
firstswap challenge 20 77
object oriented programming comparison 5 71
Error in @AspectJ Based AOP with Spring 2 13
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 …
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

770 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