• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using PreparedStatement: Is there anything special for Oracle ?

 
Artemesia Lakener
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For PreparedStatement, I hvae used it for SQL server and Sybase. Is there anything special I need to pay attention to if I want to use it in Oracle ? what difference should I care ?
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you know you're having a problem or just looking out for them?

The code for JDBC should be the same between servers, that is the way it is designed. The only difference I can think of is that Oracle give their classes additional methods, available through casting to the correct type. Not really advisable though.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34870
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Artemesia,
Not specific to PreparedStatements, but make sure you aren't using any SQL server or Sybase specific SQL statements. Oracle uses standard SQL, so you will be ok if you didn't use any specific extensions.
 
Adam Richards
Ranch Hand
Posts: 135
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I agree with the previous post. I use PreparedStatement with Oracle all the time & it works just fine. Of coruse, if you're porting queries previously used in other RDBMS's, you'll need to ensure the SQL doesn't have any proprietary (i.e., non-standard) extensions.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic