Re: Facing Issues in updating data in dynamic table through OpenJPA

2008-06-13 Thread Jeremy Bauer
Another option may be to create a "fixed-name" view or alias over your existing table and then use that fixed-name within your JPA app. For example, to create an alias with DB2: CREATE ALIAS JPATBLALIAS FOR * <> appended by <>*; Depending on how your new table gets created each day, you may be a

Re: Facing Issues in updating data in dynamic table through OpenJPA

2008-06-13 Thread Ognjen Blagojevic
Srinivas Sastry wrote: My Application reads data from a flat file every day and inserts into a table whose name is like * <> appended by <>* So the table name changes everyday (the table will end with date on which the data is inserted). Maybe you could try to insert everything into <>_TEMP, a

Facing Issues in updating data in dynamic table through OpenJPA

2008-06-12 Thread Srinivas Sastry
Hi, I am facing issues in inserting data from a web application (Using OpenJPA) into DB2 table which is renamed daily. The issue is : My Application reads data from a flat file every day and inserts into a table whose name is like * <> appended by <>* So the table name changes everyday (the tabl