> 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
