cancel
Showing results for 
Search instead for 
Did you mean: 

problems connecting to external oracle databse from WAS

Former Member
0 Kudos

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...

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Abhijeet

Regarding the question about alternate way(could be the best) is to use the JDBC connector service. Here you can configure Java based thin drivers to connect to Oracle Database. Advanatages of doing this are you can configure several connection paramaters and also do a rough monitoring of the connection usage. I havent checked how closely it is integrated to the Log Viewer , but there are ways.

Check this document on how to achieve this

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/how to configure ud connect on the j2ee server for jdbc access to external databases.pdf

Check this link for Oracle thin drivers

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc817.html

Regards

Pran