Hibernate version: 3.1.3

Mapping documents: hibernate.cfg.xml



Name and version of the database you are using: PostgreSQL 8.2

Hi everybody!
I have a class that load the data into the database and another one that looks into it and shows the data. When I run the first one, hbm2ddl.auto property is as above. When I run the second one, I must delete that cfg entry, otherwise my program drops the table, re-creates it (empty) and shows nothing (of course).

My question is:

Is it necessary for me to change everytime the config file or is there another way???

Not, you can do it programatically. See:

http://www.hibernate.org/hib_docs/v3/re ... ogrammatic

Yes, but I can't figure out how to use this info...
Can you post some code, please?
Thanx in advance...

What do you exactly want to do?

SpectraLoader.java loads spectra into the db, SpectraView.java lists spectra already in the db. If I run SpectraLoader, then SpectraView, my table SPECTRA is created and populated by SpectraLoader, then recreated and printed (nothing!) by SpectraView ;-(
I would insert some lines of code into SpectraView to check if the table SPECTRA already exists. If no, create, if yes, update. I'm not able...
If you need, I'll post all my code.

Well, i do not think you need to re-create de table each time. Run the app once with <property name="hbm2ddl.auto">create</property> so the tables are created, and then comment out that property from the hibernate cfg file. If you need fresh data every time, delete all rows from the table before inserting the new data...