Issue with sql task accessing MySql
Eric Fetzer <[email protected]> Wed, 28 Aug 2019 16:02:05 +0000 (UTC)
| Newsgroups | gmane.comp.jakarta.ant.user |
|---|---|
| Message-ID | <[email protected]> |
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:
<sql driver="com.mysql.jdbc.Driver" url="jdbc:mysql://myServerName.myDomain:3306/myDB" userid="myUser" password="myPassword"> <classpath> <pathelement path="c:/apache-ant-1.7.0/lib/mysql-connector-java-8.0.17.jar"/> </classpath> CALL sp_setBuildStatus('${pk_build}','${full.buildnumber}-${build-time}','${result}'); </sql>
Seems I did the right thing, but still getting the error when I attempt to call this Stored Procedure:
$ ant -f test.xmlBuildfile: test.xml
main:
BUILD FAILEDc:\BuildDeployScripts\test.xml:22: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Total time: 1 second
Anyone have any idea what I'm running into here?
Thanks,Eric