run in my PC: Type 1 db driver Access / java[SE1.6] Desktop Applications, what I need

[lse123]

paphoscarhire.mobi/odbc-bridge2.jpg
desktop control panel settings, I have above URL (IMG) Settings
well, I need to run in my PC: Type 1 db driver Access / java[SE1.6] Desktop Applications, what I need to install ?

I refer for Type 1, JDBC-ODBC Bridge driver.... Is it needed install and Access 2003 ODBC driver (see URL) ...? How I understand if I already installed it(?) since I do not know ?

How to load driver in my program ? The below are correct for: Class.forName & DriverManager.getConnection ?

 class  ResultSetDemo    {
  public static void main (String  [ ] args)    {
    try {
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       Connection conn
          =DriverManager.getConnection("jdbc:odbc:RedWines");  // DSN=RedWines
       Statement  sttmnt  =  conn.createStatement (  );

I GET ERROR !

 C:\Users\User\Documents\TextBooks Data Files\The Web Warrior Guide to Web Database Technolo
gies, 1st Edition\extract\Chapter06\Chapter>java ResultSetDemo
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM claus
e.
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
        at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
        at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
        at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
        at ResultSetDemo.main(ResultSetDemo.java:10)


C:\Users\User\Documents\TextBooks Data Files\The Web Warrior Guide to Web Database Technolo
gies, 1st Edition\extract\Chapter06\Chapter>

[Eranga]

What you've on line 10 in ResultSetDemo class?

ResultSetDemo.main(ResultSetDemo.java:10)

[Tolls]

At a guess, got the SQL query wrong?

[lse123]

import java.sql.*;

class ResultSetDemo {
public static void main (String [ ] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn
=DriverManager.getConnection("jdbc:odbc:RedWines") ;
Statement sttmnt = conn.createStatement ( ); // line 9
ResultSet rs = sttmnt.executeQuery("SELECT * FROM WINES"
+ "WHERE COLOR_WINE = 'Red' ");

while (rs.next ( ) ) {
String name = rs.getString("NAME_WINE");
int on_hand = rs.getInt("ON_HAND");
System.out.println(name + " " + on_hand);
} // end of while loop
sttmnt.close ( );
conn.close ( );
} catch (Exception err) {
System.out.println (err.getMessage( ) );
err.printStackTrace( ) ;
} // end of catch block
} // end of method main
} // end of class

[Tolls]

As I suspected...

This:

       ResultSet rs = sttmnt.executeQuery("SELECT  * FROM WINES"
         + "WHERE COLOR_WINE  =   'Red' ");

will result in this as your SQL statement:
SELECT * FROM WINESWHERE COLOR_WINE = 'Red'

Can you see the problem?

[Eranga]

I don't think still he/she got the point. Actually if OP reads the error message he/she got able to find the solution him/her self. Anyway, we'll see the comment here, still no any response.

[Tolls]

No response over on the Sun forums either...a thank you would have been nice.

[Eranga]

So this is cross-posted then. Why people really doing this. What happen is found the answer from one forum and sometimes no response on others, or post some comments that found the solution them self. I found such instance in many cases.