Thread: Small problem, help please?

Originally Posted by Norm

Did you look thru the code you posted a link to? The MysqlManager class definition.
Did you do a search for "conn =" in that code as I suggested back in post#8?

What do you mean, did I look through it, the MysqlManager class definition?

Also, I searched for conn = - and it found a few, but it was just conn = null;

I also found public static Connection con = null;

Notice the one N on con, and that con = null; was mentioned in a few files also.

Lots of people have had it working without going through all this, there must be an easy fix to it.

How do I give a connection a value. Why can't you just answer that

Is your code different from the code at the link you posted? When I copied the code from that site into my editor and did a Search for "conn =" I found this line:

      //conn = DriverManager.getConnection("jdbc:mysql://riotscape.com/riot_forum", "riot_forum", "ryan16");

That looks like the syntax for creating the object you need.

Yes, I have that line.

It's // commented out, so is that why it's not working? o.O

I've just looked at another tutorial thread, and I found this.

	public synchronized static void createKillDeathConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
				conn = DriverManager.getConnection("jdbc:mysql://ADDRESS:3306/DATABASE","USERNAME","PASSWORD");
			statement = conn.createStatement();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

This uses conn = and the DriverManager part isn't commented out.

It's // commented out, so is that why it's not working

The commented out part should NOT have stopped you Searching the file and finding the line the same way that I did it. Since you did not post that line I can only assume that your code is NOT the same as the code at the site that you posted a link to.
I have no idea why that line is commented out. Ask the person that wrote the code or read the page where the code is posted.
It does appear to give the needed syntax for creating a Connection object.

I found it, but because it was already commented out, I presumed that it was un-needed.
My code is the same, just I assumed it wasn't needed as I wasn't aware that was what created the syntax for the connection, I'm trying it now, will post back with results in a sec.

That didn't work. I've just been reading and it said a lot of people were having troubles with that tutorial, so I'm going to remove it and put a new one I have found in its place, I'll let you know how it goes.

your problems is that u need to create a object to connect to the data base. it should look something like this

Connection conn = DriverManager.getConnection ("jdbc:mysql://where database is","userName of database","password");

the con variable should look something like this

Connection con = DriverManager.getConnection ("jdbc:mysql://localhost/database name","user name for database","password");