23/10/2009, 06:09
|
| | | Fecha de Ingreso: octubre-2009
Mensajes: 10
Antigüedad: 15 años, 1 mes Puntos: 0 | |
| Respuesta: Java + Hibernate + SQLServer
la que me ejecuta es la que pone en segundo lugar, sin where ni nada, y sigue devolviendo ningun valor, mientras que ejecutandola directamente sobre SQL Server si funciona. Si es que que cosas mas raras. Por si puede ser util, posteo la traza: Cita: [2009-10-23 14:05:29,745 DEBUG] [main] util.SQLStatementLogger - select db2prax0_.COD_ENT as COD1_0_, db2prax0_.EJER_CONT as EJER2_0_, db2prax0_.COD_BAL as COD3_0_, db2prax0_.COD_MOD as COD4_0_, db2praxc0_.DES_BAL as DES5_0_, db2prax0_.COD_USU as COD6_0_, db2prax0_.ACCION_USU as ACCION7_0_, db2prax0_.FECHA_USU as FECHA8_0_, db2prax0_.HORA_USU as HORA9_0_ from dbo.DB2PRAX db2prax0_
Hibernate: select db2prax0_.COD_ENT as COD1_0_, db2prax0_.EJER_CONT as EJER2_0_, db2prax0_.COD_BAL as COD3_0_, db2prax0_.COD_MOD as COD4_0_, db2prax0_.DES_BAL as DES5_0_, db2prax0_.COD_USU as COD6_0_, db2prax0_.ACCION_USU as ACCION7_0_, db2prax0_.FECHA_USU as FECHA8_0_, db2prax0_.HORA_USU as HORA9_0_ from dbo.DB2PRAX db2prax0_
[2009-10-23 14:05:29,808 DEBUG] [main] jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
[2009-10-23 14:05:29,808 DEBUG] [main] jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
[2009-10-23 14:05:29,808 DEBUG] [main] jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[2009-10-23 14:05:29,823 DEBUG] [main] engine.StatefulPersistenceContext - initializing non-lazy collections
[2009-10-23 14:05:29,823 DEBUG] [main] transaction.JDBCTransaction - commit
[2009-10-23 14:05:29,823 DEBUG] [main] transaction.JDBCTransaction - committed JDBC Connection
[2009-10-23 14:05:29,823 DEBUG] [main] jdbc.ConnectionManager - aggressively releasing JDBC connection
[2009-10-23 14:05:29,823 DEBUG] [main] jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
[2009-10-23 14:05:29,823 DEBUG] [main] modules.Module2 - TENEMOS UN TOTAL DE 0 VALORES
[2009-10-23 14:05:29,823 INFO ] [main] modules.Module2 - CONEXION CERRADA
[2009-10-23 14:05:29,823 INFO ] [main] main.Main - FINAL DE LA EJECUCION las ultimas tres trazas son introducidas por mi en el codigo. |