Oracle: Ass first design pattern

Search Options	close
Search the following clips: All Clips

news science politics food economy art
technology health internet religion psychology

Sign Up Install Learn More Login


	Oracle: Ass first design pattern

travislaborde

8-22-2007 7:52 AM

292 views

tags:

programming, .net, oracle

travislaborde says:

LOL. And this stuff comes from the "Advanced ODP.NET Samples" part of their site. OMG

Add a Comment

Login to Comment. Not a member yet? Sign up

Today's Top Clips

visit the Top Clips page

View the Top Clips from August 22, 2007

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/5d6cb545-4696-4f73-a517-0042416c3355/4BBF4EE8-7CBC-470D-8E21-8155EB06102B/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://blah.winsmarts.com//post.aspx?postid=58" href="http://blah.winsmarts.com//post.aspx?postid=58" style="font-size: 11px;">blah.winsmarts.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blah.winsmarts.com//post.aspx?postid=58"><H2>
                Oracle: Ass first design pattern: Just "Orrible"
            </H2></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blah.winsmarts.com//post.aspx?postid=58"><P><FONT size="2" face="Tahoma">Pardon the title, but this is quite Orrible. </FONT></P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blah.winsmarts.com//post.aspx?postid=58">the webservice (ASMX) that runs on a webserver, that holds the OracleConnection as a "protected shared" global to the class variable - it's connection opening and closing - is controlled by the remote client using two WebMethods - <STRONG>OpenConnection</STRONG>/<STRONG>CloseConnection</STRONG>. </blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blah.winsmarts.com//post.aspx?postid=58">The CloseConnection is called from the client side ASPX. You think that is bad? Oh you haven't seen the real crappy part yet - The CloseConnection WebMethod is called using the OnClick of a button on an ASPX. So not only is the connection open for - well - if you went for lunch for instance,</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blah.winsmarts.com//post.aspx?postid=58">WebMethod that runs DDL - Yes sir, <STRONG>Create Table/Drop Table</STRONG>, right over a web service.</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blah.winsmarts.com//post.aspx?postid=58">So let me get this straight, the remote user is passing in a userName, passWord, and dataSource over a webservice?</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blah.winsmarts.com//post.aspx?postid=58">Check the <A href="http://www.oracle.com/technology/sample_code/tech/windows/odpnet/odpadv.html"><FONT color="#800080">title of the page I got this sample from</FONT></A> -- "<STRONG>Advanced ODP.NET Samples</STRONG>". </blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/4BBF4EE8-7CBC-470D-8E21-8155EB06102B/blog/" title="blog or email this clip"><img src="http://content6.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Copyright; Privacy; EULA

Search Options

Today's Top Clips