ravi beli

Melody Siu wrote:Hi all,
Got the following error when trying to create connection to a queue
factory, the link exceptin is also included below. The code is working
fine for me but not on another machine where the setup is the same.
Is there something that is bothing mq in wsad....we are using embedded
messaging in wsad 5.1.1.....
Thanks for any input...
../Melody
3/26/04 9:11:00:604 MST] 77317731 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource THEQUEUEFACTORY, throwing ResourceAllocationException. Original exception: javax.resource.spi.ResourceAdapterInternalException: createQueueConnection failed
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at javax.resource.ResourceException.<init>(ResourceException.java:73)
at com.ibm.ejs.jms.JMSCMUtils.mapToResourceException(JMSCMUtils.java:125)
at com.ibm.ejs.jms.JMSManagedQueueConnection.createConnection(JMSManagedQueueConnection.java:174)
at com.ibm.ejs.jms.JMSManagedConnection.<init>(JMSManagedConnection.java:166)
at com.ibm.ejs.jms.JMSManagedQueueConnection.<init>(JMSManagedQueueConnection.java:64)
at com.ibm.ejs.jms.WSJMSManagedQueueConnectionFactory.createManagedConnection(WSJMSManagedQueueConnectionFactory.java:84)
at com.ibm.ejs.jms.JMSManagedConnectionFactory.createManagedConnection(JMSManagedConnectionFactory.java:477)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1280)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1064)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1571)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:622)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:424)
at com.ibm.ejs.jms.JMSQueueConnectionFactoryHandle.createQueueConnection(JMSQueueConnectionFactoryHandle.java:80)
-----------------------
Next Linked Exception:
com.ibm.mq.MQException: MQJE001: An MQException occurred: Completion Code 2, Reason 2009
MQJE007: IO error reading message data
at java.lang.Throwable.<init>(Throwable.java)
at com.ibm.mq.MQException.<init>(MQException.java:859)
at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:239)
at com.ibm.mq.MQClientManagedConnectionFactoryJ11._createManagedConnection(MQClientManagedConnectionFactoryJ11.java:276)
at com.ibm.mq.MQClientManagedConnectionFactoryJ11.createManagedConnection(MQClientManagedConnectionFactoryJ11.java:296)
at com.ibm.mq.StoredManagedConnection.<init>(StoredManagedConnection.java:80)
at com.ibm.mq.MQSimpleConnectionManager.allocateConnection(MQSimpleConnectionManager.java:171)
at com.ibm.mq.MQQueueManager.obtainBaseMQQueueManager(MQQueueManager.java:737)
at com.ibm.mq.MQQueueManager.construct(MQQueueManager.java:671)
at com.ibm.mq.MQQueueManager.<init>(MQQueueManager.java:452)
at com.ibm.mq.MQSPIQueueManager.<init>(MQSPIQueueManager.java:52)
at com.ibm.mq.jms.MQConnection.createQM(MQConnection.java:1659)
at com.ibm.mq.jms.MQConnection.createQMXA(MQConnection.java:1077)
at com.ibm.mq.jms.MQQueueConnection.<init>(MQQueueConnection.java:123)
at com.ibm.mq.jms.MQXAQueueConnection.<init>(MQXAQueueConnection.java:56)
at com.ibm.mq.jms.MQXAQueueConnectionFactory.createXAQueueConnection(MQXAQueueConnectionFactory.java:122)
at com.ibm.ejs.jms.JMSManagedQueueConnection.createConnection(JMSManagedQueueConnection.java:157)
at com.ibm.ejs.jms.JMSManagedConnection.<init>(JMSManagedConnection.java:166)
at com.ibm.ejs.jms.JMSManagedQueueConnection.<init>(JMSManagedQueueConnection.java:64)
at com.ibm.ejs.jms.WSJMSManagedQueueConnectionFactory.createManagedConnection(WSJMSManagedQueueConnectionFactory.java:84)
at com.ibm.ejs.jms.JMSManagedConnectionFactory.createManagedConnection(JMSManagedConnectionFactory.java:477)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1280)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1064)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1571)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:622)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:424)
at com.ibm.ejs.jms.JMSQueueConnectionFactoryHandle.createQueueConnection(JMSQueueConnectionFactoryHandle.java:80)

