· 6 years ago · Mar 28, 2019, 11:12 AM
1org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #12 of URL [file:/C:/KPZ/Web_app/target/classes/schema.sql]: CREATE TABLE IF NOT EXISTS `DatabaseSP`.`ParkingPlaces` ( `placeID` INT NOT NULL AUTO_INCREMENT, `sector` VARCHAR(3) NULL, `placeNumber` INT NULL, `stateOfPlace` VARCHAR(20) NULL, `toll` INT NOT NULL, `category` INT NOT NULL, PRIMARY KEY (`placeID`), INDEX `fk_ParkingPlaces_Costs_idx` (`toll` ASC) VISIBLE, INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CONSTRAINT `fk_ParkingPlaces_Costs` FOREIGN KEY (`toll`) REFERENCES `DatabaseSP`.`Costs` (`costID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_ParkingPlaces_CategoriesOfVehicles1` FOREIGN KEY (`category`) REFERENCES `DatabaseSP`.`CategoriesOfVehicles` (`categoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; nested exception is java.sql.SQLSyntaxErrorException: (conn=56) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CO' at line 1
2 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
3 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:218) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
4 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1325) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
5 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1171) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
6 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
7 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
8 at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
9 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
10 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
11 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
12 at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:392) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
13 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1305) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
14 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1144) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
15 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
16 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
17 at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
18 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
19 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
20 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
21 at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105) ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
22 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
23 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
24 at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142) ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
25 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
26 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
27 at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
28 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
29 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
30 at org.kpz.smartparking.configuration.SmartparkingApplication.main(SmartparkingApplication.java:19) ~[classes/:na]
31Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #12 of URL [file:/C:/KPZ/Web_app/target/classes/schema.sql]: CREATE TABLE IF NOT EXISTS `DatabaseSP`.`ParkingPlaces` ( `placeID` INT NOT NULL AUTO_INCREMENT, `sector` VARCHAR(3) NULL, `placeNumber` INT NULL, `stateOfPlace` VARCHAR(20) NULL, `toll` INT NOT NULL, `category` INT NOT NULL, PRIMARY KEY (`placeID`), INDEX `fk_ParkingPlaces_Costs_idx` (`toll` ASC) VISIBLE, INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CONSTRAINT `fk_ParkingPlaces_Costs` FOREIGN KEY (`toll`) REFERENCES `DatabaseSP`.`Costs` (`costID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_ParkingPlaces_CategoriesOfVehicles1` FOREIGN KEY (`category`) REFERENCES `DatabaseSP`.`CategoriesOfVehicles` (`categoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; nested exception is java.sql.SQLSyntaxErrorException: (conn=56) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CO' at line 1
32 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:601) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
33 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
34 at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
35 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
36 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
37 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
38 at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
39 at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1247) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
40 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1167) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
41 at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
42 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
43 ... 28 common frames omitted
44Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #12 of URL [file:/C:/KPZ/Web_app/target/classes/schema.sql]: CREATE TABLE IF NOT EXISTS `DatabaseSP`.`ParkingPlaces` ( `placeID` INT NOT NULL AUTO_INCREMENT, `sector` VARCHAR(3) NULL, `placeNumber` INT NULL, `stateOfPlace` VARCHAR(20) NULL, `toll` INT NOT NULL, `category` INT NOT NULL, PRIMARY KEY (`placeID`), INDEX `fk_ParkingPlaces_Costs_idx` (`toll` ASC) VISIBLE, INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CONSTRAINT `fk_ParkingPlaces_Costs` FOREIGN KEY (`toll`) REFERENCES `DatabaseSP`.`Costs` (`costID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_ParkingPlaces_CategoriesOfVehicles1` FOREIGN KEY (`category`) REFERENCES `DatabaseSP`.`CategoriesOfVehicles` (`categoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; nested exception is java.sql.SQLSyntaxErrorException: (conn=56) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CO' at line 1
45 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1762) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
46 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
47 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
48 at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
49 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
50 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
51 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:224) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
52 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1115) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
53 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveBean(DefaultListableBeanFactory.java:407) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
54 at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:341) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
55 at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:335) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
56 at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerPostProcessor.postProcessAfterInitialization(DataSourceInitializerPostProcessor.java:55) ~[spring-boot-autoconfigure-2.1.3.RELEASE.jar:2.1.3.RELEASE]
57 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:429) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
58 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1766) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
59 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
60 ... 38 common frames omitted
61Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #12 of URL [file:/C:/KPZ/Web_app/target/classes/schema.sql]: CREATE TABLE IF NOT EXISTS `DatabaseSP`.`ParkingPlaces` ( `placeID` INT NOT NULL AUTO_INCREMENT, `sector` VARCHAR(3) NULL, `placeNumber` INT NULL, `stateOfPlace` VARCHAR(20) NULL, `toll` INT NOT NULL, `category` INT NOT NULL, PRIMARY KEY (`placeID`), INDEX `fk_ParkingPlaces_Costs_idx` (`toll` ASC) VISIBLE, INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CONSTRAINT `fk_ParkingPlaces_Costs` FOREIGN KEY (`toll`) REFERENCES `DatabaseSP`.`Costs` (`costID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_ParkingPlaces_CategoriesOfVehicles1` FOREIGN KEY (`category`) REFERENCES `DatabaseSP`.`CategoriesOfVehicles` (`categoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; nested exception is java.sql.SQLSyntaxErrorException: (conn=56) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CO' at line 1
62 at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:509) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
63 at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:238) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
64 at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:48) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
65 at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runScripts(DataSourceInitializer.java:210) ~[spring-boot-autoconfigure-2.1.3.RELEASE.jar:2.1.3.RELEASE]
66 at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.createSchema(DataSourceInitializer.java:104) ~[spring-boot-autoconfigure-2.1.3.RELEASE.jar:2.1.3.RELEASE]
67 at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker.afterPropertiesSet(DataSourceInitializerInvoker.java:64) ~[spring-boot-autoconfigure-2.1.3.RELEASE.jar:2.1.3.RELEASE]
68 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1821) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
69 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1758) ~[spring-beans-5.1.5.RELEASE.jar:5.1.5.RELEASE]
70 ... 52 common frames omitted
71Caused by: java.sql.SQLSyntaxErrorException: (conn=56) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CO' at line 1
72 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:242) ~[mariadb-java-client-2.4.1.jar:na]
73 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:171) ~[mariadb-java-client-2.4.1.jar:na]
74 at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238) ~[mariadb-java-client-2.4.1.jar:na]
75 at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:327) ~[mariadb-java-client-2.4.1.jar:na]
76 at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:378) ~[mariadb-java-client-2.4.1.jar:na]
77 at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.2.0.jar:na]
78 at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.2.0.jar:na]
79 at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:488) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
80 ... 59 common frames omitted
81Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CO' at line 1
82Query is: CREATE TABLE IF NOT EXISTS `DatabaseSP`.`ParkingPlaces` ( `placeID` INT NOT NULL AUTO_INCREMENT, `sector` VARCHAR(3) NULL, `placeNumber` INT NULL, `stateOfPlace` VARCHAR(20) NULL, `toll` INT NOT NULL, `category` INT NOT NULL, PRIMARY KEY (`placeID`), INDEX `fk_ParkingPlaces_Costs_idx` (`toll` ASC) VISIBLE, INDEX `fk_ParkingPlaces_CategoriesOfVehicles1_idx` (`category` ASC) VISIBLE, CONSTRAINT `fk_ParkingPlaces_Costs` FOREIGN KEY (`toll`) REFERENCES `DatabaseSP`.`Costs` (`costID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_ParkingPlaces_CategoriesOfVehicles1` FOREIGN KEY (`category`) REFERENCES `DatabaseSP`.`CategoriesOfVehicles` (`categoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB
83java thread: main
84 at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:126) ~[mariadb-java-client-2.4.1.jar:na]
85 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:233) ~[mariadb-java-client-2.4.1.jar:na]
86 at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:321) ~[mariadb-java-client-2.4.1.jar:na]
87 ... 63 common frames omitted
88
89
90Process finished with exit code 1