Ограничения ListView

[Jetraccoon]

Всем привет. Имеется готовая база на 1600 строк. При попытке копировании и вывода данной базы приложение крашится.Максимум выводит 10 записей.

[Foenix]

и?

[парень]

а логи смотрел? LogCat ?

[Jetraccoon]

Хотел узнать какой максимум? есть ли ограничения? Когда пытаюсь открыть базу больше чем 10 строк в логах выдает:

Код: Выделить всё

07-31 13:01:31.238: E/SQLiteLog(8225): (14) cannot open file at line 30176 of [00bb9c9ce4]
07-31 13:01:31.238: E/SQLiteLog(8225): (14) os_unix.c:30176: (2) open(//data//data//com.example.test//databases//yourdb2.sqlite3) - 
07-31 13:01:31.289: E/SQLiteDatabase(8225): Failed to open database '//data//data//com.example.test//databases//yourdb2.sqlite3'.
07-31 13:01:31.289: E/SQLiteDatabase(8225): android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
07-31 13:01:31.289: E/SQLiteDatabase(8225): 	at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)

[Mikhail_dev]

Вроде бы и правильную информацию начали показывать, а вроде бы и не всю.
Вот допустим стектрейс ошибки с такой же ошибкой
http://stackoverflow.com/questions/1703 ... or-code-14
[syntax=java5]
06-10 23:07:01.831: E/Trace(4419): error opening trace file: No such file or directory (2)
06-10 23:07:03.611: E/SQLiteLog(4419): (14) cannot open file at line 30176 of [00bb9c9ce4]
06-10 23:07:03.621: E/SQLiteLog(4419): (14) os_unix.c (2) open(/data/data/com.example.quotes/databasesQuotesdb) -
06-10 23:07:03.641: E/SQLiteDatabase(4419): Failed to open database '/data/data/com.example.quotes/databasesQuotesdb'.
06-10 23:07:03.641: E/SQLiteDatabase(4419): android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:804)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:789)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:669)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at com.example.quotes.DataBaseHelper.checkDataBase(DataBaseHelper.java:94)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at com.example.quotes.DataBaseHelper.createDataBase(DataBaseHelper.java:58)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at com.example.quotes.MainActivity.onCreate(MainActivity.java:34)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.app.Activity.performCreate(Activity.java:5104)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.app.ActivityThread.access$600(ActivityThread.java:141)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.os.Handler.dispatchMessage(Handler.java:99)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.os.Looper.loop(Looper.java:137)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at android.app.ActivityThread.main(ActivityThread.java:5041)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at java.lang.reflect.Method.invokeNative(Native Method)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at java.lang.reflect.Method.invoke(Method.java:511)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
06-10 23:07:03.641: E/SQLiteDatabase(4419): at dalvik.system.NativeStart.main(Native Method)
06-10 23:07:03.731: E/SQLiteLog(4419): (14) cannot open file at line 30176 of [00bb9c9ce4]
06-10 23:07:03.731: E/SQLiteLog(4419): (14) os_unix.c (2) open(/data/data/com.example.quotes/databasesQuotesdb) -
06-10 23:07:03.781: E/SQLiteDatabase(4419): Failed to open database '/data/data/com.example.quotes/databasesQuotesdb'.
06-10 23:07:03.781: E/SQLiteDatabase(4419): android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:804)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:789)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:669)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at com.example.quotes.DataBaseHelper.openDataBase(DataBaseHelper.java:145)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at com.example.quotes.MainActivity.onCreate(MainActivity.java:44)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.app.Activity.performCreate(Activity.java:5104)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.app.ActivityThread.access$600(ActivityThread.java:141)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.os.Handler.dispatchMessage(Handler.java:99)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.os.Looper.loop(Looper.java:137)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at android.app.ActivityThread.main(ActivityThread.java:5041)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at java.lang.reflect.Method.invokeNative(Native Method)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at java.lang.reflect.Method.invoke(Method.java:511)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
06-10 23:07:03.781: E/SQLiteDatabase(4419): at dalvik.system.NativeStart.main(Native Method)
06-10 23:07:03.791: D/AndroidRuntime(4419): Shutting down VM
06-10 23:07:03.791: W/dalvikvm(4419): threadid=1: thread exiting with uncaught exception (group=0x40a71930)
06-10 23:07:03.831: E/AndroidRuntime(4419): FATAL EXCEPTION: main
06-10 23:07:03.831: E/AndroidRuntime(4419): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.quotes/com.example.quotes.MainActivity}: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.ActivityThread.access$600(ActivityThread.java:141)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.os.Handler.dispatchMessage(Handler.java:99)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.os.Looper.loop(Looper.java:137)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.ActivityThread.main(ActivityThread.java:5041)
06-10 23:07:03.831: E/AndroidRuntime(4419): at java.lang.reflect.Method.invokeNative(Native Method)
06-10 23:07:03.831: E/AndroidRuntime(4419): at java.lang.reflect.Method.invoke(Method.java:511)
06-10 23:07:03.831: E/AndroidRuntime(4419): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
06-10 23:07:03.831: E/AndroidRuntime(4419): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
06-10 23:07:03.831: E/AndroidRuntime(4419): at dalvik.system.NativeStart.main(Native Method)
06-10 23:07:03.831: E/AndroidRuntime(4419): Caused by: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:804)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:789)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:669)
06-10 23:07:03.831: E/AndroidRuntime(4419): at com.example.quotes.DataBaseHelper.openDataBase(DataBaseHelper.java:145)
06-10 23:07:03.831: E/AndroidRuntime(4419): at com.example.quotes.MainActivity.onCreate(MainActivity.java:44)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.Activity.performCreate(Activity.java:5104)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
06-10 23:07:03.831: E/AndroidRuntime(4419): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
06-10 23:07:03.831: E/AndroidRuntime(4419): ... 11 more
06-10 23:07:04.083: D/dalvikvm(4419): GC_CONCURRENT freed 203K, 11% free 2676K/3000K, paused 25ms+18ms, total 306ms
06-10 23:07:07.811: I/Process(4419): Sending signal. PID: 4419 SIG: 9
[/syntax]
Вот также скопируйте.

