RE: [sqlite4java] spatialite & sqlite4java compile with Android NDK

[Igor Sereda]

Hi, not sure I understood you well. Are you the author of spatialite4android and trying to reuse sqlite4java in that project, by compiling it with spatial extension?

 

Cheers,

Igor

 

From: sqlit...@googlegroups.com [mailto:sqlit...@googlegroups.com] On Behalf Of ??
Sent: Sunday, December 09, 2012 7:02 PM
To: sqlit...@googlegroups.com
Subject: [sqlite4java] spatialite & sqlite4java compile with Android NDK

 

I always got this error:

 

/Users/techzhou/android-ndk/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld.gold: /Users/techzhou/Code/spatialstorage/obj/local/armeabi/objs/sqlite4java-android/sqlite4java/sqlite_wrap.o: in function Java_com_almworks_sqlite4java__1SQLiteSwiggedJNI_sqlite3_1column_1database_1name:/Users/techzhou/Code/spatialstorage/jni/sqlite4java/sqlite_wrap.c:7716: error: undefined reference to 'SPLite3_column_database_name'

 

the spatialite4android : https://code.google.com/p/spatialite-android/

it use jsqlite but jsqlite has performance problem.

 

so I want try replace it with sqlite4java, I really not good at that.  "SQLiteSwiggedJNI" I cannt compile correctly.

 

sry my bad english and bad description.

--
You received this message because you are subscribed to the Google Groups "sqlite4java" group.
To view this discussion on the web visit https://groups.google.com/d/msg/sqlite4java/-/0wOGDPvBqBwJ.
To post to this group, send email to sqlit...@googlegroups.com.
To unsubscribe from this group, send email to sqlite4java...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sqlite4java?hl=en.

[周超]

not the author

just trying to reuse sqlite4java in that project, by compiling it with spatial extension

在 2012年12月10日星期一UTC+8下午4时19分35秒，Igor Sereda写道：

[Igor Sereda]

I don’t think I can help you without trying to do that myself or inspecting your code, which I can’t do. Maybe someone from the group has tried the same thing – please chime in.

 

You may also try using SQLite’s extension loading mechanism, exposed via SQLiteConnection.loadExtension(), instead of recompiling sqlite4java

 

Igor

[周超]

thanks, I finish it. load extension successfully.

I have a new question,  https://groups.google.com/d/topic/spatialite-users/in_O_D99J2A/discussion

I use sqlite4java, its still slow when sqlite3_step().

the situation is about bad sql (rewrite sql)or slow wrapper(try to implement SQLiteStatement.loadBytes()? ),  both?

在 2012年12月10日星期一UTC+8下午9时33分57秒，Igor Sereda写道：