Total Pageviews

2015/04/24

org.springframework.orm.jpa.JpaSystemException: null id generated for:class {0}

Problem
Here is my table schema with composite key

Owning to this table has composite key, so it will have primary key class and entity class.

  primary key class
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
package gov.nta.entity.dbm;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Embeddable;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 * The primary key class for the DBM400FA database table.
 * 
 */
@Embeddable
public class Dbm400faPK implements Serializable {
    // default serial version id, required for serializable classes.
    private static final long serialVersionUID = 1L;

    @Column(name = "CONTRACT_YEAR", unique = true, nullable = false, length = 4)
    private String contractYear;

    @Column(name = "BANK_SEQ_NO", unique = true, nullable = false, precision = 10)
    private long bankSeqNo;

    @Temporal(TemporalType.DATE)
    @Column(name = "CONTRACT_DATE", unique = true, nullable = false)
    private java.util.Date contractDate;

    public Dbm400faPK() {
    }

    public String getContractYear() {
        return this.contractYear;
    }

    public void setContractYear(String contractYear) {
        this.contractYear = contractYear;
    }

    public long getBankSeqNo() {
        return this.bankSeqNo;
    }

    public void setBankSeqNo(long bankSeqNo) {
        this.bankSeqNo = bankSeqNo;
    }

    public java.util.Date getContractDate() {
        return this.contractDate;
    }

    public void setContractDate(java.util.Date contractDate) {
        this.contractDate = contractDate;
    }

    public boolean equals(Object other) {
        if (this == other) {
            return true;
        }
        if (!(other instanceof Dbm400faPK)) {
            return false;
        }
        Dbm400faPK castOther = (Dbm400faPK) other;
        return this.contractYear.equals(castOther.contractYear)
                && (this.bankSeqNo == castOther.bankSeqNo)
                && this.contractDate.equals(castOther.contractDate);
    }

    public int hashCode() {
        final int prime = 31;
        int hash = 17;
        hash = hash * prime + this.contractYear.hashCode();
        hash = hash * prime + ((int) (this.bankSeqNo ^ (this.bankSeqNo >>> 32)));
        hash = hash * prime + this.contractDate.hashCode();

        return hash;
    }
}


entity class
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
package gov.nta.entity.dbm;

import java.io.Serializable;
import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the DBM400FA database table.
 * 
 */
@Entity
@Table(name="DBM400FA")
@NamedQuery(name="Dbm400fa.findAll", query="SELECT d FROM Dbm400fa d")
public class Dbm400fa implements Serializable {
 private static final long serialVersionUID = 1L;

 @EmbeddedId
 private Dbm400faPK id;

 @Column(name="BORROW_AMOUNT", precision=20, scale=4)
 private BigDecimal borrowAmount;

 @Column(name="CONTRACT_AMOUNT", precision=20, scale=4)
 private BigDecimal contractAmount;

 @Temporal(TemporalType.DATE)
 @Column(name="CREATE_DATE")
 private Date createDate;

 @Column(name="DAILY_LIMIT", precision=20, scale=4)
 private BigDecimal dailyLimit;

 @Column(name="REVIEW_ID", length=20)
 private String reviewId;

 @Column(name="REVIEW_STATUS", length=1)
 private String reviewStatus;

 @Column(name="SOURCE_ID", precision=10)
 private BigDecimal sourceId;

 @Column(name="TOTAL_LIMIT", precision=20, scale=4)
 private BigDecimal totalLimit;

 @Temporal(TemporalType.DATE)
 @Column(name="UPDATE_DATE")
 private Date updateDate;

 @Column(name="USER_ID", length=20)
 private String userId;

 public Dbm400fa() {
 }

 public Dbm400faPK getId() {
  return this.id;
 }

 public void setId(Dbm400faPK id) {
  this.id = id;
 }

 public BigDecimal getBorrowAmount() {
  return this.borrowAmount;
 }

