[JCA/JBoss] - Re: Connection closed problem after DB restart.
by vickyk
"jackminder" wrote : I never see these errors during normal operation just when the oracle 10g RAC database is restarted. So I would not think this would be a connection leak. I guess I could increate the blocking timeout. Any recommendations for this?
|
Increasing the blocking timeout means that you are sure that the connections are held for longer time in your application code .
That means that you have some genuine long ruinning SQL's which can't be optimized anymore and the server peak load is consuming all the connections .
The first things you should try is to increase the pool size and if this can't be don't then you can go and increase the blocking time .
anonymous wrote : Is the JMX-Console provided in Jboss 3.2.2?
Yes it is there , don't feel lazy to run http://localhost:8080/jmx-console when Jboss3.2.2 is running .
If you get lazy in starting the Jboss3.2.2 then look for the jmx-console folder in the $JBOSS_HOME/server/default/deploy/jmx-console.war :)
Finally think of doing SQL tunining , I guess you need it .
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4109253#4109253
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4109253
18 years, 4 months
[JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster
by vickyk
at org.jboss.mq.sm.jdbc.JDBCStateManager$JDBCSession.close(JDBCStateManager.java:638)
The error appears to come from here , enable the TRACE logging on
org.jboss.mq.sm.jdbc.JDBCStateManager class and trace the flow .
Also make sure that datasource configuration is working , you can write a simple jsp to test that .
First let us make sure that the datasource is configured properly.
anonymous wrote :
| One thing that you have to be careful of, SQL Server will frequently change the port that it listens on to some other number (that's Microsoft for ya) if you get a connection refused on startup check and see what port it is actually listening on.
Do you mean to say that every time you restart the MSSQL server it listens on different ports? There should be some way to configure the fixed port , I wanted to try this but I have fedora installed on my laptop .
Ronald , I don't believe that the MS doesn't provide a way to configure the fixed port to listen :) , google to know more configuration !!!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4109249#4109249
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4109249
18 years, 4 months