Netbeans Module deployment fails - cannot cast BigInteger Into Long

Question

I'm trying to create a Java Server CRUD application for a MySQL database in Netbeans as demonstrated here:

https://netbeans.org/kb/docs/web/jsf20-crud.html

but this is the error I get:

In-place deployment at

C:\Users\john\Documents\Java Practice\CustomerService\build\web GlassFish Server 4.1.1, deploy, null, false

C:\Users\john\Documents\Java Practice\CustomerService\nbproject\build-impl.xml:1048: The module has not been deployed.

Looking at the Glassfish server log I see:

java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

My current connection uses the Connector/J 8.0.20.jar driver located at C:\Program Files (x86)\MySQL\Connector J 8.0.20\mysql-connector-java-8.0.20.jar. The admin properties are:

Path/URL to admin tool:

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin.exe

Path to start command:

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe

Path to stop command:

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin.exe

Is this a compatibility issue? Any help would be greatly appreciated, thanks!