Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / February 2008

Tip: Looking for answers? Try searching our database.

Need to Learn about the Java ODBC

Thread view: 
kvnsmnsn@hotmail.com - 22 Feb 2008 00:01 GMT
From February to July of last year I worked for a company where I
wrote C code that accessed a PostgreSQL database with SQL commands and
generated the output my supervisor wanted.

    Now I'm working for a different company that doesn't have a C
compiler and doesn't really want me writing C code.  The company does
have a Java compiler, and think Java is the better route to maintain-
able code.  I'm still working with databases, and as I understand it I
can use the Java ODBC to generate SQL queries to get the information
my colleagues are looking for.

    Does anybody on this newsgroup know how I would go about using
Java this way?  Is there any documentation on how to use the ODBC?
I've coded with Java before; in fact I have about five years of expe-
rience with Java; but I've never done anything with SQL with it.

                               ---Kevin Simonson

"You'll never get to heaven, or even to LA,
if you don't believe there's a way."
from _Why Not_
RedGrittyBrick - 22 Feb 2008 00:11 GMT
>      From February to July of last year I worked for a company where I
> wrote C code that accessed a PostgreSQL database with SQL commands and
[quoted text clipped - 11 lines]
> I've coded with Java before; in fact I have about five years of expe-
> rience with Java; but I've never done anything with SQL with it.

http://java.sun.com/docs/books/tutorial/jdbc/

I recall a similar posting elsewhere - are you multi-posting? If so,
please don't.

http://www.blakjak.demon.co.uk/mul_crss.htm
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

>                                 ---Kevin Simonson
>
> "You'll never get to heaven, or even to LA,
> if you don't believe there's a way."
> from _Why Not_

SignatureSeparatorException: hyphen hyphen space newline is a separator
that is recognised by most newsgroup reading software.

Signature

RGB
- who doesn't particularly want to visit smog city again. YMMV.

Lew - 22 Feb 2008 00:44 GMT
> SignatureSeparatorException: hyphen hyphen space newline is a separator
> that is recognised by most newsgroup reading software.

I think there's even an RFC about that.

RGB wrote:
> http://java.sun.com/docs/books/tutorial/jdbc/

To the OP: what you want is JDBC, not ODBC.  That's the link RGB gave you.

kvnsmnsn@hotmail.com wrote:
> PostgreSQL database

ODBC will be horrid with Java.  Postgres has a really good JDBC driver that
works with the Java Transaction API (JTA) and other advanced DBMS-access
libraries.
<http://jdbc.postgresql.org/documentation/82/index.html>

Signature

Lew



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.