Hello,
I'm using Websphere 4.0.7, Oracle 8.1.7.4 on Solaris 8 with OJB 1.0.
When I use a direct connexion defined in the repository_database.xml file,
it works OK in our development server (with Websphere and Oracle installed
on the same server):
****************************************************
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="Oracle"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle:thin"
dbalias="@172.18.226.4:1521:WSPAVT2"
username="user "
password="*******"
batch-mode="false"
useAutoCommit="0"
>
<connection-pool
maxActive="25"
whenExhaustedAction="0"
/>
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl"/>
</jdbc-connection-descriptor>
****************************************************
But in production we have some troubles because the Websphere Server
connects the Oracle server through a firewall. This firewall is configured
to end inactive connection. So, the application can't connect to the
database at the end of the day! We need to retstart the application every
day! Here is the error:
****************************************************
[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR:
[2/5/04 19:07:08:758 CET] c7f06 SystemOut U Io exception: Connection
reset by peer: Connection reset by peer
[2/5/04 19:07:08:787 CET] c7f06 SystemOut U
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
[2/5/04 19:07:08:788 CET] c7f06 SystemOut U
PersistenceBrokerException
during the execution of the query: Io exception: Connection reset by peer:
Connection reset by peer
[2/5/04 19:07:08:788 CET] c7f06 SystemOut U Io exception: Connection
reset by peer: Connection reset by peer
[2/5/04 19:07:08:795 CET] c7f06 SystemOut U
[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO:
[2/5/04 19:07:08:795 CET] c7f06 SystemOut U Rollback was called, do
rollback on current connection [EMAIL PROTECTED]
[2/5/04 19:07:08:796 CET] c7f06 SystemOut U
[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR:
[2/5/04 19:07:08:796 CET] c7f06 SystemOut U Rollback on the
underlying
connection failed
[2/5/04 19:07:08:796 CET] c7f06 SystemOut U Io exception: Broken pipe
[2/5/04 19:07:08:803 CET] c7f06 SystemOut U 05 Feb 2004 -
19:07:08,802
ERROR [com.aventis.sage.service.ServiceUserBackBone] error : (ligne 180) -
Io
exception: Connection reset by peer: Connection reset by peer
****************************************************
We have another application using Websphere datasource (without OJB) and it
works OK through the firewall. So we decided to configure OJB with a jndi
datasource. But I didn't find any document to do this with Websphere (except
the repository.dtd.
I tried this configuration with my development environment:
****************************************************
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="Oracle"
jdbc-level="2.0"
jndi-datasource-name="jdbc/mydatasource"
batch-mode="false"
useAutoCommit="0"
>
<connection-pool
maxActive="25"
whenExhaustedAction="0"
/>
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl"/>
</jdbc-connection-descriptor>
****************************************************
The datasource is found but we have this error:
org.apache.ojb.broker.TransactionNotInProgressException: ConnectionManager
is NOT in transaction.
This configuration is working OK with WSAD 5(Windows).
Any idea about how to configure a datasource with Websphere (solaris) or
about our firewall problem?
Thanks a lot.
Yannick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
