This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: 63348

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

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: mysql enum to java string
It's not a secret anymore!