Please search for "socket creation error" including all terms. This question has been already answered several times.
...Alright, here it goes: you're looking in the right place. In hsqldb-ds.xml, near the start, comment the section that reads "for in-process persistent db" and uncomment "for tco connection". Also, near the end, comment the section "this mbean can be used when using in-process persistent db" and uncomment "this mbean should be used only when using tcp connection".
Please note that this opens a security hole so you shouldn't deploy such a data source in production. In addition, you shouldn't need to do this if you are accessing the database from within JBoss.
thank you very match for your reply
i will do it
I met the same problem as "java.sql.SQLException: socket creation error ". I also modified the hsqldb-ds.xml as what you indicated. But the error still exists. Any suggestions? Thanks!