[Jetraccoon]

Код: Выделить всё

07-31 13:20:50.748: D/dalvikvm(10432): GC_FOR_ALLOC freed 36K, 6% free 2657K/2812K, paused 56ms, total 59ms
07-31 13:20:50.758: I/dalvikvm-heap(10432): Grow heap (frag case) to 3.782MB for 1127536-byte allocation
07-31 13:20:50.828: D/dalvikvm(10432): GC_FOR_ALLOC freed 2K, 5% free 3756K/3916K, paused 67ms, total 67ms
07-31 13:20:50.898: D/dalvikvm(10432): GC_CONCURRENT freed <1K, 4% free 3760K/3916K, paused 8ms+11ms, total 73ms
07-31 13:20:50.948: I/class com.example.db.DatabaseHelper(10432): Database already exists
07-31 13:20:51.009: E/SQLiteLog(10432): (1) no such table: DR
07-31 13:20:51.018: D/AndroidRuntime(10432): Shutting down VM
07-31 13:20:51.018: W/dalvikvm(10432): threadid=1: thread exiting with uncaught exception (group=0x40a71930)
07-31 13:20:51.038: E/AndroidRuntime(10432): FATAL EXCEPTION: main
07-31 13:20:51.038: E/AndroidRuntime(10432): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.test/com.example.test.MainActivity}: android.database.sqlite.SQLiteException: no such table: DR (code 1): , while compiling: SELECT _id, Name FROM DR ORDER BY Name
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.ActivityThread.access$600(ActivityThread.java:141)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.os.Handler.dispatchMessage(Handler.java:99)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.os.Looper.loop(Looper.java:137)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.ActivityThread.main(ActivityThread.java:5041)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at java.lang.reflect.Method.invokeNative(Native Method)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at java.lang.reflect.Method.invoke(Method.java:511)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at dalvik.system.NativeStart.main(Native Method)
07-31 13:20:51.038: E/AndroidRuntime(10432): Caused by: android.database.sqlite.SQLiteException: no such table: DR (code 1): , while compiling: SELECT _id, Name FROM DR ORDER BY Name
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1161)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1032)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1200)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at com.example.test.MainActivity.fillFreinds(MainActivity.java:68)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at com.example.test.MainActivity.onCreate(MainActivity.java:42)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.Activity.performCreate(Activity.java:5104)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
07-31 13:20:51.038: E/AndroidRuntime(10432): 	... 11 more
07-31 13:21:14.698: I/Process(10432): Sending signal. PID: 10432 SIG: 9

вот полностью.

[KamiSempai]

В базе отсутствует таблица DR.

[Mikhail_dev]

java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.test/com.example.test.MainActivity}: android.database.sqlite.SQLiteException: no such table: DR (code 1): , while compiling: SELECT _id, Name FROM DR ORDER BY Name

У foenix в подписи ссылка на вебинар, который учит ошибки находить и понимать их.
viewtopic.php?f=60&t=3198

[Jetraccoon]

Эта ошибка выходит только если строк больше 10. Спасибо за ссылку на вебинар обязательно просмотрю, но сейчас желательно побыстрее это доделать.

[Foenix]

ну нет такой таблицы, говоирится, и все тут. Есть она у тебя? Надо точно проверять.

[Mikhail_dev]

Вообще надо смотреть код создания таблицы и прочее. Сейчас гадание на кофейной гуще. Хз что там грузилось в первых записях, вдруг там логика таблицы не берет оттуда данные.