JDBC MSACCESS

[fux]

Hi,

I get the following Exception, while selecting MS-Access with a wildcard
in the where-clause.
When working with he exact name as in commented line above it works.
What is wrong?

Thank you

output:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Ungültiger
Cursor-Zustand
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:1902)
at
sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:1774)

at
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:185)
at
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:241)
at ConnectNord.main(ConnectNord.java:21)

java-program:

import java.sql.*;
import java.util.Properties;
import java.io.InputStream;

public class ConnectNord {
public static void main (String args[]) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (Exception e) {
System.out.println("Failed to load JDBC/ODBC driver.");
return;
}
try {
Connection con = DriverManager.getConnection("jdbc:odbc:MS Access
97-Datenbank", "", "");
Statement stmt = con.createStatement ();
//String kunde="Alfreds Futterkiste";
String kunde="Alfreds*";
String qu="SELECT Firma FROM Kunden where Firma like \'"+kunde+"\'";
System.out.println(qu);
ResultSet rs = stmt.executeQuery (qu);
rs.next();
String str=rs.getString("Firma");
System.out.println("Name: "+str+"\n");
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}

[James Olsen]

Try substituting the * with a % - I know MSAccess uses * as wildcard but the
% is standard SQL and your driver could be interperting it wrongly.

Just something you can try out - I don't know if it'll work
fux <fu...@usa.net> wrote in message news:38BD5940...@usa.net...

> file://String kunde="Alfreds Futterkiste";

[Kevin Ryan]

Please see:

http://search.java.sun.com/query.html?qt=%2Bjdbc+%2B%22invalid+cursor+state%22+&col=obug&qp=&qs=&qc=&pw=100%25&ws=0&qm=0&st=1&nh=10&lk=1&rf=0&rq=0

[Kevin Ryan]

Sorry, I realized after posting a reply that I probably totally mis-read
the question. Actually, I'm not sure I understand the question now.

Is it that

SELECT Firma FROM Kunden where Firma like \'"+kunde+"\'";

works, but

SELECT * FROM Kunden where Firma like \'"+kunde+"\'";

fails?

----------