Re: [sqlite] Unable to make SQLite working with Java

OK, I found the solution for Jython. I must list my jars in CLASSPATH and not in JYTHONPATH. I don't have to copy my native library to /usr/lib if I point to them using the Java system property java.library.path. :-) 2010/11/29 Pierre Thibault > I am able to do

Re: [sqlite] Unable to make SQLite working with Java

I am able to do System.loadLibrary("sqlite_jni") in my Jython script so it seems the problem is more with Jython itself. I am progressing. I have this error instead: java.sql.SQLException: java.sql.SQLException: No suitable driver found for

Re: [sqlite] Unable to make SQLite working with Java

2010/11/28 Timothy A. Sawyer > Not knowing much about your specific environment, wouldn't it be easier to > just do what you need to do in Java without having to use C? > > The point of all this is trying to use web2py, a Python web framework, with the Jython

Re: [sqlite] Unable to make SQLite working with Java

2010/11/28 Timothy A. Sawyer > Check the LD_LIBRARY_PATH variable and make sure that /usr/local/lib is in > the path. > > LD_LIBRARY_PATH is a awful solution. It is not working any better when I do export LD_LIBRARY_PATH=/usr/local/lib. Putting /usr/local/lib in the

Re: [sqlite] Unable to make SQLite working with Java

Not knowing much about your specific environment, wouldn't it be easier to just do what you need to do in Java without having to use C? --Original Message-- From: Pierre Thibault Sender: sqlite-users-boun...@sqlite.org To: sqlite-users@sqlite.org ReplyTo: General Discussion of SQLite

Re: [sqlite] Unable to make SQLite working with Java

Check the LD_LIBRARY_PATH variable and make sure that /usr/local/lib is in the path. --Original Message-- From: Pierre Thibault Sender: sqlite-users-boun...@sqlite.org To: sqlite-users@sqlite.org ReplyTo: General Discussion of SQLite Database Subject: Re: [sqlite] Unable to make SQLite

Re: [sqlite] Unable to make SQLite working with Java

Hello, I found that copying the library, libsqlite_jna.so and libsqlite_jna.la, from /usr/local/lib to /usr/lib solve the problem. I don't why but it works. :-) 2010/11/28 Pierre Thibault > Hello, > > I am unable to access an sqlite file in Groovy: > > import

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 28, 2010, at 6:19 PM, Rick Regan wrote: > On Sun, Nov 28, 2010 at 5:52 PM, Doug Currie wrote: > >> >> There is a new publication on this subject that may be of interest to those >> looking at providing solutions: >> >>

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Sun, Nov 28, 2010 at 5:52 PM, Doug Currie wrote: > > There is a new publication on this subject that may be of interest to those > looking at providing solutions: > > http://portal.acm.org/citation.cfm?id=1806623 > > It (Grisu2) works without bignums if you are willing

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 28, 2010, at 5:37 PM, Rick Regan wrote: > On Sun, Nov 28, 2010 at 4:01 PM, Doug Currie wrote: > >> On Nov 28, 2010, at 11:18 AM, Rick Regan wrote: >> >>> Michael, >>> Thanks for the very thorough analysis. >> >> This is a difficult problem; fortunately it was

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Sun, Nov 28, 2010 at 4:01 PM, Doug Currie wrote: > On Nov 28, 2010, at 11:18 AM, Rick Regan wrote: > > > Michael, > > Thanks for the very thorough analysis. > > This is a difficult problem; fortunately it was solved 20 years ago... > > Well, it's not solved on Windows.

Re: [sqlite] Multilingual query

Both answer was great, thanks a lot for your help Igor and Michael. Regards, and thanks again Date: Wed, 24 Nov 2010 07:10:58 -0600 From: michael.bla...@ngc.com To: sqlite-users@sqlite.org Subject: Re: [sqlite] Multilingual query Depends on what he means by "first". If alphabetically Igor's

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 28, 2010, at 11:18 AM, Rick Regan wrote: > Michael, > Thanks for the very thorough analysis. This is a difficult problem; fortunately it was solved 20 years ago... http://www.mail-archive.com/sqlite-users@sqlite.org/msg09529.html e ___

Re: [sqlite] cascade-delete doesn't seem to work

On 28 Nov 2010, at 5:51pm, Chris Wolf wrote: > Simon Slavin wrote: >> Which version of SQLite are you using ? > > It's 3.7.3 on MacOs 10.5 but I have two versions on my Mac - 3.4.0 > which comes out-of-the > box and a dev version I'm hacking around with, 3.7.3. I just forgot to > qualify the

Re: [sqlite] cascade-delete doesn't seem to work

Simon Slavin wrote: > On 28 Nov 2010, at 4:23pm, Chris Wolf wrote: > > >> Unfortunately, it's not deleting the child records. >> > > Which version of SQLite are you using ? > It's 3.7.3 on MacOs 10.5 but I have two versions on my Mac - 3.4.0 which comes out-of-the box and a dev

Re: [sqlite] cascade-delete doesn't seem to work

On 28 Nov 2010, at 4:23pm, Chris Wolf wrote: > Unfortunately, it's not deleting the child records. Which version of SQLite are you using ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Some floats of 15 digits or less do not round-trip

BTW, I get the CORRECT result when running the precompiled command line on Linux: SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t1(d float); sqlite> insert into t1 values(8.948471e15); sqlite> select * from t1; 8.948471e+15

[sqlite] cascade-delete doesn't seem to work

I am trying to get child records to automatically delete upon deletion of their parent record, as described here: http://www.sqlite.org/foreignkeys.html#fk_actions Unfortunately, it's not deleting the child records. Either with pragma foreign_keys on or off. Thanks for any help, -Chris

Re: [sqlite] Some floats of 15 digits or less do not round-trip

Michael, Thanks for the very thorough analysis. Yes, sorry, I forgot to state I was running on Windows. The results I got came from running the command window (the precompiled Windows binary sqlite-3_7_3.zip). I also got the same results from compiling the amalgamation

Re: [sqlite] Some floats of 15 digits or less do not round-trip

There's a difference between GCC and MS Visual Studio 2008 Express. GCC works fine. But Visual Studio shows this problem. The difference comes in this section of code where the rounding error during computation is different. if( realvalue>0.0 ){ while( realvalue>=1e32 && exp<=350 ){

Re: [sqlite] Question

Quoth Jason Dixon , on 2010-11-27 15:31:37 -0600: > I was curious if there is a way to find out the cell number that a > particular SMS file is from once I have identified the file in the backup > folder on my computer. This doesn't have anything directly to do with

[sqlite] Question

Hello, I was curious if there is a way to find out the cell number that a particular SMS file is from once I have identified the file in the backup folder on my computer. Thank you so much. Best, Jason A. Dixon, MBA Cell: 972.207.5118 ___

Re: [sqlite] WAL file size

Hi, > For a large scale system you have a third choice: use some other RDBMS > which is implemented in one process and has a much better control over > its data and much better communication between readers and writers. Well, I love sqlite, and I want to continue using it (small, fast,

[sqlite] Unable to make SQLite working with Java

Hello, I am unable to access an sqlite file in Groovy: import java.sql.DriverManager driverManager = Class.forName("java.sql.DriverManager").newInstance(); //Class.forName("org.sqlite.JDBC").newInstance(); // SQLite.JDBCDriver org.sqlite.JDBC print