API tools faq
paste
Guest User

Untitled

a guest
Jan 23rd, 2019
127
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.50 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE "public"."dcf_pmtflow_flags_2" (
  2. "STR_CREATED_BY" character varying(255) COLLATE pg_catalog."default",
  3. "DT_CREATED" TIMESTAMP (6) without time zone,
  4. "STR_PROPOSAL_NO" character varying(255) COLLATE pg_catalog."default",
  5. "STR_SCREEN_REF_NO" character varying(255) COLLATE pg_catalog."default",
  6. "STR_LOB_TYPE" character varying(255) COLLATE pg_catalog."default",
  7. "STR_PROPOSAL_FLAG" character varying(1) COLLATE pg_catalog."default",
  8. "STR_RECEIPT_ENTRY_FLAG" character varying(1) COLLATE pg_catalog."default",
  9. "STR_SUBRECEIPT_FLAG" character varying(1) COLLATE pg_catalog."default",
  10. "STR_PROPOSAL_TAGGING_FLAG" character varying(1) COLLATE pg_catalog."default",
  11. "STR_PDF_GEN_FLAG" character varying(1) COLLATE pg_catalog."default",
  12. "STR_FINAL_STATUS" character varying(1) COLLATE pg_catalog."default",
  13. "STR_PAYMENT_NO" character varying(255) COLLATE pg_catalog."default",
  14. "STR_PRODUCER_CODE" character varying(255) COLLATE pg_catalog."default",
  15. "STR_RECEIPT_NO" character varying(255) COLLATE pg_catalog."default",
  16. "STR_APPLICATION_NO" character varying(255) COLLATE pg_catalog."default",
  17. "STR_SUBRECEIPT_NO" character varying(255) COLLATE pg_catalog."default",
  18. "STR_POLICY_NO" character varying(255) COLLATE pg_catalog."default",
  19. "STR_ERROR_MSG_RECEIPT_BFL" character varying(2000) COLLATE pg_catalog."default",
  20. "STR_ERROR_MSG_SUBRECEIPT" character varying(2000) COLLATE pg_catalog."default",
  21. "STR_ERROR_MSG_PROP_TAG" character varying(2000) COLLATE pg_catalog."default",
  22. "STR_ERROR_MSG_PDF_GEN" character varying(2000) COLLATE pg_catalog."default",
  23. "STR_PROPOSAL_REQ" character varying(2000) COLLATE pg_catalog."default",
  24. "STR_PDF_GEN_REQ" character varying(2000) COLLATE pg_catalog."default",
  25. "STR_COUNT" character varying(255) COLLATE pg_catalog."default",
  26. "STR_ADDITIONAL_DTLS_1" character varying(255) COLLATE pg_catalog."default",
  27. "STR_ADDITIONAL_DTLS_2" character varying(255) COLLATE pg_catalog."default",
  28. "STR_ADDITIONAL_DTLS_3" character varying(255) COLLATE pg_catalog."default",
  29. "STR_ADDITIONAL_DTLS_4" character varying(255) COLLATE pg_catalog."default",
  30. "STR_ADDITIONAL_DTLS_5" character varying(255) COLLATE pg_catalog."default",
  31. "STR_ERROR_MSG" character varying(255) COLLATE pg_catalog."default"
  32. );
  33.  
  34. public void updatePmtFlowFlag(PmtFlowFlags pmtFlowFlags){
  35.  
  36. Session session = null;
  37. Transaction transaction = null;
  38. try {
  39. if(pmtFlowFlags != null && pmtFlowFlags.getStrproposalno() != null && pmtFlowFlags.getStrproposalno() != ""){
  40. session = HibernateUtil.getSessionFactory().getCurrentSession();
  41. transaction = session.getTransaction();
  42. if(!transaction.isActive()){
  43. session.beginTransaction();
  44. }
  45. PmtFlowFlags pmtOld =(PmtFlowFlags) session.get(PmtFlowFlags.class, pmtFlowFlags.getStrproposalno());
  46. if(pmtOld != null){
  47.  
  48. if(pmtFlowFlags.getStrcreatedby() != null){
  49. pmtOld.setStrcreatedby(pmtFlowFlags.getStrcreatedby());
  50. }
  51. if(pmtFlowFlags.getDtcreated() != null){
  52. pmtOld.setDtcreated(pmtFlowFlags.getDtcreated());
  53. }
  54. if(pmtFlowFlags.getStrproposaltaggingflag() != null){
  55. pmtOld.setStrproposaltaggingflag(pmtFlowFlags.getStrproposaltaggingflag());
  56. }
  57.  
  58. if(pmtFlowFlags.getStrreceiptentryflag() != null){
  59. pmtOld.setStrreceiptentryflag(pmtFlowFlags.getStrreceiptentryflag());
  60. }
  61. if(pmtFlowFlags.getStrlobtype() != null){
  62. pmtOld.setStrlobtype(pmtFlowFlags.getStrlobtype());
  63. }
  64.  
  65. if(pmtFlowFlags.getStrpdfgenflag() != null){
  66. pmtOld.setStrpdfgenflag(pmtFlowFlags.getStrpdfgenflag());
  67. }
  68. if(pmtFlowFlags.getStrpdfgenreq() != null){
  69. pmtOld.setStrpdfgenreq(pmtFlowFlags.getStrpdfgenreq());
  70. }
  71. if(pmtFlowFlags.getStrproposalflag() != null){
  72. pmtOld.setStrproposalflag(pmtFlowFlags.getStrproposalflag());
  73. }
  74. if(pmtFlowFlags.getStrproposalreq() != null){
  75. pmtOld.setStrproposalreq(pmtFlowFlags.getStrproposalreq());
  76. }
  77. if(pmtFlowFlags.getStrfinalstatus() != null){
  78. pmtOld.setStrfinalstatus(pmtFlowFlags.getStrfinalstatus());
  79. }
  80. if(pmtFlowFlags.getStrpaymnetno() != null){
  81. pmtOld.setStrpaymnetno(pmtFlowFlags.getStrpaymnetno());
  82. }
  83. if(pmtFlowFlags.getStrscreenrefno() != null){
  84. pmtOld.setStrscreenrefno(pmtFlowFlags.getStrscreenrefno());
  85. }
  86. if(pmtFlowFlags.getStrpolicyno() != null){
  87. pmtOld.setStrpolicyno(pmtFlowFlags.getStrpolicyno());
  88. }
  89. if(pmtFlowFlags.getStrreceiptno() != null){
  90. pmtOld.setStrreceiptno(pmtFlowFlags.getStrreceiptno());
  91. }
  92. if(pmtFlowFlags.getStrcount() != null){
  93. pmtOld.setStrcount(pmtFlowFlags.getStrcount());
  94. }
  95. if(pmtFlowFlags.getStrerrormsginpdfgen() != null){
  96. pmtOld.setStrerrormsginpdfgen(pmtFlowFlags.getStrerrormsginpdfgen());
  97. }
  98. if(pmtFlowFlags.getStrerrormsginproptag() != null){
  99. pmtOld.setStrerrormsginproptag(pmtFlowFlags.getStrerrormsginproptag());
  100. }
  101. if(pmtFlowFlags.getStrerrormsginreceiptBfl() != null){
  102. pmtOld.setStrerrormsginreceiptBfl(pmtFlowFlags.getStrerrormsginreceiptBfl());
  103. }
  104. if(pmtFlowFlags.getStrapplicationno() != null){
  105. pmtOld.setStrapplicationno(pmtFlowFlags.getStrapplicationno());
  106. }
  107.  
  108. if(pmtFlowFlags.getStrlobtype() != null){
  109. pmtOld.setStrlobtype(pmtFlowFlags.getStrlobtype());
  110. }
  111. if(pmtFlowFlags.getStrsubreceiptno() != null){
  112. pmtOld.setStrsubreceiptno(pmtFlowFlags.getStrsubreceiptno());
  113. }
  114. if(pmtFlowFlags.getStrsubreceiptflag() != null){
  115. pmtOld.setStrsubreceiptflag(pmtFlowFlags.getStrsubreceiptflag());
  116. }
  117. if(pmtFlowFlags.getStradditionaldtls1() != null){
  118. pmtOld.setStradditionaldtls1(pmtFlowFlags.getStradditionaldtls1());
  119. }
  120. if(pmtFlowFlags.getStradditionaldtls2() != null){
  121. pmtOld.setStradditionaldtls2(pmtFlowFlags.getStradditionaldtls2());
  122. }
  123. if(pmtFlowFlags.getStradditionaldtls3() != null){
  124. pmtOld.setStradditionaldtls3(pmtFlowFlags.getStradditionaldtls3());
  125. }
  126. if(pmtFlowFlags.getStradditionaldtls4() != null){
  127. pmtOld.setStradditionaldtls4(pmtFlowFlags.getStradditionaldtls4());
  128. }
  129. if(pmtFlowFlags.getStradditionaldtls5() != null){
  130. pmtOld.setStradditionaldtls5(pmtFlowFlags.getStradditionaldtls5());
  131. }
  132. if(pmtFlowFlags.getStrerrormsgsubreceipt() != null){
  133. pmtOld.setStrerrormsgsubreceipt(pmtFlowFlags.getStrerrormsgsubreceipt());
  134. }
  135. if(pmtFlowFlags.getStrproducercode() != null){
  136. pmtOld.setStrproducercode(pmtFlowFlags.getStrproducercode());
  137. }
  138. if(pmtFlowFlags.getStrapplicationno() != null){
  139. pmtOld.setStrapplicationno(pmtFlowFlags.getStrapplicationno());
  140. }
  141.  
  142. }else{
  143. session.save(pmtFlowFlags);
  144. }
  145.  
  146. transaction.commit();
  147. logger.info(className, "DBService", "Schduler Details Stored Successfully: ", "n");
  148. }
  149. } catch (Exception e) {
  150. logger.fatal("In DBService :: updatePmtFlowFlag error ::"+e.getMessage());
  151. e.printStackTrace();
  152. transaction.rollback();
  153. }finally{
  154. if (session != null && session.isOpen()) {
  155. session.close();
  156. }
  157. }
  158.  
  159. }
  160.  
  161. <!-- Customer Portal SIT DB -->
  162. <property name="hibernate.connection.url">jdbc:postgresql://192.168.38.109/postgres</property>
  163. <property name="hibernate.connection.username">postgres</property> <property
  164. name="hibernate.connection.password">postgres</property>
  165.  
  166.  
  167.  
  168. <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
  169. <property name="hibernate.hbm2ddl.auto">update</property>
  170.  
  171. <property name="hibernate.current_session_context_class">thread</property>
  172. <property name="hibernate.show_sql">true</property>
  173. <property name="connection.autocommit">false</property>
  174.  
  175. <!-- enable second level cache and query cache -->
  176. <property name="hibernate.cache.use_second_level_cache">false</property>
  177. <property name="hibernate.cache.use_query_cache">false</property>
  178.  
  179.  
  180. <property name="hibernate.c3p0.min_size">10</property>
  181. <property name="hibernate.c3p0.max_size">20</property>
  182. <property name="hibernate.c3p0.timeout">180</property>
  183. <property name="hibernate.c3p0.max_statements">50</property>
  184. <property name="hibernate.c3p0.idle_test_period">3000</property>
  185.  
  186. <mapping class="com.majesco.dcf.common.entity.IntermediaryEntity"></mapping>
  187. <mapping class="com.majesco.dcf.common.entity.InterfaceParam"></mapping>
  188. <mapping class="com.majesco.dcf.common.entity.PAPremium"></mapping>
  189. <mapping class="com.majesco.dcf.common.entity.ParameterList"></mapping>
  190. <mapping class="com.majesco.dcf.common.entity.ParameterDetailList"></mapping>
  191. <mapping class="com.majesco.dcf.common.entity.UserParameterList"></mapping>
  192. <mapping class="com.majesco.dcf.common.entity.ExternalMapList"></mapping>
  193. <mapping class="com.majesco.dcf.common.entity.MessageIncomingEntity"></mapping>
  194. <mapping class="com.majesco.dcf.common.entity.MessageOutgoingEntity"></mapping>
  195. <mapping class="com.majesco.dcf.common.entity.RTOLocation"></mapping>
  196. <mapping class="com.majesco.dcf.common.entity.Motor"></mapping>
  197. <mapping class="com.majesco.dcf.common.entity.Manufact"></mapping>
  198. <mapping class="com.majesco.dcf.common.entity.QuotationPA"></mapping>
  199. <mapping class="com.majesco.dcf.pg.entity.PGMaster"></mapping>
  200. <mapping class="com.majesco.dcf.pg.entity.PGTransaction"></mapping>
  201. <mapping class="com.majesco.dcf.common.entity.VehicleAddOn" />
  202. <mapping class="com.majesco.dcf.common.entity.VehicleIdv" />
  203. <!-- communication related classes -->
  204. <mapping class="com.majesco.dcf.common.entity.OTPDetails" />
  205. <mapping class="com.majesco.dcf.common.entity.EmailSmsContent" />
  206. <mapping class="com.majesco.dcf.common.entity.EmailAttatchments" />
  207. <mapping class="com.majesco.dcf.common.entity.UserTransaction" />
  208.  
  209. <!-- communication related classes -->
  210. <!--Start: Code revamping for single hibernate** config file for application -->
  211. <mapping class="com.majesco.dcf.common.entity.TravelCountryEntity"></mapping>
  212. <mapping class="com.majesco.dcf.common.entity.Product"></mapping>
  213.  
  214. <!--End: Code revamping for single hibernate** config file for application -->
  215. <!--Start: Code for Travel Details -->
  216. <mapping class="com.majesco.dcf.common.entity.TravelTransactionDtls"></mapping>
  217. <mapping class="com.majesco.dcf.common.entity.TravelAddressDtls"></mapping>
  218. <mapping class="com.majesco.dcf.common.entity.TravelInsuredDetails"></mapping>
  219. <mapping class="com.majesco.dcf.common.entity.RenewalTransactionData"></mapping>
  220. <mapping class="com.majesco.dcf.common.entity.PinCode"></mapping>
  221. <mapping class="com.majesco.dcf.common.entity.City"></mapping>
  222. <mapping class="com.majesco.dcf.common.entity.State"></mapping>
  223. <mapping class="com.majesco.dcf.common.entity.Country"></mapping>
  224. <mapping class="com.majesco.dcf.common.entity.ProposalTransDtls"></mapping>
  225. <mapping class="com.majesco.dcf.common.entity.AccountServiceErrLog"></mapping>
  226. <mapping class="com.majesco.dcf.common.entity.PolicyTransactionDetails"></mapping>
  227. <mapping class="com.majesco.dcf.common.entity.CustomerAAdharDetails"></mapping>
  228. <mapping class="com.majesco.dcf.common.entity.PmtFlowFlags"></mapping>
  229.  
  230.  
  231. <!--End: Code for Travel Details -->
  232.  
  233. </session-factory>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!