AW: Issue with sql task accessing MySql

2019-08-31 Thread jhm
19 16:04 > An: user@ant.apache.org > Betreff: Re: Issue with sql task accessing MySql > > Just to get the solution documented this thread, here's what I did. > This is a winders 7 machine running ant in cygwin. The ant call: > >value="update_build_tabl

Re: Issue with sql task accessing MySql

2019-08-29 Thread Eric Fetzer
Just to get the solution documented this thread, here's what I did.  This is a winders 7 machine running ant in cygwin.  The ant call:                                                         The bash script: #!/usr/bin/bash# ssh myUser@myMachine "mysql -u mySqlUser -pmySqlPassword mySqlDB -e

Re: Issue with sql task accessing MySql

2019-08-29 Thread Eric Fetzer
Thanks Stefan!  Took the easy path and outsourced the update to a simple bash script that ssh's to the MySql Server and runs the SProc there.  Thanks for all your help! On Wednesday, August 28, 2019, 04:02:17 PM EDT, Stefan Bodewig wrote: On 2019-08-28, Eric Fetzer wrote: >  Is there

Re: Issue with sql task accessing MySql

2019-08-28 Thread Stefan Bodewig
On 2019-08-28, Eric Fetzer wrote: > Is there a way to set that version JUST for this call? I'm afraid there is no way to run the task in a different JVM than the rest of Ant. Judging from https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-versions.html your MySQL Connector requires Java8

Re: Issue with sql task accessing MySql

2019-08-28 Thread Eric Fetzer
Also, any clue what version of Java do I need to use with this?  1.8? On Wednesday, August 28, 2019, 12:57:34 PM MDT, Eric Fetzer wrote: Is there a way to set that version JUST for this call?  We're building a legacy application here that CANNOT upgrade to a newer version of Java... 

Re: Issue with sql task accessing MySql

2019-08-28 Thread Eric Fetzer
Is there a way to set that version JUST for this call?  We're building a legacy application here that CANNOT upgrade to a newer version of Java...  Thanks! On Wednesday, August 28, 2019, 12:28:55 PM MDT, Stefan Bodewig wrote: On 2019-08-28, Eric Fetzer wrote: >  Thanks Stefan, a bit

Re: Issue with sql task accessing MySql

2019-08-28 Thread Stefan Bodewig
On 2019-08-28, Eric Fetzer wrote: > Thanks Stefan, a bit better: > $ ant -f test.xmlBuildfile: test.xml > main: > BUILD FAILEDc:\BuildDeployScripts\test.xml:22: > java.lang.UnsupportedClassVersionError: (com/mysql/jdbc/Driver) bad major > version at offset=6 > Total time: 0 seconds You are run

Re: Issue with sql task accessing MySql

2019-08-28 Thread Eric Fetzer
Thanks Stefan, a bit better: $ ant -f test.xmlBuildfile: test.xml main: BUILD FAILEDc:\BuildDeployScripts\test.xml:22: java.lang.UnsupportedClassVersionError: (com/mysql/jdbc/Driver) bad major version at offset=6 Total time: 0 seconds On Wednesday, August 28, 2019, 10:49:54 AM MDT, Stefan B

Re: Issue with sql task accessing MySql

2019-08-28 Thread Stefan Bodewig
On 2019-08-28, Eric Fetzer wrote: > The MySql server I'm accessing upgraded to version 8.0.17: > So, accordingly, I downloaded the proper driver and linked to it in my task: > > BUILD FAILEDc:\BuildDeployScripts\test.xml:22: > com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Cl

Issue with sql task accessing MySql

2019-08-28 Thread Eric Fetzer
The MySql server I'm accessing upgraded to version 8.0.17: mysql> select version();+---+| version() |+---+| 8.0.17    |+---+1 row in set (0.00 sec) So, accordingly, I downloaded the proper driver and linked to it in my task: