thanks a lot, 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 SQLite.MyDay.main(MyDay.java:20) Exception in thread "main" java.lang.OutOfMemoryError: unable to get SQLite handle at SQLite.Database._open4(Native Method) at SQLite.Database.open(Database.java:37) at SQLite.MyDay.main(MyDay.java:20)
the source java code: public static void main(String[] args) { // TODO Auto-generated method stub int count=0; while(count<=17990){ Database db = new Database(); try { // open connection,but not close db.open("c:\\my1.db", 0666); count++; db.interrupt(); db.busy_timeout(1000); db.busy_handler(null); } catch (Exception e) { 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" <sqlite-users@sqlite.org> > Cc: > Subject: Re: [sqlite] some questions about sqlite > > On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin <slav...@bigfraud.org> 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, > >> what => 'prc_g_test;', > >> next_date => to_date('22-10-2008 10:06:41', > >> 'dd-mm-yyyy hh24:mi:ss'), > >> interval => > >> 'sysdate+1/1440');--每天1440分钟,即一分钟运行test过程一次 > >> commit; > >> end; > > > > No. > > > >> 2、how many user connections the sqlite can handler > > > > There is no limit in SQLite for connections. > > It is not advised to have multiple processes connect to same file. .. > but in-process probably no limit of connections. > > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users