problems connecting to external oracle databse from WAS

Hi,

we have webdynpro application (deployed on WAS)which is required to fetch and update data in oracle database. The restriction here is we are required to use DSN (provided by Primavera Inc..for connection). We are using connection pool, where we have configured data source with DSN(system DSN) with appropriate parameters.

We have tested the dSN for extensive data transfer from our local jvm's...but when used with J2EE on WAS..its not that stable, when used to transfer data say for more than 2-3 times, gives SQL Exception with general error. Then after, when J2EE engine is stopped...it starts working fine...then again after when J2EE started, same problem occurs...

Is it some problem with memory??

Because our server has 1 GB RAM + 4 GB VM there fore total 5GB available memory. Previous performance of server was very slow due to wrong VM setting...

Now also the performance is not that good...jalunch.exe consumes upto 1.4 gB of memory..is it ok..or something wrong???

Is there alternative best way to talk to external oracle database from WAS J2EE...or connection pool is the best possible method..

Please help..

Thanks in advance..

Abhijeet

If there are any settings to be done on server also..

fine..we have complete access of it...