Re: SQL Error on fetch

2020-02-11 Thread Gino Pacitti via Webobjects-dev
Yes... what I meant to say was that I upgraded to a new connector and using that new class path seemed to work better... Gino > On 11 Feb 2020, at 02:41, Tim W wrote: > > Hi Gino: > > Were you not specifying the database driver class in Properties before this? > Driver class and PlugIn

Re: SQL Error on fetch

2020-02-10 Thread Tim W via Webobjects-dev
Hi Gino: Were you not specifying the database driver class in Properties before this? Driver class and PlugIn class definitely should always be specified. Tim > On Feb 10, 2020, at 5:37 AM, Gino Pacitti via Webobjects-dev > wrote: > > What seems to have fixed is adding this in my

Re: SQL Error on fetch

2020-02-10 Thread Gino Pacitti via Webobjects-dev
What seems to have fixed is adding this in my properties file for the connection dictionary: mymodel.DBDriver = com.mysql.cj.jdbc.Driver I installed the latest JDBC adaptor from MySQL and updated the Drive info… The last few days I have had no issues… Gino > On 7 Feb 2020, at 17:36, Tim W

Re: SQL Error on fetch

2020-02-07 Thread Tim W via Webobjects-dev
Hi Gino: I think I might have seen this error when the MySQLPlugin is not in the app classpath? In other words, some SQL that the frameworks are trying to build for a transaction are subsequently not being customized properly for MySQL before being sent to the DB. The errors makes sense in

Re: SQL Error on fetch

2020-02-04 Thread Jesse Tayler via Webobjects-dev
Isn’t that just when the adaptor needs to reconnect after a period of rest? > On Feb 4, 2020, at 4:00 PM, Gino Pacitti via Webobjects-dev > wrote: > > Hi > Has anyone encountered this sort of error before? > > It does not happen all the time but just on occasion. > > mysql Ver 14.14

Re: SQL Error on fetch

2020-02-04 Thread OCsite via Webobjects-dev
Gino, I can be completely wrong, but it looks like two problem logs interspersed, which stinks by a threading issue, along with the fact it happens intermittently. If possible, I'd check race conditions and try to synchronize (or lock) where needed. Quite possibly someone other would give a

SQL Error on fetch

2020-02-04 Thread Gino Pacitti via Webobjects-dev
Hi Has anyone encountered this sort of error before? It does not happen all the time but just on occasion. mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper Java 8 mysql-connector-java-8.0.19.jar This is my connection URL