Re: [sqlite] JDBC driver experience

[Doug White]

This writing is 4/22/2018.
I have been playing with the latest connect/j for android java downloaded
from Oracle's web site and have had no luck getting it to connect to the
latest Community version of MySQL on Windows 10 using Oracles example java
code... then I found an example that someone posted that does all of the
java calls from within a java thread and it works perfectly on several
types of SQL calls that I added to the code. As soon as I try to
incorporate the same code outside of a thread it won't connect. Has anyone
else had similar problems, solutions or ideas about what may be causing the
problem.  A working android studio code example would be wonderful to
analyze.
Doug White
dglsn...@gmail.com

On Apr 22, 2018 12:42 PM, "Seiji Amalai"  wrote:

no


On Wed, Apr 18, 2018 at 8:34 PM, Richard Hipp  wrote:

> Are you using SQLite with JDBC?  If so, can you please answer a few
> questions below?
>
> You can post on this mailing list or send your reply directly to me.
>
> 1. Which JDBC are you using?
> 2. For how long have you been using it?
> 3. What issues you had with this driver?
> 4. What advise do you have for avoiding problems in this driver?
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] JDBC driver experience

[Gerry Snyder]

1.  I use an old version of xerial with Aejaks for an on-line voting system.
2.  I started around 2010, and updated only once, in order to get the
backup command (greatly simplifying my process).
3.  My only issue is paranoia about breaking something, which keeps me from
doing further updates.
4.  None. After learning how to use it I have had no problems.

Gerry Snyder

On Wed, Apr 18, 2018 at 12:34 PM, Richard Hipp  wrote:

> Are you using SQLite with JDBC?  If so, can you please answer a few
> questions below?
>
> You can post on this mailing list or send your reply directly to me.
>
> 1. Which JDBC are you using?
> 2. For how long have you been using it?
> 3. What issues you had with this driver?
> 4. What advise do you have for avoiding problems in this driver?
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] JDBC driver experience

[Seiji Amalai]

no

On Wed, Apr 18, 2018 at 8:34 PM, Richard Hipp  wrote:

> Are you using SQLite with JDBC?  If so, can you please answer a few
> questions below?
>
> You can post on this mailing list or send your reply directly to me.
>
> 1. Which JDBC are you using?
> 2. For how long have you been using it?
> 3. What issues you had with this driver?
> 4. What advise do you have for avoiding problems in this driver?
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

[Seiji Amalai]

nope

On Tue, Apr 17, 2018 at 10:39 PM, Simon Slavin  wrote:

> Dear list-posters,
>
> Are you getting a new dating-spam each time you post to this list ?  If
> you are, please post a brief follow-up to this message.  Please do /not/
> include any details about the spam, its headers, or the person it's
> apparently from.  Just a "me too" until I say I have seen enough responses.
>
> I'm trying to work out if I personally am being targeted or whether it's
> being sent to everyone who posts here.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] JDBC driver experience

[Sylvain Pointeau]

Hi,

Le mer. 18 avr. 2018 à 21:34, Richard Hipp  a écrit :

> Are you using SQLite with JDBC?  If so, can you please answer a few
> questions below?
>
> You can post on this mailing list or send your reply directly to me.
>
> 1. Which JDBC are you using?


I am using xerial and one from Christian Werner

>
> 2. For how long have you been using it?


since 3 years ago when I migrated to sqlite from H2

>
> 3. What issues you had with this driver?


the xerial is almost up to date with frequent release so ready to use.
(intellij uses xerial when querying a sqlite db)
however it does not give the possibility to use the SSE encryption module
and it found it impossible to compile myself.

when I though I will need to encrypt the database, I looked at the lib from
Christian Werner.
With his help I succeeded to compile it for mingw32 for windows (I then
proposed a CMake file to compile it cross plateform so easy to use the
latest sqlite release). At the end, I did not buy the SSE but I am happy
about my journey.


> 4. What advise do you have for avoiding problems in this driver?


I did not have issues with both of these driver. I trend to like more the
one from Christian Werner since I can compile it and use the most recent
sqlite version, as well as the option for the SSE (that I may buy one day)

Best regards,
Sylvain


>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users