Hi Rachers,

I am also having similar issue, Unable to create queue connection, getting following error if anybody has solution to fix this issue or any clue would help me.

Any authentication issue to access...I am ?

[9/22/11 1:24:26:042 CDT] 00000017 VirtualHost I SRVE0250I: Web Module <null> has been bound to default_host[*:9080,*:80,*:*,*:9443,*:5060,*:5061,*:443].
[9/22/11 1:24:26:148 CDT] 00000017 MDBListenerIm W WMSG0019E: Unable to start MDB Listener AsyncInternalMessageBean, JMSDestination jms/PeleCoreIntQueue : javax.jms.JMSException: Failed to create queue connection
at com.ibm.ejs.jms.JMSCMUtils.mapToJMSException(JMSCMUtils.java:141)
at com.ibm.ejs.jms.JMSQueueConnectionFactoryHandle.createQueueConnection(JMSQueueConnectionFactoryHandle.java:90)
at com.ibm.ejs.jms.listener.MDBListenerImpl.createResources(MDBListenerImpl.java:419)
at com.ibm.ejs.jms.listener.MDBListenerImpl.internalStart(MDBListenerImpl.java:734)
at com.ibm.ejs.jms.listener.MDBListenerImpl.start(MDBListenerImpl.java:657)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.start(MDBListenerManagerImpl.java:699)
at com.ibm.ejs.jms.listener.MsgListenerPort.add(MsgListenerPort.java:227)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.startApplicationMDBs(MDBListenerManagerImpl.java:941)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.stateChanged(MDBListenerManagerImpl.java:899)
at com.ibm.ws.runtime.component.MessageListenerImpl.stateChanged(MessageListenerImpl.java:188)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.stateChanged(ApplicationMgrImpl.java:1226)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectEvent(DeployedApplicationImpl.java:1120)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.setState(DeployedApplicationImpl.java:234)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.setState(DeployedApplicationImpl.java:229)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:828)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:945)
at com.ibm.ws.runtime.component.ApplicationMgrImpl$AppInitializer.run(ApplicationMgrImpl.java:2120)
at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:342)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1551)
---- Begin backtrace for Nested Throwables
javax.resource.spi.ResourceAllocationException: Expected QueueConnectionFactory
at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2314)
at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1664)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2368)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:937)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:611)
at com.ibm.ejs.jms.JMSQueueConnectionFactoryHandle.createQueueConnection(JMSQueueConnectionFactoryHandle.java:84)
at com.ibm.ejs.jms.listener.MDBListenerImpl.createResources(MDBListenerImpl.java:419)
at com.ibm.ejs.jms.listener.MDBListenerImpl.internalStart(MDBListenerImpl.java:734)
at com.ibm.ejs.jms.listener.MDBListenerImpl.start(MDBListenerImpl.java:657)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.start(MDBListenerManagerImpl.java:699)
at com.ibm.ejs.jms.listener.MsgListenerPort.add(MsgListenerPort.java:227)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.startApplicationMDBs(MDBListenerManagerImpl.java:941)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.stateChanged(MDBListenerManagerImpl.java:899)
at com.ibm.ws.runtime.component.MessageListenerImpl.stateChanged(MessageListenerImpl.java:188)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.stateChanged(ApplicationMgrImpl.java:1226)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectEvent(DeployedApplicationImpl.java:1120)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.setState(DeployedApplicationImpl.java:234)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.setState(DeployedApplicationImpl.java:229)
at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:828)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:945)
at com.ibm.ws.runtime.component.ApplicationMgrImpl$AppInitializer.run(ApplicationMgrImpl.java:2120)
at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:342)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1551)
Caused by: java.lang.ClassCastException: com.tibco.tibjms.TibjmsConnectionFactory incompatible with javax.jms.QueueConnectionFactory
at com.ibm.ejs.jms.JMSManagedQueueConnection.createConnection(JMSManagedQueueConnection.java:128)
at com.ibm.ejs.jms.JMSManagedConnection.<init>(JMSManagedConnection.java:333)
at com.ibm.ejs.jms.JMSManagedQueueConnection.<init>(JMSManagedQueueConnection.java:71)
at com.ibm.ejs.jms.GenericJMSManagedQueueConnectionFactory.createManagedConnection(GenericJMSManagedQueueConnectionFactory.java:91)
at com.ibm.ejs.jms.JMSManagedConnectionFactory.createManagedConnection(JMSManagedConnectionFactory.java:635)
at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1992)
... 22 more

