java (small code) less than 100 lines errors "help"
Budget: $10 – $30 USD
PLEASE NOTE: HERE IS THE task
-------------------------------------------------------
These commands do not work in a script
Please note I have insRecord.java and getRecord.java and seems the errors suggest mysql needs update (already done)
mysql --version
mysql Ver 8.0.23 for osx10.16 on x86_64 (Homebrew)
mysql connector 8.0.26
repo. https://gitlab.com/advocatediablo/tracking-db-client
➜ tracking-db-client git:(main) ✗ insRecord 55 TAXING_1.2.3.4 APACHE pvcsusr TAXING /VOL1 EJ
Path: ./xml/config.xml
Debugging output is ON
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at insertRecord.main(insertRecord.java:59)
Exception: com.mysql.jdbc.Driver
➜ tracking-db-client git:(main) ✗ getRecord 55
Path: ./xml/config.xml
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at getRecord.main(getRecord.java:60)
Exception: Client does not support authentication protocol requested by server; consider upgrading MySQL client
➜ tracking-db-client git:(main) ✗
SINCERELY WOULD BE NICE TO MEET YOU PLEASE
------------------------------------------------------------------------------------------------------------------------------------
There is hope you can give your “best” price; unemployed, and have cancer with bills backing up.
My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others.
is $12 possible? if not how much would it really take?
ANY THOUGHTS ? Please note project is due in two hours as this projects deadline, as this is needed if we can get some done - then we can talk about next steps and 5 stars and another job also. If this is a good one and we are "successful"; would need a couple others setup, but will handle one at a time? Can you do this for something reasonable in a couple hours? thoughts ?
-------------------------------------------------------
These commands do not work in a script
Please note I have insRecord.java and getRecord.java and seems the errors suggest mysql needs update (already done)
mysql --version
mysql Ver 8.0.23 for osx10.16 on x86_64 (Homebrew)
mysql connector 8.0.26
repo. https://gitlab.com/advocatediablo/tracking-db-client
➜ tracking-db-client git:(main) ✗ insRecord 55 TAXING_1.2.3.4 APACHE pvcsusr TAXING /VOL1 EJ
Path: ./xml/config.xml
Debugging output is ON
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at insertRecord.main(insertRecord.java:59)
Exception: com.mysql.jdbc.Driver
➜ tracking-db-client git:(main) ✗ getRecord 55
Path: ./xml/config.xml
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at getRecord.main(getRecord.java:60)
Exception: Client does not support authentication protocol requested by server; consider upgrading MySQL client
➜ tracking-db-client git:(main) ✗
SINCERELY WOULD BE NICE TO MEET YOU PLEASE
------------------------------------------------------------------------------------------------------------------------------------
There is hope you can give your “best” price; unemployed, and have cancer with bills backing up.
My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others.
is $12 possible? if not how much would it really take?
ANY THOUGHTS ? Please note project is due in two hours as this projects deadline, as this is needed if we can get some done - then we can talk about next steps and 5 stars and another job also. If this is a good one and we are "successful"; would need a couple others setup, but will handle one at a time? Can you do this for something reasonable in a couple hours? thoughts ?
Related categories:
Business, Accounting, Human Resources & Legal
Python
Linux
Docker
Bash Scripting