Hi all,
I've tried procrun for making my java application works as windows service, it successfully created and runs. Here are the commands: prunsrv //IS//TestSvc --Install=D:\INSTALLER\commons-daemon\commons-daemon-1.0.5-bin-windows\prunsrv.exe --Description="Test Service" --Jvm=auto --Classpath="D:\PROJECTS\MyService\build\classes";"C:\Documents and Settings\User\workspace\TestSVC\lib\activation.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\axis.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\axis-ant.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\bsf.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\castor-0.9.5.2.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-codec-1.2.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-collections-3.2.1.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-discovery-0.2.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-httpclient-3.0-rc2.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-lang-2.5.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-logging.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-logging-1.0.4.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-net-1.0.0-dev.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\commons-validator-1.3.1.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\grouplayout.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\httpunit.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\ibmjsse.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\javax.jms.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\jaxrpc.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\jcalendar-1.3.3.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\JimiProClasses.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\junit-3.8.1.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\log4j-1.2.16.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\looks-2.0.1.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\mail.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\mailapi_1_3_1.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\mysql-connector-java-5.1.13-bin.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\ojdbc14.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\orai18n.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\quartz-1.8.3.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\saaj.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\servlet.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\slf4j-api-1.6.1.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\slf4j-log4j12-1.6.1.jar";"C:\Documents and Settings\User\workspace\TestSVC\lib\wsdl4j.jar" --StartMode=jvm --StartClass=TestSVCProcRun --StartMethod=main --StartParams=start --StopMode=jvm --StopClass=TestSVCProcRun --StopMethod=main --StopParams=stop --LogPath=C:\TestSVC --StdOutput=auto --StdError=auto But after a while, the application stopped when trying to execute a long and complex SQL query. It rarely detected, but sometimes I catch an error like this in the log: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP And most of the time, the process stopped at SQL query execution (and it will be forever like that all the time). Strangely enough, the application and the SQL query execution works fine when it runs without service. Any idea on what causing this? Or could that be any additional configuration that I've missed? Thanks in advance. Best Regards, Irfan R.
