• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

access denied connecting Amazon RDS-Mysql from local Spring-JPA application

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have set up a mysql db at amazon RDS.
I'm able to connect to and query tables from my mac at home by mysqlworkbench, but when I try to connect it from a jersey-jpa-hibernate application inside eclipse I am getting below exception.



At the same time I'm successfully able to query database from mysqlWorkbench on same machine.
my MYSQL-RDS endpoint is
whereas the local tomcat trying to connect pool-xxx-.nwrknj.fios.verizon.ne
 
Bartender
Posts: 1210
25
Android Python PHP C++ Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Manvendra, welcome to CodeRanch!

I've moved this to the ORM forum since it's related to JPA.

Coming to your question, did you use the same username 'manvendra' in Mysql workbench too?
 
manvendra P singh
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for reply Karthik.

I tried old way of JDBC api from my JPA DAO class, to check the connection problem, and realized that I'm able to query the DB from my server by java.

So I corrected all my config files. there was a discrepancy in db.properies and persistence.xml.
Its all working fine now.
Below are my working configurations.


Spring Config



Persistance XML


db.properties
 
She said she got a brazillian. I think owning people is wrong. That is how I learned ... tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic