YemisiSCG's questions

I have the following query:

SELECT datoUno(double), datoDos(double), datoTres(varchar) 
FROM
    Table_ejemplo
WHERE
    dato_ID IN (164246, 164353,...);

My problem comes when from my implementing class for the data_ID parameters I pass a List like this: [164246, 164353, 123131,...].

This is the code:

private TransaccionResponse busquedaEjemplo(List<Integer> lstEjemplo) {
        StringBuffer sql = new StringBuffer();

        creaQueryEjemplo(sql);

        SQLQuery query = db.createSQLQuery(sql.toString());

        query.addScalar("datoUno", StandardBasicTypes.DOUBLE);
        query.addScalar("datoDos", StandardBasicTypes.DOUBLE);
        query.addScalar("datoTres", StandardBasicTypes.STRING);

        query.setResultTransformer(
                Transformers.aliasToBean(BeanReporteEjemplo.class));

        query.setParameter("datoId",lstEjemplo);

        List<BeanReporteEjemplo> resultados = query.list();

        BeanReporteEjemplo= new ArrayList<BeanReporteEjemplo>();

        for (Object object : resultados) {
            BeanReporteEjemplo b = (BeanReporteEjemplo) object;
            BeanReporteEjemplo.add(b);
        }

        return new SimpleTransaccionResponse(BeanReporteEjemplo);
    }

BeanReportExample

private double datoUno;
private double datoDos;
private String datoTres;

    public final static Campo PROP_DATO_UNO = new Campo("datoUno",
            "dato Uno", double.class, 150, false, null,
            new RendererSimple(Renderer.CENTER));
    public final static Campo PROP_DATO_DOS = new Campo(
            "datoDos", "dato Dos", double.class, 150, false,
            null, new RendererSimple(Renderer.CENTER));
    public final static Campo PROP_DATO_TRES = new Campo("datoTres", "dato Tres",
            String.class, 150, false, null,
            new RendererSimple(RendererSimple.CENTER));



 public static List<Campo> getCampos() {
        List<Campo> campos = new ArrayList<Campo>();


        campos.add(PROP_DATO_UNO);
        campos.add(PROP_DATO_DOS);
        campos.add(PROP_DATO_TRES);

        return campos;
    }



 getters() and Setters()....

It throws me the following error:

2019-11-01 09:53:06,642 WARN : SqlExceptionHelper - SQL Error: -4474, SQLState: null 2019-11-01 09:53:06,642 ERROR : SqlExceptionHelper - [jcc][1083][10406][3.66.46 ] Illegal conversion: can not convert from "byte[]" to "java.math.BigDecimal" ERRORCODE=-4474, SQLSTATE=null

The problem occurs when I pass a List: [164246, 164353, 123131,...] but when I perform a sub-query instead of passing the list, it does so without problem.

This way I don't get any errors.

SELECT datoUno(double), datoDos(double), datoTres(varchar) 
FROM
    Table_ejemplo
WHERE
    dato_ID IN (SELECT
    DISTINCT dato
FROM
    tableExample
WHERE
    datoEjemplo = 1142
    AND datoEjemplo = 1);

I would be grateful if someone could guide me to solve this situation.

Good morning everyone.

I have recently switched to Eclipse Photon 4.8.0 and am trying to add a Jboss server.

But it gives me the following error:

I've searched but haven't really found a solution. Thanks.

Good morning everyone!

I find myself making a plan in JMeter for the famous stress tests, although I have already tested Weblogic queues, I have a problem with MQ queues, I had never done it.

I have carried out the procedure of different tutorials as it is, but I have not been successful. Here are some of the tutorials I've based on:

1. jMeter - JMS Test Plan
2. 10.2 JMS point-to-point sample addition
3. Among others.

The configuration I have is the following:

in the properties of the JNDI I have the data:

• queueManager.
• hostName.
• port.
• transportType.
• queue.QL.QUEUE.IN

This is the error I get when launching the request:

