Hi all,

First sorry, my english isn't good! :S

I need add columns to tables at runtime. The user at any time can be create new columns in a table.

How I can make this? Is it possible? I try find some example or documents, but I don´t get any sucess.

Maybe, I don´t make the right question on the google! :P

I using a Hibernate 3.

Thanks in advance,

Murilo Henrique Marecki Foltran

Use native SQL/JDBC to create the table, then use DOM to create the model and the recreate the session factory to take account of the new mappings and then work out a way of creating POJOs to represent the mapping.

Ok...

I have a deployed application in Jboss with jar files.

The database is already created, and everything is alright.

Then the user, throught the system deployed, create a new column in the table 'client' which have this columns.

Client
-------
id -> long
name -> string

and user create a new column called 'email'

Client
-------
id -> long
name -> string
email -> string

So, I have to 'alter table' and put the new column via JDBC.
After this recreate the hbm´s and the session factory.

I understood the process until here.

And now I create the new pojo and put into the jars? So when the jboss reboot, the system knows the new column? Is it correct?

You have an example? It´s a confused solution, or I have to learn more about hibernate. :D

Sorry by my english :S,

Thanks in advance again,

Murilo

The point where you stopped understanding the process is roughly the same point as where I get stuck on how to proceed. I've never tried this, but I have a feeling it would be possible to use either reflection or byte code modification to create the POJOs. How JBoss would react to the packaging I don't know.

First Thanks by your attention.

Maybe works, but is a crazy solution. The worst part of solution is how put the new hbm and pojo files.

With this solution, We tried "alter table" without hibernate knows this, it is not the solution that I think initially.

I want modify the table with hibernate, but I almost give up this solution.

Maybe I use jdbc to modify and to make select or updates in table.

And I think, this requirement doesn't suported by any java framework.

The problem is up to date the files.

You have a bigger imagination. Congratulations!!!! heheheh

So, if I find a good solution, I post this here!!! OK?

Thanks a lot,

Murilo