Announcement Announcement Module
Collapse
No announcement yet.
not recognized parameter Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • not recognized parameter

    I have this error:

    Caused by: java.sql.SQLException: Parameter #3 has not been set.

    This parameter is set, I sure, this is code

    THIS QUERY
    select factnegsol0_.ID_SOLICITUD as ID1_0_0_, negnegocia1_.ID_NEGOCIACION as ID1_6_1_, gempresas2_.ID_EMPRESA as ID1_2_2_, ggrupos3_.ID_GRUPO as ID1_3_3_, gempleados4_.ID_EMPLEADO as ID1_1_4_, factnegsol0_.ID_NEGOCIACION as ID2_0_0_, factnegsol0_.F_ENTRADA as F3_0_0_, factnegsol0_.ID_ESTADO as ID4_0_0_, factnegsol0_.COMENTARIOS as COMENTAR5_0_0_, factnegsol0_.F_APROBACION as F6_0_0_, factnegsol0_.ID_MONEDA as ID7_0_0_, factnegsol0_.ID_EMPLEADO_SOLICITANTE as ID8_0_0_, negnegocia1_.ID_SUBCATEGORIA as ID2_6_1_, negnegocia1_.ID_MONEDA as ID3_6_1_, negnegocia1_.ID_OWNER as ID4_6_1_, negnegocia1_.TITULO as TITULO6_1_, negnegocia1_.TIPO_TRANSACCION as TIPO6_6_1_, negnegocia1_.F_INICIO_NEG as F7_6_1_, negnegocia1_.F_1ST_EST_CIERRE_NEG as F8_6_1_, negnegocia1_.F_ESTIMADA_CIERRE_NEG as F9_6_1_, negnegocia1_.F_REAL_CIERRE_NEG as F10_6_1_, negnegocia1_.F_ESTIMADA_INIC_PER_SUMINISTRO as F11_6_1_, negnegocia1_.F_ESTIMADA_FIN_PER_SUMINISTRO as F12_6_1_, negnegocia1_.F_PREV_FACTURACION as F13_6_1_, negnegocia1_.F_LANZAMIENTO_RFQ as F14_6_1_, negnegocia1_.F_VTO_RFQ as F15_6_1_, negnegocia1_.F_ULTIMA_RONDA as F16_6_1_, negnegocia1_.F_PRESENTACION_RESULTADOS as F17_6_1_, negnegocia1_.F_ADJUDICACION as F18_6_1_, negnegocia1_.F_CONTRATOS as F19_6_1_, negnegocia1_.ID_STATUS_NEG as ID20_6_1_, negnegocia1_.SITUACION as SITUACION6_1_, negnegocia1_.IVA_NEG as IVA22_6_1_, negnegocia1_.VOL_ESTIMADO_ANUAL_PRENEG as VOL23_6_1_, negnegocia1_.VOL_TOTAL_PRENEG as VOL24_6_1_, negnegocia1_.VOL_TOTAL_POSTNEG as VOL25_6_1_, negnegocia1_.VOL_ADJUDICADO as VOL26_6_1_, negnegocia1_.PORCENTAJE_AHORRO_OBJETIVO as PORCENTAJE27_6_1_, negnegocia1_.ID_EMPLEADO_COMERCIAL as ID28_6_1_, negnegocia1_.ID_EMPLEADO_GERENTE as ID29_6_1_, negnegocia1_.ID_EMPLEADO_ANALISTA as ID30_6_1_, negnegocia1_.MANDATO_FIRMADO as MANDATO31_6_1_, negnegocia1_.COMENTARIOS as COMENTA32_6_1_, negnegocia1_.ANO_PPTO as ANO33_6_1_, negnegocia1_.MES_PPTO as MES34_6_1_, negnegocia1_.MARCA_AGRUPACION as MARCA35_6_1_, negnegocia1_.CONTACTO_CLIENTE as CONTACTO36_6_1_, negnegocia1_.DESCRIPCION_ESTADO as DESCRIP37_6_1_, negnegocia1_.COD_NEG_CLIENTE as COD38_6_1_, negnegocia1_.CONDICIONES_FACTURACION as CONDICI39_6_1_, negnegocia1_.FORMA_FACTURACION as FORMA40_6_1_, negnegocia1_.FEE_FIJO as FEE41_6_1_, negnegocia1_.TASA_FEE_VBLE as TASA42_6_1_, negnegocia1_.APLICACION_TASA_FEE_VBLE as APLICACION43_6_1_, negnegocia1_.INC_S_VOLUMEN as INC44_6_1_, negnegocia1_.F_ALTA as F45_6_1_, negnegocia1_.ID_EMPRESA as ID46_6_1_, gempresas2_.EMPRESA as EMPRESA2_2_, gempresas2_.DIRECCION as DIRECCION2_2_, gempresas2_.TELF as TELF2_2_, gempresas2_.FAX as FAX2_2_, gempresas2_.E_MAIL as E6_2_2_, gempresas2_.WWW as WWW2_2_, gempresas2_.CIF as CIF2_2_, gempresas2_.F_ALTA_REG as F9_2_2_, gempresas2_.PROVINCIA as PROVINCIA2_2_, gempresas2_.CP as CP2_2_, gempresas2_.ID_GRUPO as ID12_2_2_, gempresas2_.ID_SUBGRUPO as ID13_2_2_, ggrupos3_.GRUPO as GRUPO3_3_, ggrupos3_.TELF as TELF3_3_, ggrupos3_.FAX as FAX3_3_, ggrupos3_.E_MAIL as E5_3_3_, ggrupos3_.WWW as WWW3_3_, ggrupos3_.CIF as CIF3_3_, ggrupos3_.F_ALTA_REG as F8_3_3_, gempleados4_.NUMERO_MATRICULA as NUMERO2_1_4_, gempleados4_.ALIAS as ALIAS1_4_, gempleados4_.NOMBRE as NOMBRE1_4_, gempleados4_.APELLIDO1 as APELLIDO5_1_4_, gempleados4_.APELLIDO2 as APELLIDO6_1_4_, gempleados4_.OUSER as OUSER1_4_, gempleados4_.TR_ROL as TR8_1_4_, gempleados4_.ACTIVO as ACTIVO1_4_, gempleados4_.TELF as TELF1_4_, gempleados4_.E_MAIL as E11_1_4_, gempleados4_.EVENTMAIL_TR as EVENTMAIL12_1_4_, gempleados4_.F_ALTA as F13_1_4_, gempleados4_.F_BAJA as F14_1_4_, gempleados4_.GMT as GMT1_4_, gempleados4_.ID_IDIOMA_PREFERIDO as ID16_1_4_, gempleados4_.ID_PAIS as ID17_1_4_, gempleados4_.ID_MONEDA_PREFERIDA as ID18_1_4_ from dbo.FACT_NEG_SOLICITUD factnegsol0_, dbo.NEG_NEGOCIACIONES negnegocia1_, dbo.G_EMPRESAS gempresas2_, dbo.G_GRUPOS ggrupos3_, dbo.G_EMPLEADOS gempleados4_ where gempleados4_.ID_EMPLEADO=factnegsol0_.ID_EMPLEADO_ SOLICITANTE and factnegsol0_.ID_NEGOCIACION=negnegocia1_.ID_NEGOCI ACION and negnegocia1_.ID_EMPRESA=gempresas2_.ID_EMPRESA and gempresas2_.ID_GRUPO=ggrupos3_.ID_GRUPO and year(factnegsol0_.F_ENTRADA)=? and month(factnegsol0_.F_ENTRADA)=? and ggrupos3_.ID_GRUPO=?

    THIS PARAMETER
    cQuery.setParameter("Anno",this.alParameter.get(0) , Hibernate.STRING );
    cQuery.setParameter("Mes",this.alParameter.get(3), Hibernate.STRING );
    cQuery.setParameter("Grupo", this.alParameter.get(2), Hibernate.BIG_INTEGER);

  • #2
    Download P6Spy from sourceforge and use that for your test - here is a sample configuration:

    Code:
        <bean id="dataSource" class="com.p6spy.engine.spy.P6DataSource" destroy-method="close">
            <constructor-arg>
                <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource">
                    <property name="driverClassName" value="org.apache.derby.jdbc.EmbeddedDriver"/>
                    <property name="url" value="jdbc:derby:/Temp/mydb"/>
                    <property name="username" value="user"/>
                    <property name="password" value="pwd"/>
                </bean>
            </constructor-arg>
        </bean>
    Then look in spy.log for more detailed info regarding parameters and values being set.

    Comment

    Working...
    X