==== Databas procedurer ====

=== SQLBuilder ===
  * sqlbuilder,  metod: buildSQL(int rinfoid, String uemp, String tablename, String prodplace)
  * installera miljö (JDeveloper) http://blogs.oracle.com/shay/2009/04/installing_jdeveloper_11g_on_m.html
  * kod (även examplet med alias som är gjort)
  * visa hur det deployas
  * testas externt
== Testning/Deploying ==
  * SQLBuilder.buildSQL(...)
  * DURING TESTING  = System.out.println(sb.toString());
  * DURING LIVE     = BuilderDataManager.updateSQL(sb.toString(), rinfoid, uemp, tablename, prodplace);    
  * **Only one should be present at a time.**

  * BuildDataManager.getRecInfo(...)
  * Here we shall change connection depending of testing or not
  * getConnection();         = test against LIVE
  * getConnectionDEV();      = test against DEV
  * getInternalConnection(); = LIVE in database
  * Connection conn = getConnection(); 

== Notes ==
  * http://www.oracle.com/technetwork/developer-tools/jdev/loadjava-howto-095487.html
  * Remember when testing to uncomment BuilderDataManager.updateSQL(...) and to change the connection
  * loadjava: http://www.developer.com/db/article.php/3337411/Oracle-and-Java-Stored-Procedures.htm
  * call buildSQL(42328, 'MOS', 'REC_INFO', 'PROD' )
  * select buildOCR(126789) from dual
  * New_deployment_file
  {{:loadjava_new_deploy.png|}}
  
=== Övriga procedurer ===
  * OCRBuilder, metod: buildOCR(String ocr)
  * calcsample, metod: getSelProfileHits(String sql, String dbuser, String autitem15)
  * campaignbuilder, metod: buildCampaing(int id, String uemp, String tablename, int prodcode)
  * descrbuildernoitem, metod: buildDescrStr(inte item, int operand, Stringa value, String lang, int codetype, int showcode) används bl.a i descrbuilder webapp
  * (descrbuilder, metod: buildDescrString(int item, int operand, String value, String lang, int codetype)) Används??
  * sqlinsert, metod: insertSQL(String sql)
  * wordwrapper, metod wordWrapper(String text, int string_cut, int returnrow, String delimiter)
  * autprivatebauetext, metod: buildAutPrivatebaueText(Long prevcode, String prop2, String releasedate, String cstartdate)
  * (alias_sqlbuilder, metod: buildSQL(int rinfoid, String uemp, String tablename, String prodplace)) TEST version, kan vara nyligen uppdaterade saker i sqlbuilder som saknas här
 
OBS! Vid deploy till databasen, se till att det är den interna drivaren som används inte den externa (brukar orsaka security eller socket exception om man har fel drivare