...
Understanding JDBC Errors In joget.log
| Error Message | Cause and solution |
|---|---|
| Message on screen: Record cannot be found | There is a JDBC configuration error. Check the joget.log file for more information. |
| The rest of the error messages below are found in the "\apache-tomcat-x.x.xx\logs\" folder. | |
| ERROR org.joget.plugin.enterprise.JdbcLoadBinder - org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class | The property Custom JDBC Driver is incorrect |
| ERROR org.joget.plugin.enterprise.JdbcLoadBinder - org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not connect to address=(host=localhost)(port=3306)(type=master) : Socket fail to connect to host:localhost, port:3306. Connection refused: connect) | The property Custom JDBC URL is incorrect |
| ERROR org.joget.plugin.enterprise.JdbcLoadBinder - org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not connect to address=(host=localhost)(port=3307)(type=master) : Access denied for user 'xxxx'@'localhost' (using password: YES) | The property Custom JDBC Username or Custom JDBC Password is incorrect. |
| ERROR org.joget.plugin.enterprise.JdbcLoadBinder - java.sql.SQLSyntaxErrorException: (conn=376) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 | The property SQL SELECT Query is incorrect. Do also check the SQL lower or upper case spelling, especially if you are running a database on the Linux operating system (case sensitive). |
Related JDBC Binders
...