July 3, 2007

Using ANYDATA in Oracle 9i

First introduced in Oracle 9i, ANYDATA is a “self-describing data instance type” which means it not only holds the value, but it also holds its own data type within each instance of it. An ANYDATA can be persistently stored in the database. It also contains many methods that allow you

In-memory JDBC Driver Details

When you’re working with JDBC, you can load more than one JDBC driver in memory. To find out how many drivers are in memory, along with other useful driver information, use the following code: import java.sql.*;import java.util.*;public class drvinf{public static void main(String[] args) { Connection conn=null; ResourceBundle bundle = ResourceBundle.getBundle(“START”);

Determine Whether a URL Is Valid

Use this Boolean function to determine whether a URL is valid: public static bool checkUrl(string url) { bool rt = false; if (url.StartsWith(“www.”)) { url = “http://” + url; } HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(url); HttpStatusCode code = new HttpStatusCode(); HttpWebResponse myResponse = null; try { myResponse = (HttpWebResponse)myRequest.GetResponse(); code =

SQLCLR Security and Designing for Reuse

n important principal of software design is that of “least privilege.” Basically, in any given layer of a program, you should grant only minimal access such that the code has rights to only exactly the resources it needs to get its job done?and nothing more. Most SQL Server developers understand