The Artima Developer Community
Sponsored Link

Java Answers Forum
Passing String as Oracle date to PrepareStatement

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Andrew

Posts: 1
Nickname: rew
Registered: Oct, 2002

Passing String as Oracle date to PrepareStatement Posted: Oct 23, 2002 6:40 AM
Reply to this message Reply
Advertisement
When i set String value to parameter in PrepareStatment,("Select * from tab_name where field_date=to_date(?,'dd-mon-yyyy') "), throws an exception like "After clearAllParameters has been reset, all parameters must be reset".

This happens when i immdly reload html page built by servlet, under weblogic server 5.0 and using weblogic jdbc driver.

When i alter the query as ("Select * from tab_name where field_date=?"), it works fine.

what could be wrong?

Topic: Polymorphsim: Previous Topic   Next Topic Topic: Sending a mail using Java!

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use