Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Error MessageCause and solution
Message on screen: Record  Record cannot be foundThere 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 on table and column names, especially if you are running a database on the Linux operating system (a Linux OS which is case sensitive).










Related JDBC Binders

...