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();
}
}
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";
Is it that
SELECT Firma FROM Kunden where Firma like \'"+kunde+"\'";
works, but
SELECT * FROM Kunden where Firma like \'"+kunde+"\'";
fails?
----------