Bonjour,
J'ai installé MySQL et j'ai tout configurer (configurer le startup.bat, peupler la base...) mais quand je lance le lien squash j'ai toujours ce message : !!! ATTENTION. Vous utilisez actuellement une base de donnees h2, qui convient uniquement pour des besoins de démonstration. NE PAS UTILISER EN PRODUCTION !!!
Quelqu'un sait d'où le problème vient ?
Merci d'avance
Hassane
toujours connecté à la base H2
impossible de lancer squash tm 1.20
Pardon il s'agit seulement d'un problème de connexion neomoins j'ai rencontré un autre soucis c'est au moment de startup.bat j'ai ces erreurs dans le log :
[19-09-23 17:56:39.226] SquashTM - 14552 WARN [main] [] --- org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 42102, SQLState: 42S02
[19-09-23 17:56:39.226] SquashTM - 14552 ERROR [main] [] --- org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Table "CORE_CONFIG" not found; SQL statement:
select VALUE from CORE_CONFIG where STR_KEY = ? [42102-187]
[19-09-23 17:56:39.231] SquashTM - 14552 WARN [main] [] --- org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashServletConfig': Unsatisfied dependency expressed through field 'credentialsProvider'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashtest.tm.service.CredentialsProvider': Unsatisfied dependency expressed through field 'storedCredentialsManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'storedCredentialsManagerImpl': Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
[19-09-23 17:56:39.233] SquashTM - 14552 INFO [main] [] --- org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean: Closing JPA EntityManagerFactory for persistence unit 'default'
[19-09-23 17:56:39.234] SquashTM - 14552 INFO [main] [] --- com.zaxxer.hikari.HikariDataSource: HikariPool-1 - Shutdown initiated...
[19-09-23 17:56:39.237] SquashTM - 14552 INFO [main] [] --- com.zaxxer.hikari.HikariDataSource: HikariPool-1 - Shutdown completed.
[19-09-23 17:56:39.239] SquashTM - 14552 INFO [main] [] --- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[19-09-23 17:56:39.240] SquashTM - 14552 INFO [main] [] --- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[19-09-23 17:56:39.250] SquashTM - 14552 INFO [main] [] --- org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener:
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[19-09-23 17:56:39.253] SquashTM - 14552 ERROR [main] [] --- org.springframework.boot.SpringApplication: Application run failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashServletConfig': Unsatisfied dependency expressed through field 'credentialsProvider'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashtest.tm.service.CredentialsProvider': Unsatisfied dependency expressed through field 'storedCredentialsManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'storedCredentialsManagerImpl': Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:587) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:373) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1350) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:580) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.0.7.RELEASE.jar!
La version de JAVA que j'ai est : jre1.8.0_221
Merci pour vos Retour !
[19-09-23 17:56:39.226] SquashTM - 14552 WARN [main] [] --- org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 42102, SQLState: 42S02
[19-09-23 17:56:39.226] SquashTM - 14552 ERROR [main] [] --- org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Table "CORE_CONFIG" not found; SQL statement:
select VALUE from CORE_CONFIG where STR_KEY = ? [42102-187]
[19-09-23 17:56:39.231] SquashTM - 14552 WARN [main] [] --- org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashServletConfig': Unsatisfied dependency expressed through field 'credentialsProvider'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashtest.tm.service.CredentialsProvider': Unsatisfied dependency expressed through field 'storedCredentialsManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'storedCredentialsManagerImpl': Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
[19-09-23 17:56:39.233] SquashTM - 14552 INFO [main] [] --- org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean: Closing JPA EntityManagerFactory for persistence unit 'default'
[19-09-23 17:56:39.234] SquashTM - 14552 INFO [main] [] --- com.zaxxer.hikari.HikariDataSource: HikariPool-1 - Shutdown initiated...
[19-09-23 17:56:39.237] SquashTM - 14552 INFO [main] [] --- com.zaxxer.hikari.HikariDataSource: HikariPool-1 - Shutdown completed.
[19-09-23 17:56:39.239] SquashTM - 14552 INFO [main] [] --- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[19-09-23 17:56:39.240] SquashTM - 14552 INFO [main] [] --- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[19-09-23 17:56:39.250] SquashTM - 14552 INFO [main] [] --- org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener:
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[19-09-23 17:56:39.253] SquashTM - 14552 ERROR [main] [] --- org.springframework.boot.SpringApplication: Application run failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashServletConfig': Unsatisfied dependency expressed through field 'credentialsProvider'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'squashtest.tm.service.CredentialsProvider': Unsatisfied dependency expressed through field 'storedCredentialsManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'storedCredentialsManagerImpl': Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:587) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:373) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1350) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:580) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.0.7.RELEASE.jar!
La version de JAVA que j'ai est : jre1.8.0_221
Merci pour vos Retour !
impossible de lancer squash tm 1.20
Bonjour quelqu'un peut m'aider svp.. je suis toujours bloqué…?!!