Error messages using ODBC

[Wolfgang Obi]

Hi , I'm having a problem with this code.
I'm trying to connect to a locally stored access databank. I am running the Java application from within Eclipse....

can someone help me here?

thank you!

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
public class test2 extends Frame {
// GUI-Variable
Label status = new Label("bereit ...", Label.LEFT);
Panel panel = new Panel(new GridLayout(0,2));
TextField tf_name = new TextField();
TextField tf_pin = new TextField();
TextField tf_konto = new TextField();
TextField tf_verf�gbar = new TextField();
Button btn = new Button("Ermittle...");
// JDBC-Variable
String drv = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:person";
int code;
Connection c;
Statement s;
ResultSet rs;
public test2() {
// Fenster
add("Center", panel);
// Im panel sind folgende Steuerelemente drin
panel.add(new Label("Name"));
panel.add(tf_name);
panel.add(new Label("PIN"));
panel.add(tf_pin);
panel.add(new Label("Kontostand"));
panel.add(tf_konto);
panel.add(new Label("verf�gbar"));
panel.add(tf_verf�gbar);
panel.add(btn);
panel.setBackground(Color.lightGray);
add("South", status);
setSize(350,180);
setTitle("GUI");
setVisible(true);
try
{
Class.forName(drv);
c = DriverManager.getConnection(url, "", "");
s = c.createStatement();
}
catch (Exception ex) {ex.printStackTrace();}
addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0); }} );
btn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
ermittle();}});
}
private void ermittle()
{
//Der Sql-Befehl wird vorbereitet, der dann sp�ter zum ResultSet geschickt wird
String sql = "SELECT * FROM person WHERE kundenname = '" + tf_name.getText() + "'" + " AND pin = '" + tf_pin.getText() + "'";
try
{
//aus diesem SQL_Befehl (sql) wird ein ResultSet erzeugt, das die gew�nschten Spalten von den gew�nschten personen enth�lt
rs = s.executeQuery(sql);
if (rs.next()) //so lange der ResultSer NICHT leer ist, mache...
{
tf_konto.setText(rs.getString("kontostand")); //Der Kontostand wird aus dem ResultSet gelesen und in das TextFeld "tf_konto" eingef�gt
int i1 = Integer.parseInt(rs.getString("�berziehung"));
int i2 = Integer.parseInt(tf_konto.getText());
int erg = (i2 + i1);
tf_verf�gbar.setText(String.valueOf(erg));
}
}//try
catch (Exception ex) {ex.printStackTrace();}
}//ermittle
public static void main(String[] args)
{
new test2();
}
}//class

error message:

at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Uebung_2.<init>(Uebung_2.java:60)
at Uebung_2.main(Uebung_2.java:104)

 

[sathish kumar]

Do you have person ODBC:JDBC bridge defined in your workspace?

[Herman Schelti]

hi Wolfgang.

I don't understand why your stacktrace says Uebung_2, but your class is called
test2.

Herman