Home > database >  For big solution to a problem! Very strange! PLsql connection with normal=user password is correct
For big solution to a problem! Very strange! PLsql connection with normal=user password is correct

Time:10-01

The Exception in the thread "main" org. Apache. Ibatis. Exceptions. PersistenceException:
# # # Error querying the database. Cause: Java, SQL. SQLException: ORA - 01017: invalid username/password. Logon denied

# # # The error may exist in aaa/mapper/EmpMapper XML
# # # The error may involve triple-a. Dao. EmpMapper. SelectOne
# # # The error occurred while executing a query
# # # Cause: Java. SQL. SQLException: ORA - 01017: invalid username/password. Logon denied

The at org. Apache. Ibatis. Exceptions. ExceptionFactory. WrapException (ExceptionFactory. Java: 23)
The at org. Apache. Ibatis. Session. Defaults. DefaultSqlSession. SelectList (DefaultSqlSession. Java: 107)
The at org. Apache. Ibatis. Session. Defaults. DefaultSqlSession. SelectList (DefaultSqlSession. Java: 98)
The at org. Apache. Ibatis. Session. Defaults. DefaultSqlSession. SelectOne (DefaultSqlSession. Java: 62)
The at aaa. Test. TestSelect. Main (TestSelect. Java: 20)
Under Caused by: Java. SQL. SQLException: ORA - 01017: invalid username/password. Logon denied

At oracle, the JDBC driver. SQLStateMapping. NewSQLException (SQLStateMapping. Java: 70)
At oracle, the JDBC driver. DatabaseError. NewSQLException (DatabaseError. Java: 112)
At oracle, the JDBC driver. DatabaseError. ThrowSqlException (DatabaseError. Java: 173)
At oracle, the JDBC driver. T4CTTIoer. ProcessError (T4CTTIoer. Java: 455)
At oracle, the JDBC driver. T4CTTIoer. ProcessError (T4CTTIoer. Java: 406)
At oracle, the JDBC driver. T4CTTIoer. ProcessError (T4CTTIoer. Java: 399)
At oracle, the JDBC driver. T4CTTIoauthenticate. ReceiveOauth (T4CTTIoauthenticate. Java: 794)
At oracle, the JDBC driver. T4CConnection. Logon (T4CConnection. Java: 391)
At oracle, the JDBC driver. PhysicalConnection. & lt; init> (PhysicalConnection. Java: 490)
At oracle, the JDBC driver. T4CConnection. & lt; init> (T4CConnection. Java: 202)
At oracle, the JDBC driver. T4CDriverExtension. GetConnection (T4CDriverExtension. Java: 33)
At oracle, the JDBC driver. OracleDriver. Connect (OracleDriver. Java: 465)
The at Java. SQL. DriverManager. GetConnection (DriverManager. Java: 582)
The at Java. SQL. DriverManager. GetConnection (DriverManager. Java: 154)
The at org. Apache. Ibatis. The datasource. Unpooled. UnpooledDataSource. DoGetConnection (UnpooledDataSource. Java: 180)
The at org. Apache. Ibatis. The datasource. Unpooled. UnpooledDataSource. DoGetConnection (UnpooledDataSource. Java: 175)
The at org. Apache. Ibatis. The datasource. Unpooled. UnpooledDataSource. GetConnection (UnpooledDataSource. Java: 79)
The at org. Apache. Ibatis. The datasource. Pooled. PooledDataSource. PopConnection (PooledDataSource. Java: 373)
The at org. Apache. Ibatis. The datasource. Pooled. PooledDataSource. GetConnection (PooledDataSource. Java: 82)
The at org. Apache. Ibatis. Transaction. JDBC. JdbcTransaction. OpenConnection (JdbcTransaction. Java: 131)
The at org. Apache. Ibatis. Transaction. JDBC. JdbcTransaction. GetConnection (58) JdbcTransaction. Java:
The at org. Apache. Ibatis. Executor. BaseExecutor. GetConnection (BaseExecutor. Java: 271)
The at org. Apache. Ibatis. Executor. SimpleExecutor. PrepareStatement (SimpleExecutor. Java: 69)
The at org. Apache. Ibatis. Executor. SimpleExecutor. DoQuery (SimpleExecutor. Java: 56)
The at org. Apache. Ibatis. Executor. BaseExecutor. QueryFromDatabase (BaseExecutor. Java: 259)
The at org. Apache. Ibatis. Executor. BaseExecutor. Query (BaseExecutor. Java: 132)
The at org. Apache. Ibatis. Executor. CachingExecutor. Query (CachingExecutor. Java: 105)
The at org. Apache. Ibatis. Executor. CachingExecutor. Query (CachingExecutor. Java: 81)
The at org. Apache. Ibatis. Session. Defaults. DefaultSqlSession. SelectList (DefaultSqlSession. Java: 104)
. 3 more

CodePudding user response:

1, make sure the configuration file content correct
2, confirm the correct reading profile
3, after oracle11G, are case sensitive

CodePudding user response:

Cleaning project, the configuration database user name and password of the file, multiple input blank lines, to save it,
  • Related