Solved

What does this error means?

Posted on 2006-07-20
17
245 Views
Last Modified: 2010-03-31
This is my code to access an MS-ACCESS database in java

private static boolean prepareStationCodeNameTable(){
        Statement stmt; // SQL statement object
        String query;   // SQL select string
        ResultSet rs;   // SQL query results

        ArrayList contentTypes = new ArrayList();
        query = "SELECT st-code, st-name from station";
       
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(query);
            while(rs.next()){
                stationCodeMap.put(rs.getString("st-code"),rs.getString("st-name"));
            }
            System.out.println("--- Prepared Station Code and Name Map. Total Records are : " + stationCodeMap.size());
            return true;
        }catch(SQLException ex){
            ex.printStackTrace();
        }
        return false;
    }


BUT i am getting this error:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
      at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
      at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3065)
      at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
      at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
      at Import.prepareStationCodeNameTable(Import.java:295)
      at Import.main(Import.java:59)
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
      at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
      at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
      at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3065)
      at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
      at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
      at Import.prepareMentorHorizonTable(Import.java:317)
      at Import.main(Import.java:65)


any clue?
0
Comment
Question by:jaipur07
  • 6
  • 3
  • 2
  • +2
17 Comments
 
LVL 35

Accepted Solution

by:
girionis earned 168 total points
Comment Utility
It means that your SELECT statement is not syntactically correct. It is posible that the ODBC bridge does not support all the SQL statements.
0
 

Author Comment

by:jaipur07
Comment Utility
whats wrong in this select statement? you see it in my post?
0
 
LVL 35

Expert Comment

by:girionis
Comment Utility
> SELECT st-code, st-name from station

Make sure that you refer to the proper variables and tables in the database.
0
 

Author Comment

by:jaipur07
Comment Utility
of course I am there are only 2 fields in this table and i am accesing both
0
 
LVL 35

Expert Comment

by:girionis
Comment Utility
DO the "st-code" and "st-name" exist in the table "station"? Does the table station exist? Also, not sure if it helps, but what happens if you take the minus signs off the table names?
0
 
LVL 8

Expert Comment

by:hiteshgupta1
Comment Utility
>>    query = "SELECT st-code, st-name from station";
is ur table name correct??
Can u use  try and catch to know which block is creating error?
0
 
LVL 4

Assisted Solution

by:astorer
astorer earned 166 total points
Comment Utility
Is "st-code" a valid column name in SQL?  I think it is not.  

the "-" is bad.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 8

Expert Comment

by:hiteshgupta1
Comment Utility
ohhhh
u r already using try and catch!!
0
 
LVL 35

Expert Comment

by:girionis
Comment Utility
Also check if the path of the database you are accessing contains a dot (".").

http://support.microsoft.com/kb/171899/
0
 

Author Comment

by:jaipur07
Comment Utility
i tried select * from station
and then i am getting values like

String code = rs.getString("st-code");

working fine nowwww
0
 
LVL 35

Expert Comment

by:girionis
Comment Utility
This SELECT st-code, st-name from station should also work.
0
 
LVL 92

Assisted Solution

by:objects
objects earned 166 total points
Comment Utility
try:

        query = "SELECT [st-code], [st-name] from station";
0
 
LVL 4

Expert Comment

by:astorer
Comment Utility
> SELECT st-code, st-name from station should also work.

No it shouldn't in standard SQL.  What you are asking for is values for
  st minus code
  st minus name

Access may allow you to define such column names but grown up databases would not.
0
 
LVL 35

Expert Comment

by:girionis
Comment Utility
If they are defined I cannot see why they cannot be accessed. If they are not to be accessed then why does a databaselet you define them?
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
commonTwo  challenge 63 98
factorial example challenge 10 59
wordlen challenge 3 45
solarwind tftp server 2 29
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now