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

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

javascript - Why in IE loading image not show at center bottom of page? -

-
this question has answer here: how “position:fixed” css work in ie 7+ transitional doctype? 2 answers why in ie loading image not show @ center bottom of page ? this function load content on load page , load content on scroll bottom. first, load page index.php see loading image @ center bottom of page. but test on ie 7,8 loading not show @ center bottom of page , how can ? index.php <script src="http://code.jquery.com/jquery-1.7.2.js"></script> <script> // on submit form call function code // $("#f1").submit(send_requests()); </script> <body> <form method="post" id="f1"> <input type="hidden" name="something"/> </form> <div id="loading" style="padding: 0px; margin: 0px; position: fixed; bottom: 135px; right: 50%;...
Read more

Phantomjs login, redirect and render page after pageLoad finishes -

-
i have website login form. if user not logged , tries access internal page redirected default page. instance if try access http://siteurl.phantomprint.aspx redirected http://siteurl/default.aspx?returnurl=phantomprint.aspx. , after login automatic redirect take place page. after redirect want render page phantomjs , save pdf. problem rendering takes place before page load finished , can render page if use timeouts. in case, if page loading takes longer normal resulted pdf not proper one. below can find java script code: var page = require('webpage').create(); var index = 0, page.onconsolemessage = function (msg) { console.log(msg); }; var steps = [ function () { //load login page page.open("http://siteurl.phantomprint.aspx", function () { //enter credentials page.evaluate(function () { console.log("filling inputs"); var usernameinput = document.getelementbyid("txtusername...
Read more