| re: Java variable for db not found
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" <weinstei@nova.edu> wrote in message
news:69fca47c.0308261630.5f62eb80@posting.google.c om...[color=blue]
> 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 =[/color]
("jdbc:mysql://192.168.1.101/test?user=jerald&password=wein3150");[color=blue]
> 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[/color]
| 
