Hi, everybody:
I'm quite new to hibernate. Now i just want to use Hibernate as a query tool over the existed database. (in MYSQL)

I also donn't need anything from the database's table, only a few column is needed.

I defined the necessary mapping file and the hibernate configuration file. But when i execute:
session.createQuery("from PortBean").list();
not only nothing return, but also my existed table is erased with all its datas. It looks like a new table is created with only those columns mapping defined. And also, no data in that table.

Can anyone show some light for me? I thought this much be a basic question, but i just donn't know how to solve. In which case, the hibernate will erase all the data and create a new table?

In addition: i notice the hibernate output, after i change the table to a view(portview):
ERROR SchemaExport:274 - Unsuccessful: create table portview .
ERROR SchemaExport:275 - Table 'portview' already exists

it looks like hibernate try to create the table first before query.

cheers,
Warren

Hi,
Just verify the value for property "hbm2ddl.auto". ( hibernate.cfg.xml )

Looks like, in your case, it has the value "create".

You can comment out that option. ( or not set that if you are doing it programatically )

http://www.hibernate.org/hib_docs/v3/re ... n-optional

----------------------------------------------------------------------
Rate the reply if you find it helpful