FanaticZine

Are you experiencing the same problem as the title ? are you working with a MySQL DB server. Then the cause for this problem is. The MySQL driver remove it’s connection from the connection pool due to inactivity after few hours if the server is not processing anything though the db connection.

There is a solution introduced in the Pentaho forum for this, you can find the thread with the following link.

http://forums.pentaho.com/showthread.php?54939-Pentaho-Server-falls-each-night-..&p=178067#post178067

But above forum post is based on the JBoss server. My intention with this post is to implement the same on the tomcat server since the file structure is a bit different. Ok without further due, let get into action.

01.    Download the C3P0 driver from SourceForge
02.    Extract the  c3p0-0.9.1.2.jar file into \biserver-ce\tomcat\common\lib\
03.    Open the mysql5.hibernate.cfg.xml XML file in the \biserver-ce\pentaho-solutions\system\hibernate\ folder
04.    Add the following code into the file

<!— hibernate c3p0 settings —>

<property name=”connection.provider_class”>org.hibernate.connection.C3P0ConnectionProvider</property>
<property name=”hibernate.c3p0.acquire_increment”>3</property>
<property name=”hibernate.c3p0.idle_test_period”>10</property>
<property name=”hibernate.c3p0.min_size”>5</property>
<property name=”hibernate.c3p0.max_size”>75</property>
<property name=”hibernate.c3p0.max_statements”>0</property>
<property name=”hibernate.c3p0.timeout”>25200</property>
<property name=”hibernate.c3p0.preferredTestQuery”>select 1</property>
<property name=”hibernate.c3p0.testConnectionOnCheckout”>true</property>

05.    Save and Restart the B.I Server or Service

That should do the trick…

( When you are editing the XML file, please be careful with the quotation characters )

Newest Upgrade to my work, this an unboxing review of the Behringer PodCast Studio Firewire Version. Hope you guys will find this useful and please leave any questions as I would be happy to answer. And Pros please leave comments with Tips & Tricks as I would like to learn from you Thanks

**** Please make sure you install the latest drivers for the firewire interface from the Behringer site.

Behringer product page for this package.
http://www.behringer.com/EN/Products/PODCASTUDIO-FIREWIRE.aspx

This human body, It’s blood and flesh,
one day will have to leave it into dust and leave this place ,
till that day it’s a short ride and why all these hating, separatism  and complications ?…
enjoy the journey with the small things you have, rather worrying about big things that you cant have…

Live your dream, enjoy working  hard for it, but do not make your own  dream your suffering…. and stand straight when challenged..

(Thank you Mome.. for teaching that to me… you are my biggest inspiration  )

it’s almost 1:00 AM in the morning.. Just thought to let you guys know that I will not be able to upload my mixdownz on YouTube, since YouTube doesn’t like uploading copyright stuff.. so for now i’m stopping uploading them here.. but later somewhere in a corner on the internet.. you’ll be able hear them..

Hey Guys,
Couldn’t write anything new, since I was busy for the last few days. well could not try much things as well because of the same reason. I was back at home a few days back and I came across this  little incident, so I caught that with my phone. bunch of ants trying get their “just found” food  home. I know this is just a normal thing, but it’s still amusing to look at it. and I accept ants could be very painful insects, but very encouraging creatures as well. check it out…

Another remake done by me

Today in the morning when I was checking the news paper, I went through shocking news. The news was about a Mother who threw her 4 years old child to the “Kalu Ganga”, the river which meets the sea from Kaluthara. The child was rescued by a truck driver and has being admitted to the hospital. Good job Mr. Truck Driver (I don’t your name ), Some times Gods angels comes for rescue in many faces. I thank God for that.

According the news paper the mother refused to accept her crime by saying the she left the child at the “Bo” tree, but later admitted and has being arrested by the Police.

After I read this message, I was thinking to myself, what’s happening to this world. Why these people are losing their mind and act all crazy. I mean it is human nature that you get irritated and angry, but if you don’t control it sometime it could end with a shocking crime.

I’m sure that mother had a difficult life situation (According to the news paper she is), but taking a life of a human is insane.

I think as the technology grows as our lives get busy, we are being carried away with our daily routines and sometimes we forget that we are humans. The foundation of our humanity which fed from the day we were born into our soul is our religion. In every religion in this world teaches that human life is secret and taking a life is a greater sin.