[9/22/11 1:24:26:157 CDT] 00000017 MDBListenerIm I WMSG0058I: Listener Port PeleCoreIntJMSPort will attempt to restart in 60 seconds
[9/22/11 1:24:26:158 CDT] 00000017 MsgListenerPo W WMSG0049E: Failed to start MDB AsyncInternalMessageBean against listener port PeleCoreIntJMSPort
[9/22/11 1:24:26:179 CDT] 00000017 MDBListenerIm W WMSG0019E: Unable to start MDB Listener WorkflowMDB, JMSDestination jms/PeleCoreQueue : javax.jms.JMSException: Failed to create queue connection
at com.ibm.ejs.jms.JMSCMUtils.mapToJMSException(JMSCMUtils.java:141)
at com.ibm.ejs.jms.JMSQueueConnectionFactoryHandle.createQueueConnection(JMSQueueConnectionFactoryHandle.java:90)
at com.ibm.ejs.jms.listener.MDBListenerImpl.createResources(MDBListenerImpl.java:419)
at com.ibm.ejs.jms.listener.MDBListenerImpl.internalStart(MDBListenerImpl.java:734)
at com.ibm.ejs.jms.listener.MDBListenerImpl.start(MDBListenerImpl.java:657)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.start(MDBListenerManagerImpl.java:699)
at com.ibm.ejs.jms.listener.MsgListenerPort.add(MsgListenerPort.java:227)
at com.ibm.ejs.jms.listener.MDBListenerManagerImpl.startApplicationMDBs(MDBListenerManagerImpl.java:941)
[/qoute]

Ravi Beli - Ajax Application Demo with source code

Ajax Search suggestion/Auto completion - Source code with steps.

Create web aplication - "AjaxSearchApp" - Search suggestion (Auto completion) using Ajax

