caArray Installation

Date entered: 2/25/2009

Release Up To: caArray 2.X

Question: Invalid Login or No Application found Error When Login UPT

I created a new UPT user and UPT application (caArray) in UPT using the configuration from the caArray install guide. However, when logging in as the new user and specifying caArray as the application, I encounter the following error:

"No Application found for the Context Name. Invalid database login credentials in the application hibernate configuration file.
I know my database login credentials are correct because they are the same for all the LSD install."

Topic:

Release:

Date entered:

Question

Answer

Have a comment?

Please leave your comment in the caArray End User Forum.

Answer:

Followings are the common scenarios associated with login errors:
1: User was not created in the right schema.
If a caArray user is created properly, the user will be found in caArray's CSM_User table. To avoid any confusion, it is recommended to use different names for database/schema owner and application admin/user. For detail, see How to Create caArray User with UPT?
2: Application Name created with UPT is case sensitive. For example, caaaray != caArray
3: UPT does not support environment variable substitution string (${}) for application configuration. Only literals are accepted. see details (http://wiki.c2b2.columbia.edu/icrkc/index.php/Caarray000009#Create_caArray_Application_with_UPT').

Incorrect: Application Database Driver: ${com.mysql.jdbc.Driver}
Correct: Application Database Driver: com.mysql.jdbc.Driver