• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc

 
Mukesh Jain
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sir
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.
===========program==============================================

=======================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
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Perhaps if you put this in the JDBC forum you might get a better response.
 
Cindy Glass
"The Hood"
Sheriff
Posts: 8521
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Marilyn de Queiroz
Sheriff
Posts: 9059
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm moving this to the jdbc forum.
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's taking s1 and s2 as text and not as variables. Try this:
st.executeUpdate("insert into deep values(" + s1 + ", " + s2+ ")");
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic