Re: [sqlite] some questions about sqlite

2012-09-02 Thread Jay A. Kreibich
On Sat, Sep 01, 2012 at 11:56:33PM -0700, J Decker scratched on the wall: > On Sat, Sep 1, 2012 at 8:24 PM, Jay A. Kreibich wrote: > > On Sat, Sep 01, 2012 at 07:37:04PM -0700, J Decker scratched on the wall: > >> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin

Re: [sqlite] some questions about sqlite

2012-09-02 Thread Keith Medcalf
> but about the second question，I write java code，and find if the connection > exceeds 17990，then will throws exception > SQLite.Exception: unknown error in open > at SQLite.Database._open4(Native Method) > at SQLite.Database.open(Database.java:37) > at

Re: [sqlite] some questions about sqlite

2012-09-02 Thread Simon Slavin
On 2 Sep 2012, at 7:56am, J Decker wrote: > the point would be 'and not have concurrancy issues that I'd have to > solve myself...' Apache runs one process for each request it's serving [1]. I have multiple Apache processes -- i.e. multiple web page requests -- accessing

Re: [sqlite] some questions about sqlite

2012-09-02 Thread J Decker
On Sat, Sep 1, 2012 at 8:24 PM, Jay A. Kreibich wrote: > On Sat, Sep 01, 2012 at 07:37:04PM -0700, J Decker scratched on the wall: >> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin wrote: >> > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote: > >> >>

Re: [sqlite] some questions about sqlite

2012-09-01 Thread Pavel Ivanov
-Original E-mail- >> From: "J Decker" <d3c...@gmail.com> >> Sent Time: 2012-9-2 10:37:04 >> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> >> Cc: >> Subject: Re: [sqlite] some questions about

Re: [sqlite] some questions about sqlite

2012-09-01 Thread Jay A. Kreibich
On Sat, Sep 01, 2012 at 07:37:04PM -0700, J Decker scratched on the wall: > On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin wrote: > > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote: > >> 2??how many user connections the sqlite can handler > > > > There is no limit

Re: [sqlite] some questions about sqlite

2012-09-01 Thread shuifeng
e.printStackTrace(); } } System.out.println(count); } > -Original E-mail- > From: "J Decker" <d3c...@gmail.com> > Sent Time: 2012-9-2 10:37:04 > To: "General Discussion of SQLite Database"

Re: [sqlite] some questions about sqlite

2012-09-01 Thread J Decker
On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin wrote: > > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote: > >> 1、Do the sqlite support job like oracle or sqlserver,such as >>variable job1 number; >>begin >>sys.dbms_job.submit(job => :job, >>

Re: [sqlite] some questions about sqlite

2012-09-01 Thread Simon Slavin
On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote: > 1、Do the sqlite support job like oracle or sqlserver,such as >variable job1 number; >begin >sys.dbms_job.submit(job => :job, >what => 'prc_g_test;', >