 public void setBorrowAmount(BigDecimal borrowAmount) {
  this.borrowAmount = borrowAmount;
 }

 public BigDecimal getContractAmount() {
  return this.contractAmount;
 }

 public void setContractAmount(BigDecimal contractAmount) {
  this.contractAmount = contractAmount;
 }

 public Date getCreateDate() {
  return this.createDate;
 }

 public void setCreateDate(Date createDate) {
  this.createDate = createDate;
 }

 public BigDecimal getDailyLimit() {
  return this.dailyLimit;
 }

 public void setDailyLimit(BigDecimal dailyLimit) {
  this.dailyLimit = dailyLimit;
 }

 public String getReviewId() {
  return this.reviewId;
 }

 public void setReviewId(String reviewId) {
  this.reviewId = reviewId;
 }

 public String getReviewStatus() {
  return this.reviewStatus;
 }

 public void setReviewStatus(String reviewStatus) {
  this.reviewStatus = reviewStatus;
 }

 public BigDecimal getSourceId() {
  return this.sourceId;
 }

 public void setSourceId(BigDecimal sourceId) {
  this.sourceId = sourceId;
 }

 public BigDecimal getTotalLimit() {
  return this.totalLimit;
 }

 public void setTotalLimit(BigDecimal totalLimit) {
  this.totalLimit = totalLimit;
 }

 public Date getUpdateDate() {
  return this.updateDate;
 }

 public void setUpdateDate(Date updateDate) {
  this.updateDate = updateDate;
 }

 public String getUserId() {
  return this.userId;
 }

 public void setUserId(String userId) {
  this.userId = userId;
 }

}


But as I execute this query SQL statement by JPA:
1
2
3
4
5
SELECT *
FROM DBM400FA
WHERE CONTRACT_YEAR = :contractYr
  AND BANK_SEQ_NO = :bankSeqNo
  AND to_char(contract_date,'yyyyMMdd') = :contractDate + '19110000'

It will throw exception:
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
org.springframework.orm.jpa.JpaSystemException: null id generated for:class gov.nta.entity.dbm.Dbm400fa; nested exception is org.hibernate.id.IdentifierGenerationException: null id generated for:class gov.nta.entity.dbm.Dbm400fa
 at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:244) ~[spring-orm-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:155) ~[spring-orm-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417) ~[spring-orm-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) ~[spring-tx-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) ~[spring-tx-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) ~[spring-tx-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.data.jpa.repository.support.LockModeRepositoryPostProcessor$LockModePopulatingMethodIntercceptor.invoke(LockModeRepositoryPostProcessor.java:105) ~[spring-data-jpa-1.5.2.RELEASE.jar:na]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) ~[spring-aop-4.0.3.RELEASE.jar:4.0.3.RELEASE]
 at com.sun.proxy.$Proxy112.saveAndFlush(Unknown Source) ~[$Proxy112.class:na]
 at gov.nta.dbm.service.DbmBankContractService.saveDbm400faFromDbm400f1(DbmBankContractService.java:312) ~[classes/:na]


Solution
You should use @IdClass instead of @EmbeddedId

 Id class
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
package gov.nta.entity.dbm;

import java.io.Serializable;

/**
 * The primary key class for the DBM400FA database table.
 * 
 */
public class Dbm400faPK implements Serializable {
    // default serial version id, required for serializable classes.
    private static final long serialVersionUID = 1L;

    private String contractYear;

    private long bankSeqNo;

    private java.util.Date contractDate;

    public Dbm400faPK() {
    }

    public String getContractYear() {
        return this.contractYear;
    }

    public void setContractYear(String contractYear) {
        this.contractYear = contractYear;
    }

    public long getBankSeqNo() {
        return this.bankSeqNo;
    }

    public void setBankSeqNo(long bankSeqNo) {
        this.bankSeqNo = bankSeqNo;
    }

    public java.util.Date getContractDate() {
        return this.contractDate;
    }

    public void setContractDate(java.util.Date contractDate) {
        this.contractDate = contractDate;
    }

