Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Need to Learn about the Java ODBC

 
   Database Forums (Home) -> Java RSS
Next:  php not outputting xml  
Author Message
kvnsmnsn

External


Since: Apr 13, 2007
Posts: 3



(Msg. 1) Posted: Thu Feb 21, 2008 4:01 pm
Post subject: Need to Learn about the Java ODBC
Archived from groups: comp>lang>java>databases (more info?)

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_

 >> Stay informed about: Need to Learn about the Java ODBC 
Back to top
Login to vote
RedGrittyBrick

External


Since: Sep 28, 2006
Posts: 8



(Msg. 2) Posted: Thu Feb 21, 2008 10:01 pm
Post subject: Re: Need to Learn about the Java ODBC [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

kvnsmnsn DeleteThis @hotmail.com wrote:
> 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.

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.

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

 >> Stay informed about: Need to Learn about the Java ODBC 
Back to top
Login to vote
Lew

External


Since: Aug 30, 2007
Posts: 57



(Msg. 3) Posted: Thu Feb 21, 2008 10:01 pm
Post subject: Re: Need to Learn about the Java ODBC [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

RedGrittyBrick wrote:
> 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.DeleteThis@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>

--
Lew
 >> Stay informed about: Need to Learn about the Java ODBC 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Java All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]