Response message: javax.jms.JMSException: Cannot send, channel has already failed: tcp://XX.XX.XX.XX:XXXX

If someone has done this type of configuration in JMeter and could help me, I really thank you.

Good morning everyone!

I find myself maintaining a project that makes use of a Spring context file, the truth is the first time I work with this type of technology. Anyway the point is that I am trying to implement a connection to a Weblogic remote queue, when I use the spring annotations, I can do it without any problem, but when I try to make this connection through the use of contexts, I have the following error:

java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[weblogic, Administrators] at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:309) at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java :555) at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:313) at weblogic.jms.frontend.FEConnectionFactoryImpl_12210_WLStub.connectionCreateRequest(Unknown Source) at weblogic.jms.client.JMSConnectionFactory.createConnection(JMSConnectionFactory.java:399 )

Actually I don't know if it's a security problem, (although that's the error that I get) because as I mentioned, I have already made this type of connection through annotations. I want to believe that the problem is in the implementation of my context file.

 <bean id="wlMessageSenderRemote"
     class="com.serviceplatform.example.jms.WLMessageSenderRemote">
    <property name="wlMessageSenderRemote">
        <ref bean="jmsTemplate" />
    </property>
  </bean>

<bean id="jmsTemplate"
    class="org.springframework.jms.core.JmsTemplate">
    <property name="connectionFactory">
        <ref bean="connectionFactoryProxy" />
    </property>
    <property name="destinationResolver">
        <ref bean="jmsDestinationResolver" />
    </property>
    <property name="receiveTimeout">
        <value>50000</value>
    </property>
  </bean>

  <!--Este es el bean donde no estoy segura de la implentación, pero igual trate eliminandolo y pasando el  bean "jndiTemplateRemote" directamente en el bean "jmsTemplate" y obtuve el mismo error-->
<bean id="connectionFactoryProxy"
    class="org.springframework.jms.connection.TransactionAwareConnectionFactoryProxy">
    <constructor-arg ref="jndiTemplateRemote" />
</bean>

<bean id="jndiTemplateRemote"
    class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="jndiName">
        <value>${example.example.wl.remote.jndi.name}</value>
    </property>
    <property name="lookupOnStartup" value="true" />
    <property name="proxyInterface"
        value="javax.jms.ConnectionFactory" />
</bean>

<bean id="jmsDestinationResolver"
    class="org.springframework.jms.support.destination.JndiDestinationResolver">
    <property name="jndiTemplate">
        <ref bean="jndiTemplate" />
    </property>
    <property name="cache">
        <value>true</value>
    </property>
</bean>

<bean id="jndiTemplate"
    class="org.springframework.jndi.JndiTemplate">
    <property name="environment">
        <props>
            <prop key="java.naming.factory.initial">${example.example.example.wl.remote.factory.initial}
            </prop>
            <prop key="java.naming.provider.url">${example.example.example.wl.remote.provider.url}
            </prop>
            <prop key="java.naming.security.principal">${example.example.example.wl.remote.credential.username}
            </prop>
            <prop key="java.naming.security.credentials">${example.example.example.wl.remote.credential.password}
            </prop>
        </props>
    </property>
</bean>

In this bean file I also have remote connections to queues of type MQ. These connections do work.

This is the class I am basing myself on to make the implementation in beans and it is the one with which I have already managed to make the connection to the remote queue:

/**
* Clase de configuracion.
*/
@EnableJms
@Configuration
public class WLMessagingConfiguration {

/**
 * bean que extrae la informacion del propertvi ies.
 */
@Autowired
CommonEnv commonEnv;

@Bean
@Scope(BeanDefinition.SCOPE_PROTOTYPE)
public JndiObjectFactoryBean connectionFactory() {
    JndiObjectFactoryBean jndiObjectFactoryBean = new JndiObjectFactoryBean();

    jndiObjectFactoryBean.setJndiTemplate(jndiTemplate());
    jndiObjectFactoryBean.setJndiName(commonEnv.getProperty(Const.WL_JNDI));
    return jndiObjectFactoryBean;
}

@Bean
@Scope(BeanDefinition.SCOPE_PROTOTYPE)
public JndiTemplate jndiTemplate() {
    JndiTemplate jndiTemplate = new JndiTemplate();
    Properties jndiProps = new Properties();

    jndiProps.setProperty(InitialContext.INITIAL_CONTEXT_FACTORY, commonEnv.getProperty(Const.WL_FACTORY));
    jndiProps.setProperty(InitialContext.PROVIDER_URL, commonEnv.getProperty(Const.WL_PROVIDER));
    jndiProps.setProperty(InitialContext.SECURITY_PRINCIPAL, commonEnv.getProperty(Const.WL_USERNAME));
    jndiProps.setProperty(InitialContext.SECURITY_CREDENTIALS, commonEnv.getProperty(Const.WL_PASSWORD));
    jndiTemplate.setEnvironment(jndiProps);
    return jndiTemplate;
}

@Bean
@Scope(BeanDefinition.SCOPE_PROTOTYPE)
public TransactionAwareConnectionFactoryProxy connectionFactoryProxy() {
    return new TransactionAwareConnectionFactoryProxy((ConnectionFactory) connectionFactory().getObject());
}


@Bean(name = "wlJmsTemplate")
@Scope(BeanDefinition.SCOPE_PROTOTYPE)
public JmsTemplate jmsTemplate() {
    JmsTemplate template = new JmsTemplate();
    template.setConnectionFactory(connectionFactoryProxy());
    JndiDestinationResolver destinationResolver = new JndiDestinationResolver();
    destinationResolver.setJndiTemplate(jndiTemplate());
    destinationResolver.setCache(true);

    template.setDestinationResolver(destinationResolver);

    template.setReceiveTimeout(50000);
    return template;
}

@Bean
@Scope(BeanDefinition.SCOPE_PROTOTYPE)
public DefaultJmsListenerContainerFactory containerFactory() {
    DefaultJmsListenerContainerFactory factory = new DefaultJmsListenerContainerFactory();
    factory.setConnectionFactory(connectionFactoryProxy());
    factory.setConcurrency(commonEnv.getProperty(Const.WL_CONCURRENCY));
    JndiDestinationResolver destinationResolver = new JndiDestinationResolver();
    destinationResolver.setJndiTemplate(jndiTemplate());
    destinationResolver.setCache(true);
    factory.setDestinationResolver(destinationResolver);
    return factory;
}

}

The truth is that I have already been investigating everywhere, and the information I find is similar to what I have, but no matter how many times I have given it, I cannot solve it. If anyone has had this kind of situation, I would appreciate it if you could help me.

First of all, Thanks.

Good morning everyone, I have the following situation: it turns out that I have to maintain a project, for this I use a new domain in Weblogic Server , in which I make different configurations of external servers MQ. It is worth mentioning that these configurations and foreign MQ servers are the same as those used in the previous version of the project that I am modifying.

I have successfully deployed my components, which listen to MQ messages, however, when I inject a message into the queueinput of any component, it is not consumed, it remains enqueued.

The funny thing is that it shows me absolutely nothing, not even an error, the messages are simply not consumed. It is important to mention that the domain in which the project was developed, everything works perfectly, but not in the new one.

We thought it was the version of Weblogic but we tried installing it, in itself it can be said that we have made a copy of the domain in which everything works fine, but this has not worked.

The truth is that we have been stranded in this situation for a long time, I would appreciate your help.

PS: If I haven't explained myself well, please let me know.

Good morning everyone!

I am currently working with Gradle, the problem is that when I want to select a project to perform any task from the Gradle Task view , it seems that it goes "crazy" since it tries to select all the projects at the same time, and finally throws me this error:

After I give it ok , the following appears:

The problem is that even if I completely restart my IDE, I still get the error. I already updated the Gradle but the problem persists.

If anyone knows how to fix it and could guide me, I would greatly appreciate it.

Thanks in advance!