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" <[email protected]>
> Sent Time: 2012-9-2 10:37:04
> To: "General Discussion of SQLite Database" <[email protected]>
> Cc:
> Subject: Re: [sqlite] some questions about sqlite
>
> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin <[email protected]> wrote:
> >
> > On 2 Sep 2012, at 3:13am, [email protected] 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
> > [email protected]
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
