java - Getting error while inserting data to MySQL using Hibernate -
hi developing project in eclipse using hibernate. found error in hibernate.cfg.xml file
please problem.
i have included necessary libraries.
hibernate.cfg.xml
<hibernate-configuration> <session-factory> <!-- related connection start --> <property name="connection.driver_class">com.mysql.jdbc.driver</property> <property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property> <property name="connection.user">root</property> <property name="connection.password">93pb3ganv0</property> <!-- related connection end --> <!-- related hibernate properties start --> <property name="show_sql">true</property> <property name="dailet">org.hibernate.dialect.mysqldialect</property> <property name="hbm2ddl.auto">update </property> <!-- related hibernate properties end --> <!-- related mapping start --> <mapping resource="user.hbm.xml"/> <!-- related mapping end --> </session-factory> </hibernate-configuration>
user.hbm.xml
<?xml version='1.0' encoding='utf-8'?>
<hibernate-mapping> <class name="mypack.dataprovider" table="user_info"> <id name="user_id" column="id"> <generator class="assinged"></generator> </id> <property name="user_name" column="name"></property> <property name="user_address" column="address"></property> </class> </hibernate-mapping>
dataprovider.java
package mypack; public class dataprovider { private int user_id; public int getuser_id() { return user_id; } public void setuser_id(int user_id) { this.user_id = user_id; } public string getuser_name() { return user_name; } public void setuser_name(string user_name) { this.user_name = user_name; } public string getuser_address() { return user_address; } public void setuser_address(string user_address) { this.user_address = user_address; } private string user_name; private string user_address; }
datainsertion.java
package mypack; import org.hibernate.session; import org.hibernate.sessionfactory; import org.hibernate.transaction; import org.hibernate.cfg.configuration; public class datainsertion { public static void main(string[] args) { new datainsertion().insertinfo(); } public void insertinfo() { configuration con = new configuration(); con.configure("hibernate.cfg.xml"); sessionfactory sf = con.buildsessionfactory(); session session = sf.opensession(); dataprovider provider = new dataprovider(); provider.setuser_id(121); provider.setuser_name("mehandi hassan"); provider.setuser_address("delhi"); transaction tr = session.begintransaction(); session.save(provider); system.out.println("object save successfully"); tr.commit(); session.close(); sf.close(); } }
error:
may 29, 2015 5:34:46 pm org.hibernate.annotations.common.reflection.java.javareflectionmanager <clinit> info: hcann000001: hibernate commons annotations {4.0.5.final} may 29, 2015 5:34:46 pm org.hibernate.version logversion info: hhh000412: hibernate core {4.3.10.final} may 29, 2015 5:34:46 pm org.hibernate.cfg.environment <clinit> info: hhh000206: hibernate.properties not found may 29, 2015 5:34:46 pm org.hibernate.cfg.environment buildbytecodeprovider info: hhh000021: bytecode provider name : javassist may 29, 2015 5:34:46 pm org.hibernate.cfg.configuration configure info: hhh000043: configuring resource: hibernate.cfg.xml may 29, 2015 5:34:46 pm org.hibernate.cfg.configuration getconfigurationinputstream info: hhh000040: configuration resource: hibernate.cfg.xml exception in thread "main" org.hibernate.mappingexception: invalid configuration @ org.hibernate.cfg.configuration.doconfigure(configuration.java:2160) @ org.hibernate.cfg.configuration.configure(configuration.java:2077) @ mypack.datainsertion.insertinfo(datainsertion.java:18) @ mypack.datainsertion.main(datainsertion.java:11) caused by: org.xml.sax.saxparseexception; linenumber: 1; columnnumber: 25; document invalid: no grammar found. @ com.sun.org.apache.xerces.internal.util.errorhandlerwrapper. createsaxparseexcepti on (unknown source) @ com.sun.org.apache.xerces.internal.util. errorhandlerwrapper.error(unknown source) @ com.sun.org.apache.xerces.internal.impl. xmlerrorreporter.reporterror(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmlerrorreporter.reporterror(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmlerrorreporter.reporterror(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmlnsdocumentscannerimpl.scanstartelement(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmlnsdocumentscannerimpl$nscontentdriver. scanrootelementhook(unknown source) @ com.sun.org.apache.xerces.internal.impl. xmldocumentfragmentscannerimpl$fragmentcontentdriver.next(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmldocumentscannerimpl$prologdriver.next(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmldocumentscannerimpl.next(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmlnsdocumentscannerimpl.next(unknown source) @ com.sun.org.apache.xerces.internal. impl.xmldocumentfragmentscannerimpl. scandocument(unknown source) @ com.sun.org.apache.xerces. internal.parsers.xml11configuration.parse(unknown source) @ com.sun.org.apache.xerces.internal. parsers.xml11configuration.parse(unknown source) @ com.sun.org.apache.xerces.internal. parsers.xmlparser.parse(unknown source) @ com.sun.org.apache.xerces.internal. parsers.abstractsaxparser.parse(unknown source) @ com.sun.org.apache.xerces. internal.jaxp.saxparserimpl$jaxpsaxparser.parse(unknown source) @ org.dom4j.io.saxreader.read(saxreader.java:465) @ org.hibernate.cfg.configuration.doconfigure(configuration.java:2157) ... 3 more
you need annotate dataprovider @entity , id @id
@entity public class dataprovider { @id private int user_id; @column private string user_name; @column private string user_address;
... setters getters }
Comments
Post a Comment