Java variable for db not found

[Jerry]

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

[John Bell]

Hi

This is not a SQL Server question! I would check out any documentation for
the JDBC driver and hopefully there will be an example similar to your
configuration.

John

"Jerry" <we******@nova.edu> wrote in message
news:69**************************@posting.google.c om...

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