I am using JBoss2.4.4 and wrote a simply BMP to see how it goes. I tried using MySQL and MS-Access. Both have the same problem when the bean doing the SELECT, it throws Exception says TABLE NOT FOUND....

I also try the same code on my friend's machine(but he's running postgreSQL), BMP works, no problem occured.

So, I wrote a simple testing java program on my machine which just using jdbc to query the same databases(both MySQL and Access, things went well, I got the data back from database.