Lamia's stack and heap based memories...

I'm currently suffering from a terrible back pain... I wasn't able to get much sleep before my examination day because I was so nervous and afraid that I would fail. God on the other hand, was very forgiving and in spite all the sins I've done he still answered my prayers(during the exam) and I passed with a passing score of 79% (57 / 79). I'm so proud that I passed the exam, it was the fruit of my hard work. For those who are planning to take the exam I would recommend:

- Buying K & B Study guide for Java 5

- Examulator (Marcus Green's) simulator

- Eat a lot of peanuts(the one which has lots of proteins)

- Drink lots of water before your exam, be sure you don't drink too much that you'd have to pee all the time...

- Eat some meat, TAPSILOG did great for me. :)

- Get some sleep(I didn't, don't follow my example on this)

- Fix whatever issue you have to fix with your girlfriend (I was caught up in a fight and that added to my stress factor)
 

I really wanted to score higher, around 90%. Unfortunately I wasn't good enough to score that high. But I'm happy I passed.
 

The thing I hate about SQLServer is that it gives me too much headache whenever I use it with Java. Since I already had share of of those from my last company, I already had some precautions.

• Use jtds driver
• Enable TCP/IP on default port 1433
• For SQLServer 2000 be sure to atleast upgrade to SP4
• And many others

Last night I wanted to test the CRUD feature of netbeans 5.5. I needed to generate Entity Classes from the database using one of the wizards. However, although I was able to connect to the database it didn't list the list of tables. I tried to check my JDBC url. I had to set this through the connetion property at the runtime view BTW.

jdbc:jtds:sqlserver://127.0.0.1:1433/ - OK
net.sourceforge.jtds.jdbc.Driver - OK

 
It took me until today to figure out and remember that my friend Sam set my username as an alias of dbo. What is dbo BTW? Like I care...

Anyway, in the connection properties my schema was set to wpinventorydb which was the name of my database. After a few trial and error I noticed that when I try to create a table through the runtime view (which failed BTW) the error message would say something like:

Unable to execute command:

create table "wpinventorydb."tablename"
{

    "id" TINYINT 
}
 

Hmmm... "wpinventorydb."tablename".... That rings a bell. I remember when I created a database through the SQL Server Management Studio(I'm using SQLServer  2005) my tables were saved with a name prefixed by dbo. So I just changed the schema from the connection properties from wpinventorydb to dbo then I became happy. I'm not sure of the reason why, but it did the job.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 

public class Employee implements Comparable<Employee>
{
    private String name;
    private int age;

    public Employee(String name, int age)
    {
        this.name = name;
        this.age = age;
    }

    public int compareTo(Employee e)
    {
        //comparison strategy
    }


}

1
2
3
4
5
6
7
8
9
10
11
12
13
 

public class Main
{
    public static void main(String[] args)
    {
        List<Employee> employeeList = new ArrayList<Employee>();
        employeeList.add( new Employee("Tim", 10) );
        employeeList.add( new Employee("Rolvin", 11) );
        employeeList.add( new Employee("Gerald", 12) );

        Collections.sort(employeeList);
     
    }
}

1
2
3
4
5
6
7
 

public class SortByName implements Comparator<Employee>
{
    public int compare(Employee e1, Employee e2)
    {
         //comparison strategy here
    }
}

1
2
3
4
5
6
7
 

public class SortByAge implements Comparator<Employee>
{
    public int compare(Employee e1, Employee e2)
    {
         //comparison strategy here
    }
}

1
2
3
4
5
6
7
8
9
10
11
 
public static void main(String[] args)
{
    List<Employee> employeeList = new ArrayList<Employee>();
    employeeList.add( new Employee("Tim", 10) );
    employeeList.add( new Employee("Rolvin", 11) );
    employeeList.add( new Employee("Gerald", 12) );
 
    Collections.sort(employeeList, new SortByName() );//sort by name;
    Collections.sort(employeeList, new SortByAge() );//sort by age;        
     
}