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]
Please do not cross-post: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=150529