Consegui realizar o deploy do projeto em JAVA no heroku contudo estou tendo dificuldades em realizar a conexão ao banco(também do heroku) mysql jawsdb
Estou usando o hibernate para realizar a persistência ao banco
- hibernate.cfg.xml
Codigo
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://g8mh6ge01lu2z3n1.cbetxkdyhwsb.us-east-1.rds.amazonaws.com:3306/mro3io1m3qiarize</property>
<property name="hibernate.connection.username">xxxxxx</property>
<property name="hibernate.connection.password">yyyyyy</property>
Apos o deploy e roda a aplicação no heroku, recebo a mensagem de erro:
[web.1]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string:
Codigo do Persistence
public class HibernateUtil {
private static SessionFactory fabricaDeSessoes = criarFabricaDeSessoes();
public static SessionFactory getFabricaDeSessoes() {
return fabricaDeSessoes;
}
private static SessionFactory criarFabricaDeSessoes() {
ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().configure("hibernate.cfg.xml").applySettings(jdbcUrlSettings).build();
try {
Configuration configuracao = new Configuration().configure();
@SuppressWarnings("unused")
ServiceRegistry registro = new StandardServiceRegistryBuilder().applySettings(configuracao.getProperties()).build();
SessionFactory fabrica = configuracao.buildSessionFactory();
return fabrica;
} catch (Exception ex) {
System.err.println("Não foi possível criar a fábrica de sessões ! erro: " + ex);
throw new ExceptionInInitializerError(ex);
}
}
}
Logs no CMD
C:\Users\ALEXTI\Documents\SELECAO\IVIA\DesafioSefazIvia>heroku logs --app desafiosefazivia
2019-11-01T16:14:26.787597+00:00 app[web.1]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2019-11-01T16:14:26.787599+00:00 app[web.1]: at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2019-11-01T16:14:26.787602+00:00 app[web.1]: at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
2019-11-01T16:14:26.787604+00:00 app[web.1]: at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
2019-11-01T16:14:26.787606+00:00 app[web.1]: at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
2019-11-01T16:14:26.787608+00:00 app[web.1]: at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2019-11-01T16:14:26.78761+00:00 app[web.1]: at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
2019-11-01T16:14:26.787612+00:00 app[web.1]: at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
2019-11-01T16:14:26.787614+00:00 app[web.1]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2019-11-01T16:14:26.787617+00:00 app[web.1]: at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2019-11-01T16:14:26.787619+00:00 app[web.1]: at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
2019-11-01T16:14:26.787621+00:00 app[web.1]: at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
2019-11-01T16:14:26.787624+00:00 app[web.1]: at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
2019-11-01T16:14:26.787626+00:00 app[web.1]: at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2019-11-01T16:14:26.787628+00:00 app[web.1]: at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
2019-11-01T16:14:26.78763+00:00 app[web.1]: at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2019-11-01T16:14:26.787632+00:00 app[web.1]: at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
2019-11-01T16:14:26.787634+00:00 app[web.1]: at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2019-11-01T16:14:26.787637+00:00 app[web.1]: at org.apache.catalina.startup.Tomcat.start(Tomcat.java:459)
2019-11-01T16:14:26.787639+00:00 app[web.1]: at webapp.runner.launch.Main.main(Main.java:289)
2019-11-01T16:14:26.787641+00:00 app[web.1]: Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
2019-11-01T16:14:26.787643+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275)
2019-11-01T16:14:26.787645+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
2019-11-01T16:14:26.787648+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
2019-11-01T16:14:26.78765+00:00 app[web.1]: at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152)
2019-11-01T16:14:26.787652+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286)
2019-11-01T16:14:26.787654+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243)
2019-11-01T16:14:26.787656+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
2019-11-01T16:14:26.787659+00:00 app[web.1]: at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:179)
2019-11-01T16:14:26.787661+00:00 app[web.1]: at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:119)
2019-11-01T16:14:26.787664+00:00 app[web.1]: at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:84)
2019-11-01T16:14:26.787666+00:00 app[web.1]: at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:474)
2019-11-01T16:14:26.787668+00:00 app[web.1]: at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:85)
2019-11-01T16:14:26.78767+00:00 app[web.1]: at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:689)
2019-11-01T16:14:26.787672+00:00 app[web.1]: at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724)
2019-11-01T16:14:26.78768+00:00 app[web.1]: at br.com.desafiosefaz.util.HibernateUtil.criarFabricaDeSessoes(HibernateUtil.java:22)
2019-11-01T16:14:26.787683+00:00 app[web.1]: ... 27 more
2019-11-01T16:14:26.787685+00:00 app[web.1]: Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
2019-11-01T16:14:26.787688+00:00 app[web.1]: at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
2019-11-01T16:14:26.78769+00:00 app[web.1]: at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
2019-11-01T16:14:26.787692+00:00 app[web.1]: at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
2019-11-01T16:14:26.787694+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:118)
2019-11-01T16:14:26.787696+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:41)
2019-11-01T16:14:26.787699+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
2019-11-01T16:14:26.787701+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections.addConnections(DriverManagerConnectionProviderImpl.java:363)
2019-11-01T16:14:26.787705+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections.<init>(DriverManagerConnectionProviderImpl.java:282)
2019-11-01T16:14:26.787708+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections.<init>(DriverManagerConnectionProviderImpl.java:260)
2019-11-01T16:14:26.78771+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections$Builder.build(DriverManagerConnectionProviderImpl.java:401)
2019-11-01T16:14:26.787712+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:112)
2019-11-01T16:14:26.787714+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:75)
2019-11-01T16:14:26.787716+00:00 app[web.1]: at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:100) 2019-11-01T16:14:26.787719+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246)
2019-11-01T16:14:26.787722+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
2019-11-01T16:14:26.787724+00:00 app[web.1]: at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
2019-11-01T16:14:26.787726+00:00 app[web.1]: at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
2019-11-01T16:14:26.787728+00:00 app[web.1]: at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
2019-11-01T16:14:26.78773+00:00 app[web.1]: at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:94)
2019-11-01T16:14:26.787733+00:00 app[web.1]: at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
2019-11-01T16:14:26.787735+00:00 app[web.1]: ... 41 more
2019-11-01T16:14:26.787737+00:00 app[web.1]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "[email removido]:3306"'.
2019-11-01T16:14:26.78774+00:00 app[web.1]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2019-11-01T16:14:26.787742+00:00 app[web.1]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2019-11-01T16:14:26.787744+00:00 app[web.1]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2019-11-01T16:14:26.787746+00:00 app[web.1]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2019-11-01T16:14:26.787748+00:00 app[web.1]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
2019-11-01T16:14:26.78775+00:00 app[web.1]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
2019-11-01T16:14:26.787752+00:00 app[web.1]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
2019-11-01T16:14:26.787754+00:00 app[web.1]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
2019-11-01T16:14:26.787756+00:00 app[web.1]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
2019-11-01T16:14:26.787758+00:00 app[web.1]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
2019-11-01T16:14:26.78776+00:00 app[web.1]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:338)
2019-11-01T16:14:26.787762+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
2019-11-01T16:14:26.787765+00:00 app[web.1]: ... 56 more
2019-11-01T16:14:26.787771+00:00 app[web.1]: Caused by: java.lang.NumberFormatException: For input string: "[email removido]:3306"
2019-11-01T16:14:26.787773+00:00 app[web.1]: at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
2019-11-01T16:14:26.787775+00:00 app[web.1]: at java.lang.Integer.parseInt(Integer.java:580)
2019-11-01T16:14:26.787778+00:00 app[web.1]: at java.lang.Integer.parseInt(Integer.java:615)
2019-11-01T16:14:26.78778+00:00 app[web.1]: at com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:825)
2019-11-01T16:14:26.787784+00:00 app[web.1]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
2019-11-01T16:14:26.787786+00:00 app[web.1]: ... 57 more
2019-11-01T16:14:26.787788+00:00 app[web.1]:
2019-11-01T16:14:26.864962+00:00 app[web.1]: Nov 01, 2019 4:14:26 PM com.sun.faces.config.ConfigureListener contextInitialized
2019-11-01T16:14:26.864966+00:00 app[web.1]: INFO: Initializing Mojarra 2.2.12 ( 20150720-0848 https://svn.java.net/svn/mojarra~svn/tags/2.2.12@14885) for context ''
2019-11-01T16:14:24.911422+00:00 app[web.1]: Nov 01, 2019 4:14:24 PM org.hibernate.Version logVersion
2019-11-01T16:14:24.911436+00:00 app[web.1]: INFO: HHH000412: Hibernate Core {5.3.5.Final}
2019-11-01T16:14:24.917262+00:00 app[web.1]: Nov 01, 2019 4:14:24 PM org.hibernate.cfg.Environment <clinit>
2019-11-01T16:14:24.917265+00:00 app[web.1]: INFO: HHH000206: hibernate.properties not found
2019-11-01T16:14:31.580966+00:00 app[web.1]: Nov 01, 2019 4:14:31 PM org.apache.catalina.loader.WebappClassLoaderBase checkStateForResourceLoading
2019-11-01T16:14:31.580982+00:00 app[web.1]: INFO: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
2019-11-01T16:14:31.580985+00:00 app[web.1]: java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
2019-11-01T16:14:31.580988+00:00 app[web.1]: at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1385)
2019-11-01T16:14:31.58099+00:00 app[web.1]: at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:1038)
2019-11-01T16:14:31.580992+00:00 app[web.1]: at com.mysql.jdbc.AbandonedConnectionCleanupThread.checkContextClassLoaders(AbandonedConnectionCleanupThread.java:90)
2019-11-01T16:14:31.580995+00:00 app[web.1]: at com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:63)
2019-11-01T16:14:31.580998+00:00 app[web.1]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
2019-11-01T16:14:31.581+00:00 app[web.1]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
2019-11-01T16:14:31.581003+00:00 app[web.1]: at java.lang.Thread.run(Thread.java:748)
2019-11-01T16:14:31.581005+00:00 app[web.1]:
2019-11-01T16:14:27.315527+00:00 app[web.1]: Nov 01, 2019 4:14:27 PM com.sun.faces.spi.InjectionProviderFactory createInstance
2019-11-01T16:14:27.315549+00:00 app[web.1]: INFO: JSF1048: PostConstruct/PreDestroy annotations present. ManagedBeans methods marked with these annotations will have said annotations processed.