openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From is_maximum <mnr...@gmail.com>
Subject Persisting interface
Date Sun, 05 Apr 2009 08:23:29 GMT

Hi all
My question is if we can persist interfaces instead of pure classes as entities without using
OpenJPA features. Currently with a test case I encountered the persistence exception however
the OpenJPA logs shows that it is going to insert data but with wrong value !!!

9233  pu-cm  TRACE  [main] openjpa.jdbc.SQL - <t 14104547, conn 0> executing prepstmnt
14116828 SELECT t0.NAME FROM GL1TEST_INTERFACE t0 WHERE t0.ID = ? [params=(long) 12]
9280  pu-cm  TRACE  [main] openjpa.jdbc.SQL - <t 14104547, conn 0> [47 ms] spent
9343  pu-cm  TRACE  [main] openjpa.jdbc.SQL - <t 14104547, conn 0> executing prepstmnt
32459120 INSERT INTO GL1TEST_TX (ID, NAME, INTERFACE_ID) VALUES (?, ?, ?) [params=(long) 12,
(String) hello, (String) com.kishware.core.gl.data.InterfaceImpl:com.kishware.core.gl.data.In...]
9374  pu-cm  TRACE  [main] openjpa.jdbc.SQL - <t 14104547, conn 0> [31 ms] spent
9374  pu-cm  TRACE  [main] openjpa.jdbc.SQL - <t 14104547, conn 0> executing prepstmnt
7839182 INSERT INTO GL1TEST_INTERFACE (ID, NAME) VALUES (?, ?) [params=(long) 12, (String)
interface]
9374  pu-cm  TRACE  [main] openjpa.jdbc.SQL - <t 14104547, conn 0> [0 ms] spent


as you can see in first insert statement INTERFACE_ID should be a long value but OpenJPA put
a String value to be inserted and this ends up in an oracle error with message "invalid number"

Here is the entities definition:

public class TestTx {
	@Id
	@Column(name="ID")
	private Long id;
	@Column(name="NAME")
	private String name;
	@ManyToOne(cascade = CascadeType.ALL)
	@JoinColumn(name = "INTERFACE_ID")
	private IInterface iInterface;

//getters and setters....

}

@Entity
@Table(name = "GL1TEST_INTERFACE")
public class InterfaceImpl implements IInterface {
 
	@Id
	@Column(name = "ID")
	private Long id;
	@Column(name = "NAME")
	private String name;

//getters and setters....
}

Thanks
-- 
View this message in context: http://n2.nabble.com/Persisting-interface-tp2587940p2587940.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.


Mime
View raw message