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