If you need Tibco in your every day work, you should take a look at this reminder of Tibco offers with a schort description

http://javarevisited.blogspot.fr/2010/10/upcoming-tibco-tutorials.html

The menu :

• 1. Difference between RVD and RVRD.
• 2. Difference between Tibco EMS and Tibco RV
• 3. Reliable vs Certified messaging in Tibco RV
• 4. Publish Subscribe vs Request Reply messaging.
• 5. Tibco Hawk
• 6. Using Tibco API in Java
• 7. Using Tibco API in C++
• 8.Low level implementation of Tibco
• 9. Tibco Rendezvous issues
• 10. Tibco Advisory messages

I have a beginner level at oracle, I can write queries and stored procedure but as in Java I like to know precisely the language and the system I use. In my mission I discovered some noob details about Oracle that I must admit, I did not know.

Select * Paradigm

When I worked with Sybase, SQL Server or MySQL and tried to extract multiple column, I have the habbit to put the most important columns at the beginning of my request such as

Initial request that show me the most important column at first position and all other information (JOB_NAME is only in one table) :

 SQL | 
 copy code |
?
 
1
SELECT  JOB_NAME, p.* FROM jobstatetreatments j, prismjobs p WHERE j.job_id = p.job_id AND j.job_id ...

With Oracle, this will not work  :

ORA-00936: expression absente

00936. 00000 -  “missing expression”

…. the solution is to prefix all data, by their table name or aliases

 SQL | 
 copy code |
?
 
1
SELECT  p.JOB_NAME, j.*, p.* FROM jobstatetreatments j, prismjobs p WHERE j.job_id = p.job_id ..

I really would like to ask a DBA why Oracle did not provide that easy way to query data.

ORDERBY / ROWNUM Observation

How can you select the highest value? Once again if you try to query Oracle as in regular SQL command you may try this.

Let’s say that we have those values in the table myTable

• myTable
  • col1
    • 5
    • 7
    • 3
    • 9
    • 10
    • 11

 SQL | 
 copy code |
?
 
1
SELECT * FROM myTable WHERE ROWNUM <= 3 ORDER BY col1 DESC;

• col1
  • 7
  • 5
  • 3

Oracle first treats the rownum criteria to extract values then it sorts the list. So the solution is to separate the order by criteria from the rownum criteria.

 SQL | 
 copy code |
?
 
1
SELECT * FROM (SELECT * FROM myTabme ORDER BY col1 DESC) WHERE ROWNUM <= 3;

• col1
  • 11
  • 10
  • 9

   

You may encounter trouble when comparing double value to string values, when you compare CSV values that are related to the system :   expected (for a US system): 100.50 and actual testing (With a FR system) : 100,50

Java and locale behaviour on Windows

The JVM rely on the Windows locale configuration but it does not rely on advanced configuration or personalization. It means that in our case if you have a French configuration but changes the decimal parameter to use the dot. It would not work with java. You need to change the entire localization option (to English for instance).

I would rather find a solution to specify the locale for all JUnit tests. Sorry! There is no portable way to set the JUnit locale. You must define it specifically.

With Eclipse.

on your JUnit tests launch configuration add to vm args  :

−Duser.language=en

With Maven

1
2
3
4
5
6
7
8

>
    >org.apache.maven.plugins>
    >maven-surefire-plugin>
    >2.9>
    >
        >-Duser.language=en>
    >
>

In this article, I will show you how to quickly implement unit tests with mockito. This is fast and simple.  From its web site : “Mockito library enables mocks creation, verification and stubbing.”. Which means that all underlying external services behaviour can be customized. It’s very easy to create clean and simple unit tests with that framework.

More information at :

• http://code.google.com/p/mockito/
• http://refcardz.dzone.com/refcardz/mockito

This is the configuration I will create and the interface StringConfigService represents the service I want to test :

Continue reading