473,809 Members | 2,733 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

18 New Member
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
May 28 '07 #1
5 1609
JosAH
11,448 Recognized Expert MVP
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
May 28 '07 #2
mamoon
18 New Member
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
May 28 '07 #3
JosAH
11,448 Recognized Expert MVP
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
May 28 '07 #4
mamoon
18 New Member
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
May 28 '07 #5
JosAH
11,448 Recognized Expert MVP
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
May 28 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
4672
by: Choubey | last post by:
hi everybody, Iam a java programmer actually i want to know how the Connection object is created through DriverManager.getConnection when DriverManager class is not implements Connection interface and no class in java implementas interface connection so how can we get a object reference for connection object and call a getconnection method through the connection object. i seen that there are lots of interface in java which are not...
8
2508
by: Zheng Da | last post by:
I don't know where should I ask the question, so send the email to this group. I choose this group, because I want to write the program with c++ :) I want to write a program which support multiprotocol, but do not want to write code for all protocols which I want to support. I plan I give a interface and others give a module which implements a protocol, and then the module can be inserted into my program without recompiling my program....
1
2746
by: BARTKO, Zoltán | last post by:
Hello folks, I have installed PgSQL8 beta4 via pginstaller to WinXP. I must tell you I am more familiar with Linux, so maybe my problem is trivial to solve: I made myself a table with PgAdmin III (I was lazy to use psql) that I tried to reach via ODBC. I created connection to my database, supplied a user, server, etc., all that was needed.
122
7932
by: seberino | last post by:
I'm interested in knowing which Python web framework is most like Ruby on Rails. I've heard of Subway and Django. Are there other Rails clones in Python land I don't know about? Which one has largest community/buzz about it?
34
3193
by: Guch Wu | last post by:
Boost has many terrific libraries. But I want to know whether they are ready for using in real projects. Which of them are mature enough, or just only in progress?
2
1722
by: ABC | last post by:
Can I create an Interface which have a method have variate type parameters? I want create an Interface named IDataEditable which have two methods: LoadRecord and SaveRecord. As the LoadRecord have variate type parameters based on the record primary key definition such as: The product table should be:
3
4975
by: kavallin | last post by:
I wonder if anyone has compared the db2 universal jdbc driver type 2 and 4 with the legacy db2 driver. Which one is the best to use ? I'm working in a project where the envm looks like this Solaris 10 Websphere 6.1 with app db2 connect 9 ============================as/400 5.3 as/400 databases cataloged on db2 connect with auth SERVER_ENCRYPT
5
1560
by: bz | last post by:
Hi, I create a class that retrieves a number of records from database. Internally, the class store the returned data in a datatable / datareader. I would like to bind a listbox to that class (to the records from this datatable), using data binding wizard and to be able to select bind to object How should I make this class to be able to accomplish this? Do I have to define it to implement some interface? Which one? I want to bind...
6
1449
by: greenxiar | last post by:
How to get the function from "rewrited interface implement"? interface I { int Value { get; } } class A : I { int I.Value { get { return 1; } } } class B : I { int I.Value { get { return 2; } }
0
9721
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10115
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9199
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7660
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6881
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3861
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3014
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.