Database not being populated....

[System_Error]

I have the datasoure and drivers set up, but for some reason this code is not updating the database.

import java.sql.*;

public class TestCreateCoffeeTable
{
	public TestCreateCoffeeTable()
	{
	}
	public static void main(String[] args)
	{
	   try
	   {
		String createStatement;
		
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		
		String dataSource = "jdbc:odbc:Coffeebreak";
		
		Connection con = DriverManager.getConnection(dataSource);
		
		Statement statement1 = con.createStatement();
		
		String insert;
		
		//add the info
		insert = "INSERT INTO Coffeebreak VALUES( 'Bob', 24, 23)";
		
		statement1.executeUpdate(insert);
		
	   }
	   catch(ClassNotFoundException cnfe)
	   {
		   System.err.println(cnfe);
	   }
	   catch(SQLException sqle)
	   {
		   System.err.println(sqle);
	   }
	   catch(Exception e)
	   {
		   System.err.println(e);
	   }
	}
}

I'm sure that the problem has to be with what's in bold, but it looks right...
I do have the code that created the table if you need that. It created three columns, Name, ID_NUM, and Pay...But none of those are being populated.

[Dillinger4]

Im not sure if your datasource is right. Im pretty sure you have to follow a pattern like the following jdbc:<subprotocol>://hostnameort/subsubname
but in your case im not too sure because i notice that you are using the jdbcdbc bridge and not the MySql JConnector which i use.

[CornedBee]

Whatever comes after the subprotocol is entirely up to the subprotocol handler. MySQL requires the URL. ODBC requires an ODBC connection string. Oracle requires something really weird. Etc...

Have you tested the return value of executeUpdate()? Have you checked Connection.getWarnings()?

[System_Error]

When I created the table through code, I accidently put the data types after the name of the field. I also changed the statement to this:

 createStatement = "CREATE TABLE Coffeebreak(Name String PRIMARY KEY, " +
		 			"int ID_NUM, int Pay)";

It did populate the database, but it still throws the sql exception...


Dillenger, what is this sql JConnector?

[Dillinger4]

JConnector is just the offical driver for MySql. What backend are you using? Sounds like Access.

[CornedBee]

Something's still not right with that create table statement. In the first column, you have the field name first, in the other columns the type.
According to the MySQL docs, the name must come first. And I don't think Access deviates that strongly from standard SQL.

http://dev.mysql.com/doc/mysql/en/create-table.html

[System_Error]

for some reason, when I put String infront of name, I get an sql exception saying syntax error in field definition...When I had the data type after, it just threw a sql exception saying general error...?

[CornedBee]

Well, I don't have an Access SQL reference at hand. I found this:
http://msdn.microsoft.com/library/de.../acfundsql.asp
But it's more of a tutorial. The reference is supposed to come with Access.

Are you sure String is a valid data type? It's not a standard SQL type, anyway.

[System_Error]

I don't think that String is a standard type...I looked at one of my books, and for each String field they had, they just declared the field name and had this after it: VARCHAR(30)......I tried putting this after the fieldname, but it still had the same error...In the book they also had the datatype after the fieldname(which doesn't make much sense, but it's suppose to work that way)

[Dillinger4]

String is not a datatype in MySql you have to use varchar()

create table employee(
 empfname varchar(25),
 emplname varchar(30),
);

[Dillinger4]

This might help you instead of looking through the documentation of your specific database. I know MySql's doc are extremely long.

http://www.functionx.com/sql/index.htm

[System_Error]

Thanks dillenger, I'll check that website out..Glad you pointed it out too, because it's going to come in handy later.