Showing posts with label Troubleshooting. Show all posts
Showing posts with label Troubleshooting. Show all posts

SQL Server 2005 Driver Signer Issue Websphere 6

If you are facing the following issue while using SQL Server 2005 JDBC driver in websphere 6 : "java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection "'s signer information does not match signer information of other classes in the same package"
here is the work around link

Capturing Microsoft Crash Dump

Steps to capture the Microsoft Crash Dump
Pre requisite
Machine should have 'Debugging tools for Windows' installed.If not download and install from this location : http://www.microsoft.com/whdc/devtools/debugging/installx86.mspx
Note:The above package will install windbg.Note the path of windbg.exe.we will use this to capture the crash dump
Steps
1]Open the Registry using Regedit
2]Open the following key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AeDebug"
3]Take the backup of the AeDebug regisrty key.This is to restore the original settings once the crash dump is captured.
4]To take backup, right click on 'AeDebug' and select 'Export' option.Specify the name and location to store this.
5]Now set AeDebug\Auto key to 1
6]Set AeDebug\Debugger key to 
"" -p%ld -e%ld -g -c ".dump /mfa C:\\dump %ld.dump:q"
7]Try to reproduce the issue.On crash windbg will start and generate the crash dump file at C:\ location.
8]Restore the original settings by double clicking the file exported earlier in step 4

Handling the Stack OverFlow

Stack overflow
The JVM allocates a Java and native stack for each thread that is created by the application. If either of these stacks become exhausted, a stack overflow error occurs. A Java stack overflow can occur for the following reasons:

The stack is not large enough to handle the request. Setting the following JVM parameter increases the Java stack size to 1 MB:
-Xoss1m
The default is 400 KB.

The JIT compiler is causing a recursion in the application code. There is a recursion in the application code
A native stack overflow can occur for the following reasons:
The stack is not large enough to handle the request. Setting the following JVM parameter increases the native stack size to 1 MB:

-Xss1m
The default is 400 KB.

Setting JVM parameters: To set a JVM parameter, use the Generic JVM arguments field for the application server. You can find this at Servers Application Servers Java and Process Management Process Definition Java Virtual Machine