hiho,

in a persistance layer for jasper reports (ussrp.com) there is a Report object. in data loading, the pk must be explicit (to support sub-reports).

at runtime, when a user uploads a new report, the pk must auto increment.

ussrp accomplishes this by having two hib. mapping files for the one Report object. (there is a second 'ReportAssigned' object which is empty, just extends Report, and is used to support the second mapping file.)

...this all works fine until i try to use both objects in one jvm, then my hql starts seeing double :-). (e.g. Report rep = (Report)session.createQuery("from net.sf.ussrp.bus.Report where DESCRIPTION = '"+ description + "'").uniqueResult(); returns 2 records/error)

do you have an idea (pattern) for how to have a single object that must somtimes use generator class="assigned", sometimes "increment"?

thanks!

tom

I'd do that the heavy-handed way: make the column non-identity, create your own generator that selects the highest current ID and adds one, and allows the user to modify that before writing to the DB.

It may be that the sequence generator will do what you want, but I've never used it so I can't confirm that.

thanks - good idea. ...need to get used to forum, did not get email on your post.

...i like your idea and will put it into the next ussrp release and remove the "double trouble" hibernate mapping :-). ...but it was fun while it lasted...

thanks again,

tom

Hello!
I'm bigginer in ussrp and download this application.
I read setup file and edit files according to it. I start Tomcat but when i write url in explorer (Mozila) it doesn't run and i get this error ("HTTP Status 404 - /ussrp") .
I realy need your help.
Thanks.