使用Derby數(shù)據(jù)庫進(jìn)行JUnit測試時(shí), 報(bào)出了org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLNonTransientConnectionException: 用戶 ID 長度 (0) 超出 1 到 255 的范圍。錯(cuò)誤, 詳細(xì)的Failure Trace如下:

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLNonTransientConnectionException: 用戶 ID 長度 (0) 超出 1 到 255 的范圍。

at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:242)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)

at org.springframework.test.AbstractTransactionalSpringContextTests.startNewTransaction(AbstractTransactionalSpringContextTests.java:349)

at org.springframework.test.AbstractTransactionalSpringContextTests.onSetUp(AbstractTransactionalSpringContextTests.java:201)

at org.springframework.test.AbstractSingleSpringContextTests.setUp(AbstractSingleSpringContextTests.java:104)

at junit.framework.TestCase.runBare(TestCase.java:128)

at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:79)

at junit.framework.TestResult$1.protect(TestResult.java:106)

at junit.framework.TestResult.runProtected(TestResult.java:124)

at junit.framework.TestResult.run(TestResult.java:109)

at junit.framework.TestCase.run(TestCase.java:120)

at junit.framework.TestSuite.runTest(TestSuite.java:230)

at junit.framework.TestSuite.run(TestSuite.java:225)

at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)

at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Caused by: java.sql.SQLNonTransientConnectionException: 用戶 ID 長度 (0) 超出 1 到 255 的范圍。

at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)

at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)

at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:153)

at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:144)

at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:155)

at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:120)

at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:204)

... 18 more

Caused by: org.apache.derby.client.am.SqlException: 用戶 ID 長度 (0) 超出 1 到 255 的范圍。

at org.apache.derby.client.net.NetConnection.checkUserLength(Unknown Source)

at org.apache.derby.client.net.NetConnection.checkUser(Unknown Source)

at org.apache.derby.client.net.NetConnection.checkUserPassword(Unknown Source)

at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)

at org.apache.derby.client.net.NetConnection.(Unknown Source)

at org.apache.derby.client.net.NetConnection40.(Unknown Source)

at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)

... 26 more在經(jīng)過仔細(xì)的檢查后, 發(fā)現(xiàn)原來是配置文件中沒有給這個(gè)數(shù)據(jù)庫指定用戶名和密碼(用戶名和密碼為空), 結(jié)果導(dǎo)致了這個(gè)錯(cuò)誤.

beans.xml文件, 設(shè)置username和password的value后, 重新測試, 錯(cuò)誤消失.

總結(jié)

以上是生活随笔為你收集整理的java 拼sql最大长度,java.sql.SQLNonTransientConnectionException: 用户 ID 长度 (0) 超出 1 到 255 的范围...的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。