java - Unable to connect to Amazon RDS DBInstance via Hibernate or sqlplus -

-

i have created dbinstance in rds. have added vpc security group subnet including machines ip sending requests. however, not able connect dbinstance yet. connection times out. specifying following details in hibernate.cfg.xml:

<session-factory>  <property name="hibernate.dialect">   org.hibernate.dialect.mysql5innodbdialect  </property>  <property name="hibernate.connection.driver_class">   com.mysql.jdbc.driver  </property>  <property name="hibernate.connection.url">   jdbc:mysql://{dbinstancename}.us-west-2.rds.amazonaws.com:3306/{dbname}  </property>  <property name="hibernate.connection.username">   {username}  </property>  <property name="hibernate.connection.password">   {password}  </property> </session-factory>

i out of ideas on wrong. appreciated.

p.s: tried connecting using sqlplus in vain.

thanks.

log aws account, go rds, click on security groups. make sure security group set allow ip address connect rds (add cidr appropriate security group).

more information can found here working db security groups


Comments

Post a Comment

Popular posts from this blog

c# - HttpResponseMessage System.InvalidOperationException -

-
quite simple problem i've got easy solve reckon brains. it's tried different queries on google , nothing popped hey that's why here. here error: system.invalidoperationexception basically error thrown on piece of code here string test = response.content.headers.getvalues("location").firstordefault(); location in fiddler looks this: location: https://www.redirecturlishere.com/blah here entire function: private async task<string> getrequest() { //httpcontent postcontent = new stringcontent(post, encoding.ascii, "application/x-www-form-urlencoded"); using (httpresponsemessage response = await httpclient.getasync( "http://www.cant-share-url.com")) { using (httpcontent content = response.content) { string test = response.content.headers.getvalues("location").firstordefault(); } } return ""; ...
Read more

sql - Postgresql error: "failed to find conversion function from unknown to text" -

-
i have following postgresql query: ( select '201405mase04' testid, count(*) totq, count(distinct case when se1 = '' null else se1 end) totse, case when count(*)=0 7 else count(distinct rc) end totrc eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti.omit <> 1 ), b ( select '201405mase04' testid, count(*) totq eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti.omit = 1 ), c ( select '201405mase04' testid, count(*) totq eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti....
Read more