Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

daust / JasperReportsIntegration

JasperReportsIntegration provides an interface to use the JasperReports reporting engine in an Oracle database application, specifically with Oracle Application Express (Oracle APEX).

Could not connect via JDBC: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-28000: The account is locked. #26

himansu1491 ·
#1

When i am running test report i am getting below error.
Please guide me how to resolve this.

Could not connect via JDBC: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-28000: The account is locked.Capture.PNG

  • replies 1
  • views 2.3K
  • likes 0
Dietmar Aust daust · Team
#2

Hi,

I don't quite understand. The error message says the account is locked. You need do unlock it.
Connect as a dba user (SYS, SYSTEM, etc.) and issue:

alter user <username> account unlock;

Then restart the Tomcat so that the connection pool is rebuilt.

Or do you have another more complex issue?

Thanks