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);}
%>
