When working in Netbeans Visual Web Pack, you can add new JDBC drivers and database connections from the Runtime window. You can even test the connections and view data from the tables once the connection is made.
However, if you add that data connection to your project, you will run into an interesting problem. Netbeans does not copy the JDBC drivers to the deployment server by itself. Java Studio Creator users will be expecting this to happen for them.
Here is a quick way to get this to work in your project when deployed
Right-click on the project name in the Project window and select Properties
When the properties dialog opens, select the Library node and then click on the Add JAR/Folder button. Navigate to the locate of the JDBC .jar file and select it.
Click Open. Make sure the driver library has a check mark in the package box and then click on the OK button.
You should now be able to deploy the application without the DB connect errors.