The following code error occurred:
Conn=database ('data.db',"',"','Org.sqlite.JDBC','jdbc:sqlite:c:/matlab7/work/del_man_voice_from_wave/data.db');%Ping(conn);% Set (conn,'autocommit','off'); EXEC (Conn,'CREATE TABLE mytst (ID, name, score1, Score2)'); EXEC (Conn,'INSERT INTO MYTST values (1, "Zhangsan", 88.5,90)'); EXEC (Conn,'INSERT INTO MYTST values (2, "Lisi", 98.5,92);'); Curs=EXEC (Conn,'Select Id,name from Mytst') disp Aacurs=fetch (curs);% commit (conn);
???Java Exception Occurred:java.lang.IllegalStateException:SQLite jdbc:inconsistent internal state at ORG.SQLITE.R S.checkcol (Rs.java: +) at Org.sqlite.RS.getColumnCount (Rs.java:319) at Com.mathworks.toolbox.database.fetchTheData.maximumColumns (Fetchthedata.java:174). Errorinch==> Cursor.cols at -Columns=Double(maximumcolumns (cursor. Fetch,resultsetmetadata)); Errorinch==> Cursor.fetch at -NumberOfColumns=Double(cols (cursor)); Errorinch==> Test_sqlite at9Curs=fetch (Curs);
The workaround:
MATLAB7 + Sqlitejdbc-v056.jar Access database