• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

OC4J - Connection issues.. Very important

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi,
I need some help with production issue.We use Oracle application server 10.1.2 and oracle database. The ear is deployed in OC4j Container. Whenever we restart the oracle application server ,some of the functionalities in the web application doesn't work.and we restart it over and over again until all the functionalities work.When i say don't work the usual problems encountered are - login failed issues even when you enter correct username and password it just says login failed and this is same for all the users and we restart the OAS again and login would work but other functionalities like when searching for datas in the application would throw an arrow "not found".
And we bounce the server again both login and search would work but other functionalities like retrieving data for a particular customer number won't work.. We believe all these are caused by connections to the Oracle database.
So we keep bouncing the server over and over again till everything works right
I have looked into opmn/logs/ file it doesn't provide much clue It just says "loginfailedexception" or
nullpointerexception. We are using EJB both session and entity beans. Sometimes it throws JNDI exception "not found"
or javas.naming.exception : not found

or propertynot found exceptions.

After so many restarts all come back to normal.

This happens only when we have an outage and when we do a code promotion or restart the server for other reasons not related to web application.Once we restart even once the problems start showing up.

We use data-source.xml and connection pool , min-connections: 15 and max-connections: 160 are specified in data-sources.xml. The application works well in Test environment with no problems after OAS restarts. Only production has problems .. The reason could be there are plenty of users in production.
But once when you restart the Application server shouldn't all the connections be reset?.



<data-source class="com.evermind.sql.DriverManagerDataSource" location="jdbc/OracleCoreDS" password="keyvalues" username="software" url="jdbc:oracle:thin:@rpgdb:1521:prod" xa-location="jdbc/xa/OracleXADS" connection-driver="oracle.jdbc.driver.OracleDriver" wait-timeout="400" max-connections="160" min-connections="15" inactivity-timeout="100" name="OracleDS" ejb-location="jdbc/OracleDS"><description>Datafield Connection</description></data-source>


we are unable to track down what causes this problem because the log doesn't provide any clue.

Is there a connection cache issue? EJB issue? .. But remember it works well in Test environment same Ear with no problems after OAS restarts.



scott

 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
(after PMing the OP:) You havn't posted the username and password of your database.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic