simple question:

i have a simple application consisting of:

- A Value Object(.java file)
- The XML mapping (.hbm.xml file)
- A hibernate.properties file
- A java class that makes a jdbc connection and does a simple test

All the files are in the same directory, but still when i run the test it says:
"hibernate.properties not found"

Where is hibernate.properties supposed to be?

thanks/cheers

In the root of the classpath

ok,


but... sorry if the question is silly, anyway its in Hibernate Beginners :-)

i have all that files in a common directory:

/home/myuser/testapp

java is installed in /opt/sun-jdk-1.4.01/

where exactly is that "root of the classpath" ???

thanks again...

cheers

If you are writing a stand-alone application (not a webapp), the main directory of your project is where you want to put the hibernate.properties file. If you are using a webapp, you want to put it in your project's WEB-INF/classes folder.

Regards,
David

ok, my app is a stand-alone application...
and the hibernate.properties file is in the same directory as all of the other files...

still, when i run the program it says it cannot find hibernate.properties.

any idea of what the problem might be?

thanks

Are you invoking the java application from the same directory as your hibernate.properties file? Is your configuration build like this:

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;

public class Me {

public static void main(String[] args) {
Configuration cfg = null;
SessionFactory sf = null;
try {
cfg = (new Configuration()).addFile("Misc.hbm.xml");
sf = cfg.buildSessionFactory();
System.out.println("Three.");
Session sess = sf.openSession();
sess.close();

} catch (HibernateException he) {
System.out.println("Hibernate exception: " + he.getMessage());
} catch (IOException ioe) {
}
}
}

Regards,
David

yes, i am invoking them from the same directory.

i put all the files in:
http://azambuja.homelinux.com/files

take a look...

thank you very much for your help!

Marcelo

You probably shouldn't .addProperties an empty Properties object, but it worked with our without that call. I did have to rename your file, supplied as hibernate.txt, to the proper name of hibernate.properties so it would be seen and used (with the database name, username, and password changed for my MySQL database).

The problem seems to be somewher else. I recommend you check your classpath and post the output messages (errors, diagnostics, etc.).

I see your demo code manually creates the JDBC connection. The code I included works on it's own by using information in the hibernate.properties file to do that for you. If you ever need the raw JDBC connection, just call session.connection() to use it as a normal JDBC connectin, without hibernate's influence.

Again, my one change is marked in the below comments but it worked both with and without that alteration.

cfg = new Configuration() .addClass(Person.class);
// removed useless addProperties - yours is empty!
// .addProperties(props);

Regards,
David

ok, here's the output:



hope it can help!

thanks one more time ;-)

Marcelo

the are there just because i wanted to highlight them, but as you and i can see it did not make the text bold!

Marcelo

I see the problem. Primary keys <id.../> need to have a 'generator' tag inside them. I didn't see that error message since I was using Eclipse v2.1. Once I used the command line java, I saw that error.

The fix is to change your <id ../>.. </id> tag from:

<id name="id" type="string" unsaved-value="null" >
<column name="ID" sql-type="varchar(10)" not-null="true"/>
</id>

TO include a GENERATOR tag:

<id name="id" type="string" unsaved-value="null" >
<column name="ID" sql-type="varchar(10)" not-null="true"/>
<generator class="assigned" />
</id>

I normally used "native" as the Generated type under MySQL and with the type being an int(11), or bigint (Long to hibernate) using AUTO_INCREMENT. I honestly don't know how Strings work with mysql for auto-key generation.

Anyway, with the generator set appropriately, the errors disappear:

