Thursday, July 9, 2009

DQL query similar to TOP and ROWCOUNT in SQL

If you want to restrict your query result to a selected number of records as we are doing someting similar to "select top 5 * from authors_table" or similar to ROWCOUNT.
The same criteria can be achieved in DQL using the following parameter ENABLE(FETCH_ALL_RESULTS )

select r_object_id from dm_document ENABLE(FETCH_ALL_RESULTS 5) will return the first five records

select r_object_id from dm_document ENABLE(FETCH_ALL_RESULTS 0) will return the entire results collection.

For more information can be found at : http://robineast.wordpress.com/2007/08/14/dql-hints-optimize-top/

Monday, July 6, 2009

Weapon of Fear

As told in TPM CHURCH, ROYAPETTA 04-JULY-2009 SUNDAY SERVICE

Isaiah 54:17
"no weapon forged against you will prevail,
and you will refute every tongue that accuses you.
This is the heritage of the servants of the LORD,
and this is their vindication from me," declares the LORD.

Against the children of God, the devil uses diffrent types of weapons. In old testment, they used literal weapons but in new testmenat the weapons are not literal. Satan uses this weapon to distract the mind of Gods child away from God and mke him a backslider.

Here we will discuss one of the weapons that devil uses as a weapon against the children of God.
The weapon is FEAR.

Genesis 32:11
"Save me, I pray, from the hand of my brother Esau, for I am afraid he will come and attack me ..."
Here Jacob prayed because of fear. Eventhough he had said that the God is with me, he had heavenly dreams, he saw angels of God climbing up and dwon through the ladder , still he is afraid of his brother.

To overcome the fear, Jacob prayed.

I Samuel 17:11
"On hearing the Philistine's words, Saul and all the Israelites were dismayed and terrified."
Eventhough Saul is the King of Israel and the he is chosen by God, right now he is afraid of Goliath.
The reason is he had lost his anointing to overcome Goliath. He had lost his fellowship with God.
The fear will come into our mind when we loss the anointing or fellowship with God.

To overcome this fear , we need a heavenly anointing.

I King 19:4
"while he himself went a day's journey into the desert. He came to a broom tree, sat down under it and prayed that he might die. "I have had enough, LORD," he said. "Take my life; I am no better than my ancestors."
Eventhough he is a great prophet , when he prayed the there was no rain for three years, when he prayed the doors of sky opened, when he prayed fire descended from sky, but right now he is afraid of a woman with name Jezebel.

He also prayed, the Lord sent his angel to encourage him. I Kings 19: 7, 8 "All at once an angel touched him and said, 'Get up and eat.' He looked around, and there by his head was a cake of bread baked over hot coals, and a jar of water". Here the cake shows the word of God and water shows the holy spirit

To overcome the fear we need the word of God and water shows the holy spirit

II Samuel 15: 13, 14
"Come! We must flee, or none of us will escape from Absalom. ...".
Here the King David is fearing his son Absalom and he is flleeing from the city of Jerusalem. Jerussalem shows the Church of God and Absalom shows the word or the spirit of taking revenge. Absalom is looking for taking revenge against the king. This fear shows backsliding from the God. Even thoug David was a great king he alone killed the gigantic Goliath, now he is afraid of his son.


Job 3:25
"What I feared has come upon me; what I dreaded has happened to me."

Here Job curses his birthday. In Bible we find that two people curses their birthady and two people celebrated their birthday. The people who curses their birthady are Job (3:25) and Jeremiah (20:14). The people who celebrated their birthday are Pharaoh (Genesis 40: 20, 22) and Herod (Mathew 14: 5, 10). Then what happens on their birthady , there were two deaths. So neither celebrate birthday nor curse birthday. Pray to Lord to reveal the will of God.


Let the God helped you to overcome the weapon of fear through Prayer and Holy Spirit.

Experience of Wilderness

As told in TPM CHURCH, ROYAPETTA 21-JUNE-2009 SUNDAY SERVICE

