File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Column name too wide Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Column name too wide" Watch "Column name too wide" New topic

Column name too wide

Mel Calvin

Joined: Sep 11, 2007
Posts: 9
If I have a sql query that looks like this:

and result is returned as a collection of dynabeans. When I want to retrieve the data from the updated_date column I need to write like this:

with the "column name" truncated down to 32 chars, else it won't work. Now, this isn't an elegant solution. Anyone have better solution for this?

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Could you not alias the columns in your result set? i.e.:

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Mel Calvin

Joined: Sep 11, 2007
Posts: 9
Aah.. I knew there was a SQL-side solution to this. My SQL skills are limited, thanks for the help!
I agree. Here's the link:
subject: Column name too wide
It's not a secret anymore!