Benjamin Confino
Reputation: 2364
how to access a mySQL enum field with Java ResultSet and PreparedStatement
Quick question what's the correct way to use ResultSet and PreparedStatement to access an ENUM field in MySQL?
Upvotes: 3
Views: 5982
Answers (1)
user85421
Reputation: 29680
never did but I would use String, see the documentation:
21.4.4.3. Java, JDBC and MySQL Types
Upvotes: 3
Related Questions
- Java: How to get an enum value to a string?
- Saving and reading the enum value to the database with jdbc?
- Update ENUM value with PreparedStatement java PostgreSQL
- Java enum in mysql
- possible to get mysql enum filed's index value in java?
- Java enum to mysql enum in prepared statement
- how do I show all enum values from database in Java
- How to work with ENUM types in sql with java
- Using a PreparedStatement to persist an array of Java Enums to an array of Postgres Enums
- List MySQL enum in Java