Originally posted by Carlos Andres Holguin Arboleda:
Hi, Jeanne. My onMessage() invoke the next method:
public void insert( InfoOperacion operacion) throws AuditoriaException
{
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
String sql="INSERT INTO COMPONENTE_AUDITORIA ( COMPONENTE_AUDITORIA_ID_OP"+
",COMPONENTE_AUDITORIA_USUARIO,COMPONENTE_AUDITORIA_US_BD"+
",COMPONENTE_AUDITORIA_F_HORA,COMPONENTE_AUDITORIA_ACCION"+
",COMPONENTE_AUDITORIA_OBJETO," +
"COMPONENTE_AUDITORIA_ANTES,COMPONENTE_AUDITORIA_DESPUES" +
",COMPONENTE_AUDITORIA_OID, COMPONENTE_AUDITORIA_IP) " +
"values (?,?,?,?,?,?,?,?,?,?)";
try
{
connection = DBLocator.getConnection ();
//Buscar ultimo id
statement = connection.prepareStatement("SELECT MAX(COMPONENTE_AUDITORIA_ID_OP) FROM COMPONENTE_AUDITORIA");
rs = statement.executeQuery();
if(rs.next()) {
operacion.setIdOperacion(rs.getInt(1)+1);
} else {
operacion.setIdOperacion(1);
}
rs.close();
statement.close();
statement = connection.prepareStatement ( sql );
statement.setInt(1, operacion.getIdOperacion());
statement.setString(2,operacion.getUsuario());
statement.setString(3,operacion.getUsuarioBD());
statement.setString(4,operacion.getFechaHora());
statement.setString(5,operacion.getAccion());
statement.setString(6,operacion.getObjeto());
statement.setString(7,operacion.getAntes().toString());
statement.setString(8,operacion.getDespues().toString());
statement.setString(9,operacion.getOid());
statement.setString(10,operacion.getIp());
statement.executeUpdate ( );
}
catch(Exception e)
{
throw new AuditoriaException(e.getMessage(),e);
}
finally
{
DBLocator.closeDBObject(rs);
DBLocator.closeDBObject(statement);
DBLocator.closeDBObject(connection);
}
}
Do you have any suggestion for this problem??, thanks
[ September 21, 2008: Message edited by: Carlos Andres Holguin Arboleda ]
[ September 21, 2008: Message edited by: Carlos Andres Holguin Arboleda ]
Originally posted by Vishal Vohra:
Hello,
I am new to MQ and want to know how to setup the MQ environment.
I have WebSphere installed on my system with "MQ Messaging Provider" that comes with default with WebSphere.
I have found some PDF's from IBM explaining how to code using MQ Base JAVA and MQ JMS java classes, but I am finding it difficult to set up the MQ environment like the Queue Manager, Connection Factory, Queue itself and the destination.
I also came to know that this environment setting can be done with the help of JMSAdmin tool, but where I can find this tool.
On my system I have RAD installed with a plugin support for WebSphere, I mean the WebSphere has not been installed seperately, it is being used from the RAD and therefore I am not able to find JMSAdmin tool.
Please let me know how to set up Queue managers, connection factory, queue and the destination and once configured how can I administer them from WebSphere Administration console.
Originally posted by Mujeebur Rahman:
Check your code weather login.jsp uses <jsp:useBean>
The problem seems with the lower case. Let me know the result.
Originally posted by Lee Sha:<br /> Hi,<br /> I am trying to migrate my application from WSAD5.1 to RAD7. In RAD7, it is throwing the below exception when I try to access a jsp page which uses "usebean":<br /> <br /> Servlet Error]-[/logon/logon.jsp]: com.ibm.ws.jsp.translator.JspTranslationException: JSPG0227E: Exception caught while translating /logon/logon.jsp: <br /> /logon/logon.jsp(11,1) --> JSPG0145E: Unknown JSP element : jsp:usebean
at com.ibm.ws.jsp.translator.visitor.JspVisitor.processJspElement(JspVisitor.java:263)
at com.ibm.ws.jsp.translator.visitor.JspVisitor.processChildren(JspVisitor.java:309)
at com.ibm.ws.jsp.translator.visitor.JspVisitor.processJspElement(JspVisitor.java:139)
at com.ibm.ws.jsp.translator.visitor.JspVisitor.visit(JspVisitor.java:121)
at com.ibm.ws.jsp.translator.JspTranslator.processVisitors(JspTranslator.java:121)
at com.ibm.ws.jsp.translator.utils.JspTranslatorUtil.translateJsp(JspTranslatorUtil.java:181)
at com.ibm.ws.jsp.translator.utils.JspTranslatorUtil.translateJspAndCompile(JspTranslatorUtil.java:83)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp(AbstractJSPExtensionServletWrapper.java:349)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper._checkForTranslation(AbstractJSPExtensionServletWrapper.java:317)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.checkForTranslation(AbstractJSPExtensionServletWrapper.java:226)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:131)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:270)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:308)
at com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:472)
at com.ibm.ws.wswebcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:111)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
Does anyone know what may be the reason for this?
[ August 21, 2008: Message edited by: Lee Sha ]