my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc" Watch "jdbc" New topic


Mukesh Jain

Joined: Jan 17, 2001
Posts: 9
Here with i am sending the code in which i am trying to insert a record in the table "deep"(oracle 7.3), the dsn name is mukesh and the user name and password to access the database are also written,
the problem is i am unable to insert a record into it.

=======================end of program===========================

Mukesh Jain
(Marilyn inserted spaces so code appears and code tags to preserve indentation)

[This message has been edited by Marilyn deQueiroz (edited February 24, 2001).]
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Perhaps if you put this in the JDBC forum you might get a better response.

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Cindy Glass
"The Hood"

Joined: Sep 29, 2000
Posts: 8521
Also you need to put spaces in your HTML tags so that the code displays instead of executing. You might want to turn smilies off or put a space in you code also.

"JavaRanch, where the deer and the Certified play" - David O'Meara
Marilyn de Queiroz

Joined: Jul 22, 2000
Posts: 9059
I'm moving this to the jdbc forum.

"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
It's taking s1 and s2 as text and not as variables. Try this:
st.executeUpdate("insert into deep values(" + s1 + ", " + s2+ ")");
I agree. Here's the link:
subject: jdbc
It's not a secret anymore!