i need to add table at runtime to existing db schema
i made a business object java code generator
and i compiled this BO, and when i use this BO compiled, i got class not mapped
any one have an idea
thx.

use <prop key="hibernate.hbm2ddl.auto">create</prop> in your hibernate config file

thx for ur reply
do i need to add something in the code once i compile the new Business Object ?

Only add auto to true in hibernate config file and run.

i did this and the DB are recreated

what i need is after i run the application i wnat to add a new Business object and use this BO at runtime without stopping the application recompile it

BO at runtime means what? Do you want to create an object(class) for newly created(at runtime) table without mapping file?

at runtime i create a table in the Database,
i generate a java Class corresponding on business object to a new table added , (annotation mapping is described into the Java Class )
and i compile this class;
and then i want to use this BO
so i got as error class not mapped.

Please post your code and error message

at runtime the end user create a table in the DataBase Address_type
and in the server , i have a service that generate a Business object to the created new table [businness object' name = AddressType]

AnnotationConfiguration myConfiguration = new AnnotationConfiguration();

myConfiguration.setProperty("hibernate.dialect",
"it.roxana.tools.hibernate.MySQLDialect").setProperty(
"hibernate.connection.driver_class",
"com.mysql.jdbc.Driver").setProperty(
"hibernate.connection.username", "root").setProperty(
"hibernate.connection.password", "").setProperty(
"hibernate.connection.url",
"jdbc:mysql://localhost:3306/testDB?autoReconnect=true");

myConfiguration.addPackage("it.test.rc.model.bo");
hibSessionFactory = myConfiguration.configure("hibernate.cfg.xml")
.buildSessionFactory();

the hibSessionFactory definition is (in spring-data.xml )

<bean id="hibSessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="packagesToScan" value="it.test.rc.model" />
<property name="annotatedPackages">
<list>
<value>it.test.rc.model.bo</value>
</list>
</property>
<property name="configLocation">
<value>classpath:hibernate.cfg.xml</value>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">it.roxana.tools.hibernate.MySQLDialect</prop>
<prop key="hibernate.query.substitutions">true 1, false 0</prop>
</props>
</property>
<property name="exposeTransactionAwareSessionFactory">
<value>false</value>
</property>
</bean>



finally i got the folowwing error

org.hibernate.hql.ast.QuerySyntaxException: AddressType is not mapped [SELECT adt.addressTypeId AS pk, adt.addressTypeName AS addressTypeName
FROM AddressType adt
]

for info, the new Business object generated is compiled by a java service
before i use the new BO

Please use addAnnotatedClass() for adding class.

For your information

To add an annotated class to the configuration, you must call the addAnnotatedClass method with the Class of the class that you want to persist. (Yes, that's a great sentence to read aloud.) If you were unaware, you might instead try to call the addClass method that AnnotationConfiguration inherits from Configuration, and if you did, you would be mistaken because that method is looking for XML metadata in a classpath resource.

i think u need to compile the code.once u have cretaed the new table ,add information to configuration and resources .without compiling that code its not possible