    public boolean equals(Object other) {
        if (this == other) {
            return true;
        }
        if (!(other instanceof Dbm400faPK)) {
            return false;
        }
        Dbm400faPK castOther = (Dbm400faPK) other;
        return this.contractYear.equals(castOther.contractYear)
                && (this.bankSeqNo == castOther.bankSeqNo)
                && this.contractDate.equals(castOther.contractDate);
    }

    public int hashCode() {
        final int prime = 31;
        int hash = 17;
        hash = hash * prime + this.contractYear.hashCode();
        hash = hash * prime + ((int) (this.bankSeqNo ^ (this.bankSeqNo >>> 32)));
        hash = hash * prime + this.contractDate.hashCode();

        return hash;
    }
}


entity class with Id class
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
package gov.nta.entity.dbm;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.IdClass;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

import org.apache.commons.lang.builder.ToStringBuilder;

/**
 * The persistent class for the DBM400FA database table.
 * 
 */
@Entity
@Table(name = "DBM400FA")
@IdClass(Dbm400faPK.class)
@NamedQuery(name = "Dbm400fa.findAll", query = "SELECT d FROM Dbm400fa d")
public class Dbm400fa implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @Column(name = "CONTRACT_YEAR", unique = true, nullable = false, length = 4)
    private String contractYear;

    @Id
    @Column(name = "BANK_SEQ_NO", unique = true, nullable = false, precision = 10)
    private long bankSeqNo;

    @Id
    @Temporal(TemporalType.DATE)
    @Column(name = "CONTRACT_DATE", unique = true, nullable = false)
    private java.util.Date contractDate;

    @Column(name = "BORROW_AMOUNT", precision = 20, scale = 4)
    private BigDecimal borrowAmount;

    @Column(name = "CONTRACT_AMOUNT", precision = 20, scale = 4)
    private BigDecimal contractAmount;

    @Temporal(TemporalType.DATE)
    @Column(name = "CREATE_DATE")
    private Date createDate;

    @Column(name = "DAILY_LIMIT", precision = 20, scale = 4)
    private BigDecimal dailyLimit;

    @Column(name = "REVIEW_ID", length = 20)
    private String reviewId;

    @Column(name = "REVIEW_STATUS", length = 1)
    private String reviewStatus;

    @Column(name = "SOURCE_ID", precision = 10)
    private BigDecimal sourceId;

    @Column(name = "TOTAL_LIMIT", precision = 20, scale = 4)
    private BigDecimal totalLimit;

    @Temporal(TemporalType.DATE)
    @Column(name = "UPDATE_DATE")
    private Date updateDate;

    @Column(name = "USER_ID", length = 20)
    private String userId;

    public Dbm400fa() {
    }

    public BigDecimal getBorrowAmount() {
        return this.borrowAmount;
    }

    public void setBorrowAmount(BigDecimal borrowAmount) {
        this.borrowAmount = borrowAmount;
    }

    public BigDecimal getContractAmount() {
        return this.contractAmount;
    }

    public void setContractAmount(BigDecimal contractAmount) {
        this.contractAmount = contractAmount;
    }

    public Date getCreateDate() {
        return this.createDate;
    }

    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }

    public BigDecimal getDailyLimit() {
        return this.dailyLimit;
    }

    public void setDailyLimit(BigDecimal dailyLimit) {
        this.dailyLimit = dailyLimit;
    }

    public String getReviewId() {
        return this.reviewId;
    }

    public void setReviewId(String reviewId) {
        this.reviewId = reviewId;
    }

    public String getReviewStatus() {
        return this.reviewStatus;
    }

    public void setReviewStatus(String reviewStatus) {
        this.reviewStatus = reviewStatus;
    }

    public BigDecimal getSourceId() {
        return this.sourceId;
    }

    public void setSourceId(BigDecimal sourceId) {
        this.sourceId = sourceId;
    }

    public BigDecimal getTotalLimit() {
        return this.totalLimit;
    }

    public void setTotalLimit(BigDecimal totalLimit) {
        this.totalLimit = totalLimit;
    }

    public Date getUpdateDate() {
        return this.updateDate;
    }

    public void setUpdateDate(Date updateDate) {
        this.updateDate = updateDate;
    }

    public String getUserId() {
        return this.userId;
    }

    public void setUserId(String userId) {
        this.userId = userId;
    }

    public String getContractYear() {
        return contractYear;
    }

    public void setContractYear(String contractYear) {
        this.contractYear = contractYear;
    }

    public long getBankSeqNo() {
        return bankSeqNo;
    }

    public void setBankSeqNo(long bankSeqNo) {
        this.bankSeqNo = bankSeqNo;
    }

    public java.util.Date getContractDate() {
        return contractDate;
    }

    public void setContractDate(java.util.Date contractDate) {
        this.contractDate = contractDate;
    }

    public String toString() {
        return ToStringBuilder.reflectionToString(this);
    }

}


