How to fix [invalid character value for cast...] with ucanaccess in microsoft access 2013

92 Views Asked by At

Every time i run this code it gave me error that told me there is an invalid character in the text i entered even empty text

**net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 data exception: invalid character value for cast
    at net.ucanaccess.jdbc.UcanaccessPreparedStatement.setString(UcanaccessPreparedStatement.java:766)
    at database.data.<init>(data.java:18)
    at database.data.main(data.java:28)
Caused by: java.sql.SQLDataException: data exception: invalid character value for cast
    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
    at org.hsqldb.jdbc.JDBCPreparedStatement.setParameter(Unknown Source)
    at org.hsqldb.jdbc.JDBCPreparedStatement.setString(Unknown Source)
    at net.ucanaccess.jdbc.UcanaccessPreparedStatement.setString(UcanaccessPreparedStatement.java:764)
    ... 2 more
Caused by: org.hsqldb.HsqlException: data exception: invalid character value for cast
    at org.hsqldb.error.Error.error(Unknown Source)
    at org.hsqldb.error.Error.error(Unknown Source)
    at org.hsqldb.Scanner.convertToNumber(Unknown Source)
    at org.hsqldb.types.NumberType.convertToType(Unknown Source)
    ... 5 more**

This is Class

package database;
import java.sql.*;
import java.util.Scanner;

public class data {
    Connection con;
    PreparedStatement stat;
    
    public data() {
        Scanner scan = new Scanner(System.in);
        String name = scan.nextLine();
        
        try {
            //Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
            con = DriverManager.getConnection("jdbc:ucanaccess://C:/Users/Gobran_Group/Desktop/ /H/data.accdb");
            
            stat = con.prepareStatement("insert into records(ID,Name)values(?,?) ");
            stat.setString(1, name);
            stat.executeUpdate();
            System.out.println("Finish");
            
        }catch(Exception e) {
            e.printStackTrace();
        }
    }
    
    public static void main(String[] args) {    
        new data();
    }
}

The Jars i used

https://1drv.ms/u/s!AmFO75QZK_9paZkm2e1xiAtYnvI?e=sOdrcS

0

There are 0 best solutions below