Thread: variable not found: database name

variable not found: database name

From
weinstei@nova.edu (Jerry)
Date:
My configuration is as follows.
I have a Linux MySQL server database on one box and
I want to connect to it from a local Windows XP laptop.
My application was developed using SunOneStudio.
I have registered the DSN and tested the database connection via ODBC
in Windows XP.
It apparently connects from XP to the server.


I have compiled two base classes and have a tester class which
compiles except for the following compiler error:


PathTesterOne.java [19:1] cannot resolve symbol
symbol : variable patholog
location: class PathTesterOne
Connection c = patholog.initialize();

"patholog" is the Database Name on the Linux MYSQL server.
the initialize method looks like this....


// establish the database connection
public static void initialize()
{
aMenu = new MainMenu();
try
{ // load the jdbc - odbc bridge driver for Windows
Class.forName("com.mysql.jdbc.Driver");

// create connection instance
aConnection = DriverManager.getConnection(url, "username",
"password");
// create statement object instance for this connection
aStatement = aConnection.createStatement();
}
catch (ClassNotFoundException e)
{System.out.println(e);}
catch (SQLException e)
{ System.out.println(e); }
}

// The Data Source name is "patholog"
static String url = ("jdbc:mysql://192.168.1.101/test?user=jerald&password=wein3150");
static Connection aConnection;
static Statement aStatement;

Why am I not able to connect to the database?

I am not understanding what the source of the error may be.

Thanks for any help