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>
and this is my jsp file:
<%@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();
}
}
%>
I got the following error:
Exception thrown java.sql.SQLException: Table not found in statement [select * from quest_choices]
Any help pleeeeeeeeeeeeeeeease????
