File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes MetaData question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MetaData question" Watch "MetaData question" New topic
Author

MetaData question

Melinda Savoy
Ranch Hand

Joined: Jun 21, 2005
Posts: 386

In the code below I am trying to acquire the COLUMN DATA TYPE from the meta data resultset. This database resides on an M204 database and I have a schema print out from the DBA whereby the mainframe fields are mapped to a sql-column-name. Each has a particular datatype such as INTEGER, CHAR(1), CHAR(30), FLOAT(21), etc. However in the highlighted code I am getting a blank for the column type and not the actual datatype. It would appear that the datatype is blank but on the database it would not appear so.

If anyone has a suggestion or can give me some direction or point out what I'm doing wrong it would be appreciated. Thank you.

Here is my code:



[ December 28, 2005: Message edited by: Melinda Savoy ]
[ December 28, 2005: Message edited by: Melinda Savoy ]
Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
I would work with getColumnType instead...


There is no emoticon for what I am feeling!
Melinda Savoy
Ranch Hand

Joined: Jun 21, 2005
Posts: 386

Jeff,

Thanks for the reply. That is exactly what I had to do. I wish I knew why the column data type name was an issue.

Thanks again for your response.

Regards.
Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
Originally posted by Melinda Savoy:
I wish I knew why the column data type name was an issue.


It just smelled a bit too vendor-specific to me. Didn't think the method would return nothing, though...
 
 
subject: MetaData question
 
Similar Threads
Help needed on SQL Server Error
SQL Server Connection question
upgrading UTF data from mysql 4.0 to 4.1 script
Passing values into the SQL connection class?
Error java util NoSuchElementException