Monday, November 29, 2010

@schedule_uid is not a parameter for procedure sp_add_jobschedule

I received this error when trying to copy a SQL job from one server to another, by trying to script out the create statement:

Msg 8145, Level 16, State 1, Procedure sp_add_jobschedule, Line 0

@schedule_uid is not a parameter for procedure sp_add_jobschedule



The problem is that the parameters for the stored procedure, sp_add_jobschedule, have changed from SQL2005 to SQL2008, so you need to change the script to match.

- SQL 2005 uses @schedule_id (an integer) and SQL 2008 uses @schedule_uid (a uniqueidentifier)


- All you have to do is change the parameter name and data-type to the correct value
    If it's @schedule_uid, change it to @schedule_id.
    Then, find an un-used integer value in: select * from sysjobschedules (MSDB database)

- If you are going the other way, you can change the parameter to @schedule_uid, then create a new
   uniqueidentifier by running:  select newid()

Friday, November 26, 2010

Grails Bootstrapping Issue

I'm sure this is a newbie issue, but it's interesting to me.

I've created the Race applications from the book, "Getting Started With Grails, 2nd Edition" by Jason Rudolph.  After creating the Runner domain class, I add "package racetrack", then I try to bootstrap some data.



   1:  class BootStrap {
   2:  def init = { servletContext ->
   3:  def jane = new Runner(firstName:'Jane',lastName:'Doe')
   4:  jane.save()
   5:  }
   6:  def destroy = {}
   7:  }

But, when I run the application, I don't get any data populated and no error.

The answer was in #GRAILS-3842.  In order to create the data, you MUST set the values for "ALL PROPERTIES THAT ARE NOT NULLABLE".

So, when you create a new Runner(), you must supply values for all properties or mark the properties as "nullable:true".  Also, there is a new parameter for the save() method, save(failOnError:true).  This will cause the compilation to fail if the save() method in Bootstrap does not work.

