File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes hibernate with struts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply locked New topic
Author

hibernate with struts

subha nair
Greenhorn

Joined: Jun 19, 2008
Posts: 23
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.

Initial SessionFactory creation failed.java.lang.NoClassDefFoundError: org/hibernate/engine/query/sql/NativeSQLQueryReturn

Please help me in this..It is urgent,,
Thanks
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

Just looks like the runtime can't find a certain Hibernate jar file.

Where are you packaging your Hibernate JAR files? In the lib directory of the web module is one common place to put them.

At the very least, you should have these on the classpath of the classloader that creates the Hibernate Session and SessionFactory:

1. ejb3-persistence.jar
2. hibernate-commons-annotations.jar
3. hibernate-annotations.jar
4. hibernate3.jar

You also need all the libraries that these files link to.


-Cameron McKenzie
subha nair
Greenhorn

Joined: Jun 19, 2008
Posts: 23
Thankxx a lot..
I reloaded all the library in the lib folder.
Now it's working.I could get the result page..

Thanksss
subha nair
Greenhorn

Joined: Jun 19, 2008
Posts: 23
I am using Mysql and hibernate annotations. Below shown is Employee.java

@Entity
@Table(name = "employee")
public class Employee implements Serializable {

public Employee() {

}
@Id
@Column(name = "id")
Integer id;

@Column(name = "name")
String name;

public Integer getId() {
return id;
}

public void setId(Integer id) {
this.id = id;
}}

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"

Help pleasee
subha nair
Greenhorn

Joined: Jun 19, 2008
Posts: 23
Sorry I got it working..

i had previously set <property name="hbm2ddl.auto">none</property>

now I made it as <property name="hbm2ddl.auto">create</property>
Aditya Bhardwaj
Greenhorn

Joined: Aug 12, 2012
Posts: 4
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.

Initial SessionFactory creation failed.java.lang.NoClassDefFoundError: org/hibernate/engine/query/sql/NativeSQLQueryReturn

Please help me in this..It is urgent,,
Thanks
Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1680
    
    7

Please do not resurrect old threads for new questions. Please start a new topic for your question.


[How To Ask Questions][Read before you PM me]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: hibernate with struts