[sqlite] Usign sqlite as user authentication JDBC Realm in tomcat 7

2014-05-20 Thread Mario Emmanuel
Dear all, I would like to know if it would be possible to use sqlite3 as db with JDBC Realm authentication in tomcat 7. If so, any configuration example would be really welcomed. I have found  contradictory information on the net (web sites where people say that it can be done and web sites wh

Re: [sqlite] Regarding SQLITE installation

2014-04-18 Thread DELOGET, Emmanuel
convenience… > > Regards, > Nitin BR, -- Emmanuel Deloget ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is it guaranteed that aggregate functions access tables sequentially?

2012-03-07 Thread Emmanuel MacCaull
e to assume that the aggregate will access each row in order? Thank you, Emmanuel MacCaull Software Developer Research In Motion Limited - This transmission (including any attachments) may contain confidential information,

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy > Are you using synchronous=NORMAL or synchronous=FULL? When opening the database, in sqlite3PagerSetSafetyLevel(), I get: level:3, noSync:0, fullSync:1, sync_flags:2 > What does sqlite3_vfs_f

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin > Sorry to say that this subject is one where the longer you spend looking at > it the more annoying it gets. You are not annoying me at all! ;-) > You either have storage devices which supp

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin > > That's the usual scenario with spinning media. I'm less familiar with the > > internal workings of flash memory controllers. But people tell me that they > > fail in similar ways. > > Yes

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
> From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy > > Can you post the hex of the first 28 bytes of the journal > file? 000 d5d9 f905 a120 d763 0400 a15c eae6 010 6300 0002 0004 020

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin > Can I ask where a power failure or a crash is involved in your finding at all > ? > Or is the corruption found when programs have only ever run as designed with

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Stephan Beal > seek() allows one to seek past the end of the file, so the problem is not > with seek (unless sqlite3's VFS interface castrates it), but probably a > follow-up read() after the seek. It is pe

Re: [sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
can do to work around it. Other database engines have also run into this same problem." Emmanuel. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, September 20, 2011 2:08 PM To: General Discu

[sqlite] Disk I/O Error on Ext3/write-back/barrier FS.

2011-09-20 Thread Berthier, Emmanuel
is 1024B, is-it necessary to patch Sqlite to use this size instead of 512? NB2: I will switch Ext3 FS to "ordered" mode, without being sure it will solve the issue. Thanks, Emmanuel BERTHIER Intel. - Intel

[sqlite] NFS SQLITE problem

2008-03-12 Thread William Emmanuel S. Yu
sqlite3 from source. Thanks. -- --- William Emmanuel S. Yu (杨怀义) Department of Information Systems and Computer Science Ateneo de Manila University email : wyu at ateneo dot edu blog : http://hip2b2.yutivo.org/ web: http://CNG.ateneo.edu/cng/wyu/ phone : +63(2)4266001 loc. 4186 GPG: http://C

Re: [sqlite] String --> Integer date formatting

2006-11-07 Thread Emmanuel
Dennis Cote wrote: > Emmanuel, > > Check out the functions on this page > http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions > > In particular the function julianday(datestring) will return a julian > day number for a suitably formatted date string. The supported date &

[sqlite] String --> Integer date formatting

2006-11-06 Thread Emmanuel
Hello, I am using SQLite as part of Trac (http://trac.edgewall.com/) to generate reports on our ticket system. I have normal date fields (stored as an integer, and easily manipulated with date(), strftime(), etc.) I have one extra field that contains a date but is stored as a DD/MM/ string.