The syntax:
SELECT [ DISTINCT | ALL ] { * | <select list> }
FROM <table reference> [ { , <table reference> } . . . ]
[ WHERE <search condition> ]
[ GROUP BY <grouping specification> ]
[ HAVING <search condition> ]
[ ORDER BY <order condition> ]
The evaluation:
● FROM clause
● WHERE clause (optional)
● GROUP BY clause (optional)
● HAVING clause (optional)
● SELECT clause
● ORDER BY clause (optional)
Wednesday, May 30, 2007
Saturday, May 26, 2007
Researching week...
Since we didn't get the requitment for next release, so we spend the whole week to do some reseaches about the technology we are using.
BIRT chart
I think design a simple chart in BIRT is very easy job. As we might introduce some charts for the project in the following release, I think preparing good SQL querys turns out to be more challege.
JBoss Portal
I learned how to configure portlet and portal page. The configurations are all basiced on XML files, such as configuring servlet in web.xml, they're *-objects.xml, *-portlet.xml.
I ignored the *-instance.xml which mentioned in JBoss Portal Reference because I found those configures can be placed into *-objects.xml. I got this idea by looking through several config files both in JBoss Portal and Pentaho(PCI). So till now I knowed how Pentaho add a new Portal instead of the default one.
QUESTION: how different portlet windows conmmunicate? For instance, the Pentaho dashboard portal page.
Pentaho Component
This's a good extended point in Pentaho. Create a custome component following(which word is suitable here? ) Pentaho API, do anything we want to, interesting, isn't it?
I created a component to read a specific row and a specific column value from SQL result set. I wondered whether Pentaho has already implemented this functionality?
I also modified the BIRT component to read BIRT design files dynamicly by the input parameter and of course I think about if there is a better way.
QUESTION: How to use the JBoss login-modul? What I want to do is that create a component and it call the JBoss login-module to do something. Such as when log in JBoss Portal, it will call the login-modul to determine if the username/password are both correct.
Integrate JOSSO into Pentaho-GA-1.2.0
As JOSSO 1.5 supports JBoss AS 4.0.5, I think it should work well in JBoss AS 4.0.4 which Pentaho-GA-1.2.0 used. It seemed that everything went well and I also could login JOSSO with the LDAP configuration. But I failed to integrate it with partner application. Very confused when I saw that NullPointerException!
Anyone has ideas?
JNDI in Pentaho-GA-1.2.0
I want to add a JNDI not only for Pentaho action sequence, but BIRT reports. I add a JNDI following examples in Pentaho and used a simple servlet to make sure it's ok.(also could find the added JNDI in ../portal/jmx-console/JNDIView). Then I modified the oda-datasource config value in BIRT report, added the 'jndiname' value and used a wrong password for JDBC connection. It said if the 'jndiname' value is offered in BIRT report, BIRT will try to get datasource through JNDI first. It's indeed. And I also placed a file ' jndi.properties' into the plugin/oda-jdbc-driver directory with empty content.
With any luck, reports could show up value successfully. But a exception background. Again, very confused.
Any ideas?
All configuration below are not excat because I couldn't remember them.
BIRT datasource config:
org....mysql.driver> </property>
<property name="odaUrl>jdbc:mysql:.. 192.168.77.82/ppdev</property>
<property name="odaUser>correct-user-name </property>
<property name="odaPassword">wrong-pwd</property>
<property name="odaJndiName">java:/PentahoMysqlDs</property>
JNDI config:
its value was as the same as those values of JDBC config above but with a correct password.
Exception backgroud:
couldn't connect with 'ppdevadmin@192.168.77.81 (password:YES)'.
192.168.77.81 is my machine's IP.
192.168.77.82 is a sever with the MySQL running.
Take some time in researching after delivery should be a good idea. But not too long, I wish.
BIRT chart
I think design a simple chart in BIRT is very easy job. As we might introduce some charts for the project in the following release, I think preparing good SQL querys turns out to be more challege.
JBoss Portal
I learned how to configure portlet and portal page. The configurations are all basiced on XML files, such as configuring servlet in web.xml, they're *-objects.xml, *-portlet.xml.
I ignored the *-instance.xml which mentioned in JBoss Portal Reference because I found those configures can be placed into *-objects.xml. I got this idea by looking through several config files both in JBoss Portal and Pentaho(PCI). So till now I knowed how Pentaho add a new Portal instead of the default one.
QUESTION: how different portlet windows conmmunicate? For instance, the Pentaho dashboard portal page.
Pentaho Component
This's a good extended point in Pentaho. Create a custome component following(which word is suitable here? ) Pentaho API, do anything we want to, interesting, isn't it?
I created a component to read a specific row and a specific column value from SQL result set. I wondered whether Pentaho has already implemented this functionality?
I also modified the BIRT component to read BIRT design files dynamicly by the input parameter and of course I think about if there is a better way.
QUESTION: How to use the JBoss login-modul? What I want to do is that create a component and it call the JBoss login-module to do something. Such as when log in JBoss Portal, it will call the login-modul to determine if the username/password are both correct.
Integrate JOSSO into Pentaho-GA-1.2.0
As JOSSO 1.5 supports JBoss AS 4.0.5, I think it should work well in JBoss AS 4.0.4 which Pentaho-GA-1.2.0 used. It seemed that everything went well and I also could login JOSSO with the LDAP configuration. But I failed to integrate it with partner application. Very confused when I saw that NullPointerException!
Anyone has ideas?
JNDI in Pentaho-GA-1.2.0
I want to add a JNDI not only for Pentaho action sequence, but BIRT reports. I add a JNDI following examples in Pentaho and used a simple servlet to make sure it's ok.(also could find the added JNDI in ../portal/jmx-console/JNDIView). Then I modified the oda-datasource config value in BIRT report, added the 'jndiname' value and used a wrong password for JDBC connection. It said if the 'jndiname' value is offered in BIRT report, BIRT will try to get datasource through JNDI first. It's indeed. And I also placed a file ' jndi.properties' into the plugin/oda-jdbc-driver directory with empty content.
With any luck, reports could show up value successfully. But a exception background. Again, very confused.
Any ideas?
All configuration below are not excat because I couldn't remember them.
BIRT datasource config:
<property name="
<property name="
<property name="odaPassword">wrong-pwd</property>
<property name="odaJndiName">java:/PentahoMysqlDs</property>
JNDI config:
its value was as the same as those values of JDBC config above but with a correct password.
Exception backgroud:
couldn't connect with 'ppdevadmin@192.168.77.81 (password:YES)'.
192.168.77.81 is my machine's IP.
192.168.77.82 is a sever with the MySQL running.
Take some time in researching after delivery should be a good idea. But not too long, I wish.
Tuesday, May 22, 2007
Sunday, May 20, 2007
International Developer Conference (second day)
The first section this day is about SAAS. The guy spend lots of time introducing a platform designed by Alibaba.
And I didn't find much interesting.
The second one is talking about the search engine and looking forward its future.
At third section, distinguished Engineer Mark Harpner from Sun Microsystems Inc. shared several products for implementing SOA.
Then Ben Wang from JBoss showed several JBoss open source project in SOA area.
The last section I went for that about Oracle presented by a famous DBA in Alibaba and also in China.
Key words: SAAS, Oracle, SOA.
Now the conference was closed and what I gain from these two days in the conference?
And I didn't find much interesting.
The second one is talking about the search engine and looking forward its future.
At third section, distinguished Engineer Mark Harpner from Sun Microsystems Inc. shared several products for implementing SOA.
Then Ben Wang from JBoss showed several JBoss open source project in SOA area.
The last section I went for that about Oracle presented by a famous DBA in Alibaba and also in China.
Key words: SAAS, Oracle, SOA.
Now the conference was closed and what I gain from these two days in the conference?
Saturday, May 19, 2007
China International Developer Conference
首�弥����W�j工程���b客行大�� 暨中��互���W技�g精英����
This conference is arranged by Alibaba in Hang Zhou, China. Today is the first day.
In the morning, the first presentation was taken by Rasmus Lerdorf who is the father of PHP.
And the second guy is Jermy Zawodny,also a extreme famous from Yahoo Inc. and an expert in Yahoo search engine.
I couldn't totally follow what they were talking without translation. But it's fine.
Because I think that listening their talking was an interesting thing.
In the afternoon, I attend two sections. One is about Java by Robin from JavaEye and the other is workflow with jBPM by Ben Wang from JBoss.
Since I learned jBPM just for about two months, I found the content of the second section more interesting.
IMHO, two sections for a afternoon is much better than three and increase the time for asking questions.
What might be studied in future:
PHP, RoR, Rest, JBoss Rules.
This conference is arranged by Alibaba in Hang Zhou, China. Today is the first day.
In the morning, the first presentation was taken by Rasmus Lerdorf who is the father of PHP.
And the second guy is Jermy Zawodny,also a extreme famous from Yahoo Inc. and an expert in Yahoo search engine.
I couldn't totally follow what they were talking without translation. But it's fine.
Because I think that listening their talking was an interesting thing.
In the afternoon, I attend two sections. One is about Java by Robin from JavaEye and the other is workflow with jBPM by Ben Wang from JBoss.
Since I learned jBPM just for about two months, I found the content of the second section more interesting.
IMHO, two sections for a afternoon is much better than three and increase the time for asking questions.
What might be studied in future:
PHP, RoR, Rest, JBoss Rules.
Sunday, May 13, 2007
The May Holiday
放假那天看了张学友的2007世界巡回演唱会，效果一般，大概是坐的太远了，索性没兴趣欣赏歌曲，找个机会溜进了内场，挤到最前面看他表演，也算是一睹真容.^^
其实每次放假都是想待在杭州的，可以整理些东西，房间，书，电脑，不像回家去，吃喝，睡觉，聊天娱乐，基本上就这么过去了。也许这样也好，算作休息，
本来一年里待在家里的时间就没多少，和朋友碰面的机会自然也少，整理的事情应该随时安排掉。
似乎已经跟不上家里那些朋友们的言语了，不再真话，是实话，带几分虚；
我不大相信说者无心，听者有意的事情，所以我认为被间那个总是把兄弟挂在嘴上的兄弟间接的骂了一次；
还有一位朋友把同一个东西对不同的人说了不同的价格，很是不解为何如此，意在何为？心里寒阿！
'突然'发现一些朋友原来那么有钱，也不过工作了同样长的时间，而我却...; '突然'发现家里经济状况不乐观，而我却素手无策.
Maybe what I can do is only keeping learning something, English, technology and something else.
And I even have no planning for the next. So terrible!
其实每次放假都是想待在杭州的，可以整理些东西，房间，书，电脑，不像回家去，吃喝，睡觉，聊天娱乐，基本上就这么过去了。也许这样也好，算作休息，
本来一年里待在家里的时间就没多少，和朋友碰面的机会自然也少，整理的事情应该随时安排掉。
似乎已经跟不上家里那些朋友们的言语了，不再真话，是实话，带几分虚；
我不大相信说者无心，听者有意的事情，所以我认为被间那个总是把兄弟挂在嘴上的兄弟间接的骂了一次；
还有一位朋友把同一个东西对不同的人说了不同的价格，很是不解为何如此，意在何为？心里寒阿！
'突然'发现一些朋友原来那么有钱，也不过工作了同样长的时间，而我却...; '突然'发现家里经济状况不乐观，而我却素手无策.
Maybe what I can do is only keeping learning something, English, technology and something else.
And I even have no planning for the next. So terrible!
Subscribe to:
Posts (Atom)
