Discussoes de Programacao e Tecnologia

Sequence

5 respostas
A
alrauber

Estou utilizando o Jboss com CMP. Gostaria de acessar uma sequence que criei no meu banco (Postgres). Estou configurando da sequinte forma o meu arquivo jbosscmp-jdbc.xml:

…

<unknown-pk>

<unknown-pk-class>java.lang.Integer</unknown-pk-class>

<field-name>id</field-name>

<read-only>true</read-only>

<column-name>co_tp_perfil</column-name>

<jdbc-type>SHORT</jdbc-type>

<sql-type>INT2</sql-type>

</unknown-pk>

<entity-command name=“keygen”>

<attribute name=“sequence”>segweb_fnde.nu_seq_tipoperfil_seq</attribute>

</entity-command>

</entity>

</enterprise-beans>

<entity-commands>

<entity-command name=“keygen” class=“org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCPostgreSQLCreateCommand” />

</entity-commands>

…

Obrigado galera…

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

5 Respostas

jgbt
jgbt

qual erro ta dando???
posta o erro p/ facilitar…

esse é um exemplo usando oracle, talves te ajude:

&lt;unknown-pk&gt;
		&lt;unknown-pk-class&gt;java.lang.Object&lt;/unknown-pk-class&gt;
		&lt;column-name&gt;codCredito&lt;/column-name&gt;
		&lt;auto-increment/&gt;
	&lt;/unknown-pk&gt;
	&lt;entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand"&gt;
		&lt;attribute name="sequence"&gt;CREDITO_SEQ&lt;/attribute&gt;
	&lt;/entity-command&gt;

[]'s

A
alrauber

Parece que ele não está conseguindo recuperar o id… não sei…
O erro que estou tomando é o seguinte:

An error occurred in the bean. Error Message is: EJBException:; nested exception is: javax.ejb.EJBException: Could not create entity:java.sql.SQLException: ERROR: null value in column “co_tp_perfil” violates not-null constraint

Stack Trace is :

java.rmi.ServerException: EJBException:; nested exception is:

javax.ejb.EJBException: Could not create entity:java.sql.SQLException: ERROR: null value in column “co_tp_perfil” violates not-null constraint

at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:351)

at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)

at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)

at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)

at org.jboss.ejb.Container.invoke(Container.java:709)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)

at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)

at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)

at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)

at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)

at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)

at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)

at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)

at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)

at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)

at $Proxy49.createTipoPerfil(Unknown Source)

at seguranca.delegate.SegurancaDelegate.createTipoPerfil(SegurancaDelegate.java:18)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:55)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:417)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

at java.lang.Thread.run(Thread.java:534)

Caused by: javax.ejb.EJBException: Could not create entity:java.sql.SQLException: ERROR: null value in column “co_tp_perfil” violates not-null constraint

at seguranca.SegurancaSfBean.createTipoPerfil(SegurancaSfBean.java:50)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)

at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)

at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)

at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)

at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)

at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)

at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)

at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)

… 61 more
jgbt
jgbt

vc tem que dizer que o metodo set da propriedade vai usar a sequence.
vc ta fazendo isso???
se vc usa xdoclet fica assim:

/**
     * @ejb.interface-method view-type="local"
     * @jboss.auto-increment
     */
    public abstract void setCodXXX(Long l);

e vc sempre deve passar 0 para a coluna, que o banco vai incrementar a sequence.

[]'s

A
alrauber

Eu nao estou usando xdoclet…

A
alrauber

Coloquei o xdoclet aki…

package seguranca;

import javax.ejb.EntityBean;

import javax.ejb.EntityContext;

import javax.ejb.CreateException;

import javax.ejb.RemoveException;

public abstract class TipoPerfilBean implements EntityBean {

EntityContext entityContext;

public Short ejbCreate(String nome) throws CreateException {

setNome(nome);

return null;

}

public void ejbPostCreate(String nome) throws CreateException {
}

public void ejbRemove() throws RemoveException {
}

/**
 * @ejb.interface-method view-type="local"
 * @jboss.auto-increment
 */
public abstract void setId(Short id);

public abstract Short getId();

public abstract void setNome(String nome);

public abstract String getNome();

public void ejbLoad() {
}

public void ejbStore() {
}

public void ejbActivate() {
}

public void ejbPassivate() {
}

public void unsetEntityContext() {
    this.entityContext = null;
}

public void setEntityContext(EntityContext entityContext) {
    this.entityContext = entityContext;
}

}

Criado 9 de maio de 2005
Ultima resposta 9 de mai. de 2005
Respostas 5
Participantes 2

Topicos relacionados

Como saber se um mes tem 4 ou 5 semanas?[RESOLVIDO] 31 respostas Como converter inteiro para string! 13 respostas Comando SELECT para selecionar intervalo de data SQL SERVER 12 respostas &, &&, |, ||. Qndo usar? 6 respostas O método split 12 respostas
Alura O que são algoritmos e lógica de programação e como aprender? Entenda o que são algoritmos e lógica de programação e qual é a importância desses conceitos para começar a programar
Casa do Codigo Desbravando SOLID: Praticas avancadas para codigos de... Por Alexandre Aquiles — Casa do Codigo