spring - EERROR: org.hibernate.tool.hbm2ddl.SchemaExport - HHH000231: Schema export unsuccessful -


i use junit4 test code, , in first line code:

applicationcontext context = new classpathxmlapplicationcontext(              new string[] { "applicationcontext.xml" });

i got error:

info : org.springframework.context.support.classpathxmlapplicationcontext - refreshing org.springframework.context.support.classpathxmlapplicationcontext@5a39699c: startup date [fri apr 10 04:47:54 west 2015]; root of context hierarchy  info : org.springframework.beans.factory.xml.xmlbeandefinitionreader - loading xml bean definitions class path resource [applicationcontext.xml]  info : org.springframework.jdbc.datasource.drivermanagerdatasource - loaded jdbc driver: com.mysql.jdbc.driver  info : org.springframework.context.support.classpathxmlapplicationcontext - bean 'datasource' of type [class org.springframework.jdbc.datasource.drivermanagerdatasource] not eligible getting processed beanpostprocessors (for example: not eligible auto-proxying)  info : org.springframework.context.support.classpathxmlapplicationcontext - bean 'org.springframework.orm.jpa.vendor.hibernatejpavendoradapter#3cef309d' of type [class org.springframework.orm.jpa.vendor.hibernatejpavendoradapter] not eligible getting processed beanpostprocessors (for example: not eligible auto-proxying)  info : org.springframework.orm.jpa.localcontainerentitymanagerfactorybean - building jpa container entitymanagerfactory persistence unit 'default'  warn : org.hibernate.ejb.hibernatepersistence - hhh015016: encountered deprecated javax.persistence.spi.persistenceprovider [org.hibernate.ejb.hibernatepersistence]; use [org.hibernate.jpa.hibernatepersistenceprovider] instead.  info : org.hibernate.jpa.internal.util.loghelper - hhh000204: processing persistenceunitinfo [  	name: default  	...]  info : org.hibernate.version - hhh000412: hibernate core {4.3.5.final}  info : org.hibernate.cfg.environment - hhh000206: hibernate.properties not found  info : org.hibernate.cfg.environment - hhh000021: bytecode provider name : javassist  info : org.hibernate.annotations.common.version - hcann000001: hibernate commons annotations {4.0.4.final}  warn : org.hibernate.engine.jdbc.internal.jdbcservicesimpl - hhh000342: not obtain connection query metadata : unknown database 'appeldoffre'  info : org.hibernate.dialect.dialect - hhh000400: using dialect: org.hibernate.dialect.mysql5dialect  info : org.hibernate.engine.jdbc.internal.lobcreatorbuilder - hhh000422: disabling contextual lob creation connection null  info : org.hibernate.hql.internal.ast.astquerytranslatorfactory - hhh000397: using astquerytranslatorfactory  info : org.hibernate.search.version - hsearch000034: hibernate search 4.2.0.final  warn : org.hibernate.search.impl.configcontext - hsearch000075: configuration setting hibernate.search.lucene_version not specified, using lucene_current.  info : org.hibernate.tool.hbm2ddl.schemaexport - hhh000227: running hbm2ddl schema export  error: org.hibernate.tool.hbm2ddl.schemaexport - hhh000231: schema export unsuccessful  com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unknown database 'appeldoffre'  	at sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method)  	at sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source)  	at sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source)  	at java.lang.reflect.constructor.newinstance(unknown source)  	at com.mysql.jdbc.util.handlenewinstance(util.java:409)  	at com.mysql.jdbc.util.getinstance(util.java:384)  	at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1052)  	at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:4232)  	at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:4164)  	at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:926)  	at com.mysql.jdbc.mysqlio.proceedhandshakewithpluggableauthentication(mysqlio.java:1748)  	at com.mysql.jdbc.mysqlio.dohandshake(mysqlio.java:1288)  	at com.mysql.jdbc.connectionimpl.coreconnect(connectionimpl.java:2506)  	at com.mysql.jdbc.connectionimpl.connectonetryonly(connectionimpl.java:2539)  	at com.mysql.jdbc.connectionimpl.createnewio(connectionimpl.java:2321)  	at com.mysql.jdbc.connectionimpl.<init>(connectionimpl.java:832)  	at com.mysql.jdbc.jdbc4connection.<init>(jdbc4connection.java:46)  	at sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method)  	at sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source)  	at sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source)  	at java.lang.reflect.constructor.newinstance(unknown source)  	at com.mysql.jdbc.util.handlenewinstance(util.java:409)  	at com.mysql.jdbc.connectionimpl.getinstance(connectionimpl.java:417)  	at com.mysql.jdbc.nonregisteringdriver.connect(nonregisteringdriver.java:344)  	at java.sql.drivermanager.getconnection(unknown source)  	at java.sql.drivermanager.getconnection(unknown source)  	at org.springframework.jdbc.datasource.drivermanagerdatasource.getconnectionfromdrivermanager(drivermanagerdatasource.java:173)  	at org.springframework.jdbc.datasource.drivermanagerdatasource.getconnectionfromdriver(drivermanagerdatasource.java:164)  	at org.springframework.jdbc.datasource.abstractdriverbaseddatasource.getconnectionfromdriver(abstractdriverbaseddatasource.java:153)  	at org.springframework.jdbc.datasource.abstractdriverbaseddatasource.getconnection(abstractdriverbaseddatasource.java:119)  	at org.hibernate.engine.jdbc.connections.internal.datasourceconnectionproviderimpl.getconnection(datasourceconnectionproviderimpl.java:139)  	at org.hibernate.tool.hbm2ddl.suppliedconnectionproviderconnectionhelper.prepare(suppliedconnectionproviderconnectionhelper.java:51)  	at org.hibernate.tool.hbm2ddl.databaseexporter.<init>(databaseexporter.java:52)  	at org.hibernate.tool.hbm2ddl.schemaexport.execute(schemaexport.java:367)  	at org.hibernate.tool.hbm2ddl.schemaexport.create(schemaexport.java:304)  	at org.hibernate.tool.hbm2ddl.schemaexport.create(schemaexport.java:293)  	at org.hibernate.internal.sessionfactoryimpl.<init>(sessionfactoryimpl.java:517)  	at org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:1857)  	at org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl$4.perform(entitymanagerfactorybuilderimpl.java:850)  	at org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl$4.perform(entitymanagerfactorybuilderimpl.java:843)  	at org.hibernate.boot.registry.classloading.internal.classloaderserviceimpl.withtccl(classloaderserviceimpl.java:397)  	at org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.build(entitymanagerfactorybuilderimpl.java:842)  	at org.hibernate.jpa.hibernatepersistenceprovider.createcontainerentitymanagerfactory(hibernatepersistenceprovider.java:152)  	at org.hibernate.ejb.hibernatepersistence.createcontainerentitymanagerfactory(hibernatepersistence.java:67)  	at org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.createnativeentitymanagerfactory(localcontainerentitymanagerfactorybean.java:288)  	at org.springframework.orm.jpa.abstractentitymanagerfactorybean.afterpropertiesset(abstractentitymanagerfactorybean.java:310)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods(abstractautowirecapablebeanfactory.java:1547)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1485)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:524)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:461)  	at org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:295)  	at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:223)  	at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:292)  	at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:198)  	at org.springframework.beans.factory.support.defaultlistablebeanfactory.getbeansoftype(defaultlistablebeanfactory.java:439)  	at org.springframework.beans.factory.beanfactoryutils.beansoftypeincludingancestors(beanfactoryutils.java:277)  	at org.springframework.dao.support.persistenceexceptiontranslationinterceptor.detectpersistenceexceptiontranslators(persistenceexceptiontranslationinterceptor.java:139)  	at org.springframework.dao.support.persistenceexceptiontranslationinterceptor.<init>(persistenceexceptiontranslationinterceptor.java:79)  	at org.springframework.dao.annotation.persistenceexceptiontranslationadvisor.<init>(persistenceexceptiontranslationadvisor.java:71)  	at org.springframework.dao.annotation.persistenceexceptiontranslationpostprocessor.setbeanfactory(persistenceexceptiontranslationpostprocessor.java:85)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeawaremethods(abstractautowirecapablebeanfactory.java:1508)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1476)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:524)  	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:461)  	at org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:295)  	at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:223)  	at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:292)  	at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:198)  	at org.springframework.context.support.abstractapplicationcontext.registerbeanpostprocessors(abstractapplicationcontext.java:741)  	at org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:464)  	at org.springframework.context.support.classpathxmlapplicationcontext.<init>(classpathxmlapplicationcontext.java:139)  	at org.springframework.context.support.classpathxmlapplicationcontext.<init>(classpathxmlapplicationcontext.java:93)  	at ao.medasys.ma.testjpa.test1(testjpa.java:19)  	at sun.reflect.nativemethodaccessorimpl.invoke0(native method)  	at sun.reflect.nativemethodaccessorimpl.invoke(unknown source)  	at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source)  	at java.lang.reflect.method.invoke(unknown source)  	at org.junit.runners.model.frameworkmethod$1.runreflectivecall(frameworkmethod.java:50)  	at org.junit.internal.runners.model.reflectivecallable.run(reflectivecallable.java:12)  	at org.junit.runners.model.frameworkmethod.invokeexplosively(frameworkmethod.java:47)  	at org.junit.internal.runners.statements.invokemethod.evaluate(invokemethod.java:17)  	at org.junit.internal.runners.statements.runbefores.evaluate(runbefores.java:26)  	at org.junit.runners.parentrunner.runleaf(parentrunner.java:325)  	at org.junit.runners.blockjunit4classrunner.runchild(blockjunit4classrunner.java:78)  	at org.junit.runners.blockjunit4classrunner.runchild(blockjunit4classrunner.java:57)  	at org.junit.runners.parentrunner$3.run(parentrunner.java:290)  	at org.junit.runners.parentrunner$1.schedule(parentrunner.java:71)  	at org.junit.runners.parentrunner.runchildren(parentrunner.java:288)  	at org.junit.runners.parentrunner.access$000(parentrunner.java:58)  	at org.junit.runners.parentrunner$2.evaluate(parentrunner.java:268)  	at org.junit.runners.parentrunner.run(parentrunner.java:363)  	at org.eclipse.jdt.internal.junit4.runner.junit4testreference.run(junit4testreference.java:50)  	at org.eclipse.jdt.internal.junit.runner.testexecution.run(testexecution.java:38)  	at org.eclipse.jdt.internal.junit.runner.remotetestrunner.runtests(remotetestrunner.java:467)  	at org.eclipse.jdt.internal.junit.runner.remotetestrunner.runtests(remotetestrunner.java:683)  	at org.eclipse.jdt.internal.junit.runner.remotetestrunner.run(remotetestrunner.java:390)  	at org.eclipse.jdt.internal.junit.runner.remotetestrunner.main(remotetestrunner.java:197)  info : org.hibernate.tool.hbm2ddl.schemaexport - hhh000230: schema export complete  info : org.springframework.context.support.classpathxmlapplicationcontext - bean 'myemf' of type [class org.springframework.orm.jpa.localcontainerentitymanagerfactorybean] not eligible getting processed beanpostprocessors (for example: not eligible auto-proxying)  info : org.springframework.beans.factory.support.defaultlistablebeanfactory - pre-instantiating singletons in org.springframework.beans.factory.support.defaultlistablebeanfactory@27f723: defining beans [myemf,datasource,transactionmanager,org.springframework.aop.config.internalautoproxycreator,org.springframework.transaction.annotation.annotationtransactionattributesource#0,org.springframework.transaction.interceptor.transactioninterceptor#0,org.springframework.transaction.config.internaltransactionadvisor,persistenceexceptiontranslationpostprocessor]; root of factory hierarchy

this applicationcontext.xml

<?xml version="1.0" encoding="utf-8"?>  <beans xmlns="http://www.springframework.org/schema/beans"     xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"     xmlns:tx="http://www.springframework.org/schema/tx"     xsi:schemalocation="        http://www.springframework.org/schema/beans         http://www.springframework.org/schema/beans/spring-beans-3.2.xsd        http://www.springframework.org/schema/tx         http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">        <bean id="myemf" class="org.springframework.orm.jpa.localcontainerentitymanagerfactorybean">        <property name="datasource" ref="datasource" />        <property name="packagestoscan" value="org.baeldung.persistence.model" />        <property name="jpavendoradapter">           <bean class="org.springframework.orm.jpa.vendor.hibernatejpavendoradapter" />        </property>        <property name="jpaproperties">           <props>              <prop key="hibernate.hbm2ddl.auto">create</prop>              <prop key="hibernate.dialect">org.hibernate.dialect.mysql5dialect</prop>              <prop key="hibernate.show_sql">true</prop>           </props>        </property>     </bean>        <bean id="datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource">        <property name="driverclassname" value="com.mysql.jdbc.driver" />        <property name="url" value="jdbc:mysql://localhost:3306/appeldoffre" />        <property name="username" value="root" />        <property name="password" value="secret" />     </bean>        <bean id="transactionmanager" class="org.springframework.orm.jpa.jpatransactionmanager">        <property name="entitymanagerfactory" ref="myemf" />     </bean>     <tx:annotation-driven transaction-manager="transactionmanager"/>        <bean id="persistenceexceptiontranslationpostprocessor"        class="org.springframework.dao.annotation.persistenceexceptiontranslationpostprocessor" />     </beans>

this mu pom.xml file :

<?xml version="1.0" encoding="utf-8"?>  <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/maven-v4_0_0.xsd">  	<modelversion>4.0.0</modelversion>  	<groupid>ao.medasys</groupid>  	<artifactid>ma</artifactid>  	<name>appelsd'offres</name>  	<packaging>war</packaging>  	<version>1.0.0-build-snapshot</version>  	<properties>  		<java-version>1.6</java-version>  		<org.springframework-version>3.2.2.release</org.springframework-version>  		<org.aspectj-version>1.6.10</org.aspectj-version>  		<org.slf4j-version>1.6.6</org.slf4j-version>  	</properties>  	<dependencies>  		<!-- spring -->  		<dependency>  			<groupid>org.springframework</groupid>  			<artifactid>spring-context</artifactid>  			<version>${org.springframework-version}</version>  			<exclusions>  				<!-- exclude commons logging in favor of slf4j -->  				<exclusion>  					<groupid>commons-logging</groupid>  					<artifactid>commons-logging</artifactid>  				 </exclusion>  			</exclusions>  		</dependency>  		<dependency>  			<groupid>org.springframework</groupid>  			<artifactid>spring-webmvc</artifactid>  			<version>${org.springframework-version}</version>  		</dependency>  				  		<!-- aspectj -->  		<dependency>  			<groupid>org.aspectj</groupid>  			<artifactid>aspectjrt</artifactid>  			<version>${org.aspectj-version}</version>  		</dependency>	  		  		<!-- logging -->  		<dependency>  			<groupid>org.slf4j</groupid>  			<artifactid>slf4j-api</artifactid>  			<version>${org.slf4j-version}</version>  		</dependency>  		<dependency>  			<groupid>org.slf4j</groupid>  			<artifactid>jcl-over-slf4j</artifactid>  			<version>${org.slf4j-version}</version>  			<scope>runtime</scope>  		</dependency>  		<dependency>  			<groupid>org.slf4j</groupid>  			<artifactid>slf4j-log4j12</artifactid>  			<version>${org.slf4j-version}</version>  			<scope>runtime</scope>  		</dependency>  		<dependency>  			<groupid>log4j</groupid>  			<artifactid>log4j</artifactid>  			<version>1.2.15</version>  			<exclusions>  				<exclusion>  					<groupid>javax.mail</groupid>  					<artifactid>mail</artifactid>  				</exclusion>  				<exclusion>  					<groupid>javax.jms</groupid>  					<artifactid>jms</artifactid>  				</exclusion>  				<exclusion>  					<groupid>com.sun.jdmk</groupid>  					<artifactid>jmxtools</artifactid>  				</exclusion>  				<exclusion>  					<groupid>com.sun.jmx</groupid>  					<artifactid>jmxri</artifactid>  				</exclusion>  			</exclusions>  			<scope>runtime</scope>  		</dependency>    		<!-- @inject -->  		<dependency>  			<groupid>javax.inject</groupid>  			<artifactid>javax.inject</artifactid>  			<version>1</version>  		</dependency>  				  		<!-- servlet -->  		<dependency>  			<groupid>javax.servlet</groupid>  			<artifactid>servlet-api</artifactid>  			<version>2.5</version>  			<scope>provided</scope>  		</dependency>  		<dependency>  			<groupid>javax.servlet.jsp</groupid>  			<artifactid>jsp-api</artifactid>  			<version>2.2</version>  		</dependency>  		<dependency>  			<groupid>javax.servlet</groupid>  			<artifactid>jstl</artifactid>  			<version>1.2</version>  		</dependency>  	  		<!-- test -->  		<dependency>  			<groupid>junit</groupid>  			<artifactid>junit</artifactid>  			<version>4.12</version>  		</dependency>   		<!-- hibernate -->  		<dependency>  			<groupid>org.hibernate</groupid>  			<artifactid>hibernate-entitymanager</artifactid>  			<version>4.3.5.final</version>  			<scope>runtime</scope>  		</dependency>   		<dependency>  	<groupid>org.hibernate.javax.persistence</groupid>  	<artifactid>hibernate-jpa-2.0-api</artifactid>  	<version>1.0.1.final</version>  </dependency>  	  		<!-- mysql connector -->   		<dependency>  			<groupid>mysql</groupid>  			<artifactid>mysql-connector-java</artifactid>  			<version>5.1.30</version>  			<scope>runtime</scope>  		</dependency>  		<dependency>          <groupid>org.hibernate</groupid>          <artifactid>hibernate-search</artifactid>          <version>4.2.0.final</version>      </dependency>    		<dependency>  			<groupid>org.springframework</groupid>  			<artifactid>spring-tx</artifactid>  			<version>3.2.2.release</version>  		</dependency>  		<dependency>  			<groupid>org.springframework</groupid>  			<artifactid>spring-orm</artifactid>  			<version>3.2.2.release</version>  		</dependency>  		<dependency>  			<groupid>org.springframework</groupid>  			<artifactid>spring-beans</artifactid>  			<version>3.2.2.release</version>  		</dependency>  		<dependency>  			<groupid>org.springframework</groupid>  			<artifactid>spring-core</artifactid>  			<version>3.2.2.release</version>  		</dependency>    	</dependencies>      <build>          <plugins>              <plugin>                  <artifactid>maven-eclipse-plugin</artifactid>                  <version>2.9</version>                  <configuration>                      <additionalprojectnatures>                          <projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>                      </additionalprojectnatures>                      <additionalbuildcommands>                          <buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>                      </additionalbuildcommands>                      <downloadsources>true</downloadsources>                      <downloadjavadocs>true</downloadjavadocs>                  </configuration>              </plugin>              <plugin>                  <groupid>org.apache.maven.plugins</groupid>                  <artifactid>maven-compiler-plugin</artifactid>                  <version>2.5.1</version>                  <configuration>                      <source>1.6</source>                      <target>1.6</target>                      <compilerargument>-xlint:all</compilerargument>                      <showwarnings>true</showwarnings>                      <showdeprecation>true</showdeprecation>                  </configuration>              </plugin>              <plugin>                  <groupid>org.codehaus.mojo</groupid>                  <artifactid>exec-maven-plugin</artifactid>                  <version>1.2.1</version>                  <configuration>                      <mainclass>org.test.int1.main</mainclass>                  </configuration>              </plugin>          </plugins>      </build>  </project>

i have deal last 3 day, didn't solve it. me, please.

the exception caused by

unknown database 'appeldoffre'

create database , exception should gone.


Popular posts from this blog