Java: connecting to mysql [Unsolved]

[Raghavan Chockalingam]

I earlier tried to connect to mysql from JSP it failed so now I am trying to connect from Java but here is the error it comes up with...

 
 
C:\java\Trial>javac createtable.java
createtable.java:8: cannot find symbol
symbol  : method DriverManager(java.lang.String)
location: class CreateTable
                        con = DriverManager("jdbc:mysql://localhost/new_db?user=root&pass
word=demoPassword");
                              ^
createtable.java:9: cannot find symbol
symbol  : method createConnection()
location: interface java.sql.Connection
                        Statement stmt = con.createConnection();
                                            ^
2 errors

Here is the program ...

 
import java.sql.*;
 
public class CreateTable{
public static void main (String args[]){
Connection con = null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager("jdbc:mysql://localhost/new_db?user=root&password=demoPassword");
Statement stmt = con.createConnection();
}catch(SQLException e){
System.out.println(e.toString());
}
}
}
 

[ January 03, 2006: Message edited by: Raghavan Chockalingam ]

[Michael Duffy]

Originally posted by Raghavan Chockalingam:
I earlier tried to connect to mysql from JSP it failed so now I am trying to connect from Java but here is the error it comes up with...

 
 
C:\java\Trial>javac createtable.java
createtable.java:8: cannot find symbol
symbol  : method DriverManager(java.lang.String)
location: class CreateTable
                        con = DriverManager("jdbc:mysql://localhost/new_db?user=root&pass
word=demoPassword");
                              ^
createtable.java:9: cannot find symbol
symbol  : method createConnection()
location: interface java.sql.Connection
                        Statement stmt = con.createConnection();
                                            ^
2 errors

Here is the program ...

 
import java.sql.*;
 
public class CreateTable{
public static void main (String args[]){
Connection con = null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager("jdbc:mysql://localhost/new_db?user=root&password=demoPassword");
Statement stmt = con.createConnection();
}catch(SQLException e){
System.out.println(e.toString());
}
}
}
 

Why don't you believe the compiler when it tells you what you've done wrong?

Look at the two lines it's complaining about:

createtable.java:8: cannot find symbol
symbol : method DriverManager(java.lang.String)
location: class CreateTable
con = DriverManager("jdbc:mysql://localhost/new_db?user=root&pass
word=demoPassword");

You forgot to include the static method call:

  
con = DriverManager.getConnection("jdbc:mysql://localhost/new_db?user=root&pass
word=demoPassword");

^
createtable.java:9: cannot find symbol
symbol : method createConnection()
location: interface java.sql.Connection
Statement stmt = con.createConnection();

There is no create connection method on java.sql.Connection. However, there is a createStatement method:

  
Statement stmt = con.createStatement();

Read the error messages you get more carefully.

[Raghavan Chockalingam]

Sorry...I was tired in the morning, I did not have a close look at it...I have solved that problem now. The file compiles properly now but when it runs, it comes up with this error..

 
Exception in thread "main" java.lang.UnsupportedClassVersionError: CreateTable (Unsupport
ed major.minor version 49.0)
        at java.lang.ClassLoader.defineClass0(Native Method)
        at java.lang.ClassLoader.defineClass(Unknown Source)
        at java.security.SecureClassLoader.defineClass(Unknown Source)
        at java.net.URLClassLoader.defineClass(Unknown Source)
        at java.net.URLClassLoader.access$100(Unknown Source)
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClassInternal(Unknown Source)

Here is the file...

import java.sql.*;
 
class CreateTable{
public static void main (String args[]){
Connection con = null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = 
 
DriverManager.getConnection("jdbc:mysql://localhost/new_db?user=root&password=maximus");
Statement stmt = con.createStatement();
}catch(SQLException e){
System.out.println(e.toString());
}catch(Exception e){
System.out.println(e.toString());
}
}
}

[Jesper de Jong]

Exception in thread "main" java.lang.UnsupportedClassVersionError: CreateTable (Unsupported major.minor version 49.0)

This error means that you have compiled your source code with Java 1.5, and now you are trying to run it on an older version of Java (1.4 or older).

Do you have multiple versions of the Java runtime environment installed? Make sure you compile and run your source code with the same version.

[Raghavan Chockalingam]

As you said, I have two versions now, jdk 1.4.2 and jdk 1.5.0. Right now, the program is compiled in javac of 1.5.0 and I so far think that I am trying to run using java in 1.5.0

How can it use different version of java when i use javac of 1.5.0.
Here is the list of environment variables...

 
 
\\set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\raghavan\Application Data
classpath=.
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=RAGHAVAN
ComSpec=C:\WINDOWS\system32\cmd.exe
HOMEDRIVE=C:
HOMEPATH=\
include=C:\Program Files\Microsoft Visual Studio\VC98\atl\include;C:\Program Files\Micros
oft Visual Studio\VC98\mfc\include;C:\Program Files\Microsoft Visual Studio\VC98\include
JAVA_HOME=j:\jdk1.5.0_06
lib=C:\Program Files\Microsoft Visual Studio\VC98\mfc\lib;C:\Program Files\Microsoft Visu
al Studio\VC98\lib
LOGONSERVER=\\RAGHAVAN
MSDevDir=C:\Program Files\Microsoft Visual Studio\Common\MSDev98
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBEM;C:\PROGRAM FILES\MYSQL\MYSQL
 SERVER 4.1\BIN;C:\Program Files\Microsoft Visual Studio\Common\Tools\WinNT;C:\Program Fi
les\Microsoft Visual Studio\Common\MSDev98\Bin;C:\Program Files\Microsoft Visual Studio\C
ommon\Tools;C:\Program Files\Microsoft Visual Studio\VC98\bin;C:\jdk1.3.1_15\bin;jdk1.5.0
_09/bin;;j:/jdk1.5.0_09/bin;;jdk1.5.0_06/bin;;j:/jdk1.5.0_06/bin;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 1, AuthenticAMD
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0801
ProgramFiles=C:\Program Files
PROMPT=\\
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\raghavan\LOCALS~1\Temp
TMP=C:\DOCUME~1\raghavan\LOCALS~1\Temp
TOMCAT_HOME=j:\Tomcat 5.5
USERDOMAIN=RAGHAVAN
USERNAME=raghavan
USERPROFILE=C:\Documents and Settings\raghavan
windir=C:\WINDOWS

[ January 03, 2006: Message edited by: Raghavan Chockalingam ]

[Raghavan Chockalingam]

Recently when I tested the verions of java and javac, I found that java.exe's version is 1.4.2 and javac.exe's version is 1.5.0. I do not have a clue why this happened and I am now wondering how to make java to point to 1.5.0....

 
 
\\java -version
java version "1.4.2_08"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_08-b03)
Java HotSpot(TM) Client VM (build 1.4.2_08-b03, mixed mode)
 
