Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool

by

According to the following JIRA tickets:

this is still an unresolved issue. Even though we can expect such things since Oracle abandoned a commercial support for Glassfish, it is still horrible that such basic functionality does not work.

However, if you are really desperate, there is a very nasty workaround. Glassfish arrives with a predefined JDBC pool DerbyPool that you probably won’t need, unless you are dealing with Java DB. Feel free to edit it by changing Datasource classname to com.mysql.jdbc.jdbc2.optional.MysqlDataSource and adjusting additional properties to point on MySQL Server instance. Prior to doing this hack, make sure that you put MySQL connector to the Glassfish’s lib folder.

UPDATE

Just noticed that there is a Glassfish version that has been patched, it is called Payara and available for download here. According to the documentation, it is a GlassFish 4.1 clone, patched and further developed by the community.

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. Multiple queries executed in java in single statement
  4. Java: Insert multiple rows into MySQL with PreparedStatement
  5. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  6. Handling MySQL datetimes and timestamps in Java
  7. MySQL and JDBC with rewriteBatchedStatements=true
  8. Closing JDBC Connections in Pool
  9. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  10. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  11. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  12. Returning a ResultSet
  13. How to change MySQL timezone in a database connection using Java?
  14. How to configure Tomcat to connect with MySQL
  15. Retrieve an Image stored as BLOB on a MYSQL DB
  16. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. mysql prepared statement error: MySQLSyntaxErrorException
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. How to correctly write UTF-8 strings into MySQL through JDBC interface
  23. java.sql.SQLException: Before start of result set [duplicate]
  24. How to use prepared statement for select query in Java?
  25. Stumped SQL Exception for JDBC
  26. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. A persistent connection with JDBC to MySQL
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment