Hi,

I'm working on Web-Application (Tomcat), that mapps about 10 DB-Tables. A fatclient, which communicate via Webservice with the Server, can select, update, insert or delete some Information on the DB.
This part is already written and works fine.
Now, I want to include a dynamic part in the application. If the client does a query on a table (Testtable) that doesn't already exist on the DB, the whole configuration of the table (Tablename, attributenames and types, etc.) will be sent to the Web-Appl.
With this config-data I want to create a Pojo (Testtable.java), compile it, map it, create the table on the db and everything while runtime.
Is there an easier way to do that? Any suggestions?

Thanks in advance

Bona

most that other stuff can be done using hibernate tools and some ant tasks.

you'd still have to add it to the SessionFactory and reload the web-app for your web-container to pick up any changes. So, I'm not sure how much good that will do.

I just encounter the same problem, and I just query the records by this way but have no idea about creating pojos:

List list = session.createSQLQuery("select * from test").list();
String line = "";
for(int i =0;i<list.size();i++)
{
Object[] objs = (Object[])list.get(i);

for(int j=0;j<objs.length;j++)
{
Object o = objs[j];
if(o == null) o="null";
line += o.toString()+"\t";
}
System.out.println(line);
line = "";
}


By the way, I still wonder how to display them in JSF? Anyone get idea?