When tomcat starts in service mode, it will call tomcat52.exe to start tomcat. By default, tomcat5w.exe uses java runtime as vm, and the vm will use its own JAVA_HOME setting which is stored in system registry data. For example, when you use JDK 1.4.2_06, java_home can be found in HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Development Kit\1.4.2_06. Its default value is "C:\Program Files\Java\j2re1.4.2_06" which is java run time directory. You can change this to point to JDK home directory, like "C:\j2sdk1.4.2_06".
Several days ago, I wrote a piece of program in C#/.Net to import some records into oracle database. It is windows version 10g XE. When the program is running, I got a run-time error which is ORA-01000 maximum open cursors exceeded. Here is the Oracle docs about ORA-01000: ORA-01000 maximum open cursors exceeded Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user. Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle. In order to solve this problem, I increased my OPEN_CURSORS by using: ALTER SYSTEM SET open_cursors = 5000 SCOPE=BOTH; You can use SQL/PL client and "connect" command to login the database system by using "system" user to change the open_cursors. If you are using .NET, DBA, and Java programming, please remember to close all the re...
Comments