I am developing a simple application using hibernate 3.3( using annotations),struts(1.3),eclipse(3.3),tomcat(5.5) I have written the hibernate.cfg.xml file as below..
<hibernate-configuration> <session-factory>
<!-- Database connection settings --> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://localhost:3306/company</property> <property name="connection.username">root</property> <property name="connection.password">root</property> <!-- JDBC connection pool (use the built-in) --> <property name="connection.pool_size">1</property> <!-- SQL dialect --> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <!-- Enable Hibernate's automatic session context management --> <property name="current_session_context_class">thread</property> <!-- Disable the second-level cache --> <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <!-- Echo all executed SQL to stdout --> <property name="show_sql">true</property> <!-- Drop and re-create the database schema on startup --> <property name="hbm2ddl.auto">none</property> <mapping class="com.test.Employee"/> </session-factory> </hibernate-configuration>
I am getting an exception while runnign the program.
I have created a database in my Mysql as company. I have not created any table in mysql. will the above code dynamically create table and the columns
I have written like this .But on submitting the values in the registration page, I am getting an error...
java.lang.RuntimeException: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update java.sql.BatchUpdateException: Base table or view not found message from server: "Table 'company.employee' doesn't exist"
subha nair wrote:I am developing a simple application using hibernate 3.3( using annotations),struts(1.3),eclipse(3.3),tomcat(5.5)
I have written the hibernate.cfg.xml file as below..
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/company</property>
<property name="connection.username">root</property>
<property name="connection.password">root</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">none</property>
<mapping class="com.test.Employee"/>
</session-factory>
</hibernate-configuration>
I am getting an exception while runnign the program.