Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within JDBC and Relational Databases Search Coderanch
Advance search Google search
Register / Login
book review grid advertise on coderanch polymorphism thread boost granny
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
thread boost advertise on coderanch book review grid meaningless drivel building better world book
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Prepared statement help

 
Bob Rocks
Greenhorn
Posts: 23
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Hello everyone, I am having some trouble with prepared statements. I am getting an error when I try to run this code:



I get an incompatible error, cannot convert string to int.

I have just started to work with prepared statements and I am sure it is something dumb! Also, I am trying to write an interface which will allow a user to enter data into fields, then I want to pass it to the db. Normally I would do this over a couple pages, is there a better way?

Some of the fields will contain single quotes and have been a problem, which is why I am trying to figure out this prepared statement stuff anyway! So if someone could give me a quick code example of how to pull this off like this I would appreciate it greatly!

thanks guys!
-Bob
 
Shailesh Chandra
Ranch Hand
Posts: 1087
I like...
Oracle Spring Java
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
better you refer javadoc for preparedStatment

your problem can be solved as by setting your statemenmt in following manner

pstmt.setString(1,vtxt1);
pstmt.setString(2,vtxt2);

Gravitation cannot be held responsible for people falling in love ~ Albert Einstein

 
Bob Rocks
Greenhorn
Posts: 23
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Thank you, that did help, but now I am getting this error

java.lang.ClassNotFoundException: oracle/jdbc/driver/OracleDriver()
 
Bear Bibeault
Sheriff
Posts: 67747
173
I like...
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator

Class.forName("oracle.jdbc.driver.OracleDriver()");



What's with the parens in the driver name?

[Asking smart questions] [About Bear] [Books by Bear]

 
Shailesh Chandra
Ranch Hand
Posts: 1087
I like...
Oracle Spring Java
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
add the classes12.zip in your classpath

Gravitation cannot be held responsible for people falling in love ~ Albert Einstein

 
Shailesh Chandra
Ranch Hand
Posts: 1087
I like...
Oracle Spring Java
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator

Originally posted by Bear Bibeault:


What's with the parens in the driver name?



Thanks Bartender,

I missed to see parens

Gravitation cannot be held responsible for people falling in love ~ Albert Einstein

 
Bob Rocks
Greenhorn
Posts: 23
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Yeah, I thought the parens were odd too, but they were in some crappy book I started using. I have since stopped using that book!

I took out the parens and now it gives me another error:

Undefined variable, class, or package name: oracle
Class.forName(oracle.jdbc.driver.OracleDriver());

and classes12 is in the classpath...
 
Bear Bibeault
Sheriff
Posts: 67747
173
I like...
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Take out the parens, not the quotes!

[Asking smart questions] [About Bear] [Books by Bear]

 
Bob Rocks
Greenhorn
Posts: 23
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
wow, paying attention to what I am doing would really help in this situation!
 
Bear Bibeault
Sheriff
Posts: 67747
173
I like...
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
If you did this pre-coffee, it's understandable. I've learned never to code before coffee!

Seriously, do you understand why and how this works now?

[Asking smart questions] [About Bear] [Books by Bear]

 
Bob Rocks
Greenhorn
Posts: 23
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Oh yeah, it all kind of fell into place, thanks a ton for your help guys!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...