Hi Ricky, Let me report a problem I've run into while trying to build and run native SQLite-JDBC from sources under FreeBSD 7.0-RELEASE (diablo- jdk1.5.0)
Here is what I did 1. Downloaded src package http://www.zentus.com/sqlitejdbc/dist/sqlitejdbc-v044-src.tgz =) 2. Unpacked it =)) 3. tried to "gmake" it. Here is where I get an error [EMAIL PROTECTED] /tmp/sqlitejdbc-v044]# export JAVA_HOME=/usr/local/diablo- jdk1.5.0; gmake unzip -qo dl/sqlite-3.5.8-amal.zip -d build/sqlite-3.5.8-Default-i386 perl -pi -e "s/sqlite3_api;/sqlite3_api = 0;/g" \ build/sqlite-3.5.8-Default-i386/sqlite3ext.h (cd build/sqlite-3.5.8-Default-i386; gcc -o sqlite3.o -c -I/usr/local/ diablo-jdk1.5.0/include -O3 -fPIC -Ibuild/sqlite-3.5.8-Default-i386 - Ibuild -I/usr/local/diablo-jdk1.5.0/include/freebsd \ -DSQLITE_ENABLE_COLUMN_METADATA \ -DSQLITE_CORE \ -DSQLITE_ENABLE_FTS3 \ -DSQLITE_OMIT_LOAD_EXTENSION sqlite3.c) $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -source 1.2 - target 1.2 -sourcepath src -d build src/org/sqlite/Codes.java $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -source 1.2 - target 1.2 -sourcepath src -d build src/org/sqlite/Conn.java Note: Some input files use or override a deprecated API. Note: Recompile with -Xlint:deprecation for details. $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -source 1.2 - target 1.2 -sourcepath src -d build src/org/sqlite/JDBC.java Note: Some input files use or override a deprecated API. Note: Recompile with -Xlint:deprecation for details. $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -source 1.2 - target 1.2 -sourcepath src -d build src/org/sqlite/NativeDB.java Note: Some input files use or override a deprecated API. Note: Recompile with -Xlint:deprecation for details. $JAVA_HOME/bin/javah -classpath build -jni -o build/NativeDB.h org.sqlite.NativeDB cd build && jar cf sqlitejdbc-v044-native.jar org/sqlite/Codes.class org/sqlite/Conn.class org/sqlite/DB.class org/sqlite/Function\ $Aggregate.class org/sqlite/Function.class org/sqlite/JDBC.class org/sqlite/MetaData.class org/sqlite/NativeDB.class org/sqlite/ PrepStmt.class org/sqlite/RS.class org/sqlite/Stmt.class org/sqlite/ Unused.class gcc -I/usr/local/diablo-jdk1.5.0/include -O3 -fPIC -Ibuild/ sqlite-3.5.8-Default-i386 -Ibuild -I/usr/local/diablo-jdk1.5.0/include/ freebsd -c -o build/Default-i386/NativeDB.o \ src/org/sqlite/NativeDB.c gcc -I/usr/local/diablo-jdk1.5.0/include -O3 -fPIC -Ibuild/ sqlite-3.5.8-Default-i386 -Ibuild -I/usr/local/diablo-jdk1.5.0/include/ freebsd -shared -o build/Default-i386/libsqlitejdbc.so \ build/Default-i386/NativeDB.o build/sqlite-3.5.8- Default-i386/*.o strip build/Default-i386/libsqlitejdbc.so $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -target 1.5 - classpath "build:lib/junit-4.1.jar" \ -sourcepath src/test -d build src/test/ConnectionTest.java $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -target 1.5 - classpath "build:lib/junit-4.1.jar" \ -sourcepath src/test -d build src/test/DBMetaDataTest.java $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -target 1.5 - classpath "build:lib/junit-4.1.jar" \ -sourcepath src/test -d build src/test/PrepStmtTest.java $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -target 1.5 - classpath "build:lib/junit-4.1.jar" \ -sourcepath src/test -d build src/test/RSMetaDataTest.java $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -target 1.5 - classpath "build:lib/junit-4.1.jar" \ -sourcepath src/test -d build src/test/StatementTest.java $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -target 1.5 - classpath "build:lib/junit-4.1.jar" \ -sourcepath src/test -d build src/test/ TransactionTest.java $JAVA_HOME/bin/javac -Xbootclasspath/p:lib/jdbc-1.4.jar -target 1.5 - classpath "build:lib/junit-4.1.jar" \ -sourcepath src/test -d build src/test/UDFTest.java $JAVA_HOME/bin/java -Djava.library.path=build/Default-i386 \ -cp "build/sqlitejdbc-v044-native.jar:build:lib/ junit-4.1.jar" \ org.junit.runner.JUnitCore test.ConnectionTest test.DBMetaDataTest test.PrepStmtTest test.RSMetaDataTest test.StatementTest test.TransactionTest test.UDFTest JUnit version 4.1 .Fatal error 'Recurse on a private mutex.' at line 986 in file /usr/ src/lib/libpthread/thread/thr_mutex.c (errno = 2) Abort trap (core dumped) gmake: *** [test] Error 134 4. Even though tests didn't come off well, the lib was built OK, so I tried it out anyway: [EMAIL PROTECTED] /var/tmp/export]# java -Djava.library.path=. -jar mycandyprogram.jar Segmentation fault: 11 (core dumped) 5. Ufortunately the tests failed for a reason. Can you suggest any possible workaronds? I heard something about some issues with libpthread in FreeBSD, but coulnd't google any quick fix for the problem. Any help is highly appreciated, Ivan --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
