> 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

Reply via email to