...
Understanding JDBC Errors
| Error Messages | Causes And Solutions |
|---|---|
| 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\joget.log file. | |
| 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: ..... | The property SQL SELECT Query is incorrect. Do also check the SQL lower or upper case spelling on table and column names, especially if you are running a database on a Linux OS which is case sensitive. |
| ERROR org.joget.plugin.enterprise.JdbcLoadBinder - java.sql.SQLException: Could not set parameter at position 1 (values was '?') Query - conn:506(M) - SELECT * FROM app_fd_table WHERE id = "?" | Do not enclosed the ? in single or double quotation marks. Correct syntax is ? :SELECT * FROM app_fd_table WHERE id = ? |
ERROR org.joget.tutorial.JdbcOptionsBinder - com.microsoft.sqlserver.jdbc.SQLServerException: | DB error on JDBC Options with "Field ID to control available options based on Grouping". You can only pass one ? parameter in the SQL. |
Related JDBC Binders
...