Every time i perform my query i get a global exception. This hapens with any match query of ExpressionFactory
here is my code and the table definition.
Expression exp = ExpressionFactory.matchExp("COD_USUARIO", usuarioId);
SelectQuery query = new SelectQuery(GeUsuario.class, exp);
List usuario = dataContext.performQuery(query);
System.out.println("Numero de usuarios :" + usuario.size());
if (usuario.size() == 1) {
System.out.println("Classe :" + usuario.toArray()[0]);
return (GeUsuario) usuario.get(0);
}
return null;
CREATE TABLE SEGUROS.GE_USUARIO(
COD_PESSOA INTeger NOT NULL,
COD_USUARIO CHARacter(8) NOT NULL,
STA_USUARIO CHARacter(1) NOT NULL,
DES_SENHA_USUARIO CHARacter(20) NOT NULL,
DTH_EXPIRA_SENHA DATE,
QTD_DIAS_VIG_SENHA INTeger NOT NULL,
DTH_CADASTRAMENTO TIMESTAMP NOT NULL
)
GO
ALTER TABLE SEGUROS.GE_USUARIO ADD PRIMARY KEY (COD_PESSOA, COD_USUARIO)
GO
CREATE UNIQUE INDEX IPGET268 ON SEGUROS.GE_USUARIO(COD_PESSOA, COD_USUARIO)
GO.
thanks,
Leonardo.
This archive was generated by hypermail 2.0.0 : Wed Jan 07 2004 - 14:17:37 EST