step-1: Create Search.html in - AjaxSearchApp\html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>AJAX Search</title> <style type="text/css"> .normal { background-color: #FFFFFF; padding: 2px 6px 2px 6px; } .over { background-color: #3366CC; padding: 2px 6px 2px 6px; } div#result { display: none; border:1px solid #000000; } </style> <script language="javascript"> var xmlHttp; function searchText() { var search = document.getElementById("search").value; var url = "../RaviBeliSearchServlet?search=" + search; //alert("url: "+url); if(window.XMLHttpRequest){ xmlHttp = new XMLHttpRequest(); } else if(window.ActiveXObject){ xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlHttp.open("Get",url,true); xmlHttp.onreadystatechange = callback; xmlHttp.send(null); } function callback() { //alert('I am in callback - xmlHttp.readyState: '+xmlHttp.readyState+" xmlHttp.status: "+xmlHttp.status); if( xmlHttp.readyState==4 ){ if( xmlHttp.status==200 ) { var result = document.getElementById('result'); result.innerHTML = ''; var respText = xmlHttp.responseText; if((respText.length)!=0){ show_div('result'); show_div('close'); var str = xmlHttp.responseText.split("\n"); var items; for(i=0; i < str.length - 1; i++) { items = '<div onmouseover="javascript:overText(this);" '; items += 'onmouseout="javascript:outText(this);" '; items += 'onclick="javascript:setText(this.innerHTML);" '; items += 'class="normal">' + str[i] + '></div>'; result.innerHTML += items; } } else { hide_divs(); } } } } function focusIn(){ document.getElementById("search").focus( ); } function overText(div_value) { div_value.className = 'over'; } function outText(div_value) { div_value.className = 'normal'; } function setText(value) { document.getElementById('search').value = value; hide_divs(); document.getElementById('result').innerHTML = ''; } function show_div(div_id) { document.getElementById(div_id).style.display = 'block'; } function hide_divs() { document.getElementById('result').style.display = 'none'; document.getElementById('close').style.display = 'none'; } </script> </head> <body onload="focusIn();"> <h2>Ajax Search Example</h2> <form> <b>Enter Search Keyword</b> <table border = "0"> <tr> <td><input type="text" id="search" name="search" onkeyup="searchText()" autocomplete="off" /></td> </tr> <tr> <td><div id="result"></div></td> </tr> <tr> <td><div id="close" align="right" style="display: none;"><a rel="nofollow">close</a></div></td> </tr> </table> </form> </body> </html>

step-2: Create servelet - RaviBeliSearchServlet.java in AjaxSearchAp\WEB-INF\src


import javax.servlet.*; import javax.servlet.http.*; import java.io.IOException; import java.sql.*; public class RaviBeliSearchServlet extends HttpServlet { public void doGet( HttpServletRequest request, HttpServletResponse response ) throws ServletException, IOException { String search = request.getParameter("search"); System.out.println("---------------- search key: "+search+" ----------------"); response.setContentType("text/html"); response.setHeader("Cache-Control", "no-cache"); if(!((search.trim()).equals(""))){ String searchString = getSearchResult(search); System.out.println(searchString); response.getWriter().write(searchString); } else{ System.out.println("Length of string"+("".length())); response.getWriter().write(""); } } public String getSearchResult(String search) { Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String db = "ajax"; String driver = "com.mysql.jdbc.Driver"; String user = "root"; String pass = "root"; String finalSearch=""; try{ Class.forName(driver).newInstance(); con = DriverManager.getConnection(url+db, user, pass); // System.out.println("@@@@@@@@@@@ Connection object: "+con); try{ Statement st = con.createStatement(); ResultSet res = st.executeQuery("SELECT distinct(keyword_name) FROM keywords WHERE keyword_name like('%"+search+"%') ORDER BY keyword_name"); while (res.next()) { String un = res.getString("keyword_name"); finalSearch+= un+"\n"; } //System.out.println("---------------- while loop ends ----------------"); con.close(); } catch (SQLException s){ System.out.println("SQL code does not execute : "+s.getMessage()); } } catch (Exception e){ e.printStackTrace(); } return finalSearch; } }


step-3: web.xml entries - AjaxSearchAp\WEB-INF\web.xml
<?xml version="1.0" encoding="ISO-8859-1"?> <web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4"> <servlet> <servlet-name>RaviBeliSearchServlet</servlet-name> <servlet-class>RaviBeliSearchServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>RaviBeliSearchServlet</servlet-name> <url-pattern>/RaviBeliSearchServlet</url-pattern> </servlet-mapping> </web-app>

step-4: Create table and insert some sample data in MySQL database - DDL statement for creating table in MySQL
Login into MySQL database with user name and password //create database CREATE database ajax; //connect to "ajax" database USE ajax; //create table CREATE TABLE KEYWORDS (keyword_name varchar(20)); //insert sample records INSERT INTO KEYWORDS values('ravi') INSERT INTO KEYWORDS values('rajesh') INSERT INTO KEYWORDS values('vinod') INSERT INTO KEYWORDS values('revanth') INSERT INTO KEYWORDS values('kiran') INSERT INTO KEYWORDS values('raviraj') INSERT INTO KEYWORDS values('sangeeta') INSERT INTO KEYWORDS values('laxmi') commit; //select query to verify inserted data SELECT * FROM KEYWORDS; //SELECT distinct(keyword_name) FROM keywords WHERE keyword_name like '%ravi%' ORDER BY keyword_name;