Reference
[1] http://www.objectdb.com/java/jpa/entity/id
Posted by Albert Kuo at 5:01 PM 1 comments
Labels:

2015/04/23

[AngularJS] How to Clear Selection in ng-grid

Problem
As I selected a specific data row in ng-grid, it should fill in its data into data form

 As I click clear button, it should clear the form data and selected item in ng-grid. But it does not work.

Here is the code snippet. I had set the the length of selectedItem to zero, but in vain.
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
 $scope.resetTab2 = function() {
     cAlerter.clear();
     $scope.clearValidationMessages();
     
     $scope.dbm100eTab2FormBean.seqNo = 0;
     //預算別
     $scope.dbm100eTab2FormBean.budgetCode = "";
     //債務別
     $scope.dbm100eTab2FormBean.debtCode = "";
     //發行額
     $scope.dbm100eTab2FormBean.debtIssueAmt = 0;
     //實收額
     $scope.dbm100eTab2FormBean.realAmount = 0;
     //溢(折)價金額
     $scope.dbm100eTab2FormBean.diversityAmount = 0;
     //發行成本額
     $scope.dbm100eTab2FormBean.issueCostAmount = 0;
     
     $scope.tab2CreateBtn = false;
     $scope.tab2EditBtn = true;
     $scope.dbm100eFormGrid2.selectedItems.length = 0;
 };

Solution
In addition to set selectedItems' length to zero, I also need to set selectAll to false.
Here is the revised code snippet:
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 $scope.resetTab2 = function() {
     cAlerter.clear();
     $scope.clearValidationMessages();
     
     $scope.dbm100eTab2FormBean.seqNo = 0;
     //預算別
     $scope.dbm100eTab2FormBean.budgetCode = "";
     //債務別
     $scope.dbm100eTab2FormBean.debtCode = "";
     //發行額
     $scope.dbm100eTab2FormBean.debtIssueAmt = 0;
     //實收額
     $scope.dbm100eTab2FormBean.realAmount = 0;
     //溢(折)價金額
     $scope.dbm100eTab2FormBean.diversityAmount = 0;
     //發行成本額
     $scope.dbm100eTab2FormBean.issueCostAmount = 0;
     
     $scope.tab2CreateBtn = false;
     $scope.tab2EditBtn = true;
     $scope.dbm100eFormGrid2.selectedItems.length = 0;
     $scope.dbm100eFormGrid2.selectAll(false);
 };

Then it works now.
Reference
[1] https://github.com/angular-ui/ng-grid/issues/2243
Posted by Albert Kuo at 12:00 PM 0 comments
Labels:

[AngularJS] How to Unregister $scope.$watch

Problem
As I fill out values in this form and click create button

 The data will insert into database, and the result will show in data grid which implement by AngularJS ng-grid.

 As I click specific data row, the afterSelectionChange event will be triggered.
