You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by irfan romadona <tu...@gmail.com> on 2011/06/07 05:37:21 UTC
[daemon] Cannot execute complex SQL query when run the application
with procrun
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.
Re: [daemon] Cannot execute complex SQL query when run the application
with procrun
Posted by Michael Hagedorn <mi...@gmx.de>.
Where is Oracle server running? Local or remote?
How do you connect to Oracle? Using username/password or local
connection or OPS$?
Michael
On 07.06.2011 08:17, Mladen Turk wrote:
> On 06/07/2011 05:37 AM, irfan romadona wrote:
>>
>> prunsrv //IS//TestSvc
>> --Install=D:\INSTALLER\commons-daemon\commons-daemon-1.0.5-bin-windows\prunsrv.exe
>>
> > ...
>> --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.
>>
>
> Not sure how oracle JDBC determines the user but if it uses the current
> process token, you can end up with a different user ID asking for a TEMP
> tablespace. You can make sure you have the 'known' user running a service
> instead LOCAL_SERVICE/SYSTEM account.
> Try with using
> prunsrv //US//TestSvc --Username=you --Password=your_password
> (or just use the Control panel or prunmgr.exe)
> and see if it's still happening. If not, well, you have a DB problem so
> you can try adding more space to the ACCT tablespace.
>
>
>> Any idea on what causing this? Or could that be any additional
>> configuration
>> that I've missed? Thanks in advance.
>>
>>
>
>
> Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org
Re: [daemon] Cannot execute complex SQL query when run the application
with procrun
Posted by Mladen Turk <mt...@apache.org>.
On 06/07/2011 05:37 AM, irfan romadona wrote:
>
> prunsrv //IS//TestSvc
> --Install=D:\INSTALLER\commons-daemon\commons-daemon-1.0.5-bin-windows\prunsrv.exe
> ...
> --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.
>
Not sure how oracle JDBC determines the user but if it uses the current
process token, you can end up with a different user ID asking for a TEMP
tablespace. You can make sure you have the 'known' user running a service
instead LOCAL_SERVICE/SYSTEM account.
Try with using
prunsrv //US//TestSvc --Username=you --Password=your_password
(or just use the Control panel or prunmgr.exe)
and see if it's still happening. If not, well, you have a DB problem so
you can try adding more space to the ACCT tablespace.
> Any idea on what causing this? Or could that be any additional configuration
> that I've missed? Thanks in advance.
>
>
Regards
--
^TM
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org