search

AnantLabs / xerial

Automatically exported from code.google.com/p/xerial
0 stars 0 forks source link

Need OSX 10.6 64 bit java 1.6 library - pure java has IO errors #37

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 

What steps will reproduce the problem?
0) OSX 10.6 with Java 1.6 and sqlite-jdbc-3.6.17.3
1. create tables with sql statements
2.start transaction
3. add rows
4) commit transaction

What is the expected output? What do you see instead?

On OSX 10.6 using Java 1.6, there is no native jni library so it falls back
to pure java which then gets an IO error on the commit. The real solution
is to support the native x86_64 jni library like the ventus release .56.
Note that the 32 bit library works fine on OSX 10.6 with java 1.5 (copied
from another system)

I'm working on compiling a x86_64 version from SVN code using "make
os=Darwin arch=x86_64 native"

Original issue reported on code.google.com by todd.ric...@gmail.com on 30 Sep 2009 at 4:32

GoogleCodeExporter commented 9 years ago 
I found another bug report mentioning adding 
native/Mac/x86_64/libsqlitejdbc.jnilib
and it looks like my compiled version is loaded properly.

The only issues I had during the build were

1) the curl fetch of sqlite code is failing and saving the HTML error text as 
the
.zip file. I just downloaded directly and did not debug further
2) I had to comment out the Support10_4 line in Makefile.common because my 
system
only had 10.5 and 10.6 libraries. I installed XCode 3.2 w/o the old compat files
3) I did a manual ""make os=Darwin arch=x86_64 native" to create the file. 
There were
numerous warnings about pointer conversion that I have not reviewed
4) Added the built library with zip to the original jar file

*) Ideally the jnilib would be a universal library.
*) It would be better to compile with -O2 or -O3 instead of -Os

Original comment by todd.ric...@gmail.com on 30 Sep 2009 at 5:35

GoogleCodeExporter commented 9 years ago 
Thanks for the detailed report. 

Today, I finished to set up a 64-bit Mac OS X machine. I will try the above 
steps.

Original comment by taroleo on 6 Oct 2009 at 1:55

GoogleCodeExporter commented 9 years ago 
Please skip 3.6.18 and move directly to 3.6.19 which contains foreign key 
support. 
We've had to use some hacked up triggers to get around this so native support 
will 
be a huge win

http://www.sqlite.org/foreignkeys.html

Thanks!

Original comment by todd.ric...@gmail.com on 14 Oct 2009 at 3:05

GoogleCodeExporter commented 9 years ago 
changed the milestone

Original comment by taroleo on 10 Nov 2009 at 3:27

GoogleCodeExporter commented 9 years ago 
changed the milestone

Original comment by taroleo on 25 Nov 2009 at 11:50

GoogleCodeExporter commented 9 years ago 
Since sqlite-jdbc-3.6.19, native library for Mac OS X 64-bit is added.

Close the issue.

Original comment by taroleo on 8 Dec 2009 at 6:31