balamurugan velliambalam

Greenhorn
+ Follow
since Jul 13, 2010
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by balamurugan velliambalam

Java Insert Statement:

insert into temp2(NO,NAME,DATE) values(?,?,?)

I have recieve csv in any one of format below even it may change in formats.

How we insert this statement using PreparedStatement in java.

It may like this

NO,NAME,DATE
1,BALA,24-02-1987
2,BALA,24-02-1987

(OR)

NO,DATE,NAME
1,24-02-1987,BALA
2,24-02-1987,BALA

(OR)

DATE,NAME,NO
24-02-1987,BALA,1
24-02-1983,BALA,2
Dear Wei Dai,

How you tell my csv parse code is slow can you please explain..It will be helpful
Dear Martin,

I will work on based on your suggestion.Thanks If I feel anything confused I will ask you thank you very much
I have attached below code

Functionality

Reading csv and insert in db after replacing values with webmacro.

Reading values from csv @ first header information NO,NAME next to that read one by one values and put into webmacro context context.put("1","RAJARAJAN") next webmacro replace $(NO) ==>1 and $(NAME)==>RAJARAJAN and add in statment batch once it reached 1000 execute the batch.

Code is running as per functionality but it takes 4 minutes to parse 50,000 records need performance improvement or need to change logic ....kindly let me know if any doubts. Any change to drastic performance...

Note: I use webmacro because to replace $(NO) in merge query to values read in CSVwebmacro

I want to download this book as free any suggestions

[ UD: removed book title ]
10 years ago
Using the above code i only get null value as result.It is local host only i cannot able to getvalue.

Ya you are right eric,but we put entry like this in xml(our own framework)
<tfw_table_cols ATTRIB_ID ="29" COL_NAME ="REVISION_NO" COL_UNIQID ="N" COL_CAPTION ="Revision Number"
COL_DISPLAYTYPE ="TEXT" COL_DISPLAYFORMAT="NULL" COL_LENGTH="100"
COL_MAXVAL="NULL" COL_ALLOWNULL ="Y" COL_ADD_EDITABLE="0" COL_EDIT_EDITABLE="0" COL_ADD_ENABLE="0"
COL_EDIT_ENABLE="0" COL_ADD_HIDE="1" COL_EDIT_HIDE="1" COL_DEFA ="HQ_DEFA_S_EQN_REVISION_NO+1"/>
where i marked bold revision number it is a caption and col_display type is text means text box. we store all these values in database based upon the values we built UI which more fast than normal because more work done by client side. I hope you understand if you have any doubts regarding this kindly let me know.
I am working as a java programmer in a small concern.

Now we started ,new framework ie, if we put an entry in xml it automatically creates a UI according to that entry. I dont have much idea about javascript so kindly suggest me how to proceeds with that and kindly tell how to work with javascript data grids.
Take the scenario
when i click tab-> it redirect to next page in that page i hidden the buttons when i click at that moment all the button are show in the screen and disappear completely how to avoid this.....
Hi,
Kindly guide me to display table by aligning it while filtering as im filtering row wise its getting collapsed kindly guide me...
function search_value1()
{
var tab=new Array(50);
var row=new Array(150);
var col=new Array(150);
var col1=new Array(150);
var tablelen,rowlen,collen,a,b,c;
var usetemp,usetemp1;
tablelen=document.getElementsByTagName("TABLE").length;
for(a=0;a<tablelen;a++)
{
tab[a]=document.getElementsByTagName("TABLE")[a];
rowlen=tab[a].getElementsByTagName("tr").length;
for(b=1;b<rowlen;b++)
{
row[b]=tab[a].getElementsByTagName("tr")[b];
row[b].style.display='none';
tab[a].style.display='none';
}
}

for(a=0;a<tablelen;a++)
{
tab[a]=document.getElementsByTagName("TABLE")[a];
rowlen=tab[a].getElementsByTagName("tr").length;
for(b=1;b<rowlen;b++)
{
row[0]=tab[a].getElementsByTagName("tr")[0];
row[b]=tab[a].getElementsByTagName("tr")[b];
collen=row[0].getElementsByTagName("th").length;

for(c=0;c<collen;c++)
{
col[c]=row[0].getElementsByTagName("th")[c];

col1[c]=row[b].getElementsByTagName("td")[c];


if(col1[0].innerHTML==document.getElementById('column').value)
{

tab[a].style.display='block';
row[b].style.display='block';
row[0].style.display='block';

}
}
}
}
} thanks
I attached my xsl code below in that code using javascript i display the tables.At first we run the xml it display properly after that i give some no to search in text box if i give particular no it creates space before the table and after the table how to avoid this space
I am working as junior java developer but i am very weak in oracle i find difficult in writing queries and normalize the data so kindly suggest to improve my knowledge on both these things.
11 years ago
Hai,
Now i am working as a trainee java developer in my project we use xml,xsl,xpath,xsd with java please suggest book to implement practically.

Lester Burnham wrote:Why do you expect to get exceptions for those characters? XML can contain just about any character - that's not cause for any exceptions. If those characters are not supposed to be there, talk to the producer of the XML to fix that.



But the producer of the xml was client we don't supposed to fix it so please provide any alternate solution to find that special character in xml file.