Hi All
I posted my problem in all Java and J2EE forums, I hope I can find a solution here. I am trying to test DataSource in JBoss; so, I defined the mysql-ds.xml file:

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

 <local-tx-datasource>

 <jndi-name>DefaultDS</jndi-name>

 <connection-url>jdbc:mysql://localhost:3306/project</connection-url>

 <driver-class>com.mysql.jdbc.Driver</driver-class>

 <user-name>root</user-name>

 <password>admin</password>

 <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>

 <metadata>

 <type-mapping>mySQL</type-mapping>

 </metadata>

 </local-tx-datasource>

</datasources>

<%@page import="java.util.*,javax.naming.*,javax.sql.DataSource,java.sql.*"%>
<%
 DataSource ds = null;
 Connection con = null;
 //Statement st = null;
 InitialContext ic;

 try {
 ic = new InitialContext();
 ds = (DataSource) ic.lookup("java:/DefaultDS");
 con = ds.getConnection();
 Statement st = con.createStatement();
 ResultSet rs = st.executeQuery("select * from quest_choices;");

 while(rs.next()) {
 out.println("<br> " + rs.getString("ID"));
 }
 rs.close();
 st.close();

 out.println("DONE");
 } catch (Exception e) {
 out.println("Exception thrown " + e );
 //e.printStackTrace();
 } finally {
 if (con != null) {
 con.close();
 }
 }
%>

Exception thrown java.sql.SQLException: Table not found in statement [select * from quest_choices]