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.