D:\Code\HIBERN~1>java -cp mysql-connector-java-3.0.9-stable-bin.jar;commons-lang-2.0.jar;hibernate2.jar;.;dom4j.jar;comm
ons-logging-1.0.3.jar;commons-beanutils-1.6.1.jar;commons-collections-2.1.jar;cglib.jar PersonDemo
Nov 7, 2003 3:19:41 PM net.sf.hibernate.cfg.Environment <clinit>
INFO: Hibernate 2.0.3
Nov 7, 2003 3:19:41 PM net.sf.hibernate.cfg.Environment <clinit>
INFO: loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=com.mysql.jdbc.Driver, hi
bernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.jdbc.use
_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', h
ibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, hibernate.proxool.pool_alias=pool1, hibernate.connect
ion.username=X, hibernate.connection.url=jdbc:mysql://localhost:3306/test, hibernate.show_sql=false, hibernate.c
onnection.password=Y, hibernate.statement_cache.size=25, hibernate.connection.pool_size=1}
Nov 7, 2003 3:19:41 PM net.sf.hibernate.cfg.Environment <clinit>
INFO: using java.io streams to persist binary types
Nov 7, 2003 3:19:41 PM net.sf.hibernate.cfg.Environment <clinit>
INFO: using CGLIB reflection optimizer
Nov 7, 2003 3:19:41 PM net.sf.hibernate.cfg.Environment <clinit>
INFO: JVM proxy support: true
Nov 7, 2003 3:19:41 PM net.sf.hibernate.cfg.Configuration addClass
INFO: Mapping resource: Person.hbm.xml
Nov 7, 2003 3:19:42 PM net.sf.hibernate.cfg.Binder bindRootClass
INFO: Mapping class: Person -> Person
Nov 7, 2003 3:19:42 PM net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing one-to-many association mappings
Nov 7, 2003 3:19:42 PM net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing foreign key constraints
Nov 7, 2003 3:19:42 PM net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Nov 7, 2003 3:19:42 PM net.sf.hibernate.dialect.Dialect <init>
INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect
Nov 7, 2003 3:19:42 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
Nov 7, 2003 3:19:42 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/test
Nov 7, 2003 3:19:42 PM net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=X, password=Y}
Nov 7, 2003 3:19:42 PM net.sf.hibernate.ps.PreparedStatementCache <init>
INFO: prepared statement cache size: 25
Nov 7, 2003 3:19:42 PM net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: Use outer join fetching: true
Nov 7, 2003 3:19:42 PM net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: Use scrollable result sets: true
Nov 7, 2003 3:19:42 PM net.sf.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: no JDNI name configured
Nov 7, 2003 3:19:42 PM net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: Query language substitutions: {no='N', true=1, yes='Y', false=0}
Person = Joπo da Silva6786955904

FYI, the generators can be found at:
http://www.hibernate.org/hib_docs/refer ... pping.html

Regards,
David

hello,

unfortunately i keep getting the hibernate.properties not found message...

this is kinda supernatural :-)

thanks for your time.

Marcelo

No seeing the hibernate.properties file means it is not in a place where the classpath can find it. So, let's backup and try a different question.

Are you running this as a standalone app or a webapp?

If a standalone app, is the hibernate.properties file located in the directory /home/myuser/testapp and does your classpath reference that directory (OR you run java from that directory and have added the current directory notation '.' to the classpath) ?

If it is a webapp, what is the exact path to your properties file? Perhaps
home/myuser/testapp/WEB-INF/classes/hibernate.properties?

Regards,
David

standalone app
the hibernate.properties is in the same dir as the other files
the classpath is:



thanks again.

Marcelo

There has to be something wrong with your file locations or your classpath. Using hibernate 2.0.3, I created a simple webapp where all jar's are in the main directory, the hibernate.properties file is in the main directory, my simple 'Dgf.java' class is in the main directory, and my supporting class are there. It created a sessionFactory fine and found the hibernate.properties file in that directory.

Please output the following, removing private information as necessary:
1) pwd (or echo it)
2) echo $CLASSPATH
3) ls
4) explain how you're invoking your application (ant, java, etc.). It looks like you're using "java PersonDemo" but you're not specifying the .jar files. I have to set my CLASSPATH to include the relative or full paths to the following jars:

CLASSPATH=.;./hibernate2.jar;./commons-lang-2.0.jar;./dom4j.jar;./commons-logging-1.0.3.jar;./commons-beanuti
ls-1.6.1.jar;./commons-collections.jar;./mysql-connector-java-3.0.9-stable-bin.jar;./cglib.jar;./cglib-asm.jar

Regards,
David