code

Deltek WelcomRisk Benefits

2006-03-21T07:51:00.000-08:00

Project Managment Risk Analysis software...Jolt Winner. :)
Deltek WelcomRisk Benefits

SortedTable example

2006-03-21T07:25:00.000-08:00

Guide to Using XMLHttpRequest (with Baby Steps) from WebPasties

2005-09-05T19:28:00.000-07:00

Another nice AJAX tutorial. The momentum is getting so strong. Next, the tools will catch up.

Eventually does anyone doubt that the tools will do everything for us?

http://www.webpasties.com/xmlHttpRequest/

Concatenation Operators in SQL

2005-08-15T12:40:00.000-07:00

I always forget this one.....

SELECT TEAM || ',' FROM dfc_team; would put a comma after every result.

Operators

Enums

2005-08-11T12:51:00.000-07:00

Enums

Oracle Substring & Instring Functions Substr Instr

2005-06-14T07:10:00.000-07:00

Oracle Substring & Instring Functions Substr Instr

Substring Beginning Of String
SELECT SUBSTR(, 1, )
FROM dual;

SELECT SUBSTR('Take the first four characters', 1, 4) FIRST_FOUR
FROM dual;

Substring Middle Of String
SELECT SUBSTR(, , )
FROM dual.

SELECT SUBSTR('Take the first four characters', 16, 4) MIDDLE_FOUR
FROM dual;

Substring End of String
SELECT SUBSTR(, )
FROM dual.
SELECT SUBSTR('Take the first four characters', 16, 15) SIXTEEN_TO_END
FROM dual;

Java Examples: Convert double to string

2005-06-07T15:48:00.000-07:00

How many times do I have to do this?

:)

Java Examples: Convert double to string: "public class ConvertDoubleToString {
public static void main(String[] args) {
double aDouble = 0.11;
String aString = Double.toString(aDouble);
}
}"

test

2005-06-07T15:29:00.000-07:00

!Links: "code"

Cenqua Clover Code Coverage for Java

2005-05-26T11:42:00.000-07:00

Cenqua Clover Code Coverage for Java

Some examples of using Unix find command.

2005-05-11T09:19:00.000-07:00

This seems to work better than the grep -H -r * technique.

Some examples of using Unix find command.: "find . -exec grep 'www.athabasca' '{}' \; -print"

Tip #26 - Getting rid of ^M - mixing dos and unix : vim online

2005-05-08T20:06:00.000-07:00

Tip #26 - Getting rid of ^M - mixing dos and unix : vim online: "If you work in a mixed environment you will often open files that have ^M's in them. An example would be this:

------------------------------------------------------------------
import java.util.Hashtable; ^M
import java.util.Properties; ^Mimport java.io.IOException;
import org.xml.sax.AttributeList; ^M
import org.xml.sax.HandlerBase; ^Mimport org.xml.sax.SAXException;

