Welcome to dbForumz.com!
FAQFAQ    SearchSearch      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?)

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.

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:   
Related Topics:
java.sql.SQLException [Microsoft][ODBC Driver Manag - OK, I've see a lot of stuff out there on this error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. The only definitive solution I can find is going to Control Panel-->Administrativ...

java - Hello Im working with jdbc on a MSSQL Database. In my java client im executing a stored procedure called myProc on the database. Im doing this with the following code: ...... Statement stmt = con.createStatement(); String sql1 ="execute myProc&quo...

java or c# please help - I am starting a new application, it needs to use db such as access or msde. I know I can do this easily in c# or Java but my question is can I distribute a package as easy if it is created with java and say derby db as I can with windows based. It....

java - Do any of you know someone experienced in Java that is interested in a full time job in Tucson, Omaha or Dallas? Company dies not pay relo but has an excellent reputation as a great place to work. If you are interested sheck out www.retaliz.com

Java and Microsoft SQL - Hi ! I am experiencing some problems with MSSQL (ver 8.0). While I can execute sub-select statement directly on a MSSQL server, I cannot do the same thing in JDBC. Like the following statement( JDBC throws exception about mismatched type) select..
   Database Forums (Home) -> Java All times are: Pacific Time (US & Canada)
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 ]