\\javac -version
javac 1.5.0_06
javac: no source files
Usage: javac <options> <source files>
where possible options include:

[Jeanne Boyarsky]

Raghavan,
It is getting Java 1.4 from somewhere on the PATH.

It is likely that another application is pointing to Java 1.4. You can search for java.exe one the hard drive to try and determine which one. Note that you also have Java 1.3 on that path.

[David O'Meara]

You probably have a JRE first on your system path. If you had 'which' installed you could diagnose the problem easily. I'd edit the path and pace a single java entry first and remove the rest.

[Raghavan Chockalingam]

guys, I have put new path in place but still java.exe points to 1.4.2

  
 
//path
PATH=C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBEM;C:\PROGRAM FILES\MYSQL\MYSQ SERVER 4.1\BIN;C:\Program ;j:/jdk1.5.0_06/bin/java.exe;j:/jdk1.5.0_06/bin/javac.exe;j:/
dk1.5.0_06/bin
 
//java -version
java version "1.4.2_08"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_08-b03)
Java HotSpot(TM) Client VM (build 1.4.2_08-b03, mixed mode)

[David O'Meara]

in a command prompt, type this in:

SET PATH=j:\jdk1.5.0_06\bin\;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBEM;C:\PROGRAM FILES\MYSQL\MYSQ SERVER 4.1\BIN;C:\Program

then test java -version
Hopefully (by placing it first) you will make sure it uses the version you want in preference to anything else lying around.

Dave

[EDIT - I just realised you had your '\' slashes the wrong way.]
[ January 04, 2006: Message edited by: David O'Meara ]

[Raghavan Chockalingam]

Pls look at the post below as I taking this as a separate issue
http://www.coderanch.com/t/401934/java/java/java-javac-exes-running-different
Thanks for your support...

[s wei]

Originally posted by Raghavan Chockalingam:
I earlier tried to connect to mysql from JSP it failed so now I am trying to connect from Java but here is the error it comes up with...

 
 
C:\java\Trial>javac createtable.java
createtable.java:8: cannot find symbol
symbol  : method DriverManager(java.lang.String)
location: class CreateTable
                        con = DriverManager("jdbc:mysql://localhost/new_db?user=root&pass
word=demoPassword");
                              ^
createtable.java:9: cannot find symbol
symbol  : method createConnection()
location: interface java.sql.Connection
                        Statement stmt = con.createConnection();
                                            ^
2 errors

Here is the program ...

 
import java.sql.*;
 
public class CreateTable{
public static void main (String args[]){
Connection con = null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager("jdbc:mysql://localhost/new_db?user=root&password=demoPassword");
Statement stmt = con.createConnection();
}catch(SQLException e){
System.out.println(e.toString());
}
}
}
 

[ January 03, 2006: Message edited by: Raghavan Chockalingam ]

[s wei]

Originally posted by s wei:

 
 Are you sure you connect to the 3306 port of the server MySQL?
 

[Maximilian Xavier Stocker]

You already had this same problem in this very thread?!? There is no method called createConnection in java.sql.Connection. Based on the rest of your code you mean to use createStatement.