Nested Exception Error

[hantone <ho...@gmail.com>]

Thanks in advance! I'm having a hard time with this so I would really
appreciate your help!

I'm having problems to commit a transaction

public class Main {
	public static void main(String[] args) {
		try {
			EntityManager entityManager = 
Persistence.createEntityManagerFactory("ReportAndPay").createEntityManager();;
			EntityTransaction transaction = entityManager.getTransaction();
			transaction.begin();
			Reports report = entityManager.find(Reports.class, new Inhteger(2001));
			Blob file = null;
			try {
				file = new SerialBlob("PEPE".getBytes());
			} catch (SQLException e) {}
			report.getOutboundFileses().add(new OutboundFiles(report, file ,
"Type","Status"));
			entityManager.merge(report);
			transaction.commit();
			entityManager.close();
		} catch(RuntimeException rte) {
			System.out.println(rte.getStackTrace());
		}
	}
}

When I debug it, an exception happened when executing
"transaction.commit();", I get this error message 
"The transaction has been rolled back.  See the nested exceptions for
details on the errors that occurred.", the error cause is
<openjpa-1.2.0-r422266:683325 fatal store error>
org.apache.openjpa.persistence.RollbackException: The transaction has been
rolled back.  See the nested exceptions for details on the errors that
occurred.



@Entity
@Table(name = "REPORTS", schema = "MYPROY")
@SequenceGenerator(name="ReportsSeq",
sequenceName="MYPRO.REPORT_ROW_ID_SEQ1", initialValue=1, allocationSize=1)
public class Reports implements java.io.Serializable {
	private int reportRowId;
	private String status;
	private Date created;
	private Set<OutboundFiles> outboundFileses = new HashSet<OutboundFiles>(0);
        ...

	@Id
	@Column(name = "REPORT_ROW_ID", unique = true, nullable = false)
	@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="ReportsSeq")
	public int getReportRowId() {
		return this.reportRowId;
	}

	@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy =
"reports")
	public Set<OutboundFiles> getOutboundFileses() {
		return this.outboundFileses;
	}
}




@Entity
@Table(name = "OUTBOUND_FILES", schema = "MYPROY")
@SequenceGenerator(name="OutboundFilesSeq",
sequenceName="WWBPSM.OUTBOUND_FILE_ROW_ID_SEQ1", initialValue=1,
allocationSize=1)
public class OutboundFiles implements java.io.Serializable {
	private int outboundFileRowId;
	private Reports reports;
	private Blob file;
	private String fileType;
	private String status;

	public OutboundFiles() {
	}

	public OutboundFiles(int outboundFileRowId, Reports reports, Blob file,
			String fileType) {
		this.outboundFileRowId = outboundFileRowId;
		this.reports = reports;
		this.file = file;
		this.fileType = fileType;
	}
	public OutboundFiles(Reports reports, Blob file,String fileType, String
status) {
		this.reports = reports;
		this.file = file;
		this.fileType = fileType;
		this.status = status;
	}
	@Id
	@Column(name = "OUTBOUND_FILE_ROW_ID", unique = true, nullable = false)
	@GeneratedValue(strategy=GenerationType.SEQUENCE,
generator="OutboundFilesSeq")
	public int getOutboundFileRowId() {
		return this.outboundFileRowId;
	}
}

the same error happens as well if I use

public class Main {
	public static void main(String[] args) {
		try {
			EntityManager entityManager = 
Persistence.createEntityManagerFactory("ReportAndPay").createEntityManager();;
			EntityTransaction transaction = entityManager.getTransaction();
			transaction.begin();
			Reports report = entityManager.find(Reports.class, new Integer(2001));
			Blob file = null;
			try {
				file = new SerialBlob("PEPE".getBytes());
			} catch (SQLException e) {}
			OutboundFiles outboundFiles = new OutboundFiles(report, file ,
"Type","Status");
			entityManager.persist(outboundFiles);
			transaction.commit();
			entityManager.close();
		} catch(RuntimeException rte) {
			System.out.println(rte.getMessage());
		}
	}
}


-- 
View this message in context: http://n2.nabble.com/Nested-Exception-Error-tp2226952p2226952.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Nested Exception Error

[Pinaki Poddar <pp...@apache.org>]

Hi,
   if you do 
		} catch(RuntimeException rte) {
			rte.printStackTrace();
		}

instead of
		} catch(RuntimeException rte) {
			System.out.println(rte.getStackTrace());
		}

does that change anything?



-- 
View this message in context: http://n2.nabble.com/Nested-Exception-Error-tp2226952p2237221.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.