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
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
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
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 .
Regards,
Hai
Thank you. Indeed, that helps .
Regards,
Hai
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
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
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.
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
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
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
Thank you very much for the quick reply. I will try & update soon in the forum about the result
- Nagendra Kumar