0 Replies Latest reply on Apr 16, 2003 12:56 AM by sys user

    org.jboss.pool.jdbc.xa.XAPoolDataSource was throw?

    sys user Master

      I use a simple jsp to test my DataSource in the jboss.jcml,when jboss startup,the DataSource was sucessful,but when i brower the jsp ,a org.jboss.pool.jdbc.xa.XAPoolDataSource exception was thrown.
      I use Mysql and JBoss-2.4.4_Tomcat-4.0.1
      Can you tell me?
      the code in jsp to test the DateSource:
      <%
      Context content = new javax.naming.InitialContext();
      javax.sql.DataSource ds = (DataSource)content.lookup("java:/TestMysql");
      Connection conn = ds.getConnection();
      Statement stmt = conn.createStatement();
      String sql = "select count(*) from emailbox";
      ResultSet rs = stmt.executeQuery(sql);
      try{
      while(rs.next()){ %>
      <%= rs.getString(1) %>
      <%}
      }catch(Exception e){System.out.println(e);}
      %>