-
1. Re: MySQL Datasource on JBoss
vickyk Feb 26, 2009 8:01 AM (in response to jotnarta)"jotnarta" wrote:
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. -
2. Re: MySQL Datasource on JBoss
jotnarta Feb 26, 2009 8:03 AM (in response to jotnarta)Thank you buddy, am sure that table questions do exist in my schema.... :(, but why the program don't see it ??????????????
-
3. Re: MySQL Datasource on JBoss
vickyk Feb 26, 2009 8:11 AM (in response to jotnarta)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? -
4. Re: MySQL Datasource on JBoss
peterj Feb 26, 2009 10:53 AM (in response to jotnarta)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'.