Forums

Home » Liferay Portal » English » Liferay Legacy

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
nicolas muller
How to display SQL query in developpment
April 16, 2007 12:57 AM
Answer

nicolas muller

Rank: New Member

Posts: 8

Join Date: April 15, 2007

Recent Posts

Hello,

I would like to display SQL queries in developpement mode because i don't understand why data are not updated.

I modified the show_sql value (true now) into portal.properties. Unfortunately there is no effect...

Best regards, Nicolas
Jorge Ferrer
RE: How to display SQL query in developpment
April 19, 2007 1:04 AM
Answer

Jorge Ferrer

LIFERAY STAFF

Rank: Liferay Legend

Posts: 2771

Join Date: August 31, 2006

Recent Posts

Weird, that property has always worked for me and I've seen it mentioned by others in the forum too. Have you checked that it was changed in the correct file? It should look like:

1hibernate.show_sql=true


An alternative would be to install P6spy manually by modifying the hibernate configuration files but that's going to be more work.
nicolas muller
RE: How to display SQL query in developpment
April 25, 2007 9:34 AM
Answer

nicolas muller

Rank: New Member

Posts: 8

Join Date: April 15, 2007

Recent Posts

Thank you for your answer.

In fact, I modified the portal.properties instead of portal-ext.properties. So after merging the document with ant task, the property was lost.

I put your response into the good file and it is good.

Thank you,

Best regards, Nicolas
Senthil Chockalingam
Reg: Display SQL data in Liferay
February 2, 2010 5:37 AM
Answer

Senthil Chockalingam

Rank: Junior Member

Posts: 58

Join Date: January 18, 2010

Recent Posts

Hi Friend,

we have one requirement tht "we want to create one table in sql and we want to display those data in web content display portlet(individually, for example we are using more then one web content display portlet". can you help me on this.