Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- getSession().beginTransaction();
- String queryString1 = "CREATE TEMPORARY TABLE sage_temp_table(CRMID VARCHAR(60),POPAmountPaid DECIMAL(14,2)) ";
- getSession().createSQLQuery(queryString1).executeUpdate();
- getSession().flush();
- String queryString2 = "INSERT INTO sage_temp_table(CRMID,POPAmountPaid) SELECT CRMID,POPAmountPaid FROM sage_payments WHERE sage_payments.`CRMID` REGEXP "^[0-9]+$" AND"
- + " sage_payments.POPPaidDate NOT LIKE "%0000-00-00 00%" AND sage_payments.POPPaidDate IS NOT NULL AND sage_payments.POPAmountPaid IS NOT NULL";
- getSession().createSQLQuery(queryString2).executeUpdate();
- getSession().beginTransaction().commit();
- 04:00:04,549 INFO [STDOUT] Hibernate: CREATE TEMPORARY TABLE sage_temp_table(CRMID VARCHAR(60),POPAmountPaid DECIMAL(14,2))
- 04:00:17,463 INFO [STDOUT] Hibernate: INSERT INTO sage_temp_table(CRMID,POPAmountPaid) SELECT CRMID,POPAmountPaid FROM sage_payments WHERE sage_payments.`CRMID` REGEXP "^[0-9]+$" AND sage_payments.POPPaidDate NOT LIKE "%0000-00-00 00%" AND sage_payments.POPPaidDate IS NOT NULL AND sage_payments.POPAmountPaid IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement