|
| Problem | Getting SQL Message in Application Server stdout log | | | | Solution | Message from AppServer Log: [02.05.31 18:23:36:079 EDT] 4efd3d32 DBPortability W Could not create database table: "sessions" java.sql.SQLException: ORA-01031: insufficient privileges
at oracle.jdbc.dbaccess.DBError.throwSqlException (DBError.java(Compiled Code)) at oracle.jdbc.ttc7.TTIoer.processError (TTIoer.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive (Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) atoracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch (TTC7Protocol.java:822) atoracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:1446)
Cause:
Each time the Application Server starts it attempts to create the "session" table.
Senerio 1: The table already exists, so WebSphere will use the existing table. The above message can then be ignored. In this case this is not an error message, but an informational message that is logged by WebSphere.
Senerio 2: The table does not exist. The table will need to be created by using either the database admin user ID (dbadmin) or a WebSphere user with addiquate rights.
If the User (Userid in Session Manager persistence tab) is not authorized to create the table (in session database) you will receive the above error message. | |
| |
| |
|
Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Sessions and Session Management Operating system(s): Multi-Platform Software version: 3.5 Software edition: Advanced Reference #: 1053629 IBM Group: Software Group Modified date: 2003-06-16
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|