WebSphere -Could not create database table

Technote (FAQ)
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.











Document Information

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