mysql - Spring war file deployed on ec2 showing hibernate persistence failure connecting to rds -

-

our company has app has been hosted on media temple, since moving amazon ec2. i've been through tutorials, , got apache, php, mysql, java, , tomcat7 running fine. also, have been able connect rds instance mysql workbench.

however, when upload war file tomcat manager error states unable connect database.

here top of error in catalina.out file

-----------------snippet log file----------------------------------------

17:28:52.311 [http-bio-8080-exec-1] debug o.s.b.f.s.disposablebeanadapter - invoking destroy method 'close' on bean name 'datasource' 17:28:52.311 [http-bio-8080-exec-1] debug o.s.b.f.s.defaultlistablebeanfactory - retrieved dependent beans bean '(inner bean)#73e12051': [org.springframework.se curity.access.method.delegatingmethodsecuritymetadatasource#0] 17:28:52.311 [http-bio-8080-exec-1] debug o.s.b.f.s.defaultlistablebeanfactory - retrieved dependent beans bean '(inner bean)#3b35dc09': [(inner bean)#73e12051] 17:28:52.312 [http-bio-8080-exec-1] **error o.s.web.context.contextloader - context initialization failed org.springframework.beans.factory.beancreationexception: error creating bean name 'entitymanagerfactory' defined in file [/var/lib/tomcat7/webapps/clearbox/web -inf/classes/meta-inf/spring/applicationcontext.xml]: invocation of init method failed; nested exception javax.persistence.persistenceexception: [persistenceunit : persistenceunit] unable build entitymanagerfactory**         @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1553) ~[spring-beans- 4.0.3.release.jar:4.0.3.release]         @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:539) ~[spring-beans-4.0 .3.release.jar:4.0.3.release]

.... , on.....

severe: web application [/clearbox] registered jdbc driver [com.mysql.jdbc.driver] failed unregister when web application stopped. prevent memory leak, jdbc driver has been forcibly unregistered.  **------------end snippet log file-----------------------------**  here code applicationcontext.xml attempts run  **--------------snippet applicationcontect.xml----------------**      <bean class="org.apache.commons.dbcp.basicdatasource" destroy-method="close" id="datasource">         <property name="driverclassname" value="${database.driverclassname}"/>         <property name="url" value="${database.url}"/>         <property name="username" value="${database.username}"/>         <property name="password" value="${database.password}"/>         <property name="testonborrow" value="true"/>         <property name="testonreturn" value="true"/>         <property name="testwhileidle" value="true"/>         <property name="timebetweenevictionrunsmillis" value="1800000"/>         <property name="numtestsperevictionrun" value="3"/>         <property name="minevictableidletimemillis" value="1800000"/>         <property name="validationquery" value="select 1"/>     </bean>      <bean class="org.springframework.orm.jpa.jpatransactionmanager" id="transactionmanager">         <property name="entitymanagerfactory" ref="entitymanagerfactory"/>     </bean>

---------------end snippet ------------------------------------------

here database.properties holds info applicationcontext.xml

-------------------snippet database.properties----------------

database.driverclassname=com.mysql.jdbc.driver database.url=jdbc\:mysql\://localhost\:3306/clearboxdb hibernate.dialect=org.hibernate.dialect.mysql5innodbdialect database.username=myusernamehere database.password=mypasswordhere

---------------------end snippet---------------------------------------

the rds has security group has following inbound: mysql tcp 3306 0.0.0.0/0

everything works on local tomcat7, , our existing live app tomcat7. i'm not sure error is.

  • is @ ec2/rds security groups level?
  • is @ hibernate / spring persistence level?
  • is @ mysql user level?

can please help, or point me existing post answer. i've surfed around stackoverflow couple days now, , decided ask question.

a tip may is, before started ec2, new developer getting same error when deploying war locally. found solution, in system mysql username: root no password caused war file work.

so, i'm seeing error again, not able set root no password on live system.

your database url set localhost, if using rds not case, instead should replace hostname provided in rds console (something dbname.somerandomchars.rds.eu-west... sorry dont have example hand guess memory may different order). need make sure set db user name , password rds values.

one other thing if database accessible workbench, mean selected "publicly accessible" if must change security group, allowing traffic insecure, if absolutely must public should use security groups narrow down limited set.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more