Exception thrown java.sql.SQLException: Table not found in statement [select * from questions]
Are you sure that there exists a table by name "questions"?
and where can i find the log for JBoss server???
Why don't you check the faq's ???
check at $JBOSS_HOME/server//log/ location for the server log.
Thank you buddy, am sure that table questions do exist in my schema.... :(, but why the program don't see it ??????????????
Ok, configure the sql client with the same details as you have in -ds.xml file and see if you can execute the same query through it, you can use squirrel as client.
Another thing which you can try is to have a simple jdbc program and check if the same statement works Or not.
What errors do you see in the server.log?
Wow, deja-vu all over again.
What operating system are you using? On some OSes MySQL is case sensitive.
If you are still havingproblems, do this: run 'mysql' from a command line, logging in with user name and password from the *-ds.xml file, then enter 'use project', and then enter "show tables'. Post the entire interaction, starting with the 'mysql' command line and ending with the response from 'show tables'.