Skip to Content
0
Mar 17, 2009 at 10:06 AM

J2EE Engine Problem

17 Views

Hi All Experts,

Im under production support and I need your advice on the following scenario:

In my scenario, the sender is a EDI system which sends xml files and these xml files are processed in XI and the data is dumped in the SQL Server 2000 using the JDBC adapter. There is another .NET Production System which also links to SQL Server Database and updates it.

The problem arises when the .NET Production system goes down or its restarted, and so does the SQL Server (as both the .Net system and DB reside on the same box). This snaps the JDBC connection between the XI and the SQL Server. So, i need to log into the J2EE Visual Admin and restart the JDBC Connector datasource to re-establish the connection otherwise the dataflow stops from the XI to SQL Server.

My question is,

1. is there by any means I can automatically come to know when the JDBC connection is down ?

2. Is there by any means by which datasource automatically gets connected after the .Net server restarts so that i do not need to manually restart the datasource?

I have full access to J2EE Engine under Visual Admin.

Please provide a solution to this.

Regards,

Arkesh

Edited by: Arkesh Sharma on Mar 17, 2009 11:07 AM