Friday, September 13, 2019

jasper report mail configuration

path --> C:\Jaspersoft\jasperreports-server-cp-6.4.0\apache-tomcat\webapps\jasperserver\WEB-INF

applicationContext-report-scheduling
-----------------------------------------
<property name="javaMailProperties">
<props>
<!--  <prop key="mail.smtp.sendpartial">true</prop>
<prop key="mail.smtp.auth">false</prop>-->
<prop key="mail.smtp.auth">true</prop>
<prop key="mail.smtp.starttls.enable">true</prop>
<prop key="mail.smtp.starttls.required">true</prop>
</props>
</property>

js.quartz.properties
---------------------
    
report.scheduler.web.deployment.uri=http://172.16.5.216:8080/jasperserver


report.scheduler.mail.sender.host=smtp.gmail.com
report.scheduler.mail.sender.username=courtsfijiecom@gmail.com
report.scheduler.mail.sender.password=smcplotno15
report.scheduler.mail.sender.from=courtsfijiecom@gmail.com
report.scheduler.mail.sender.protocol=smtp
report.scheduler.mail.sender.port=25
report.scheduler.mail.smtp.starttls.enable=true
report.scheduler.mail.smtp.auth=true

Tuesday, September 3, 2019

Fixing: oracle.jbo.RowInconsistentException: JBO-25014: Another user has changed the row with primary key oracle.jbo.Key

    public void lock() {
        try {
            super.lock();
        } catch (oracle.jbo.RowInconsistentException e) {
            if (e.getErrorCode().equals("25014")) {
                refresh(REFRESH_WITH_DB_ONLY_IF_UNCHANGED | REFRESH_CONTAINEES);
                super.lock();
            } else {
                refresh(REFRESH_WITH_DB_ONLY_IF_UNCHANGED | REFRESH_CONTAINEES);
                super.lock();
            }
        }
    }