Hey guys,
Been trying for the last couple of hours trying to connect to mysql database with no luck. I have the port number right but it is still not connecting. Heres the code:
This then brings up a user screen but when I click log in (no matter what I put in the text fields) I get this
ant -f C:\\Users\\Paul17\\Documents\\NetBeansProjects\\LibraryApplicationProject jfxsa-run
init:
Deleting: C:\Users\Paul17\Documents\NetBeansProjects\LibraryApplicationProject\build\built-jar.properties
deps-jar:
Updating property file: C:\Users\Paul17\Documents\NetBeansProjects\LibraryApplicationProject\build\built-jar.properties
Compiling 1 source file to C:\Users\Paul17\Documents\NetBeansProjects\LibraryApplicationProject\build\classes
compile:
Detected JavaFX Ant API version 1.3
Launching <fx:jar> task from C:\Program Files\Java\jdk1.8.0_25\jre\..\lib\ant-javafx.jar
Warning: From JDK7u25 the Codebase manifest attribute should be used to restrict JAR repurposing.
Please set manifest.custom.codebase property to override the current default non-secure value '*'.
Launching <fx:deploy> task from C:\Program Files\Java\jdk1.8.0_25\jre\..\lib\ant-javafx.jar
jfx-deployment-script:
jfx-deployment:
jar:
Copying 12 files to C:\Users\Paul17\Documents\NetBeansProjects\LibraryApplicationProject\dist\run1191448749
jfx-project-run:
Executing C:\Users\Paul17\Documents\NetBeansProjects\LibraryApplicationProject\dist\run1191448749\LibraryApplicationProject.jar using platform C:\Program Files\Java\jdk1.8.0_25\jre/bin/java
SELECT * FROM student WHERE USERID= '' AND PASSWORD= ''
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3307/student
Deleting directory C:\Users\Paul17\Documents\NetBeansProjects\LibraryApplicationProject\dist\run1191448749
jfxsa-run:
BUILD SUCCESSFUL (total time: 6 seconds)
I have added a screen shot of the mysql databases view in netbeans.
Any help would be greatly appreciated.
Thank you.