Here is the new code:


   1:  class Runner {
   2:   
   3:  static constraints = {
   4:      firstName(blank:false)
   5:      lastName(blank:false)
   6:      dateOfBirth(nullable:true)
   7:      gender(inList:["M", "F"])
   8:      address(nullable:true)
   9:      city(nullable:true)
  10:      state(nullable:true)
  11:      zipcode(nullable:true)
  12:      email(email:true)
  13:  }
  14:  static hasMany = [registrations:Registration]
  15:      String firstName
  16:      String lastName
  17:      Date dateOfBirth
  18:      String gender
  19:      String address
  20:      String city
  21:      String state
  22:      String zipcode
  23:      String email
  24:      String toString(){
  25:          "${lastName}, ${firstName} (${email})"
  26:      }
  27:   
  28:   
  29:   
  30:   
  31:   
  32:   
  33:  class BootStrap {
  34:   
  35:      def init = { servletContext ->
  36:          def jane = new Runner(firstName:'Jane', lastName:'Doe', gender:'F',city:'Atlanta',state:'GA',email:'jane@toto.com')
  37:          jane.save(failOnError:true)
  38:          def joe = new Runner(firstName:'Joe', lastName:'Blow', gender:'M',city:'Atlanta',state:'GA',email:'joe@toto.com')
  39:          joe.save(failOnError:true)
  40:          def larry = new Runner(firstName:'Larry', lastName:'Eisenstein', gender:'M',city:'Lilburn',state:'GA',email:'larrye@toto.com')
  41:          larry.save(failOnError:true)
  42:   
  43:      }  
  44:   

Tuesday, November 16, 2010

Delete files based on Last Modified Date using FORFILES.exe

Deleting files based on last modified date or running some command on these files has been a real sticking point for Windows users.  Unix/Linux people would always hold some of those cool command line features over our heads to prove why Linux is better than Windows.

Windows Server 2000/2003/2008 has a command called ForFiles.exe (http://technet.microsoft.com/en-us/library/cc753551(WS.10).aspx).  This is a great tool once you get used to the sytnax.  You can find files based on Last Modified Date, then run a command(like del) on each of those files.


FORFILES  /P  E:\MSSQL\Backup  /S  /M  *.full.zip   /D -30   /C  “cmd  /c  del  @path”


/S – look at subdirectories
*.full.zip – that is the file pattern, you could have it be like *.txt for example
/D -30 = files greater than 30 days
/C – thats the command you want to run





Here is what I use in my SQL script:

   1:    declare @full_location varchar(8000)
   2:    SET @full_location = @backup_location + @backup_db_name 
   3:    SET @command = 'forfiles -p "' + @full_location + '" -s -m *.full.zip -d -1 -c "cmd /c move /y @path "' + @archive_destination
   4:    print @command
   5:    EXEC xp_cmdshell @command, NO_OUTPUT
   6:    --print @command
   7:   

I don't know why this isn't in Windows XP.  This is a great tool

Sunday, November 14, 2010

Deactivate Netflix on PS3

This has nothing to do with programming, but I just found a couple great tricks if you are having issues with your Netflix account on your PS3.


Deactivate Netflix from your PS3
1. Click the Netflix application
2. As soon as you do, hold Start & Select at the same time
3. This will allow you to deactivate Netflix from the PS3


Reset your Netflix account on the PS3
1. Start the Netflix account
2. You will be in the movie selections area(don't worry, this will work)
3. With the DPAD, hit these buttons:
UP, UP, DOWN, DOWN, LEFT, RIGHT, LEFT, RIGHT, UP, UP, UP, UP

4. VIOLA!!!  You can now log on as a different user.

Friday, November 12, 2010

Java Sorting: Comparator vs Comparable

I thought I'd repost this because it helped me a lot.  This article is by Kamal Mettananda and the link is: http://lkamal.blogspot.com/2008/07/java-sorting-comparator-vs-comparable.html

I just wanted to copy it in case this link disappears.  Thanks Kamal!


Java Comparators and Comparables? What are they? How do we use them? This is a question
we received from one of our readers. This article will discuss the java.util.Comparator
and java.lang.Comparable in details with a set of sample codes for further
clarifications.




Prerequisites


  • Basic Java knowledge



System Requirements


  • JDK installed



What are Java Comparators and Comparables?

As both names
suggest (and you may have guessed), these are used for comparing objects in Java. Using
these concepts; Java objects can be

sorted according to a predefined order.



Two of these concepts can be explained as follows.


Comparable

A comparable object is capable of comparing
itself with another object. The class itself must implements the java.lang.Comparable
interface in order to be able to compare its instances.




Comparator

A comparator object is capable of comparing
two different objects. The class is not comparing its instances, but some other
class's instances. This comparator class must implement the
java.util.Comparator interface.




Do we need to compare objects?

The simplest answer is yes. When there is a
list of objects, ordering these objects into different orders becomes a must in some
situations. For example; think of displaying a list of employee objects in a web page.
Generally employees may be displayed by sorting them using the employee id. Also there
will be requirements to sort them according to the name or age as well. In these
situations both these (above defined) concepts will become handy.




How to use these?

There are two interfaces in Java to
support these concepts, and each of these has one method to be implemented by
user.

Those are;



java.lang.Comparable: int compareTo(Object o1)

This method compares this object with o1 object. Returned int value has the following
meanings.

  1. positive : this object is greater than o1
  2. zero : this object equals to o1
  3. negative : this object is less than o1


java.util.Comparator: int compare(Object o1, Objecto2)

This method compares o1 and o2 objects. Returned int value has the following meanings.

  1. positive : o1 is greater than o2
  2. zero : o1 equals to o2
  3. negative : o1 is less than o1


java.util.Collections.sort(List) and java.util.Arrays.sort(Object[])
methods can be used to sort using natural ordering of objects.

java.util.Collections.sort(List, Comparator) and
java.util.Arrays.sort(Object[], Comparator) methods can be used if a Comparator
is available for comparison.



The above explained Employee example is a good candidate for explaining these two
concepts. First we'll write a simple Java bean to represent the
Employee.




public class Employee {
    private int empId;
    private String name;
    private int age;

    public Employee(int empId, String name, int age) {
        // set values on attributes
    }
    // getters & setters
}


Next we'll create a list of Employees for using in different sorting
requirements. Employees are added to a List without any specific order in the following
class.




import java.util.*;

public class Util {
    
    public static List<Employee> getEmployees() {
        
        List<Employee> col = new ArrayList<Employee>();
        
        col.add(new Employee(5, "Frank", 28));
        col.add(new Employee(1, "Jorge", 19));
        col.add(new Employee(6, "Bill", 34));
        col.add(new Employee(3, "Michel", 10));
        col.add(new Employee(7, "Simpson", 8));
        col.add(new Employee(4, "Clerk",16 ));
        col.add(new Employee(8, "Lee", 40));
        col.add(new Employee(2, "Mark", 30));
        
        return col;
    }
}



Sorting in natural
ordering

Employee's natural ordering would be done according to
the employee id. For that, above Employee class must be altered to add the comparing
ability as follows.




public class Employee implements Comparable<Employee> {
    private int empId;
    private String name;
    private int age;
    
    /**
     * Compare a given Employee with this object.
     * If employee id of this object is 
     * greater than the received object,
     * then this object is greater than the other.
     */
    public int compareTo(Employee o) {
        return this.empId - o.empId ;
    }
    
}


The new compareTo() method does the trick of implementing the natural ordering of the
instances. So if a collection of Employee objects is sorted using
Collections.sort(List) method; sorting happens according to the ordering done inside
this method.



We'll write a class to test this natural ordering mechanism.
Following class use the Collections.sort(List) method to sort the given list in natural
order.




import java.util.*;

public class TestEmployeeSort {
    
    public static void main(String[] args) {     
        List coll = Util.getEmployees();
        Collections.sort(coll); // sort method
        printList(coll);
    }
    
    private static void printList(List<Employee> list) {
        System.out.println("EmpId\tName\tAge");
        for (Employee e: list) {
            System.out.println(e.getEmpId() + "\t" + e.getName() + "\t" + e.getAge());
        }
    }
}


Run the above class and examine the output. It will be as follows. As you can see, the
list is sorted correctly using the employee id. As empId is an int value, the employee
instances are ordered so that the int values ordered from 1 to 8.




EmpId Name Age
1 Jorge 19
2 Mark 30
3 Michel 10
4 Clerk 16
5 Frank 28
6 Bill 34
7 Simp 8
8 Lee 40



Sorting by other fields

If we need to sort using other
fields of the employee, we'll have to change the Employee
class's compareTo() method to use those fields. But then
we'll loose this empId based sorting mechanism. This is not a good
alternative if we need to sort using different fields at different occasions. But no
need to worry; Comparator is there to save us.



By writing a class that implements the java.util.Comparator interface, you can sort
Employees using any field as you wish even without touching the Employee class itself;
Employee class does not need to implement java.lang.Comparable or java.util.Comparator
interface.


Sorting by name field

Following EmpSortByName class is used to sort
Employee instances according to the name field. In this class, inside the compare()
method sorting mechanism is implemented. In compare() method we get two Employee
instances and we have to return which object is greater.




public class EmpSortByName implements Comparator<Employee>{

    public int compare(Employee o1, Employee o2) {
        return o1.getName().compareTo(o2.getName());
    }
}


Watch out: Here, String class's compareTo() method is used in
comparing the name fields (which are Strings).



Now to test this sorting mechanism, you must use the Collections.sort(List, Comparator)
method instead of Collections.sort(List) method. Now change the TestEmployeeSort class
as follows. See how the EmpSortByName comparator is used inside sort method.




import java.util.*;

public class TestEmployeeSort {
    
    public static void main(String[] args) {
        
        List coll = Util.getEmployees();
        //Collections.sort(coll);
        //use Comparator implementation
        Collections.sort(coll, new EmpSortByName());
        printList(coll);
    }
    
    private static void printList(List<Employee> list) {
        System.out.println("EmpId\tName\tAge");
        for (Employee e: list) {
            System.out.println(e.getEmpId() + "\t" + e.getName() + "\t" + e.getAge());
        }
    }
}


Now the result would be as follows. Check whether the employees are sorted correctly by
the name String field. You'll see that these are sorted
alphabetically.




EmpId Name Age
6 Bill 34
4 Clerk 16
5 Frank 28
1 Jorge 19
8 Lee 40
2 Mark 30
3 Michel 10
7 Simp 8

Sorting by empId field

Even the ordering by empId (previously done using
Comparable) can be implemented using Comparator; following class

does that.




public class EmpSortByEmpId implements Comparator<Employee>{

    public int compare(Employee o1, Employee o2) {
        return o1.getEmpId() - o2.getEmpId();
    }
}



Explore further

Do not stop here. Work on the followings
by yourselves and sharpen knowledge on these concepts.


  1. Sort employees using name, age, empId in this order (ie: when names are equal,
    try age and then next empId)
  2. Explore how & why equals() method and compare()/compareTo() methods must be
    consistence.