Mark 6:31
"Come with me by yourselves to a quiet place and get some rest."
Here we see , Jesus took his disciples to wilderness and get some rest awhile
In Song of Solomon 8: 5 "Who is this coming up from the desert leaning on her lover? "
The wilderness shows leaning upon Jesus.

Here we will discuss 4 experiences of wilderness to the children of God.

Wilderness shows rest:
Matthew 11:28 "Come to me, all you who are weary and burdened, and I will give you rest."
Isaiah 28:12 saya about the rest thru anointing
to whom he said,
"This is the resting place, let the weary rest";
and, "This is the place of repose"—
but they would not listen.

Gods word is revealing to people in wilderness:
Luke 3:2 "the word of God came to John son of Zechariah in the desert."

Time of Temptation by devil:
Mathew 4: 1 "Then Jesus was led by the Spirit into the desert to be tempted by the devil."
Wilderness shows the time of temptation or time of difficulty for the children of God

Hidden Life:
Luke 1:80 "And the child grew and became strong in spirit; and he lived in the desert until he appeared publicly to Israel."

Friday, July 3, 2009

Blessings at the city of Shechem

As told in TPM CHURCH, ROYAPETTA 28-JUNE-2009 SUNDAY SERVICE

Genesis 33:18
"After Jacob came from Paddan Aram, he arrived safely at the city of Shechem in Canaan and camped within sight of the city."

Here we find that Jacob moved from Paddan Aram to Shechem . These two places have significant meaning in Bible. The city of Paddan Aram shows an ordinary life where as the city of Shechem shows a spiritual life. Here we will meditate five speciality about the city of Shechem.

Genesis 12:6
"Abram traveled through the land as far as the site of the great tree of Moreh at Shechem."
The word Moreh means teacher.
Mark 10:17 As Jesus started on his way, a man ran up to him and fell on his knees before him. "Good teacher," he asked, "what must I do to inherit eternal life?". Here the rich man called Jesus, Good teacher. Jesus is our good teacher. In new testament God gracefully given his saints to correct us and teach us. In the city of Shechem, there is good teacher to correct you and guide you in proper path.It shows accepting Jesus as your master.

Genesis 37:12
"Now his brothers had gone to graze their father's flocks near Shechem,"
In Shechem there are good pastures for sheep. In Psalms 23:1-2 "The LORD is my shepherd, I shall not be in want.
He makes me lie down in green pastures,". The Lord is our shepherd and we are his sheeps. If you are in the city of Shechem, there are green pastures for you. It shows the doctrine of life from God.
1 Corinthians 1:5-7 "For in him you have been enriched in every way—in all your speaking and in all your knowledge—because our testimony about Christ was confirmed in you. Therefore you do not lack any spiritual gift as you eagerly wait for our Lord Jesus Christ to be revealed."

Joshua 24 :1
"Then Joshua assembled all the tribes of Israel at Shechem. He summoned the elders, leaders, judges and officials of Israel, and they presented themselves before God.". Here all people irrespective of their status came together at Joshua. It shows a humility and fellowhsip with the saints of God. In the city of Shechem , there is fellowship with God, Saints and each other.
The Lord gave entire power to Jesus. But as in John 13:3-5 "Jesus knew that the Father had put all things under his power, and that he had come from God and was returning to God; so he got up from the meal, took off his outer clothing, and wrapped a towel around his waist. After that, he poured water into a basin and began to wash his disciples' feet, drying them with the towel that was wrapped around him.". It shows the complete humility.

Joshua 24:15
"But as for me and my household, we will serve the LORD."
It shows serving the Lord as a family.

Joshua 20:7
"So they set apart Kedesh in Galilee in the hill country of Naphtali, Shechem in the hill country of Ephraim, and Kiriath Arba (that is, Hebron) in the hill country of Judah."
The city of Shechem contains a refugee. you can run there and get protected.
Proverbs 18:10 "The name of the LORD is a strong tower; the righteous run to it and are safe."
Jesus is our refugee.

Let the good God fill you with the blessings of the City of Shechem.