Lien entre une BDD Mysql et Squash-tm 1.20

Skibouille
Messages : 4
Inscription : dim. août 18, 2019 7:46 pm

Lien entre une BDD Mysql et Squash-tm 1.20

Message par Skibouille »

Bonjour,

Cela fait plusieurs jours que j'essaie en vain de lier ma BDD Mysql qui se trouve sous Wamp a Squash-TM.

je n'ai aucun souci en utilisant une BDD H2.

Pour information :

Mysql version : 5.7.26
Squash-tm version : 1.20.0
Windows 10.

Code : Tout sélectionner

[19-08-18 19:43:10.093] SquashTM - 11600  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': Injection of persistence dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactory' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactoryBuilder' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactoryBuilder' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
[19-08-18 19:43:10.093] SquashTM - 11600  INFO [main] [] --- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[19-08-18 19:43:10.093] SquashTM - 11600  INFO [main] [] --- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[19-08-18 19:43:10.124] SquashTM - 11600  INFO [main] [] --- org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener: 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[19-08-18 19:43:10.124] SquashTM - 11600 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': Injection of persistence dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactory' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactoryBuilder' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactoryBuilder' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm

Caused by: 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': Injection of persistence dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactory' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactoryBuilder' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactoryBuilder' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
	
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'storedCredentialsManagerImpl': Injection of persistence dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactory' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactoryBuilder' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactoryBuilder' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
	
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactory' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactoryBuilder' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactoryBuilder' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
	
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactoryBuilder' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactoryBuilder' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
	
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
	
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
	
Caused by: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://http://127.0.1.1:3336/squash-tm
	
Caused by: java.sql.SQLException: Must specify port after ':' in connection string
Si une âme charitable peux m'aider ça serait d'un grand secours ><

Cordialement,

Skibouille
Skibouille
Messages : 4
Inscription : dim. août 18, 2019 7:46 pm

Re: Lien entre une BDD Mysql et Squash-tm 1.20

Message par Skibouille »

Bonjour,

Après quelque correction j'ai bien exécuter le script pour peuplé la BDD Mysql mais lors du lancement j'ai ce message d'erreur dans les log :

Code : Tout sélectionner

[19-08-19 00:22:54.572] SquashTM - 8052 ERROR [squashtest.tm.service.ThreadPoolTaskScheduler-1] [] --- org.springframework.scheduling.support.TaskUtils$LoggingErrorHandler: Unexpected error occurred in scheduled task.
org.springframework.jdbc.BadSqlGrammarException: jOOQ; bad SQL grammar [select `REMOTE_SYNCHRONISATION`.`REMOTE_SYNCHRONISATION_ID` from `REMOTE_SYNCHRONISATION` where `REMOTE_SYNCHRONISATION`.`KIND` = ? order by `REMOTE_SYNCHRONISATION`.`REMOTE_SYNCHRONISATION_ID` desc]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: La table 'squashtm.remote_synchronisation' n'existe pas
	at org.jooq_3.10.7.MYSQL.debug(Unknown Source) ~[?:?]
J'ai vérifié mais le script ne contient pas de table "remote_synchronisation".

Du coup comment je corrige ça ?

Info utile :


Mysql (5.7.26) installer via WampServer(3.1.9) sous windows 10 (version 1903)
Squash-tm (1.20.0)


Merci d'avance !


Cordialement,


Skibouille
agoethals
Messages : 70
Inscription : mer. août 08, 2018 12:08 pm

Re: Lien entre une BDD Mysql et Squash-tm 1.20

Message par agoethals »

Effectivement, le nom de la table est REMOTE_SYNCHRONISATION, en lettres capitales.

Pouvez-vous nous préciser également la version de java utilisée ?
Skibouille
Messages : 4
Inscription : dim. août 18, 2019 7:46 pm

Re: Lien entre une BDD Mysql et Squash-tm 1.20

Message par Skibouille »

Bonjour j'utilise la version 1.8.0_221 vu que au delà même en h2 il ce cloturé.
KathrynGah
Messages : 2
Inscription : sam. sept. 07, 2019 1:24 pm

Lien entre une BDD Mysql et Squash tm 1 20

Message par KathrynGah »

yes: copied from interface:
Connection Strings
Perl dbh = DBI->connectDBI:mysql:cohuntgu_sope1:localhost,cohuntgu_cohunt,<PASSWORD HERE>;
PHP dbh=mysql_connect localhost, cohuntgu_cohunt, <PASSWORD HERE> or die I cannot connect to the database because: . mysql_error;
mysql_select_db cohuntgu_sope1;
Pièces jointes
264.gif
264.gif (3.06 Kio) Consulté 3442 fois
Répondre

Revenir à « Installation & Base de données / Installation & Database »