java - 强制转换的字符值无效

Question

我不断收到此错误，net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.0-SNAPSHOT data exception: invalid character value for cast. 我不确定如何修复它我尝试从我的 sql 查询的值部分中省略主键，我不确定数据是否不兼容，或者我是否以某种方式声明它错误，请帮忙。我正在尝试将 GUI 中的值插入现有数据库。

这是我的代码

    String racename, noofswimmers, avgtime, raceontime, tod, winid;
    racename = txtracename.getText();
    noofswimmers = txtnoswimmers.getText();
    avgtime = txtavgtime.getText();
    raceontime = txtraceontime.getText();
    tod = txttod.getText();
    winid = txtwinid.getText();
    
    
    
    try {
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        con = DriverManager.getConnection("jdbc:ucanaccess://C:/Users/Calvin/Documents/SwimGala.accdb");
        
        pst = con.prepareStatement("insert into tblRace(RaceName,NoSwimmers,AvgTime,RaceOnTime,TimeOfDay,WinID)values(?,?,?,?,?,?)");
        pst.setString(0,racename);
        pst.setString(1,noofswimmers);
        pst.setString(2,avgtime);
        pst.setString(3,raceontime);
        pst.setString(4,tod);
        pst.setString(5,winid);
        pst.executeUpdate();
        JOptionPane.showMessageDialog(this,"Record added");
        
        
                
        
    } catch (ClassNotFoundException ex) {
        Logger.getLogger(Tabl.class.getName()).log(Level.SEVERE, null, ex);
        JOptionPane.showMessageDialog(this,ex);
        
    } catch (SQLException ex) {
        Logger.getLogger(Tabl.class.getName()).log(Level.SEVERE, null, ex);
        JOptionPane.showMessageDialog(this,ex);
    }

标签： javasqldatabaseuser-interfacems-access