Chris Paulraj

Venkat, Most of J2EE appservers support SPNEGO feature, which would pass you the client's logon credentials to J2EE application. You should be able to find the necessary configuration document, specific to your appserver.

Good Luck
Chris Paulraj

Sumanta, It looks like a logic issue, cmp should always be zero for every POST, so I don't see any reason on why it's added cumulatively? it should work, if you reinitialize cmp=0 after adding to totalcmp!

int cmp_temp=Integer.parseInt((String)inVec.elementAt(3));
cmp=cmp+cmp_temp;

}
Integer totalcmp=(Integer)session.getAttribute("cmpValue");
totalcmpdata= totalcmp.intValue()+cmp;
--> Add the below line
cmp=0

Sumantha, What is the scope of the variable "cmp"? Where is it being declared?

int cmp_temp=Integer.parseInt((String)inVec.elementAt(3));
cmp=cmp+cmp_temp;

Jay, What's your connection property values? It could be due to connection leak or hung thread conditions.If you could obtain a thread dump; you will be able to see why those connections are used up?

Cheers
Chris Paulraj

If you don't want to change code, the less intrusive way would be to either set it in deployment descriptor of your EAR file or you can add custom datasource properties to your JDBC resources on the app server.

http://www-1.ibm.com/support/docview.wss?rs=180&uid=swg21224492

cheers
Chris Paulraj

Glenn, You are almost there, since Websphere is using self signed certificate for SSL connections, the client is not trusting it. You would have to download the key.pk12 from dmgr/config/cells/YOURCELLNAME into your DummyServerTrustFile.jks.

Cheers
Chris Paulraj

Ajay, When security is enabled,you would have to connect using SSL. Add these lines before connecting, and have the server certificate imported into your client TrustFile.

connectProps.setProperty("javax.net.ssl.trustStore", ".\\properties\\DummyServerTrustFile.jks");
connectProps.setProperty("javax.net.ssl.keyStore", ".\\properties\\DummyServerKeyFile.jks");
connectProps.setProperty("javax.net.ssl.trustStorePassword", "WebAS");
connectProps.setProperty("javax.net.ssl.keyStorePassword", "WebAS");

good luck
Chris
[ October 14, 2007: Message edited by: Chris Paulraj ]