/**^M
* XMLHandler: This class parses the elements contained^M
* within a XML message and builds a Hashtable^M

[snip]
------------------------------------------------------------------

Notice that some programs are not consistent in the way they insert the line breaks so you end up with some lines that have both a carrage return and a ^M and some lines that have a ^M and no carrage return (and so blend into one). There are two steps to clean this up.

1. replace all extraneous ^M:

:%s/^M$//g

BE SURE YOU MAKE the ^M USING 'CTRL-V CTRL-M' NOT BY TYPING 'CARROT M'! This expression will replace all the ^M's that have carriage returns after them with nothing. (The dollar ties the search to the end of a line)

2. replace all ^M's that need to have carriage returns:

:%s/^M/ /g

Once again: BE SURE YOU MAKE the ^M USING 'CTRL-V CTRL-M' NOT BY TYPING 'CARROT M'! This expression will replace all the ^M's that didn't have carriage returns after them with a carriage return.

Voila! Clean file. Map this to something if you do it frequently.

:help ffs - for more info on file formats

thanks to jonathan merz, douglas potts, and benji fisher
<> "

Case Insensitive Queries

2005-05-04T13:47:00.000-07:00

Some databases have an "ignore case" flag that can be set for the entire database. Oracle does not, and thus case-insensitive queries have long caused problems, not with coding them, but with their performance (since indexes are typically not used to determine the result).

Its relatively straightforward to create a case-insensitive query:

SQL> select *
2 from EMP
3 where upper(ENAME) = upper(:b1)

but of course (by default) the "UPPER(ENAME)" cannot take advantage of an index that may have been defined on the ENAME column.

Enter 8i, where the concept of a function-based index is now possible. Before you rush off and try to create them, take note of the following:

* You must have the system privelege query rewrite to create function based indexes on tables in your own schema.
* You must have the system privelege global query rewrite to create function based indexes on tables in other schemas
* For the optimizer to use function based indexes, the following session or system variables must be set:
QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
* You must be using the Cost Based Optimiser (which means analyzing your tables/indexes)

and then its just a case of creating the index in the conventional way:

create index UPPER_ENAME_IX on ENAME ( UPPER(ENAME) ) ;

Note that this index will NOT be used for case-SENSITIVE queries. You could always have two indexes, one on ENAME and one on UPPER(ENAME), but it would probably be more efficient to just have the function-based one and code:

SQL> select *
2 from EMP
3 where upper(ENAME) = upper(:b1)
4 and ENAME = :b1

for the times where you do not want case-insenstivity.

Thanks to (http://www.jlcomp.demon.co.uk/faq/case_insensitive_query.html)

Application Environment Setup Using /etc/profile.d/*

2005-04-14T14:49:00.000-07:00

When I learned Unix, there was /etc/profile. Then you had your own .profile script. But since then, we've got profile.d directory. Its cool. Evyerhting in there is run upon a new shell.

Rock and roll.

Application Environment Setup Using /etc/profile.d/*

Listutorial: Step by step CSS list tutorial

2005-04-14T09:01:00.000-07:00

Nice!

Listutorial: Step by step CSS list tutorial

Welcome to MSN.com

2005-02-24T14:27:00.000-08:00



         private void printAllParameters(HttpServletRequest request){

			Enumeration paramNames = request.getParameterNames();

			while(paramNames.hasMoreElements()) {

			  String paramName = (String)paramNames.nextElement();

			  System.out.println(paramName + "\n");

			  String[] paramValues = request.getParameterValues(paramName);

			  if (paramValues.length == 1) {

				String paramValue = paramValues[0];

				if (paramValue.length() == 0)

				  System.out.print("No Value");

				else

				System.out.print(paramValue);

			  } else {

				

				for(int i=0; i					System.out.println("*" + paramValues[i]);

				}

				System.out.println("-");

			  }

			}

		System.out.println("\n");

		  }

Introduction To Pivot Tables

2004-11-19T15:04:00.000-08:00

Man I've always hated getting bested by some excel wonk about Pivot Tables....ooooh. Now i have this. Watch out wannabes.

Introduction To Pivot Tables

Singletons with needles and thread

2004-11-04T13:08:00.000-08:00

Some more....
Singletons with needles and thread: "The singleton factory
The singleton factory creates the singleton instance and guarantees that there will be only one instance in the system at any given time.

Here's an implementation of a factory that will return the LogImpl:

public abstract class AbstractLogFactory {

private static AbstractLogFactory factory = new SystemLogFactory();

public static AbstractLogFactory getFactory() {
return factory;
}

public abstract LogSingleton log();

}

class SystemLogFactory extends AbstractLogFactory {

private static LogSingleton log = new LogImpl();

public LogSingleton log() {
return log;
}
}

If you program your objects to retrieve a factory only from the AbstractLogFactory, you can switch logs without changing the classes that use the factory. When a new log you wish to use comes along, simply create a subclass of AbstractLogFactory that instantiates the proper type of log and update AbstractLogFactory to return the proper factory type.

Thus, if you would rather return a FileLog, you could make the following changes:

public abstract class AbstractLogFactory {

private static AbstractLogFactory factory = new FileLogFactory();

public static AbstractLogFactory getFactory() {
return factory;
}

public abstract LogSingleton log();

}

class FileLogFactory extends AbstractLogFactory {

private static LogSingleton log = new FactoryLog ();

public LogSingleton log() {
return log;
}

}

This alternate approach to singleton creation proves more flexible than other approaches because you move the Singleton-pattern enforcement responsibility from the implementation and to another object. In fact, this approach's flexibility lets you change from returning a singleton to creating and returning multiple instances -- all without the rest of your program knowing."

Singleton

2004-11-04T13:06:00.000-08:00

Small review on singletons.

Singletons with needles and thread:



 public class Singleton {



    private static Singleton instance;

    

    public static Singleton getInstance() {

        if( instance == null ) {

            instance = new Singleton();

        }

        return instance;

    }

    

    private Singleton() {}



    public static void main( String [] args ) {

        Singleton instance = Singleton.getInstance();

        // ... manipulate instance

    }

  

}

Unfortunately, in the example above, a thread may at any time pre-empt the call to getInstance(). For example, a thread may pre-empt a running thread at instance = new Singleton. If that were to happen, multiple Singleton instances might instantiate, thus defeating the purpose of a singleton.

To make a singleton thread safe, you have two choices. The first simply synchronizes the getInstance() method:



public class Singleton {



    private static Singleton instance;

    

    public synchronized static Singleton getInstance() {

        if( instance == null ) {

            instance = new Singleton();

        }

        return instance;

    }

    

    private Singleton() {}



    public static void main( String [] args ) {

        Singleton instance = Singleton.getInstance();

        // ...

    }

}

Synchronizing the method guarantees that a call to the method cannot be interrupted.

The second approach to thread safety declares a constant Singleton attribute on the Singleton class itself:



public class Singleton {



    public final static Singleton instance = new Singleton();

    

    private Singleton() {}



    public static void main( String [] args ) {

        Singleton instance = Singleton.instance;

        // ...

    }

    

}

instance will initialize when the class loades. Both solutions guarantee only one Singleton will exist.

"

TWiki . People . SmellsToRefactorings

2004-11-01T13:55:00.000-08:00

My newest happy place is Refactoring to Patterns. There are some good books on it, well, one. Here's a web resource.

Patterns are good, but since most of us inherit designs rather than creating new ones, Refactoring to patterns has helped me grok the patterns value more quickly.

TWiki . People . SmellsToRefactorings

hash map iteration

2004-10-26T09:26:00.001-07:00

code snippet for iterating over a hash:



	HashMap map = new HashMap();

		map.put("key1", "value1");

		map.put("key2", "value2");

		// the only method of iterating over a list       

		for (Iterator i = map.keySet().iterator(); i.hasNext();) {

			String key2 = (String) i.next();

			String value2 = (String) map.get(key2);

			System.out.println(key2 + value2);



		}

regex

2004-10-26T09:26:00.000-07:00

Regular expressions are a new passion of mine. You have to use them until you can speak them. Matchmaking with regular expressions

Here is a nice statement to generate sql to do an update.

2004-10-26T09:24:00.000-07:00

Here is a nice statement to generate sql to do an update.



SELECT 'UPDATE COOKIE_TABLE SET cookiecost = ''' || cost || ''' WHERE userid = ' || userid || ';'

FROM cookie_table WHERE category = 'sugar cookies'

Note the use of the triple single quotes to do this. Another way is to do a select into, but often companies want to have a script that is repeatable, and this generates such a script. You run it, and in toad save the results in a text file.

XA and NonXA datasource

2004-10-26T09:20:00.000-07:00

XA and NonXA datasource

XA and NonXA datasource
Posted by: Mike Spille on September 11, 2003 in response to Message #95297 1 replies in this thread
An XA transaction, in the most general terms, is a "global transaction" that may span multiple resources. A non-XA transaction always involves just one resource.

An XA transaction involves a coordinating transaction manager, with one or more databases (or other resources, like JMS) all involved in a single global transaction. Non-XA transactions have no transaction coordinator, and a single resource is doing all its transaction work itself (this is sometimes called local transactions).

XA transactions come from the X/Open group specification on distributed, global transactions. JTA includes the X/Open XA spec, in modified form.

Most stuff in the world is non-XA - a Servlet or EJB or plain old JDBC in a Java application talking to a single database. XA gets involved when you want to work with multiple resources - 2 or more databases, a database and a JMS connection, all of those plus maybe a JCA resource - all in a single transaction. In this scenario, you'll have an app server like Websphere or Weblogic or JBoss acting as the Transaction Manager, and your various resources (Oracle, Sybase, IBM MQ JMS, SAP, whatever) acting as transaction resources. Your code can then update/delete/publish/whatever across the many resources. When you say "commit", the results are commited across all of the resources. When you say "rollback", _everything_ is rolled back across all resources.

The Transaction Manager coordinates all of this through a protocol called Two Phase Commit (2PC). This protocol also has to be supported by the individual resources.

In terms of datasources, an XA datasource is a data source that can participate in an XA global transaction. A non-XA datasource generally can't participate in a global transaction (sort of - some people implement what's called a "last participant" optimization that can let you do this for exactly one non-XA item).

For more details - see the JTA pages on java.sun.com. Look at the XAResource and Xid interfaces in JTA. See the X/Open XA Distributed Transaction specification. Do a google source on "Java JTA XA transaction".

-Mike

quote

2004-10-14T08:16:00.000-07:00

"Before the beginning of great brilliance, there must be chaos. Before a brilliant person begins something great, they must look foolish in the crowd." -- I Ching

A Cup of Joe

2004-10-12T07:32:00.000-07:00

This is where I'll blog snippets of code that I learn, or need to repeat. I'll be adding lots.

First, basic number translations.

    

long yyy = 3849L;

String xxx = Long.toString(yyy);