Hi again!
I have some POJOs with this config (changing name and generator
attributes. off course!):
[code]
@Id
@TableGenerator(
name="categoria_id_gerador",
table="id_gerador",
pkColumnName="id_nome",
valueColumnName="id_valor",
allocationSize=1
)
@GeneratedValue(strategy=GenerationType.TABLE,
generator="categoria_id_gerador")
[/code]
And in my unit test I do init someone of them:
[code]
private EntityManagerFactory emf = null;
private EntityManager em = null;
private static final String initId = "UPDATE gfi.id_gerador SET
id_valor = 1 WHERE id_nome = ?";
public InventarioServiceTest() { }
@Before
public void setUp() {
emf = Persistence.createEntityManagerFactory("gfi-corePU");
em = emf.createEntityManager();
em.getTransaction().begin();
//init @TableGenerator(id_gerador)
em.createNativeQuery(initId).setParameter(1,
"item_id_gerador").executeUpdate();
em.createNativeQuery(initId).setParameter(1,
"categoria_id_gerador").executeUpdate();
em.createNativeQuery(initId).setParameter(1,
"produto_id_gerador").executeUpdate();
//Clean tables
em.createNativeQuery("DELETE FROM gfi.item").executeUpdate();
em.createNativeQuery("DELETE FROM gfi.produto").executeUpdate();
em.createNativeQuery("DELETE FROM gfi.categoria").executeUpdate();
em.createNativeQuery("DELETE FROM
gfi.unidade_medida").executeUpdate();
//Necessário para o teste do produto
em.createNativeQuery("INSERT INTO gfi.categoria (cd_categoria,
descricao_categoria, dt_cadastro, nome_categoria) "+
"VALUES (1, 'Vários tipos de roupas.', '2007-12-17
15:26:08.586', 'Vestuário')").executeUpdate();
//Necessário para o teste do item
em.createNativeQuery("INSERT INTO gfi.produto (cd_produto,
cd_categoria, dt_cadastro, nome_produto, VERSION, descricao_produto) "+
"VALUES (1, 1, '2007-12-17 15:26:10.451', 'Calça
Jeans', 1, 'Calça Jeans estilo sertanejo.') ").executeUpdate();
em.createNativeQuery("INSERT INTO gfi.unidade_medida
(cd_unidade_medida, descricao_unidade, VERSION) "+
"VALUES ('MT', 'Metros', 1) ").executeUpdate();
em.getTransaction().commit();
}
[/code]
I don't know why, but openjpa doesn't print any trace on the setup() method.
But the SQL generate is totally wrong (on persistRemoveCategoriaTest()):
[debug]
[DEBUG] InventarioServiceTest -
persistRemoveCategoriaTest - Criação de uma instância da classe Categoria
1368 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
5311938 executing prepstmnt 30318493 SELECT ID_VALOR FROM id_gerador
WHERE ID_NOME = ? FOR UPDATE WITH RR [params=(String) DEFAULT]
1368 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
5311938 [0 ms] spent
1380 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
18012078 executing prepstmnt 3824284 INSERT INTO id_gerador (ID_NOME,
ID_VALOR) VALUES (?, ?) [params=(String) DEFAULT, (int) 0]
1384 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
18012078 [2 ms] spent
1388 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
11147203 executing prepstmnt 8331873 SELECT ID_VALOR FROM id_gerador
WHERE ID_NOME = ? FOR UPDATE WITH RR [params=(String) DEFAULT]
1388 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
11147203 [0 ms] spent
1420 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
11147203 executing prepstmnt 30170403 UPDATE id_gerador SET ID_VALOR = ?
WHERE ID_NOME = ? AND ID_VALOR = ? [params=(long) 1, (String) DEFAULT,
(long) 0]
1424 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
11147203 [3 ms] spent
1440 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
21995759 executing prepstmnt 31255 SELECT ID_VALOR FROM id_gerador WHERE
ID_NOME = ? FOR UPDATE WITH RR [params=(String) DEFAULT]
1440 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
21995759 [0 ms] spent
1440 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
21995759 executing prepstmnt 21470969 UPDATE id_gerador SET ID_VALOR = ?
WHERE ID_NOME = ? AND ID_VALOR = ? [params=(long) 2, (String) DEFAULT,
(long) 1]
1443 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
21995759 [1 ms] spent
1468 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
17741109 executing prepstmnt 17310327 INSERT INTO categoria
(cd_categoria, descricao_categoria, dt_cadastro, nome_categoria) VALUES
(?, ?, ?, ?) [params=(int) 1, (String) Vários tipos de sapatos.,
(Timestamp) 2007-12-19 16:25:39.682, (String) Sapatos]
1528 gfi-corePU TRACE [main] openjpa.jdbc.SQL - <t 27041558, conn
17741109 [60 ms] spent
0 gfi-corePU INFO [main] openjpa.Runtime - Starting OpenJPA
1.1.0-SNAPSHOT
[/debug]
Shouldn't openjpa get the ID from the table id_gerador where the value
was equal to categoria_id_gerador (for POJO Categoria)? Where does
DEFAULT come from?
My test:
[code]
@Test
public void persistRemoveCategoriaTest() {
log.debug("\npersistRemoveCategoriaTest - Criação de uma
instância da classe Categoria\n");
String cNome = "Sapatos";
String cDescricao = "Vários tipos de sapatos.";
Categoria c = new Categoria(cNome, cDescricao);
assertNull("cdCategoria antes do método
persist:",c.getCdCategoria());
em.getTransaction().begin();
em.persist(c);
em.getTransaction().commit();
log.debug("\nObjeto pós gravação: \n"+c);
assertNotNull("cdCategoria pós persist:",c.getCdCategoria());
}
@Test
[/code]