Our lives have become a hot pursuit, from the very first day that we go to our school or to the primary school; our parents or we setup a goal for us. To become an Engineer, Doctor or Company Owner, that’s fine, every person should have a goal in their life. But what about being a good Human who Love and Respect the humanity. Won’t it solve many of these social issues that we are having in our society? , we can be the best educated person in the world but what is the use of it, if we don’t have our humanity within us.

One could argue by saying this world is cruel and wicked, being good will not help us to live in peace, but live by the way that the society is will take us at least a few miles more.

If we carried ourselves in that conduct, none of us will have any peaceful life until death. Neither the future generation. In every religious teaching, it teaches us, the hate will never end with more hate, but love will put an end to hate. The answer for the hate is love, the fire can be only be put off by water not with more fire.

Building up our spiritual foundation will restore our humanity; with humanity we can save the world.

It’s not we have to do it, but I have to do it…

Search not more ! here it is

01.  First you might want to, download the proper JDBC Driver from the Sybase website. download the ZIP file and find the jconn.jar file which is located in the \ jConnect-6_0\classes folder.
02.  Place the jconn.jar file in your {Kettle Folder}\libext\JDBC\ folder

Kettle installation\libext\JDBC folder

And now the database settings.

03.  Start Kettle, and bring up your DB settings window, and configure is as follows.

Connection Type : Generic database
Access :  Native(JDBC)

And under DB access settings

Custom Connection URL     : jdbc:sybase:Tds:<HOST ADDRESS>:<PORT NUMBER>/<DB NAME>
Custom Driver Class Name : com.sybase.jdbc3.jdbc.SybDriver
User Name : <USER NAME>
Password                                             : <DB PASSWORD>

Yup that should be it ! now test your connection, if you did everything correct, Wolah !!

Let's save it for us.

Our city life has being all about finding an easier way to do things, do things within shorter time. Go home quickly from work and go back to work in a very short time without a hassle on the next day.

In this busy life pattern polythene bags provide the best and the comfortable solution for our good carrying requirements. But it is a much known fact by all of us that this comfortable solution has started giving us problems now. All countries around the world trying so hard to battle this problem, as it is creating life threatening effects to all living things in the world.

Not so long ago Sri Lanka also imposed a policy to control the quality of the polythene that we use. Because the greatest problem with the polythene is, unlike other objects certain polythene structures are harder decomposing in the natural decompose process.

Here I am not going to talk about how polythene has become a problem to us, but how can we control this and reduce amount of polythene that we release into the environment.

Have you ever wondered how much of polythene bags that you use for a day? May be when you are going shopping, when you are going to the market. Some of you may answer very rarely that you use them. But think about when you are buying food from super markets, pastry shops or when you are buying certain products from the markets. Most of the time the person who stuff your goods into your bags may be packing may categorized them and put them in the different bags. Yes it is convenient but think he/she may be packing things into 2 or many bags that you would not mind even they were packed in one bag. There at that point you are increasing the usage of polythene by 2 or many times than you could manage with.  At that point if you can mention to the person that you don’t mind if he/she put certain goods in one bag. You are cutting down that extra release of polythene into the environment. I usually do it even when I am buying pastries from the pastry shop, I always mention  to use one bag to stuff my food if there is no situation that I should be separating them into 2 -3 bags.

If we can keep our grocery bags for another use, we are cutting down the amount of bags that we release to the environment. As one person we don’t see a big picture, but imagine, if we all are doing the same everyday. I am sure we can do a huge impact on the pollution that caused by polythene.

This is not for the future generation but for the rest of our lifetime. To live in a clean environment.

It is always harder to think about the future and save all to the future generation. Sometimes it may by frustrating, so why not just think about today and about us. Coz if we create a good life for us today. The generation who is inheriting the same from us will not have any problem. So what we save for us will be saved for the future.

I released my very first piano cover today. This track is actually a hymn named “Power of your love” by Hillsong (If I’m not mistaken). So here it is guys.. you are welcome to comment anywhere, Here , YouTube, Facebook and even in my Twitter.

Just in case if you can not watch the video here, specially my subscribers, please visit :: http://www.youtube.com/watch?v=2MzwWxG_EdU