4 Replies Latest reply on Feb 26, 2009 10:53 AM by Peter Johnson

    MySQL Datasource on JBoss

    Jotnarta Zabin Newbie

      Hi All

      Any one know how to configure a mysql datasource in JBoss??? I am using JBoss 5 and mysql 5, I tried everything, and read everything, :argh:, can anyone help me , pleassssssssse... I always get the following error

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

      following is my mysql-ds.xml file:
      <?xml version="1.0" encoding="UTF-8"?>

      and following is my client:
      <%@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();
       //out.println( "Connection: " + con. );
       Statement st = con.createStatement();
       //DatabaseMetaData md = con.getMetaData();
       out.println(" Username: " + md.getUserName());
       ResultSet rs = st.executeQuery("select * from questions");
       //ResultSet rs = md.getTables(null, null, "%", null);
       while(rs.next()) {
       out.println("<br> " + rs.getString("ID"));
       } catch (Exception e) {
       out.println("Exception thrown " + e );
       } finally {
       if (con != null) {

      Another questions is, do i have to change something in other files?? and where can i find the log for JBoss server???

      Any help please???