sorry, forgot to mention the development enviroment:
windowXP professional, Jboss3.2.4RC1, mysql4.1.1, the password hashing of mysql has been set to 16bytes for compatibility.
Post a the result of
jar -tf yourmysqldriver.jar
and its location.
You are not using JCA, you might find more help in the HTTP forums.
thanks a lot, my problem is solved. i'm just entering the wrong URL for the DB. should be
but i am still wondering why didn't i get error when i use MSAccess? i mean without telling the host and port number specifically.