Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL procedure and .props file

 
rajnish patel
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,
I have knowledge of SQL Queries and oracle 9i,10g,11g. Well I searched a lot related to SQL procedures on internet but could't understand properly. So can anybody explain me it properly?
Moreover I also want to know about data which is stored in .props files. What is that data and how it is used ?? Please explain in detail. Also let me know that why .props files are used ?

Waiting for kind reply.
Thank you.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not sure I'm understanding your question correctly.

Maybe you're asking about storing the actual texts of SQL queries in a file (usually a "standard" Java properties file), instead of hard-coding them in the application (in Java source code). The advantage of this approach is that all the SQL queries are separated from Java code, where they can be inspected by an experienced DB programmer (not all Java developers are on good terms with SQL), and they could even be automatically tested for correctness by some sort of unit test. A possible disadvantage is that this approach might make creating dynamic queries more problematic, if not impossible.

But if you asked about something else, please clarify your question.
 
rajnish patel
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Martin Vajsar wrote:I'm not sure I'm understanding your question correctly.

Maybe you're asking about storing the actual texts of SQL queries in a file (usually a "standard" Java properties file), instead of hard-coding them in the application (in Java source code). The advantage of this approach is that all the SQL queries are separated from Java code, where they can be inspected by an experienced DB programmer (not all Java developers are on good terms with SQL), and they could even be automatically tested for correctness by some sort of unit test. A possible disadvantage is that this approach might make creating dynamic queries more problematic, if not impossible.

But if you asked about something else, please clarify your question.


Thank you sir,
I got answer for what I asked.
please help me with my first question....


Thank you so much again for helping....
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm still not sure what are you asking about. Do you want a more in-depth explanation of how storing SQL queries in properties file works?
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
rajnish patel,
Your post was moved to a new topic.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic