• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempt

 
Ranch Hand
Posts: 422
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have a perl program that uses the same environment variables as my groovy code below and successfully displays the result from gov_unit.
So I know that the server is running, the IP address is correct, the table name and database name are correct and the user name/password are correct. However, when I run the following groovy program
it throws the exception:

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 10 times. Giving up.



I'm using groovy console 4.0.0.-alpha 1. Switching to Groovy 3.0.4 or 3.0.2 yields the same results...
I'm using Windows MySQL server 8.0.17-winx64 which was unzipped (instead of installed).
I could not find any config files like my.ini to experiment with changing the bind address.... However, since perl works, this should not be a problem.

Thanks

Siegfried
 
Siegfried Heintze
Ranch Hand
Posts: 422
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Wow! This is very strange...

I did not reboot or even restart the database (mysqld)...
Two days later it works for no apparent reason...

Anyone have any ideas?
reply
    Bookmark Topic Watch Topic
  • New Topic