Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

variable not found: database name



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group