sandhya menon

Ranch Hand
+ Follow
since May 22, 2001
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 sandhya menon

Dear All,
Can we change the password for WAS oracle user
EJSADMIN and EJB . And whcih all Oracle Privilges can i provide to these users. I dotn want to give DBA rights as matter of security concerns
19 years ago
Dear Friend,
Thanks for that guidance
Regards
New to XML I tried to do some experiments....
I get a blank display....Pl advise

<?xml version="1.0" standalone="yes"?>
<?xml-stylesheet type="text/xsl" href="ex_6.xsl" ?>
<BRANCH>
<BRH_NAME>DELHI
<DEALER>
<NAME>TFLXYZ LTD</NAME>
<CODE>DE</CODE>
<LOCATION>DELHI</LOCATION>
</DEALER>

<DEALER>
<NAME>COMMERCIAL AUOT MOBILES</NAME>
<CODE>CAM</CODE>
<LOCATION>DELHI</LOCATION>
</DEALER>
</BRH_NAME>

<BRH_NAME>MUMBAI
<DEALER>
<NAME>TFLXYZ</NAME>
<CODE>TFLXYZ_MUMBAI</CODE>
<LOCATION>SANPADA</LOCATION>
</DEALER>
<DEALER>
<NAME>CONCORDE</NAME>
<CODE>CONC</CODE>
<LOCATION>SOUTH_MUMBAI</LOCATION>
</DEALER>
</BRH_NAME>
</BRANCH>

=================================
My XSL is as follows
<?xml version="1.0" encoding="ISO-8859-1" ?>
<HTML xmlns:xsl="http://www.w3.org/TR/WD-xsl">
<BODY >
<xsl:for-each select="BRANCH">
<xsl:for-each select="BRH_NAME">
<xsl:value-of select="BRH_NAME"/>
<xsl:for-each select="DEALER">
<xsl:value-of select="DEALER" />
<xsl:for-each select="NAME">
<xsl:value-of select="NAME"/>
<xsl:for-each select="CODE">
<xsl:value-of select="CODE" />
<xsl:for-each select="LOCATION">
<xsl:value-of select="LCOATION"/>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>

</BODY>
</HTML>
Dear Friend,

See in appserverroot/lib folder u can see 2 jar files namely ejs.jar and ujc.jar .Apply this to ur classpath .
Try this it should work
regards
20 years ago
I have got the code as this.
a] ds =(javax.sql.DataSource)this.ctx.lookup(this.datasource);
Does at this point WAS interact with Oracle for connection objects. Later I retrive conn as
b] Connection con=ds.getConnection(this.user,this.password);
My probs is that I have got multiple datasource from which i have got retrive conn. So depends upon parm passed I want to fire code [a] repetedly. Does this is an Overhead .
Pls comment
Regards
20 years ago
I have got the code as this.
a]DataSource ds =(javax.sql.DataSource)this.ctx.lookup(this.datasource);
Does at this point WAS interact with Oracle for connection objects. Later I retrive conn as
Connection con=ds.getConnection(this.user,this.password);
My probs is that I have got multiple datasource from which i have got retrive conn.
20 years ago
Dear All,
You have to download rowset.jar files from Sun's site and add in ur path...
see this url for jar files;
http://developer.java.sun.com/developer/technicalArticles/javaserverpages/cachedrowset/#resources
Regards
Thanks Kyle,
Thansk for that expert comments. I plan to go for a Stress Test around 300-400 hits with 30 first.
Regards
20 years ago
Mr.Kyle,
I am still wating for expert opinion. Pls advise soon.
Regards
20 years ago
So as u have suggested I f change my code as
CacheRowSet crs= new CacheRowSet();
Result rs=stmt.executeQuery(Qry);
crs.populate(rs);
rs.close();
stmt.close();
con.close();
Is rs close here ok. no since crs should act as a disconnected ResultSet so if do this in my bean i can release all DB related objects at JAva Bean end and carry CRS to JSP & work freely with CacheRowset ??
Pls advise
Regards
CacheRowSet crs= new CacheRowSet();
Result rs=stmt.executeQuery(Qry);
crs.populate(rs);

rs.close();
stmt.close();
con.close();
Is rs close here ok. no since crs should act as a disconnected ResultSet so if do this in my bean i can release all DB related objects and work freely with CacheRowset ??
I am worlking with WebSphere 3.5.5 Conn.Pool etc
Regards
Thanks for all that valuable discussion.
At a times I pull around 9000 recs.USing Scrollable RS I could manage Pagiantion also. Not putting inot temp String array (Vector etc is not advisable to use in Web Programs i suppose ?) all
will result in re creation of my JSP. Dont u think all these are just work around and when we buy such costly Applciation Servers like WAS or Iplanet or WebLogic they should be able to manage all these things I mean workload management. Even after taking WAS we are forced to lot tunings / performacne issues etc etc is an extra specialised service I suppose
Pls comment
regards
Kyle Thanks for that Suggestion.
But the formula I had quoted is taken from following Websphere Tuning Guide .
a] WebSphere Conn.Pooling by Deb Erickson,Shawn Lauzon,Melissa Modjeski (PDF) Page 42 Paragraph Tuning Connection Pooling.
b] Another Big PDF (3125 kb) called as IBM WebSphere Application Server Std and Advanced Editon( Now i noticed - No authour but a collection of Tuning Papers -includes Some Notes by Gennaro(Jerry)Cuomo on Websphere Queing System)
It is from these books i got thsi formula.
I think some has to put things straight forward otherwise these PDF may be misleadeing too..
Pls reply.
Regards.
20 years ago
David O'Meara and champak,
I am eagerly waiting for furthur discussion....
Regards
hi any one ther to guide me !!
Kyle .......???
20 years ago