Q: Org. springframework. transaction. cannotcreatetransactionexception: cocould not open JDBC connection for transaction; Nested exception is Java. SQL. sqlexception: Socket creation error <br/> at Org. springframework. JDBC. datasource. datasourcetransactionmanager. dobegin (datasourcetransactionmanager. java: 238) <br/> at Org. springframework. transaction. support. abstractplatformtransactionmanager. gettransaction (abstractplatformtransactionmanager. java: 374) <br/> at Org. springframework. test. abstracttransactionalspringcontexttests. startnewtransaction (abstracttransactionalspringcontexttests. java: 387) <br/> at Org. springframework. test. abstracttransactionalspringcontexttests. onsetup (abstracttransactionalspringcontexttests. java: 217) <br/> at Org. springframework. test. abstractsinglespringcontexttests. setup (abstractsinglespringcontexttests. java: 101) <br/> at JUnit. framework. testcase. runbare (testcase. java: 128) <br/> at Org. springframework. test. conditionaltestcase. runbare (conditionaltestcase. java: 76) <br/> at JUnit. framework. testresult $1. protect (testresult. java: 106) <br/> at JUnit. framework. testresult. runprotected (testresult. java: 124) <br/> at JUnit. framework. testresult. run (testresult. java: 109) <br/> at JUnit. framework. testcase. run (testcase. java: 120) <br/> at JUnit. framework. testsuite. runtest (testsuite. java: 230) <br/> at JUnit. framework. testsuite. run (testsuite. java: 225) <br/> at Org. eclipse. jdt. internal. JUnit. runner. junit3.junit3testreference. run (junit3testreference. java: 130) <br/> at Org. eclipse. jdt. internal. JUnit. runner. testexecution. run (testexecution. java: 38) <br/> at Org. eclipse. jdt. internal. JUnit. runner. remotetestrunner. runtests (remotetestrunner. java: 467) <br/> at Org. eclipse. jdt. internal. JUnit. runner. remotetestrunner. runtests (remotetestrunner. java: 683) <br/> at Org. eclipse. jdt. internal. JUnit. runner. remotetestrunner. run (remotetestrunner. java: 390) <br/> at Org. eclipse. jdt. internal. JUnit. runner. remotetestrunner. main (remotetestrunner. (Java: 197) <br/> caused by: Java. SQL. sqlexception: Socket creation error <br/> at Org. HSQLDB. JDBC. util. sqlexception (unknown source) <br/> at Org. HSQLDB. JDBC. jdbcconnection. <init> (unknown source) <br/> at Org. HSQLDB. jdbcdriver. getconnection (unknown source) <br/> at Org. HSQLDB. jdbcdriver. connect (unknown source) <br/> at java. SQL. drivermanager. getconnection (drivermanager. java: 582) <br/> at java. SQL. drivermanager. getconnection (drivermanager. java: 154) <br/> at Org. springframework. JDBC. datasource. drivermanagerdatasource. getconnectionfromdrivermanager (drivermanagerdatasource. java: 174) <br/> at Org. springframework. JDBC. datasource. drivermanagerdatasource. getconnectionfromdriver (drivermanagerdatasource. java: 165) <br/> at Org. springframework. JDBC. datasource. abstractdriverbaseddatasource. getconnectionfromdriver (abstractdriverbaseddatasource. java: 149) <br/> at Org. springframework. JDBC. datasource. abstractdriverbaseddatasource. getconnection (abstractdriverbaseddatasource. java: 119) <br/> at Org. springframework. JDBC. datasource. datasourcetransactionmanager. dobegin (datasourcetransactionmanager. java: 200) <br/>... 18 more
A: most of them are because the database is not opened!
If HSQLDB is used, first open the HSQLDB server, such as server. bat.
Appendix server. Bat content:
Java-classpath.../webcontent/WEB-INF/lib/HSQLDB. Jar org. HSQLDB. Server-database Test