

Private connectToMysql login //to open the connection to the database string variables for holding the user name and pwd, collected from command line initially but later from a GUI login. String readPWD = new String("anonymous") //readCLI.nextLine() //get the next line of CLI data and pass to the new variable.ĬonnectSQL SQL = new ConnectSQL(readName, readPWD) String readName = new String("MyoGroup") //readCLI.nextLine() //read the CLI into the variable. ("please enter user name") //will be used to get the details from a GUI eventually Scanner readCLI = new Scanner(System.in) a scanner to read the data in from the cli Public static void main(String args) throws SQLException The program will compile fine, I have confirmed that the connector is available in netbeans in the section and that it is located in the correct place etc etc. I have tried all the obvious things from this and other forums.Įnsured that the path to the program is in both fields for path and classpath. C:\Program Files\Java\jre1.5.0_06\lib\ext\QTJava.zip C:\Sun\ConnectorJ\mysql-connector-java-5.1.7\mysql-connector-java-5.1.7-bin.jar F:\Devel\Wachabe\GetMySQLUsers Path=C:\Sun\SDK\bin F:\Devel\Wachabe\GetMySQLUsers C:\Sun\ConnectorJ\mysql-connector-java-5.1.7\mysql-connector-java-5.1.7-bin.jarĬlasspath=. My environment variables are: (copy and paste from the env variables in XP Pro) I keep getting an error for the class not found exception - as in above title of post. I'm trying to connect to a mysql dbqse (ver 6.0) via a little Java progy using JDK6 and all upto date JRE etc:

1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
