Pessoal como eu faco para falar pra minha entity q eu quero usar um a SEQUENCE QUE EU CRIEI??
usei o seguinte codigo para criar a tabela :
create sequence db_notas.tb_central_cep_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE TABLE db_notas.tb_central_cep(
cd_central_cep integer primary key not null default nextval('db_notas.tb_central_cep_seq'),
dt_central DATE,
hr_central TIME,
cd_usuario_central INTEGER,
nm_usuario_central VARCHAR(250)
);
e gerei a minha entity assim:
@Entity
@Table(name = "tb_central_cep", catalog = "db_dnaso", schema = "db_notas")
@SequenceGenerator(sequenceName="tb_central_cep_seq",allocationSize=1, initialValue=0, name = "tb_central_cep_seq")
@NamedQueries({
@NamedQuery(name = "TbCentralCep.findAll", query = "SELECT t FROM TbCentralCep t"),
@NamedQuery(name = "TbCentralCep.findByCdCentralCep", query = "SELECT t FROM TbCentralCep t WHERE t.cdCentralCep = :cdCentralCep"),
@NamedQuery(name = "TbCentralCep.findByDtCentral", query = "SELECT t FROM TbCentralCep t WHERE t.dtCentral = :dtCentral"),
@NamedQuery(name = "TbCentralCep.findByHrCentral", query = "SELECT t FROM TbCentralCep t WHERE t.hrCentral = :hrCentral"),
@NamedQuery(name = "TbCentralCep.findByCdUsuarioCentral", query = "SELECT t FROM TbCentralCep t WHERE t.cdUsuarioCentral = :cdUsuarioCentral"),
@NamedQuery(name = "TbCentralCep.findByNmUsuarioCentral", query = "SELECT t FROM TbCentralCep t WHERE t.nmUsuarioCentral = :nmUsuarioCentral")})
public class TbCentralCep implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY, generator="tb_central_cep_seq")
@Basic(optional = false)
@Column(name = "cd_central_cep", nullable = false)
private Integer cdCentralCep;
porem recebo o seguinte ERRO:
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation “db_notas.tb_central_cep_cd_central_cep_seq” does not exist
Error Code: 0
Call: select currval(‘db_dnaso.db_notas.tb_central_cep_cd_central_cep_seq’)
Query: ValueReadQuery()
ele procura a sequence “nome_da_tabela_nome_do_campo_seq” mas eu quero fazer ele usar a que eu criei com qualquer nome a minha escolha.
valeu
