Sqlite on mac

[soerenru...@googlemail.com]

When starting the sqlite db from the 3.6.11.2.jar the database doesnt
start, because the classes from org.ibex.nestedvm, which are
referenced in nestedb.java cannot be found.
In the zentus jdbc driver the ord.ibex files are included and the
database can be started with these drivers.

I thing the org.ibex.nestedvm has to be included in the jar, to make
it start on mac.
Or is there a reason why it isn't included in the jar at the moment?

By the way, the extension functions works great, thanks a lot for that.

[Taro L. Saito]

> I thing the org.ibex.nestedvm has to be included in the jar, to make
it start on mac.

Thank you for your report.

Probably, my Makefile or project file contains some mistakes,
resulting in missing classes.
I will check the problem later.

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

[soerenru...@googlemail.com]

Hi,
just wanted to ask what the status is.
I could help you if you like and put the files together that need to
be in the jar.

Thx
Sören

On Apr 27, 4:30 pm, "Taro L. Saito" <l...@xerial.org> wrote:
> > I thing the org.ibex.nestedvm has to be included in the jar, to make
>
> it start on mac.
>
> Thank you for your report.
>
> Probably, my Makefile or project file contains some mistakes,
> resulting in missing classes.
> I will check the problem later.
>
> --
> Taro L. Saito
> <l...@xerial.org>

> University of Tokyohttp://www.xerial.org/leo
> Tel. +81-47-136-4065 (64065)
>
> On Mon, Apr 27, 2009 at 11:20 PM, soerenruttkow...@googlemail.com

[Taro L. Saito]

I fixed this problem in sqlite-jdbc 3.6.13 release.

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

[soerenru...@googlemail.com]

Hi,
the changes didn't solve the whole problem.
When using the sqlite jdbc on mac, the following error occures:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at org.sqlite.NestedDB$CausedSQLException.fillInStackTrace
(NestedDB.java:667)
at java.lang.Throwable.<init>(Throwable.java:181)
at java.lang.Exception.<init>(Exception.java:29)
at java.sql.SQLException.<init>(SQLException.java:122)
at org.sqlite.NestedDB$CausedSQLException.<init>(NestedDB.java:
643)
at org.sqlite.NestedDB.call(NestedDB.java:573)
at org.sqlite.NestedDB.call(NestedDB.java:535)
at org.sqlite.NestedDB.enable_load_extension(NestedDB.java:116)
at org.sqlite.Conn.<init>(Conn.java:55)
at org.sqlite.JDBC.connect(JDBC.java:86)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)

I debugged the NestedVm as well as the NestedDB.java and when calling
the Runtime.call(String, int[]) method, the function lookupSymbol on
an Hashtable is called.
In this Hashtable there are lots of functions with the corresponding
functionnumber like "sqlite3_result_error16=652800, null,
getsockopt=111104".
The sqlite3_enable_load_extension is not in the Hastable.

I didn't really understand, how the hashtable is build, so i don't
know why the function can not be resolved to its number, but in this
case a CallException is thrown and the sqlite doesn't start.
Do you know where the problem is?

Hope you can save us again :)

Sören

On May 4, 4:03 pm, "Taro L. Saito" <l...@xerial.org> wrote:
> I fixed this problem in sqlite-jdbc 3.6.13 release.
>
> --
> Taro L. Saito
> <l...@xerial.org>

> University of Tokyohttp://www.xerial.org/leo
> Tel. +81-47-136-4065 (64065)
>

> On Mon, May 4, 2009 at 9:22 PM, soerenruttkow...@googlemail.com

[leo]

sqlite3_enable_load_extension, which is not supported in pure-java
mode, was wrongly called
upon establishing a connection. This bug was not specific to Mac.

I fixed this problem in sqlite-jdbc-3.6.13.1
http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.13.1/



On May 6, 7:08 pm, "soerenruttkow...@googlemail.com"

[cbare]

For what it's worth, I downloaded the binary distribution of sqlite-
jdbc-3.6.14.2 and it works for me on OS X in both Java1.5 (in native
mode) and Java6 (in pure mode). I'm trying to compile the JNI code for
64-bit Java 6. (Works meaning, sample code runs without errors.)

-chris

On May 6, 6:45 pm, leo <l...@xerial.org> wrote:
> sqlite3_enable_load_extension, which is not supported in pure-java
> mode, was wrongly called
> upon establishing a connection. This bug was not specific to Mac.
>

> I fixed this problem in sqlite-jdbc-3.6.13.1http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdb...