> thanks a lot, > but about the second question,I write java code,and find if the connection > exceeds 17990,then will throws exception
This probably happened because your OS restricts number of open file descriptors or something like that. Pavel On Sat, Sep 1, 2012 at 7:52 PM, <shuif...@mail.ustc.edu.cn> wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users