[jboss-user] [JBoss Tools] - Start process on JBoss Server

[zearys]

zearys [http://community.jboss.org/people/zearys] created the discussion

"Start process on JBoss Server"

To view the discussion, visit: http://community.jboss.org/message/618844#618844

--------------------------------------------------------------
Hi, 

I’m using SQLLoader to load data into my tables from a process. I would like to lunch this process once a user presses a button in my web interface. So I made tests in a single main before adding and everything was fine. Once I place the code on my JBoss Server nothing work anymore.

I would like to know why the code don't react same way on Jboss sever as on a regular java application for process execution? And what may I do to make the same code react the same way?

In a main, executed as java application, this code results X successful lines:

String[] exec = new String[] {"sqlldr","userid=ab at devl/abc","control=C:/controls.txt","log=C:/" };
 
BufferedReader br = new BufferedReader(new InputStreamReader(new ProcessBuilder(exec).start().getInputStream()));
 
while (br.readLine() != null) {
…
}

 
1. Controls.txt:
LOAD DATA
INFILE 'C:/03_JUN-11_0210SFAEXDDEFS20110712014140.txt'
APPEND
INTO TABLE S1_DATA_TEST
TRAILING NULLCOLS
(EXERCICE                CONSTANT                          2011,
 NO_PERIODE          CONSTANT                          3,
 REGISTRE                POSITION(14:20)                CHAR TERMINATED BY WHITESPACE,
 ENTITE                      POSITION(44:47)                CHAR TERMINATED BY WHITESPACE,
 A                                  POSITION(69:74)                CHAR TERMINATED BY WHITESPACE,
 PERIODE                  POSITION(219:224)           CHAR TERMINATED BY WHITESPACE,
 DESCRIPTION         POSITION(234:474)           CHAR TERMINATED BY WHITESPACE,
 B                                  POSITION(475:496)           DECIMAL EXTERNAL "to_number(replace(:B,'.',','))",
)


And once on the JBoss server with the same code :
09:58:29,339 ERROR [STDERR] java.io.IOException: CreateProcess: sqlldr userid=ab at devl/abc control=C:/controls.txt log=C:/ error=2
09:58:29,339 ERROR [STDERR]  at java.lang.ProcessImpl.create(Native Method)
09:58:29,339 ERROR [STDERR]  at java.lang.ProcessImpl.<init>(ProcessImpl.java:81)
09:58:29,339 ERROR [STDERR]  at java.lang.ProcessImpl.start(ProcessImpl.java:30)
09:58:29,339 ERROR [STDERR]  at java.lang.ProcessBuilder.start(ProcessBuilder.java:451)
09:58:29,339 ERROR [STDERR]  at exportation.Sqlldr.executer(Sqlldr.java:74)
09:58:29,339 ERROR [STDERR]  at exportation.Sqlldr.executer(Sqlldr.java:34)
09:58:29,355 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
09:58:29,355 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
09:58:29,355 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
09:58:29,355 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Method.java:585)
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/618844#618844]

Start a new discussion in JBoss Tools at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2128]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110802/cb1a6f01/attachment-0001.html