File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes mysql enum to java string Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » Servlets
Reply locked New topic

mysql enum to java string

nitin kumar

Joined: Feb 11, 2004
Posts: 6
Hi all,

Please can anyone help for the following problem.
I am using mysql as database and want to retrieve values from a table which have enum as one of the columns.
when I get the value in the resultset and try to store it in a string, the value returned by the rs.getString(<column-name> is null.

how should I convert the enum value of mysql to java string ?
mysql docs says that the queries for enum returns string object.

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63548

Please do not cross-post the same question in multiple forums. Continue any discussion here.

[Asking smart questions] [About Bear] [Books by Bear]
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: mysql enum to java string
It's not a secret anymore!