SQLite3.Exception:数据库磁盘映像格式错误 [英] SQLite3.Exception: database disk image is malformed
本文介绍了SQLite3.Exception:数据库磁盘映像格式错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在通过 NDK 使用 sqlite3 本机 c 库 (JNI) 时收到此错误消息
Mates i m getting this error message while using sqlite3 native c library (JNI) through NDK
请告诉我哪里做错了
01-29 11:04:19.532: E/Error(2023): SQLite3.Exception: database disk image is malformed
01-29 11:04:19.544: E/dalvikvm(2023): JNI ERROR (app bug): accessed stale local reference 0x7f00001d (index 7 in a table of size 7)
01-29 11:04:19.544: E/dalvikvm(2023): VM aborting
01-29 11:04:19.544: A/libc(2023): Fatal signal 11 (SIGSEGV) at 0xdeadd00d (code=1), thread 2023 (abdkosh.android)
这是我产生此错误的代码块
Here is my block of code which is generating this error
public ArrayList<String> getDefinations(String query, int column_index)
{
ArrayList<String> words = new ArrayList<String>();
MatrixCursor mcursor = null;
try {
Stmt stmt = getDB2().prepare(query);
if (stmt.step()) {
stmt.get_cursor().moveToFirst();
mcursor = stmt.get_cursor();
try {
mcursor.moveToFirst();
do {
words.add(mcursor.getString(column_index));
} while (mcursor.moveToNext());
} catch (IndexOutOfBoundsException e) {
if (MainActivity.logcat_status) {
Log.e("Error", e + "");
}
}
}
} catch (Exception e) {
// TODO Auto-generated catch block
if (MainActivity.logcat_status) {
Log.e("Error", e + "");
}
}
这是我正在尝试执行的查询
Here is the query i m trying to execute
"select pos, definition, sample FROM word INNER JOIN sense ON word.wordid = sense.wordidINNER JOIN synset ON sense.synsetid = synset.synsetid LEFT JOIN sample ONsample.synsetid = synset.synsetid WHERE lemma = 'life'"
"select pos, definition, sample FROM word INNER JOIN sense ON word.wordid = sense.wordid INNER JOIN synset ON sense.synsetid = synset.synsetid LEFT JOIN sample ON sample.synsetid = synset.synsetid WHERE lemma = 'life'"
其实字典里没有生命"这个词所以
Actually that word "life" is not in the dictionary so
stmt.get_cursor().moveToFirst();
转到实际上不退出的第一个记录集(第一行)，并且在此行之后通过异常和应用程序被 dalvikvm 关闭.
goes to first record set (1st row) which actually doesn't exits and after this line through the exception and app is closed by dalvikvm.
这正是在这种情况下发生的.
This is was exactly happening in this case.
所以我的问题是stmt"如何知道没有特定单词的记录集.
So my question is how "stmt" will know that there is no record set with specific word.
这是我下载并使用 jni(c) 包装类的链接http://www.sqlite.org/snapshot/sqlite-amalgamation-201401290146.zip然后通过 NDK 创建libsqlite3_jni.so"文件
Here is the link where i have downloaded and using the jni(c) wrapper classses http://www.sqlite.org/snapshot/sqlite-amalgamation-201401290146.zip and then created "libsqlite3_jni.so" file via NDK
使用 http://code.google.com/p/sqlite3 处理程序类的链接-android/ 用于与 c 代码交互.
link of handler class i m using http://code.google.com/p/sqlite3-android/ for interacting to c code.
IMO stmt.step() 方法仅在没有记录集时才解决问题.
IMO stmt.step() method is doing the problem only when there is no record set.
这是我完整的 Stmt.java
Here is my complete Stmt.java
package SQLite3;
import com.shabdkosh.android.MainActivity;
import android.util.Log;
/**
* Class to represent compiled SQLite3 statement.
*
* Note, that all native methods of this class are not synchronized, i.e. it is
* up to the caller to ensure that only one thread is in these methods at any
* one time.
*/
public class Stmt {
/**
* Internal handle for the SQLite3 statement.
*/
private long handle = 0;
/**
* Internal last error code for prepare()/step() methods.
*/
protected int error_code = 0;
/**
* Prepare the next SQL statement for the Stmt instance.
*
* @return true when the next piece of the SQL statement sequence has been
* prepared, false on end of statement sequence.
*/
public native boolean prepare() throws SQLite3.Exception;
/**
* Perform one step of compiled SQLite3 statement.
*
* Example:<BR>
*
* <PRE>
* ...
* try {
* Stmt s = db.prepare("select * from x; select * from y;");
* s.bind(...);
* ...
* s.bind(...);
* while (s.step(cb)) {
* Object o = s.value(...);
* ...
* }
* // s.reset() for re-execution or
* // s.prepare() for the next piece of SQL
* while (s.prepare()) {
* s.bind(...);
* ...
* s.bind(...);
* while (s.step(cb)) {
* Object o = s.value(...);
* ...
* }
* }
* } catch (SQLite.Exception e) {
* s.close();
* }
* </PRE>
*
* @return true when row data is available, false on end of result set.
*/
public native boolean step() throws SQLite3.Exception;
/**
* Close the compiled SQLite3 statement.
*/
public native void close() throws SQLite3.Exception;
/**
* Reset the compiled SQLite3 statement without clearing parameter bindings.
*/
public native void reset() throws SQLite3.Exception;
/**
* Clear all bound parameters of the compiled SQLite3 statement.
*/
public native void clear_bindings() throws SQLite3.Exception;
/**
* Bind positional integer value to compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
* @param value
* value of parameter
*/
public native void bind(int pos, int value) throws SQLite3.Exception;
/**
* Bind positional long value to compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
* @param value
* value of parameter
*/
public native void bind(int pos, long value) throws SQLite3.Exception;
/**
* Bind positional double value to compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
* @param value
* value of parameter
*/
public native void bind(int pos, double value) throws SQLite3.Exception;
/**
* Bind positional byte array to compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
* @param value
* value of parameter, may be null
*/
public native void bind(int pos, byte[] value) throws SQLite3.Exception;
/**
* Bind positional String to compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
* @param value
* value of parameter, may be null
*/
public native void bind(int pos, String value) throws SQLite3.Exception;
/**
* Bind positional SQL null to compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
*/
public native void bind(int pos) throws SQLite3.Exception;
/**
* Bind positional zero'ed blob to compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
* @param length
* byte size of zero blob
*/
public native void bind_zeroblob(int pos, int length)
throws SQLite3.Exception;
/**
* Return number of parameters in compiled SQLite3 statement.
*
* @return int number of parameters
*/
public native int bind_parameter_count() throws SQLite3.Exception;
/**
* Return name of parameter in compiled SQLite3 statement.
*
* @param pos
* parameter index, 1-based
* @return String parameter name
*/
public native String bind_parameter_name(int pos) throws SQLite3.Exception;
/**
* Return index of named parameter in compiled SQLite3 statement.
*
* @param name
* of parameter
* @return int index of parameter, 1-based
*/
public native int bind_parameter_index(String name)
throws SQLite3.Exception;
/**
* Retrieve integer column from exec'ed SQLite3 statement.
*
* @param col
* column number, 0-based
* @return int column value
*/
public native int column_int(int col) throws SQLite3.Exception;
/**
* Retrieve long column from exec'ed SQLite3 statement.
*
* @param col
* column number, 0-based
* @return long column value
*/
public native long column_long(int col) throws SQLite3.Exception;
/**
* Retrieve double column from exec'ed SQLite3 statement.
*
* @param col
* column number, 0-based
* @return double column value
*/
public native double column_double(int col) throws SQLite3.Exception;
/**
* Retrieve blob column from exec'ed SQLite3 statement.
*
* @param col
* column number, 0-based
* @return byte[] column value
*/
public native byte[] column_bytes(int col) throws SQLite3.Exception;
/**
* Retrieve string column from exec'ed SQLite3 statement.
*
* @param col
* column number, 0-based
* @return String column value
*/
public native String column_string(int col) throws SQLite3.Exception;
/**
* Retrieve column type from exec'ed SQLite3 statement.
*
* @param col
* column number, 0-based
* @return column type code, e.g. SQLite.Constants.SQLITE_INTEGER
*/
public native int column_type(int col) throws SQLite3.Exception;
/**
* Retrieve number of columns of exec'ed SQLite3 statement.
*
* @return int number of columns
*/
public native int column_count() throws SQLite3.Exception;
/**
* Retrieve column data as object from exec'ed SQLite3 statement.
*
* @param col
* column number, 0-based
* @return Object or null
*/
public Object column(int col) throws SQLite3.Exception {
switch (column_type(col)) {
case Constants.SQLITE_INTEGER:
return new Long(column_long(col));
case Constants.SQLITE_FLOAT:
return new Double(column_double(col));
case Constants.SQLITE_BLOB:
return column_bytes(col);
case Constants.SQLITE3_TEXT:
return column_string(col);
}
return null;
}
/**
* Return name of column of SQLite3 statement.
*
* @param col
* column number, 0-based
* @return String or null
*/
public native String column_name(int col) throws SQLite3.Exception;
/**
* Return table name of column of SQLite3 statement.
*
* @param col
* column number, 0-based
* @return String or null
*/
public native String column_table_name(int col) throws SQLite3.Exception;
/**
* Return database name of column of SQLite3 statement.
*
* @param col
* column number, 0-based
* @return String or null
*/
public native String column_database_name(int col) throws SQLite3.Exception;
/**
* Return declared column type of SQLite3 statement.
*
* @param col
* column number, 0-based
* @return String or null
*/
public native String column_decltype(int col) throws SQLite3.Exception;
/**
* Return origin column name of column of SQLite3 statement.
*
* @param col
* column number, 0-based
* @return String or null
*/
public native String column_origin_name(int col) throws SQLite3.Exception;
/**
* Return statement status information.
*
* @param op
* which counter to report
* @param flg
* reset flag
* @return counter
*/
public native int status(int op, boolean flg);
/**
* Destructor for object.
*/
protected native void finalize();
/**
* Internal native initializer.
*/
private static native void internal_init();
static {
internal_init();
}
protected String[] mColumns = null;
public String[] column_names(){
if(mColumns == null){
int colCount = 0;
try {
colCount = column_count();
} catch (Exception e1) {
// TODO Auto-generated catch block
if(MainActivity.logcat_status){
Log.e("Error", e1+"");}
}
mColumns = new String[colCount];
for(int i=0; i<colCount;i++){
try {
mColumns[i] = column_name(i);
} catch (Exception e) {
// TODO Auto-generated catch block
if(MainActivity.logcat_status){
Log.e("Error", e+"");}
}
}
}
return mColumns;
}
public int column_index(String col_name){
String[] names = column_names();
int col_count = names.length;
int i;
for(i=0; i < col_count; i++){
if(col_name.equals(names[i])) return i;
}
return -1;
}
public MatrixCursor get_cursor(){
return get_cursor(20);
}
public MatrixCursor get_cursor(int capacity){
MatrixCursor cursor = new MatrixCursor(column_names(), capacity);
try {
int colCount = column_count();
while(step()){
Object[] rowObject = new Object[colCount];
for(int i=0; i < colCount; i++){
rowObject[i] = column_string(i);
}
cursor.addRow(rowObject);
}
} catch (Exception e) {
// TODO Auto-generated catch block
if(MainActivity.logcat_status){
Log.e("Error", e+"");}
}
return cursor;
}
}
提前致谢
推荐答案
@Manish.我已经编辑了您的示例代码.请像这样使用 cursor.getCount() .谢谢你
@Manish. I have edited your sample code. Please use cursor.getCount() like this. Thankyou
public ArrayList<String> getDefinations(String query, int column_index)
{
ArrayList<String> words = new ArrayList<String>();
MatrixCursor mcursor = null;
try
{
Stmt stmt = getDB2().prepare(query);
if (stmt.step())
{
//stmt.get_cursor().moveToFirst();
mcursor = stmt.get_cursor();
if(mcursor != null && mcursor.getCount() > 0)
{
try
{
mcursor.moveToFirst();
do
{
words.add(mcursor.getString(column_index));
}
while (mcursor.moveToNext());
}
catch (IndexOutOfBoundsException e)
{
if (MainActivity.logcat_status)
{
Log.e("Error", e + "");
}
}
}
}
}
catch (Exception e)
{
// TODO Auto-generated catch block
if (MainActivity.logcat_status)
{
Log.e("Error", e + "");
}
}
}
这篇关于SQLite3.Exception:数据库磁盘映像格式错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
