[b]Hibernate version:[2.1.7c]
[b]Name and version of the database you are using:[MySQL 1.4]
[b]Name of server: [Tomcat 5.0.28]

hi,

after you run the build file and create the hibernate2.jar file what interface do you use to compile/run your hibernate applications.

do you need to set up any classpaths?

or do you just need to put the following jar files into WEB-INF\lib folder in your webapplication?

cglib-full-2.0.2.jar
commons-collections-2.1.1.jar
commons-logging-1.0.4.jar
dom4j-1.4.jar
ehcache-0.9.jar
hibernate2.jar
jta.jar
log4j-1.2.8.jar
mysql-connector-java-3.0.15-ga-bin.jar
odmg-3.0.jar

if any of ye know of any good tutorials on the web could you please please the links.

thanks for your help

Pretty much yes, put them in the WEB-INF/lib. Also, I recommend implementing the Open-Session-In-View pattern, which will ensure 1) That you have a Hibernate session open for the whole request, and 2) that your configuration is loaded on app startup.

To learn about that one, go to:

http://www.hibernate.org/43.html

Try these tutorials

http://www.onjava.com/pub/a/onjava/2004 ... rnate.html
http://www.onjava.com/pub/a/onjava/2004 ... bapps.html

Thanks cardsharp for your help, ill give those tutorials and the Open-Session-In-View pattern a go.

in the tutorial it uses HypersonicSQL, i was wondering how you insert the jdbc connection for a MySQL database.

ive inserted this into my server.xml file but this doesnt work. its was in another tutorial i found but not in the ones you posted earlier. im really sure if its the right jdbc connection for MySQL.





the tutorial also doesnt specify where you should put the following code
this has to be altered to suit the MySQL


cheers for the help

sorry heres my hibernate.cf.xml file as well.

You can either configure Hibernate using an XML file or a .property file. The stuff shown with:

hibernate.connection.username=sa
hibernate.connection.password=
hibernate.connection.url=jdbc:hsqldb:/home/davor/hibernate/orders
hibernate.connection.driver_class=org.hsqldb.jdbcDriver
hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect

would go into the hibernate.properties file. If you wanted it in the hibernate.cf.xml file, you'd simply do something like:

<hibernate-configuration>
<session-factory>
<property name="connection.datasource">java:comp/env/jdbc/quickstart</property>
<property name="show_sql">false</property>
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<!-- NOTE: this is the dialect for MySQL, did you want that or PostgreSQL? -->

I notice in your configuration you hadn't selected the MySQL Dialect. Hibernate needs some hints as to how to interact with your database. These hints are called a "dialect" and you have to specify the right one in your configuration.

Since you're using Tomcat, the username and password are set up in the Context. Also, I've run into problems with Tomcat's JNDI datasources when I haven't specified the resource-ref in my Web.xml properly. For example, in your /WEB-INF/web.xml you'll want something like:

<resource-ref>
<description>JDBC data source Factory</description>
<res-ref-name>jdbc/quickstart</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>


So, what else? When you say "it doesn't work" what is the exception you're seeing in the log?

i decided to stick to the example in the tutorial and ive kept the application outside of tomcat for the moment.

its MySQL im trying to get running.

When i try to run a query i get the following error.

Exception: The user must supply a JDBC connection

This is my hibernate.properties file.



the hibernate.connection.url seems to be correct as i extracted the files into the relative folders just to be on the safe side although its giving me the error above about a jdbc connection but i think the problem may be here.



the name of my database is "tutorial". is the right syntax for a MySQL database?

thanks again for the help

sorry a slight type in this line



it should have read
"the

hibernate.connection.driver_class=com.mysql.jdbc.Driver

seems to be correct as i extracted the files into the relative folders just to be on the safe side although its giving me the error above about a jdbc connection but i think the problem may be here."

Do you also have the hibernate.cfg.xml file in your classpath? It could be that hibernate is picking that up instead of your hibernate.properties file. If you're going to use hibernate.properties instead of hibernate.cfg.xml, it's a good idea to remove the hibernate.cfg.xml from the classpath.