API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 16th, 2018
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.67 KB | None | 0 0
raw download clone embed print report
  1. org.hibernate.HibernateException: Use of DefaultSchemaNameResolver requires Dialect to provide the proper SQL statement/command but provided Dialect [org.hibernate.dialect.MySQL57Dialect] did not return anything from Dialect#getCurrentSchemaCommand
  2. at org.hibernate.engine.jdbc.env.internal.DefaultSchemaNameResolver$SchemaNameResolverFallbackDelegate.resolveSchemaName(DefaultSchemaNameResolver.java:100) ~[hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  3. at org.hibernate.engine.jdbc.env.internal.DefaultSchemaNameResolver.resolveSchemaName(DefaultSchemaNameResolver.java:76) ~[hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  4. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.determineCurrentSchemaName(JdbcEnvironmentImpl.java:298) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  5. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.<init>(JdbcEnvironmentImpl.java:232) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  6. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:114) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  7. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  8. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  9. at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  10. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  11. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  12. at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  13. at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  14. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  15. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  16. at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:179) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  17. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:119) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  18. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:84) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  19. at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:474) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  20. at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:85) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  21. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:689) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  22. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724) [hibernate-core-5.3.1.Final.jar:5.3.1.Final]
  23. at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:343) [spring-orm-4.0.3.RELEASE.jar:4.0.3.RELEASE]
  24. at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:431) [spring-orm-4.0.3.RELEASE.jar:4.0.3.RELEASE]
  25. at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:416) [spring-orm-4.0.3.RELEASE.jar:4.0.3.RELEASE]
  26. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  27. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  28. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  29. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  30. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  31. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  32. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  33. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  34. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:753) [spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  35. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  36. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  37. at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  38. at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  39. at springboot.beans.app.SpringHibernateMain.main(SpringHibernateMain.java:24) [classes/:na]
  40.  
  41. package springboot.beans.app;
  42.  
  43. import java.util.List;
  44.  
  45. import org.hibernate.Session;
  46. import org.hibernate.SessionFactory;
  47. import org.hibernate.Transaction;
  48. import org.hibernate.boot.Metadata;
  49. import org.hibernate.boot.MetadataSources;
  50. import org.hibernate.boot.registry.StandardServiceRegistry;
  51. import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
  52. import org.springframework.context.support.ClassPathXmlApplicationContext;
  53.  
  54. import database.ManageEmployee;
  55. import withAnnotation.InsertRecords;
  56. import withAnnotation.InsertRecords2;
  57. import withAnnotation.Product;
  58.  
  59.  
  60. public class SpringHibernateMain {
  61.  
  62. public static void main(String[] args) {
  63.  
  64. ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("SpringHibernateConfiguration.xml");
  65.  
  66. ManageEmployee manager = context.getBean(ManageEmployee.class);
  67. /* Add few employee records in database */
  68. Integer empID1 = manager.addEmployee("Spring222", "TODAY222", 30000);
  69. Integer empID2 = manager.addEmployee("Avraham-spring", "Das", 5000);
  70. Integer empID3 = manager.addEmployee("Sarah wigh spring", "Paul", 10000);
  71.  
  72. /* List down all the employees */
  73. manager.listEmployees();
  74.  
  75. /* Update employee's records */
  76. manager.updateEmployee(empID1, 5000);
  77. System.out.println(empID2 + " = empID2");
  78. /* Delete an employee from the database */
  79. manager.deleteEmployee(empID2);
  80.  
  81. /* List down new list of the employees */
  82. manager.listEmployees();
  83.  
  84. InsertRecords2 producer = context.getBean(InsertRecords2.class);
  85. producer.updateProducts();//it's running insertion from inside
  86.  
  87.  
  88. System.out.println("check if done");
  89.  
  90.  
  91. //close resources
  92. context.close();
  93. }
  94. }
  95.  
  96. <beans xmlns="http://www.springframework.org/schema/beans"
  97. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
  98. xmlns:tx="http://www.springframework.org/schema/tx"
  99. xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  100. http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
  101. http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
  102.  
  103. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
  104. destroy-method="close">
  105. <!-- <property name = "hibernate.connection.driver_class">
  106. com.mysql.jdbc.Driver
  107. </property>
  108. -->
  109. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  110. <property name="url" value="jdbc:mysql://localhost:3306/hibernate_mysql7?useSSL=false" />
  111. <property name="username" value="XXXX" />
  112. <property name="password" value="XXXX" />
  113. </bean>
  114.  
  115. <!-- Hibernate 3 XML SessionFactory Bean definition-->
  116. <!-- <bean id="hibernate3SessionFactory"
  117. class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  118. <property name="dataSource" ref="dataSource" />
  119. <property name="mappingResources">
  120. <list>
  121. <value>person.hbm.xml</value>
  122. </list>
  123. </property>
  124. <property name="hibernateProperties">
  125. <value>
  126. hibernate.dialect=org.hibernate.dialect.MySQLDialect
  127. </value>
  128. </property>
  129. </bean> -->
  130.  
  131. <!-- Hibernate 4 Annotation SessionFactory Bean definition-->
  132. <bean id="hibernate4AnnotatedSessionFactory"
  133. class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  134. <property name="dataSource" ref="dataSource" />
  135. <property name="annotatedClasses"><!-- sessionFactory -->
  136. <list>
  137. <!-- <value>Employee.hbm.xml</value> ? <value>database.Employee</value> -->
  138. <value>withAnnotation.Product</value>
  139.  
  140. </list>
  141.  
  142.  
  143. </property>
  144. <!-- add this -->
  145. <property name="mappingResources">
  146. <list>
  147. <value>Employee.hbm.xml</value>
  148. </list>
  149. </property>
  150.  
  151. <!-- end -->
  152. <property name="hibernateProperties">
  153. <props>
  154. <!-- this cause new creating and clean all from the past
  155. <prop key="hibernate.hbm2ddl.auto">create</prop>
  156. if u want to create once and keep use that instead :-->
  157. <prop key="hibernate.hbm2ddl.auto">update</prop>
  158. <!-- hibernate found it by itself <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop> -->
  159. <prop key="hibernate.current_session_context_class">thread</prop>
  160. <prop key="hibernate.show_sql">true</prop><!-- <property name="hibernate.hbm2ddl.auto">create</property> -->
  161.  
  162. </props>
  163. </property>
  164.  
  165. </bean>
  166.  
  167.  
  168.  
  169. <bean id="managerEmployee" class="database.ManageEmployee">
  170. <property name="sessionFactory" ref="hibernate4AnnotatedSessionFactory" />
  171. </bean>
  172.  
  173. <bean id="producer" class="withAnnotation.InsertRecords2">
  174. <property name="sessionFactory" ref="hibernate4AnnotatedSessionFactory" />
  175. </bean>
  176. </beans>
  177.  
  178. <
  179.  
  180. project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  181. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  182. <modelVersion>4.0.0</modelVersion>
  183.  
  184. <groupId>springboot.beans.app</groupId>
  185. <artifactId>SpringHibernateBasic5-OtherConfiguration</artifactId>
  186. <version>0.0.1-SNAPSHOT</version>
  187. <packaging>jar</packaging>
  188.  
  189. <name>SpringHibernateBasic5-OtherConfiguration</name>
  190. <url>http://maven.apache.org</url>
  191.  
  192. <properties>
  193. <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  194. <spring.version>4.2.7.RELEASE</spring.version>
  195. <java.version>1.8</java.version>
  196. <spring-framework.version>4.0.3.RELEASE</spring-framework.version>
  197. <!-- *** added -->
  198. <!-- Hibernate / JPA -->
  199. <!-- <hibernate.version>4.3.5.Final</hibernate.version> -->
  200. <hibernate.version>5.3.1.Final</hibernate.version> <!-- 3.6.9.Final-->
  201.  
  202. <!-- Logging -->
  203. <logback.version>1.0.13</logback.version>
  204. <slf4j.version>1.7.5</slf4j.version>
  205.  
  206. </properties>
  207. <parent>
  208. <groupId>org.springframework.boot</groupId>
  209. <artifactId>spring-boot-starter-parent</artifactId>
  210. <version>2.0.5.RELEASE</version>
  211. </parent>
  212.  
  213. <dependencies>
  214. <dependency>
  215. <groupId>org.springframework</groupId>
  216. <artifactId>spring-core</artifactId>
  217. <version>${spring.version}</version>
  218. </dependency>
  219. <dependency>
  220. <groupId>org.springframework</groupId>
  221. <artifactId>spring-context</artifactId>
  222. <version>${spring.version}</version><!--$NO-MVN-MAN-VER$-->
  223. </dependency>
  224.  
  225. <!-- Spring boot dependencies -->
  226. <dependency>
  227. <groupId>org.springframework.boot</groupId>
  228. <artifactId>spring-boot-starter-web</artifactId>
  229. </dependency>
  230.  
  231.  
  232. <dependency>
  233. <groupId>org.springframework.boot</groupId>
  234. <artifactId>spring-boot-starter-test</artifactId>
  235. <scope>test</scope>
  236. </dependency>
  237. <dependency>
  238. <groupId>org.springframework</groupId>
  239. <artifactId>spring-tx</artifactId>
  240. <version>${spring-framework.version}</version>
  241. </dependency>
  242.  
  243. <!-- Spring ORM support -->
  244. <dependency>
  245. <groupId>org.springframework</groupId>
  246. <artifactId>spring-orm</artifactId>
  247. <version>${spring-framework.version}</version>
  248. </dependency>
  249.  
  250. <!-- Logging with SLF4J & LogBack -->
  251. <dependency>
  252. <groupId>org.slf4j</groupId>
  253. <artifactId>slf4j-api</artifactId>
  254. <version>${slf4j.version}</version>
  255. <scope>compile</scope>
  256. </dependency>
  257. <dependency>
  258. <groupId>ch.qos.logback</groupId>
  259. <artifactId>logback-classic</artifactId>
  260. <version>${logback.version}</version>
  261. <scope>runtime</scope>
  262. </dependency>
  263.  
  264. <!-- Hibernate -->
  265. <dependency>
  266. <groupId>org.hibernate</groupId>
  267. <artifactId>hibernate-entitymanager</artifactId>
  268. <version>${hibernate.version}</version>
  269. </dependency>
  270. <dependency>
  271. <groupId>org.hibernate</groupId>
  272. <artifactId>hibernate-core</artifactId>
  273. <version>${hibernate.version}</version>
  274. </dependency>
  275.  
  276. <dependency>
  277. <groupId>mysql</groupId>
  278. <artifactId>mysql-connector-java</artifactId>
  279. <version>5.1.47</version>
  280. </dependency>
  281. <dependency>
  282. <groupId>commons-dbcp</groupId>
  283. <artifactId>commons-dbcp</artifactId>
  284. <version>1.4</version>
  285. </dependency>
  286.  
  287.  
  288.  
  289. <!-- Spring dependency -->
  290.  
  291.  
  292. <dependency>
  293. <groupId>junit</groupId>
  294. <artifactId>junit</artifactId>
  295. <version>3.8.1</version>
  296. <scope>test</scope>
  297. </dependency>
  298.  
  299.  
  300.  
  301. </dependencies>
  302.  
  303. <build>
  304. <plugins>
  305. <plugin>
  306. <groupId>org.apache.maven.plugins</groupId>
  307. <artifactId>maven-compiler-plugin</artifactId>
  308. <version>3.2</version>
  309. <configuration>
  310. <source>1.8</source>
  311. <target>1.8</target>
  312. </configuration>
  313. </plugin>
  314.  
  315. <plugin>
  316. <groupId>org.springframework.boot</groupId>
  317. <artifactId>spring-boot-maven-plugin</artifactId>
  318. </plugin>
  319.  
  320.  
  321.  
  322. </plugins>
  323. </build>
  324. </project>
  325.  
  326. <?xml version="1.0" encoding="UTF-8"?>
  327. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  328. <modelVersion>4.0.0</modelVersion>
  329. <groupId>springboot.beans.app</groupId>
  330. <artifactId>SpringHibernateBasic5-OtherConfiguration</artifactId>
  331. <version>0.0.1-SNAPSHOT</version>
  332. <packaging>jar</packaging>
  333. <name>SpringHibernateBasic5-OtherConfiguration</name>
  334. <url>http://maven.apache.org</url>
  335.  
  336. <properties>
  337. <java.version>1.8</java.version>
  338. </properties>
  339.  
  340. <parent>
  341. <groupId>org.springframework.boot</groupId>
  342. <artifactId>spring-boot-starter-parent</artifactId>
  343. <version>2.0.5.RELEASE</version>
  344. </parent>
  345.  
  346. <dependencies>
  347. <!-- Spring boot dependencies -->
  348. <dependency>
  349. <groupId>org.springframework.boot</groupId>
  350. <artifactId>spring-boot-starter-web</artifactId>
  351. </dependency>
  352. <dependency>
  353. <groupId>org.springframework.boot</groupId>
  354. <artifactId>spring-boot-starter-data-jpa</artifactId>
  355. </dependency>
  356. <dependency>
  357. <groupId>mysql</groupId>
  358. <artifactId>mysql-connector-java</artifactId>
  359. </dependency>
  360. <dependency>
  361. <groupId>org.springframework.boot</groupId>
  362. <artifactId>spring-boot-starter-test</artifactId>
  363. <scope>test</scope>
  364. </dependency>
  365. </dependencies>
  366. <build>
  367. <plugins>
  368. <plugin>
  369. <groupId>org.springframework.boot</groupId>
  370. <artifactId>spring-boot-maven-plugin</artifactId>
  371. </plugin>
  372. </plugins>
  373. </build>
  374. </project>
  375.  
  376. spring.datasource.url=jdbc:mysql://localhost:3306/hibernate_mysql7?useSSL=false
  377. spring.datasource.username=XXXX
  378. spring.datasource.password=XXXX
  379.  
  380. spring.jpa.hibernate.ddl-auto=update
  381.  
  382. @SpringBootApplication
  383. public class SpringHibernateMain {
  384.  
  385. public static void main(String[] args) {
  386.  
  387. ApplicationContext context = SpringApplication.run(SpringHibernateMain.class ,args);
  388.  
  389. ManageEmployee manager = context.getBean(ManageEmployee.class);
  390. /* Add few employee records in database */
  391. Integer empID1 = manager.addEmployee("Spring222", "TODAY222", 30000);
  392. Integer empID2 = manager.addEmployee("Avraham-spring", "Das", 5000);
  393. Integer empID3 = manager.addEmployee("Sarah wigh spring", "Paul", 10000);
  394.  
  395. /* List down all the employees */
  396. manager.listEmployees();
  397.  
  398. /* Update employee's records */
  399. manager.updateEmployee(empID1, 5000);
  400. System.out.println(empID2 + " = empID2");
  401. /* Delete an employee from the database */
  402. manager.deleteEmployee(empID2);
  403.  
  404. /* List down new list of the employees */
  405. manager.listEmployees();
  406.  
  407. InsertRecords2 producer = context.getBean(InsertRecords2.class);
  408. producer.updateProducts();//it's running insertion from inside
  409.  
  410.  
  411. System.out.println("check if done");
  412. }
  413. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!