Solved

SQLLDr stops at 60 secs when called from websphere

Posted on 2014-01-17
10
606 Views
Last Modified: 2014-01-20
1. our application runs on websphere, on linux.
2. The application calls SQLLDr
3. SQLLdr opens up, processes some records and stops and after some time websphere process is hung (obviously!)
4.  When SQlLdr is opened directly from command prompt and the same .ctl file and .param files are used with the same text data, SQLLdr prefectly loads all the records.

Question is where is the problem. This is a highly critical issue and any help is greatly appreciated!
0
Comment
Question by:raghavanm1978
  • 5
  • 3
  • 2
10 Comments
 
LVL 34

Expert Comment

by:Gary Patterson
ID: 39790040
This really isn't the place for "highly critical issues".  If it is critical, I suggest you get a paid professional in who knows how to troubleshoot this kind of problem.  We don't have access to your system, and you've provided very little information to help with troubleshooting.

1) How is SQLLDR invoked?  Show the code.
2) What error, if any are you getting?  Provide a stacktrace.  

Finally, look at this:

http://www.coderanch.com/t/549118/java/java/Trouble-executing-sqlldr-java

- Gary Patterson
0
 
LVL 23

Expert Comment

by:David
ID: 39791020
Here's instructions on checking and changing your websphere default timeout.

http://www.techpaste.com/2011/07/12/steps-setting-custom-session-timeout-changing-default-oracle-driver-websphere/
0
 

Author Comment

by:raghavanm1978
ID: 39791464
@dvz why would your solution help?
0
 

Author Comment

by:raghavanm1978
ID: 39791466
@gary , I am trying out what has been said in the article.. Will let you know if it worked
0
 
LVL 23

Expert Comment

by:David
ID: 39791546
You've deconstructed the problem down to ensuring that sqlldr works by itself.  That suggests the root cause is something outside of sqlldr.  If websphere is "hanging", one possibility is that it's timing out (set too low?).  The article offers how to check and change the websphere default.  Hope that helps.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 34

Expert Comment

by:Gary Patterson
ID: 39792493
WAS default session timeout is 30 minutes.  This hang is apparently happening after 60 seconds, so it seems unlikely that it is related to the session timeout.
0
 

Author Comment

by:raghavanm1978
ID: 39793978
I agree it is not the WAS default session time out. And as the code ranch article states, I have the same problem in that if lesser number of records are there, it gets processed. So must be something with the pipe that is being talked about in the article. I shall post the code here soon to get your help
0
 

Author Comment

by:raghavanm1978
ID: 39794028
Here is the code :

command = "sqlplus -S "+_user+"/"+_password+"@"+_sid+" @"+m_file_name;
            String log_safe_command = "sqlplus -S *****/*****@***** @"+m_file_name;            
                  
            Runtime r = Runtime.getRuntime();
            long startTime = System.currentTimeMillis();
            
            try {
                Process process = r.exec(command);
                  command = log_safe_command;

                  if (process == null) {
                        Log.error(BatchImportManager.LOGGER,Messages.getString(E_PROCINIT, command));      
                        throw new Exception(Messages.getString(E_PROCINIT, command));
                  }
                  else {
                        Log.info(BatchImportManager.LOGGER,Messages.getString(I_WAITINGPROC, command));
                        process.waitFor();
                        String elapsed_time = (new Long((System.currentTimeMillis() - startTime)/1000)).toString();
                        Log.info(BatchImportManager.LOGGER,Messages.getString(I_PROCCOMPLETE, new String[] {command, elapsed_time}));
                        StringBuffer strBuffer = new StringBuffer();
                        String line;
                        BufferedReader reader = new BufferedReader(new InputStreamReader(process.getInputStream()));
                        while ((line = reader.readLine()) != null) {
                              strBuffer.append(line).append("\n");
                        }
                        reader.close();
                        if (process.exitValue() != 0) {
                              Log.error(BatchImportManager.LOGGER,Messages.getString(E_BADEXITCODE, new String[]{(new Integer(process.exitValue())).toString(), command}));
                              throw new Exception(Messages.getString(E_BADEXITCODE, new String[]{(new Integer(process.exitValue())).toString(), command}));
                        }
                  }                  
            }
            catch (InterruptedException e) {
                  Log.error(BatchImportManager.LOGGER, Messages.getString(E_WAITING, new String[] {command,e.toString()}));
                  throw new Exception(Messages.getString(E_WAITING, new String[] {command,e.toString()}));
            }
            catch (IOException e) {
                  Log.error(BatchImportManager.LOGGER, Messages.getString(E_EXECUTING, new String[] {command,e.toString()}));
                  throw new Exception(Messages.getString(E_EXECUTING, new String[] {command,e.toString()}));
            }
0
 
LVL 34

Accepted Solution

by:
Gary Patterson earned 500 total points
ID: 39795072
I think the runtime.exec() article referenced at that link above probably covers it all.

http://www.javaworld.com/article/2071275/core-java/when-runtime-exec---won-t.html

Looks like there is a short example here of someone with the same problem as you that found a working solution:

http://www.experts-exchange.com/Programming/Languages/Java/Q_20673018.html

- Gary Patterson
0
 

Author Closing Comment

by:raghavanm1978
ID: 39795960
The java world article absolutely helped. If you coded according to that then everything works. Basically the problem was that the output from SQLldr was not read, hence the buffer was full, not allowing  SQLLdr to continue
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
network + 7 80
Java Filesystem manipulation of Word Docx file (find replace text) 3 66
github account with ecipse 1 42
java jdbc batch example 8 21
This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now