jdbc or jdo or hibernate

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 what is the best approach to solve my problem.

Please let me know. Appreciate your help.

TP.

[1011 byte] By [tpass001a] at [2007-9-21]
# 1

Probably in your case most effective way is to use just JDBC calls. JDO and similar are rather dedicated to create layered application with bussines logic in bussines objects layer and some presistance layer wrapped by jdo or similar.

Try JDBC until you realise you need db access layer separated from bussines objects.

akulinska at 2007-7-15 > top of java,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
very good reply.. thanks.. had posted the same question on hibernate and jdo forums.any ideas where I can start with this. any links/books which can be recommended?
tpass001a at 2007-7-15 > top of java,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
The JDBC Tutorial on the Sun Java site! Might start there.
darteda at 2007-7-15 > top of java,Database Connectivity,Java Database Connectivity (JDBC)...