Foren

Can we use ServiceBuilder to generate sql scripts

Nguyen Paul, geändert vor 14 Jahren.

Can we use ServiceBuilder to generate sql scripts

New Member Beiträge: 16 Beitrittsdatum: 03.12.08 Neueste Beiträge
Dear,

Do you think it's possible to use ServiceBuilder to generate sql scripts based on service.xml file? If it is then how to do it?

Thank you in advance
thumbnail
Jonas Yuan, geändert vor 14 Jahren.

RE: Can we use ServiceBuilder to generate sql scripts

Liferay Master Beiträge: 993 Beitrittsdatum: 27.04.07 Neueste Beiträge
Hi Paul,

You can check the ext-model-hints.xml at /ext/ext-impl/src/META-INF. It is not pure sql script. Hope that it helps.

btw, you can use following properties setting in portal-ext.properties

## Hibernate update schema
hibernate.hbm2ddl.auto=update

Thus, Hibernate will update the database schema automatically when the portal started.

Thanks

Jonas Yuan

-----------------
Liferay Books

Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets
Nguyen Paul, geändert vor 14 Jahren.

RE: Can we use ServiceBuilder to generate sql scripts

New Member Beiträge: 16 Beitrittsdatum: 03.12.08 Neueste Beiträge
Mr. Jonas,

Thank you. Indeed, that helps emoticon.

Regards,
Hai
thumbnail
Nagendra Kumar Busam, geändert vor 14 Jahren.

RE: Can we use ServiceBuilder to generate sql scripts

Liferay Master Beiträge: 678 Beitrittsdatum: 07.07.09 Neueste Beiträge
Hi Jonas,

I am using LR 5.2.3. I have not seen "hibernate.hbm2ddl.auto" property in portal.properties file, even if we put that property in portal-ext.properties file is it going to update DB schema on server restart. Please clarify?

Thanks in advance.

- Nagendra Kumar
thumbnail
Jonas Yuan, geändert vor 14 Jahren.

RE: Can we use ServiceBuilder to generate sql scripts

Liferay Master Beiträge: 993 Beitrittsdatum: 27.04.07 Neueste Beiträge
Hi Nagendra

This property is additional one - Yes, It does not exist in portal.properties.

## Hibernate update schema
hibernate.hbm2ddl.auto=update


Thus, Hibernate will update the database schema automatically when the portal started.

Thanks

Jonas Yuan
Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets
thumbnail
Nagendra Kumar Busam, geändert vor 14 Jahren.

RE: Can we use ServiceBuilder to generate sql scripts

Liferay Master Beiträge: 678 Beitrittsdatum: 07.07.09 Neueste Beiträge
Hi Jonas,

Thank you very much for the quick reply. I will try & update soon in the forum about the result

- Nagendra Kumar