Owing to "預算別" and "債務別" are cascading dropdown list, the second dropdown list options will change as the value of the first dropdown list changed.
Therefore, we will watch the second dropdown list and fill in values in the form.

 The problem is......if I just change the second dropdown list instead of click data grid, it will also go into watch. Because of it had start to watch, if you change the value of the second dropdwon list, it will call the watch code even you don't trigger afterSelectionChange.

Here is the code snippet
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
  afterSelectionChange : function (newValue, oldValue) {
     if(!angular.isUndefined($scope.grid2SelectedRow[0])){
          $scope.tab2EditBtn = false;
          $scope.dbm100eTab2FormBean.budgetCode = String($scope.grid2SelectedRow[0].budgetCode);
          //等待債務別下拉單長出來
          $scope.$watch("dbm100eTab2FormBean.debtCode", function(newValue, oldValue) {
              $scope.dbm100eTab2FormBean.debtCode = String($scope.grid2SelectedRow[0].debtCode);
              //發行額
              $scope.dbm100eTab2FormBean.debtIssueAmt    = $scope.grid2SelectedRow[0].issueAmount;
              //實收額
              $scope.dbm100eTab2FormBean.realAmount      = $scope.grid2SelectedRow[0].realAmount;
              //溢(折)價金額
              $scope.dbm100eTab2FormBean.diversityAmount = $scope.grid2SelectedRow[0].diversityAmount;
              //發行成本額
              $scope.dbm100eTab2FormBean.issueCostAmount = $scope.grid2SelectedRow[0].issueCostAmount;
              //PK
              $scope.dbm100eTab2FormBean.seqNo           = $scope.grid2SelectedRow[0].seqNo;
              
              $scope.tab2CreateBtn = true;
              $scope.tab2EditBtn = false;
              
          }, true);
                            }
 }


Solution
Therefore, we need to unregister watch if we do not need to watch.
Here is the revised code snippet
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 afterSelectionChange : function (newValue, oldValue) {
    if(!angular.isUndefined($scope.grid2SelectedRow[0])){
         $scope.tab2EditBtn = false;
         $scope.dbm100eTab2FormBean.budgetCode = String($scope.grid2SelectedRow[0].budgetCode);
         //等待債務別下拉單長出來
         var unregister = $scope.$watch("dbm100eTab2FormBean.debtCode", function(newValue, oldValue) {
             $scope.dbm100eTab2FormBean.debtCode = String($scope.grid2SelectedRow[0].debtCode);
             //發行額
             $scope.dbm100eTab2FormBean.debtIssueAmt    = $scope.grid2SelectedRow[0].issueAmount;
             //實收額
             $scope.dbm100eTab2FormBean.realAmount      = $scope.grid2SelectedRow[0].realAmount;
             //溢(折)價金額
             $scope.dbm100eTab2FormBean.diversityAmount = $scope.grid2SelectedRow[0].diversityAmount;
             //發行成本額
             $scope.dbm100eTab2FormBean.issueCostAmount = $scope.grid2SelectedRow[0].issueCostAmount;
             //PK
             $scope.dbm100eTab2FormBean.seqNo           = $scope.grid2SelectedRow[0].seqNo;
             
             $scope.tab2CreateBtn = true;
             $scope.tab2EditBtn = false;
             
         }, true);
         
         //unregister watch after 3 sec.
         setTimeout(function() {
             unregister();  
         }, 3000);
  }
}


Reference
[1] http://stackoverflow.com/questions/14957614/angular-js-clear-watch
Posted by Albert Kuo at 10:17 AM 0 comments
Labels:

2015/04/20

Fail to set background color in iReport

Problem
Customer ask to set the background color of the last column to yellow.

 But it does not work after I set backcolor to yellow.
Resolution
In addition to set background color, you also need to check Opaque attribute.

 Then it will work now:

Reference
[1] http://community.jaspersoft.com/questions/817869/defining-color-band-background
Posted by Albert Kuo at 11:03 AM 0 comments
Labels:
Subscribe to: Posts (Atom)