which jdk i should opt for pgsql8.2 to implement jdbc interface

[mamoon]

hi all,
i am in urgent need of some expert suggestions regarding which jdk i install for my
linux (EL4) , so as i write programs and applications to interact with pgsql8.2 databse server through JDBC.
i went on
sun developers network
there are a lot of options-
1. JDK 6u1
2. JDK 6u1 with Java EE
3. JDK 6u1 with NetBeans 5.5.1
i am confused which one i opt.
my motto is to launch a database server using pgsql8.2 with JDBC as client interface.could any one of u plzzz suggest what to do next.i have already upgraded to pgsql8.2.
with regard
mamoon

[JosAH]

hi all,
i am in urgent need of some expert suggestions regarding which jdk i install for my
linux (EL4) , so as i write programs and applications to interact with pgsql8.2 databse server through JDBC.
i went on
sun developers network
there are a lot of options-
1. JDK 6u1
2. JDK 6u1 with Java EE
3. JDK 6u1 with NetBeans 5.5.1
i am confused which one i opt.
my motto is to launch a database server using pgsql8.2 with JDBC as client interface.could any one of u plzzz suggest what to do next.i have already upgraded to pgsql8.2.
with regard
mamoon

You mean the Postgres SQL database right? Just the latest jdk will do fine (6u1).
It depends what you want to do, if you want to build enterprise applications you
need JEE also. It also depends *how* you want to develop your applications.
If you like the Netbeans IDE install that one too, but for standalone applications
all you need is the JDK 6u1; your database comes with the version 4 jdbc
implementation.

kind regards,

Jos

[mamoon]

You mean the Postgres SQL database right? Just the latest jdk will do fine (6u1).
It depends what you want to do, if you want to build enterprise applications you
need JEE also. It also depends *how* you want to develop your applications.
If you like the Netbeans IDE install that one too, but for standalone applications
all you need is the JDK 6u1; your database comes with the version 4 jdbc
implementation.

kind regards,

Jos

hi Jos,
thanks
i have to launch a database on www. for that i want that JDBC should be client interface interacting with pgsql database server on my system on user request. you plz tell me the following queries:
1. jdbc programming will be in JAVA, isnt it?
2. i have to make quey form or search page in HTML.
3. how would i connect user's query to my jdbc program in order to fetch something from database?
please make clear the basic architecture of this plan.
with warm regard
mamoon

[JosAH]

hi Jos,
thanks
i have to launch a database on www. for that i want that JDBC should be client interface interacting with pgsql database server on my system on user request. you plz tell me the following queries:
1. jdbc programming will be in JAVA, isnt it?
2. i have to make quey form or search page in HTML.
3. how would i connect user's query to my jdbc program in order to fetch something from database?
please make clear the basic architecture of this plan.
with warm regard
mamoon

Yep, jdbc programming is just Java programming. You connect to your database
by either loading your driver given the correct URL to your database, or your
use a DataSource object for that. Jdbc doesn't care where your database is
located as long as it can reach it through the supplied URL.

On the other hand, your database doesn't care where your query comes from
and how it was composed. Jdbc simply submits the sql statement and fetches
the results (if any).

If you want to compose a sql query using html forms, you're free to do so.
Given the short description you supplied I guess a Servlet container (TomCat?)
handles the submitted form, your business logic composes the query and
passes it on to the database; the results can be send back to the client in
html format.

kind regards,

Jos

[mamoon]

Yep, jdbc programming is just Java programming. You connect to your database
by either loading your driver given the correct URL to your database, or your
use a DataSource object for that. Jdbc doesn't care where your database is
located as long as it can reach it through the supplied URL.

On the other hand, your database doesn't care where your query comes from
and how it was composed. Jdbc simply submits the sql statement and fetches
the results (if any).

If you want to compose a sql query using html forms, you're free to do so.
Given the short description you supplied I guess a Servlet container (TomCat?)
handles the submitted form, your business logic composes the query and
passes it on to the database; the results can be send back to the client in
html format.

kind regards,

Jos

thanks alot Jos for basic understanding you supplied. would you suggest me any site or source from where i may learn the basics as well as advances regarding my work.
mamoon

[JosAH]

thanks alot Jos for basic understanding you supplied. would you suggest me any site or source from where i may learn the basics as well as advances regarding my work.
mamoon

Maybe you can just start here and work your way up from there.

kind regards,

Jos