|
| Hello,<br />
<p />
I have a doubt and need help.<br />
My environment here has one WebSphere Application Server Netwotk Deployment and two federated node. I´ve created one cluster with one aplication server of each node to configure session persistence in Oracle 10g database.<br />
The DBA here created the database, user and password. I´ve configured the websphere to store session persistence data in database created fo him, look below.<br />
<br />
Server -> webcontainer -> session manager -> distributed environment ....<br />
<br />
I wrote the information in the specific fields: Datasource JNDI Name, UserId and Password .. and created the datasource in other option before configure it.<br />
<br />
My doubt is: what are the necessary grants to WebSphere work correctly in this environment ? <br />
<br />
There is a other field called <b>Table Space Name</b> and i think it´s the name of table wich Websphere will created or it have to be exist before start the JVM ?<br />
<br />
I have the following error after configure that environment<br />
<p />
<strike>26/11/07 09:44:51:420 BRST</strike> 6ebc503f SessionContex E SESN0016E: DatabaseSessionContext:performInvalidati
on detectou um erro. A invalidação do banco de dados de sessões com o tempo limite expirado encontrou um erro. Se ocorreu um SQLExce
ption, consulte a documentação do banco de dados apropriada para seu ambiente. Além disso, assegure-se de que tenha sido feita a configuração apropriada da origem de dados do Gerenciador de Sessão.<br />
<strike>26/11/07 09:44:51:420 BRST</strike> 6ebc503f SessionContex E A exceção é: java.sql.SQLException: ORA-00942: table or view does not exist<br />
<br />
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)<br />
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:672)<br />
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:598)<br />
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)<br />
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)<br />
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)<br />
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)<br />
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:447)<br />
at com.ibm.ws.webcontainer.httpsession.BackedHashtable.performInvalidation(BackedHashtable.java:3153)<br />
at com.ibm.ws.webcontainer.httpsession.DatabaseSessionContext. performInvalidation(DatabaseSessionConte
xt.java:380)<br />
at com.ibm.ws.webcontainer.httpsession.SessionContext.pollInvalidations(SessionContext.java:1023)<br />
at com.ibm.ws.webcontainer.httpsession.SessionAlarmListener.alarm(SessionAlarmListener.java:48)<br />
at com.ibm.ejs.util.am._Alarm.run(_Alarm.java(Compiled Code))<br />
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:937)<br />
<p />
Kind Regards
|
|