can i use hibernate for this

tpass001 · **Joined:** Thu Oct 30, 2003 5:31 pm **Posts:** 4

Hi,

I am totally new to database programming using java but have worked on java and databases individually for quite a long time.

So here is the requirement.

From the 3rd party application (connectivity no problem) I will get a database name and table name. If a user clicks on that link, I should sign him into the database using his username and then display the columns of the table, along with maybe the 1st 10 rows. He would enter the search criteria (for example an accnt number) and press enter. This would return the search results. The table name and database name is unknown until runtime. I could handle exception on connectivity if incorrect information in provided.

Now I have seen a lot of activity about hibernate, jdo and plain of jdbc. I know this can be done using jdbc (basically what I have is a database viewer). I would like to see you opinions on whether hibernate can be used for what i need.

Please let me know. Appreciate your help.

TP.

tpass001 · **Joined:** Thu Oct 30, 2003 5:31 pm **Posts:** 4

come ppl some help please.

cutie · **Posted:** Fri Oct 31, 2003 3:37 pm

looks like a job for JDBC to me. the whole point of Hibernate is to give an OO interface to a database schema, but you want to expose that schema directly to the user.

micho2001 · **Posted:** Fri Oct 31, 2003 6:04 pm

IMHO:

Hibernate is suited for apps that have a domain model (and thus bussiness logic). The domain model objects should preferebly know nothing about persistence.. this is where DAO's come in

Basically what this means is that if you only want to do CRUD on a simple web page, hibernate could be an overkill...

If you do go the JDBC way and need to expose db schemma details, take a look at this.. it might help
http://java.sun.com/j2se/1.3/docs/api/java/sql/DatabaseMetaData.html