Re: [sqlite] PRAGMA database_list: insert into table?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/26/2010 12:17 PM, Tim Romano wrote: > But Roger, the "layer sitting in front of SQLite" is a programming > environment which provides its own (black-box) connectivity to SQLite, and > it isn't going to be calling any DLL into which one will

Re: [sqlite] PRAGMA database_list: insert into table?

>But Roger, the "layer sitting in front of SQLite" is a programming >environment which provides its own (black-box) connectivity to SQLite, and >it isn't going to be calling any DLL into which one will have injected >a UDF >library in the manner you have laid out, and it's not going to let the

Re: [sqlite] PRAGMA database_list: insert into table?

But Roger, the "layer sitting in front of SQLite" is a programming environment which provides its own (black-box) connectivity to SQLite, and it isn't going to be calling any DLL into which one will have injected a UDF library in the manner you have laid out, and it's not going to let the

Re: [sqlite] using sqlitejdbc-v056 with ant build file

Thank you for helping me get this information. Kyle Kimberley Software Engineer 919-474-6041 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Monday, July 26, 2010 1:02 PM To: General Discussion of SQLite

Re: [sqlite] poor insert performance with 3.7/Windows

I've not seen the performance degradation you've reported here in my testing. If you could provide any more details that would help in reproducing this, it would be appreciated. And yes, you can safely modify the SQLITE_FCNTL_SIZE_HINT in os_win.c to be a "no-op" in the same way as os_unix.c.

Re: [sqlite] using sqlitejdbc-v056 with ant build file

http://lmgtfy.com/?q=sqlitejdbc-v056=1 It looks like official site of the driver with the link to appropriate mailing list. Pavel On Mon, Jul 26, 2010 at 12:56 PM, wrote: > Thanks for the clarification.  Do you know who the author of the jdbc driver > is?

Re: [sqlite] using sqlitejdbc-v056 with ant build file

Thanks for the clarification. Do you know who the author of the jdbc driver is? Kyle Kimberley Software Engineer 919-474-6041 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Monday, July 26, 2010 12:38

Re: [sqlite] using sqlitejdbc-v056 with ant build file

> I'll ask directly to SQLite support and see if I can get an answer. I hope you meant SQLite JDBC support, because SQLite support itself is here. And we can't tell anything about JDBC implementation unless its author is reading this. Pavel On Mon, Jul 26, 2010 at 12:22 PM,

Re: [sqlite] using sqlitejdbc-v056 with ant build file

Hi Pavel, I'm thinking the same thing - probably some kind of defect or, at this version, the driver doesn't implement not returning a recordset. I'll ask directly to SQLite support and see if I can get an answer. Thanks Kyle Kimberley -Original Message- From:

Re: [sqlite] PRAGMA database_list: insert into table?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/26/2010 06:03 AM, Tim Romano wrote: > The goal is to expose the UDF to the "layer sitting in front". Are you > saying sqlite3_auto_extension allows me to run a program, once, that will > register a piece of code that is loaded whenever ANY

Re: [sqlite] using sqlitejdbc-v056 with ant build file

> I'd still like > to know what I can pass to the jdbc driver to make it know I don't > expect a recordset.  I haven't found any information on this.  Since According to documentation on Ant's sql task you don't have to show it explicitly whether you expect recordset to be returned or not. So

Re: [sqlite] using sqlitejdbc-v056 with ant build file

Hi Swithum, Ant is talking directly to the jdbc driver. I figured out how to make the ant exec task work for me. I'd still like to know what I can pass to the jdbc driver to make it know I don't expect a recordset. I haven't found any information on this. Since none of the statements are

Re: [sqlite] using sqlitejdbc-v056 with ant build file

Hello > When I run a script, using sqlitejdbc-v056, with DROP, CREATE, and > INSERT statements I get this error message "java.sql.SQLException: no > ResultSet available". The statement actually is successful as the data > does appear in the database. It will be something to do with these

Re: [sqlite] using sqlitejdbc-v056 with ant build file

I figured out the problem with using the exec task and the slashes being removed. Because I am passing the directory where the sql script exists to SQLite3 in the dir property, I was able to just give the name of the file, without the path, as the second argument, and the build succeeded. I'm

[sqlite] Auto Reply: Re: Memory leak in sqlite 3.7.0

I will be out of the office starting July 26th on medical leave and generally unreachable. For all issues please contact my manager, Dave Segleau , for help during this time. apologies I hope to be back soon, -greg ___

Re: [sqlite] Memory leak in sqlite 3.7.0

What do you get when you run: ./testfixture test/permutations.test journaltest test/memsubsys2.test ./testfixture test/permutations.test inmemory_journal test/memsubsys2.test On Mon, Jul 26, 2010 at 9:47 AM, Andy Gibbs wrote: > Hi, > > I'm afraid I believe I

[sqlite] Auto Reply: Auto Reply: using sqlitejdbc-v056 with ant build file

I will be out of the office starting July 26th on medical leave and generally unreachable. For all issues please contact my manager, Dave Segleau , for help during this time. apologies I hope to be back soon, -greg ___

[sqlite] Auto Reply: using sqlitejdbc-v056 with ant build file

I will be out of the office starting July 26th on medical leave and generally unreachable. For all issues please contact my manager, Dave Segleau , for help during this time. apologies I hope to be back soon, -greg ___

[sqlite] using sqlitejdbc-v056 with ant build file

When I run a script, using sqlitejdbc-v056, with DROP, CREATE, and INSERT statements I get this error message "java.sql.SQLException: no ResultSet available". The statement actually is successful as the data does appear in the database. I'm able to get the script to continue by including the

[sqlite] Memory leak in sqlite 3.7.0

Hi, I'm afraid I believe I have observed a memory leak when running the full test suite that is part of sqlite 3.7.0. I have a log file generated from running the test suite which I can send if it is of interest to the developers - it is 5Mb compressed so I didn't think it fair to just post

Re: [sqlite] PRAGMA database_list: insert into table?

Since this discussion might help the OP too, I hope it's not regarded as a thread hijack. I will create a new thread otherwise. Mr. v3meo, your thoughts? A question about this advice: "If the layer sitting in front of SQLite doesn't expose create function then you can still do so. Load the

Re: [sqlite] Problems with 'make test' on 3.7.0

On Friday, July 23, 2010 1:26 PM, Richard Hipp wrote: > You need TCL 8.5 or (even better) 8.6. TCL 8.4 is not adequate > to run the newer parts of the test suite. Again, thank you for your quick response. Please can I suggest that the configure scripts be updated to reflect this change in