Shane W

Hi
I re-wrote the parser part of the code and it works fine now.
As we handle not more than 4k records ata time, the top to down parser that i wrote is giving decent enough performance, I'm open to suggestions though

Shane

Hi
Thanks for your suggestion
We did do a check to find out how much time each of the process is taking.
We found that insertion into the Access DB is taking around 4 inutes, so thats the bottle neck.
We are now trying to find out ways to minimize this. As its in VB, we are now trying to use ADO queries instead of SQL queries

Shane

Hi
Thanks for the suggestion.
Right now i read the access DB and for each column, I add it to the xml file with<> and <> brackets.For japanese characters, i need to convert to unicode.

Shane

Hi
Thanks for your suggestion.I'll see if i can convince the tech folks about inserting directly without having to go through the servlet. I never understood the rational behind having JBoss in between myself, but i know it'll be a tough task to get the message thru.

Meanwhile, i'll continue to look at option to speed up the current process

Shane

Hi
Sorry for not having given a background to the problem
Actually, we have some folks who are not on company network all the time.The are our sales guys.For them, there is this age old excel application, which they use to decide on the price etc based on various parameters.Access is the DB used for them
Now when they come back,we need to upload this data for management review and other decision making process. As the sales guys don't want any change to the way they go about doing their job(ie using excel), we have to give them a buton on their excel which will upload and download data from the centralised DB.
That is why use of XMLHttp was proposed and so we fetch the data from the access db, convert to xml and send it to my servlet which in turn pushes it to the oraccle db.
Now this task can't take lot of time and after an analysis, we found that we need to update say around 4k records each time we do this synchronise thing.

We already are useing connection pooling at JBoss level.
If i use csv, how do i send it to the server?

Shane
(Not the cricket guy)

Hi All
I have to come up with a solution to upload 4000 records, each record s containing about 250 columns.I have to achieve this in 1 minute. Ours is a VB application,that does this upload via JBoss, we are doing this by XMLHttp protocol hitting my serlvet.
The data is in Access(Local) and we have to upload it to Oracle(centralised)

Need some info to achieve it.

Right now, its taking 5-10 minutes which is not acceptable.
Increasing the network speed is ruled out

The conversion of data from access to XML itself is taking close to 1 minute.
We parse this XML using SAX parser in the DAO to insert into Oracle

Shane

Hi
Download JDK from Sun site and double click on the icon and it takes you through.Set classpath after that (optional,but you will have to give the path of the bin directory always otherwise)
I did not get why you used EJB in subject line,perhaps in error

Shane

Hi
As pointed out by folks above, there are some erroes in your code.Find below a simple piece of code that achieves what your code would have(more than 2 @).I have done away with the countChar method.
Incase you want to count how many times "@" appears,you need to modify countChar method

class Contain { String ocurrChar = "@"; public Contain(String word) { if(word.indexOf(ocurrChar)!=-1 &&word.indexOf(ocurrChar)!=word.lastIndexOf(ocurrChar)) System.out.println("Contains more than two @ "); } public static void main(String args[]) { Contain con=new Contain(args[0]); } }

Shane

Hi All
I've inherited some code which inserts Japanese character to Oracle DB.It converts it to Unicode, forms XML out of it,send it to the server where its converted back to original form before inserting to the DB.
However, for some clomns at radom, it is inserting some spurious characters also.
To test, i used 1 record set multiple times in the XML (so that all rows i insert are actually the same) but for some columns,i'm getting this spurious characters.
I logged the reconverted data and found that it is having those unwanted characters.
I've got the XML that is formed and it appears correct.
So something is happening in the transmission which i'm unable to detect.
Has anyoine come across any such situation or has a clue what is going wrong?

Shane

Hi All
I was planning to rename one of the sevens JSPs and reploy. But I found that the page displayed as i wanted,shows 12:00:00 AM properly,without doing any changes.

How it worked is still a mystery for me as i did no changes (i knew i need not do anything). That i tested the application on a system on which this application was never run,makes me doubt the cache theory. If it was cache, how come it did not show up properly on this "new" system?

Shane

Hi,If its the width you want to restrict,you can use a a CSS or otherwise (as stated in the solution above)to restrict the width.Tool tip can be used so that user can see the full terxt if it is not completely visible

Shane

Hi
The setup in our clients enivronment is such that all applications are accessed by first logging in from a login page which acts a common entry point to all applications.
Now the client wants that after logging in, the subsequent pages not have the address bar.
So, i added a dummy page between the login page and the forst page of our application and in this dummy page, i call the window.open javascript method and in this way i go to the first page of our application.in the window.open method, i pass location=no as an argument.

Is there any better way to do it? I'm a bit sceptical about the approach we adopted?

Shane

Hi
Use window.open java script method.You can specify all that you need there as arguments.

Shane

Hi All
I was supposed to show the local system time for one of my JSPs with hour,Min and seconds put in 3 boxes.I used the Date object and extracted the Hours mins and sec from it and set it to my form hour min sec fields. This was done in a .js file as some 7 pages had the same requirement.
All of a sudden, the client came up and asked me to set it to a defaul value,12:00:00 Am and i changed the.js file,setting the form hours filed to 12,min to 00 and sec to 00. It works fine when i run it from my local server,but when i deploy it and run it on IE, the value for time appears as i had set it initially, ie the local system time and not the default 12:00:00 valu as i wanted.I cleared the cache and temporary internet files but its not working the way i want it to. Then i opened the same page in fire fox and it comes up properly ie 12:00:00.This means the code is propely deployed on the dev server but there's some problem with IE setting.

Code is as shown below.
I'd be happy if some one can throw some light.

Shane


document.forms[1].ClockHours.value="12";
document.forms[1].ClockMins.value="00";
document.forms[1].ClockSecs.value="00";

Hi all
I've tried using the foll piece of code
oracle.sql.CLOB newClob = oracle.sql.CLOB.createTemporary(conn, false, oracle.sql.CLOB.DURATION_CALL);

This works fine if i run a standalone piece of code.But when i use it in my app,running on JBoss, I get class cast exception.

Any clue why this is happeing?
Using oracle 9.2 and JBoss 4.1

Shane