commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From irfan romadona <tunjungse...@gmail.com>
Subject [daemon] Cannot execute complex SQL query when run the application with procrun
Date Tue, 07 Jun 2011 03:37:21 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message