Makesh Kumar Ramakrishnan

One application has been running in our company from 2001 onwards. It uses Java 1.3 and XSLT 1.0.
Recently starting from last january 2009, it started behaving differently. Even "for-each statement" is not running as expected.

This application takes XMLs and XSLs as input, transforms to some output files.
Nothing has changed. Same application jar file and same input XMLs and XSLs. but the trasnsformation is different this time.

Please let me know what would be the cause of the problem. JRE(JDK) also not changed at all. we are using JRE(JDK) 1.3.

This is a swing application. So it's definitely not executing on the machine database resides.

Then I have only the second option as you mentioned. If I understood correctly,these are the things need to be done.

Separate the database code from the GUI code. Deploy the database code as a web application. And make a call to web application whenever the swing application needs to get the data from database.

Is that correct?

Or anything else we can do.

What I would do is, catch the exception assuming that Exception is thrown because of network connection failure. In that catch block, you can write your connection failure recovery mechanism.

We are facing significant delay in loading the screen. Most of the delay time is due to data fetching(JDBC) time.

It's a swing application with Oracle 10i database. It's used by our 3 plants in different locations.Database is located at Arizona.
Three plant locations are Arizona,New Mexico and Ohio.

There is no delay in loading the screen for the users accessing from Arizona and New Mexico plants.It takes 4 secs to load the screen. This is expected as there are more data and lot of screen components to load.

But the users in Ohio plant are having problem. It takes 30 secs to load the same screen. The time break up shows that most of the delay is in fetching the data.

What are my options to fix this problem?

Note: We had similar problem in New Mexico plant. But it was solved. I used setFetchSize() function to fix this.

I appreciate your help.

Config:

Database: Oracle 10i
Java : Java 5
JDBC and Oracle thin driver

Thanks,

We are facing significant delay in loading the screen. Most of the delay time is due to data fetching(JDBC) time.

It's a swing application with Oracle 10i database. It's used by our 3 plants in different locations.Database is located at Arizona.
Three plant locations are Arizona,New Mexico and Ohio.

There is no delay in loading the screen for the users accessing from Arizona and New Mexico plants.It takes 4 secs to load the screen. This is expected as there are more data and lot of screen components to load.

But the users in Ohio plant are having problem. It takes 30 secs to load the same screen. The time break up shows that most of the delay is in fetching the data.

What are my options to fix this problem?

Note: We had similar problem in New Mexico plant. But it was solved. I used setFetchSize() function to fix this.

I appreciate your help.

Config:

Database: Oracle 10i
Java : Java 5
JDBC and Oracle thin driver

Thanks,

Thanks for your reply. Yes, I could use the earlier version jar file like classes12.jar with java 1.5. The problem I have is when I use those jar files, I might lose the some of the functionality provided by the latest JDBC jar file like connection caching. Is there anyway I can use the latest JDBC driver functions compatible with Oracle 8?

Otherwise I need to implement the functions.

Thanks,

Currently we have an application in java 1.5 running in one plant. The database used in that plant is Oracle10i.
Now we want to use the application in another plant which has Oracle8i as a database.
The problem here is i couldn't find a jdbc jar file for Oracle8i compatible with Java 1.5.
Is there any hope I can run the application in Java 1.5 against Oracle 8i database? Please let me know if you have any solution.

Thanks,

Thanks Rob for your inputs.I will try to implement the solution.

Makesh

Thanks for your reply Campbell. As I mentioned I need to read the user input from system console. No user input window. I know, sometimes you get weird requirements. But that is what we need to deal with.

Makesh

Thanks Rob for your quick reply.

But I am using Java 5. What is the alternative solution?

Thanks,

Makesh

I am developing a core java application with no swing package. It requires to take user name and password by prompting the user to key in. It needs to display '*' character whenever user enters password character on the screen.
I am using System.in to read the input.

I know, if I use swing / web jars, then it would be easier to use password field to get the password from user. My requirement is not to use either of the package.

What would be the better way to implement this functionality?

Makesh

Your suggestion to use Throwable instead of Execption is a good one. I will try that one.

There is no stack trace. getMessage() of Exception returns null.

FYI, this execute method successfully ran for one month and each day it was executed more than thousand times. So I don't think I am setting some wrong properties.

Thank you for your suggestion. Your inputs are welcome.

Makesh

Jeanne,

I assure you that finally block is in place. I think that is not a problem. if there are more connections open, I could find out in DBA session.

Makesh

My application is running for a while. Usually 2 weeks once , we get the exception in JDBC call and we restart the application and it runs fine. Finally we found the source of the exception. It's from execute() method of callableStatement. The call returns exception. But there is no information in the exception object. The getMessage() function of Exception returns null and there is no stack trace.

The callableStatement execute() is being called continuously to get the record one by one. This functionality is coded in Servlet.
statement = connection.prepareCall( "{ CALL procName(?) }" ); do { try { count = new BizDelegateDBUtility().getInprogressCount(tableName); if(routerMsgCount>=0) { if(count > (routerMsgCount+1)) { routerStatus = "stop"; break; } } if(count ==0 ) { introduceDelay = false; }else { introduceDelay = true; } int currentCount = 0; while(currentCount < ( routerMsgCount - count)) { this.deQueue(connection,statement,tableName); currentCount++; } if(introduceDelay) { Thread.sleep(waitTime); } } catch(Exception exception) { // Logging error message routerState++; } } while(routerState==1 && !(routerStatus.equalsIgnoreCase("stop"))); private void deQueue(Connection connection, CallableStatement statement,String tableName) { long runSeq; boolean retrun = false; try { statement.registerOutParameter (1, OracleTypes.INTEGER); retrun = statement.execute(); runSeq = statement.getLong(1); if(!statement.wasNull()) { new BizDelegateDBUtility().updateGroupFlagHistoryStatus(runSeq,"IN PROGRESS",tableName); consultQManaggerNSend(Long.toString(runSeq)); waitCount = 0; } else { Thread.sleep(waitTime); waitCount++; if(waitCount < 3) { sLogMessage = "Waiting for Message from DC..."; // Logging message } } } catch(SQLException sqlE) { // Logging error message } catch(InterruptedException interruptedException) { // Logging error message }catch(Exception exception) { // Logging error message } }

The file path is mentioned in the log4j property file.

If the particular directory is not available, log4j is throwing FileNotFound Exception. So, Is there anyway log4j automatically creates the directory path when the mentioned path is not available?.

Thanks,

Makesh
[ July 16, 2008: Message edited by: Makesh Kumar Ramakrishnan ]