On Aug 22, 6:45 pm, Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- sakya <[EMAIL PROTECTED]> wrote:
> > There weren't any crashes 'till now *fingerscrossed*, so I haven't
> > tried your patche(s) yet.
>
> If you have not changed any code or jars, it will crash again.
> It's just a matter of time.
I've changed my code to only perform one prepared statement per
connection so maybe that bypasses the problem.
As you touch upon: in a former version I submitted the "BEGIN
TRANSACTION" and "COMMIT" before and after the loop via
'prep.execute()' (and not by setAutocommit and commit as I do now).
Could that have been a major problem (as there it used to crash often
and seems to be better now)?
> > One more question: I'm deleveloping with MacOS and using Windows only
> > for testing purposes without any compilers installed.
> > Would there be a way to patch the java code and build the .jar for the
> > windows sqlitejdbc.dll from my MacOS engine?
>
> The dll/so/dynlib files will remain the same in this case, as no C code
> has changed with those patches. You can build the jar file on any OS,
> as it contains no platform-specific code, and is the same on all platforms.
>
> The easiest way to build it is just to grab the v036 source tar ball,
> untar it, apply the patch(es) and just type "make".
Good to know, I'll try that at the weekend.
Thx again for your support!!
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---