I'm evaluating Hibernate for use in an already existing application. We're using JB2005, BES 6.5 (Borland's EJB/J2EE Container), and using CMP with some persistence code that is code generated by a JB integrated 3rd party tool. We pretty much have Transfer Objects that correspond 1:1 with db rows.

Currently, we need some multi-table advanced search type functionality, and are evaluating search frameworks. This guy on our team has a home grown framework(that looks a heckuva lot like HQ and HExample, but not as broad), but I'm thinking, surely someone else out in quality open sourceland has done this... Now to the point.

I've done about 4 hours of plugging through the docs and site, and I'm sure my questions are answered somewhere already, so feel free to point me there and I'll do the legwork. I'll be darned if I could find them, I read almost every FAQ, and several chapters of the manual.

1. It's my understanding that I can use one of the tools to point at an Oracle 9i db, and create an inital set of mapping files for use with Hibernate and our db. Is this correct?

2. Can we integrate Hibernate only to the extent that we would use the querying features, without having to adopt Hibernate for the persistence services? I want to be able to argue that we don't have to migrate fully to HB right now, but just use the part we need right now -- you know how project managers are with this kind of stuff. It might be the key to convincing him. So, can we just integrate the querying features?

I hope this will backdoor us into JBoss someday, just don't tell my boss that! :-)

Thanks in advance.

Chuck in Denver, CO
8 solid years in Java, but lost the cutting edge about 3 years ago... sadly


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:Still evaluating, most recent production quality version

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: Oracle 9i

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Sure.

http://www.hibernate.org/hib_docs/tools ... html#gen10



Or course.

Note that even though you will start out this way, it is almost certain that you will decide to ditch CMP completely once you have a taste for HB.

Thanks bigtime for the quick response!



Can you point me in any direction where I might find this in the docs? Like I said, gotta prove it to the PM.

And as far as falling in love with HB, I'm sure of it too, and that's just one step closer to JBoss. Woohoooo!

Thanks again!

Chuck

Whaddayamean? There is no docs; it "just works", I guess. Hibernate simply wraps JDBC, so whatever you can do with JDBC, you can do with HB. You can of course use JDBC alongside CMP...

I guess that's as good an explanation as any. Hopefully it will fly. Wish me luck!

Thanks for your help.