Foren
Service Builder - 200 tables existing database
J Marquez, geändert vor 7 Jahren.
Service Builder - 200 tables existing database
New Member Beiträge: 6 Beitrittsdatum: 02.06.16 Neueste Beiträge
Hi!
I have my database with around 200 tables. I have to create a Business Layer for sharing functions with other portlets. The business layer I will do with Service Builder. I have a question...
Have I to write a service.xml at first with the definitions of all my 200 tables? Is there any option in this case?
Thank you.
I have my database with around 200 tables. I have to create a Business Layer for sharing functions with other portlets. The business layer I will do with Service Builder. I have a question...
Have I to write a service.xml at first with the definitions of all my 200 tables? Is there any option in this case?
Thank you.
David H Nebinger, geändert vor 7 Jahren.
RE: Service Builder - 200 tables existing database
Liferay Legend Beiträge: 14919 Beitrittsdatum: 02.09.06 Neueste Beiträge
No, that's pretty much a necessary starting point.
You're likely going to want to separate the 200 into different xml files and import them into the service.xml holder.
Another technique is to group tables per function group and create separate projects, but this can impose issues if the tables otherwise benefit from being together in one project.
You're likely going to want to separate the 200 into different xml files and import them into the service.xml holder.
Another technique is to group tables per function group and create separate projects, but this can impose issues if the tables otherwise benefit from being together in one project.
J Marquez, geändert vor 7 Jahren.
RE: Service Builder - 200 tables existing database
New Member Beiträge: 6 Beitrittsdatum: 02.06.16 Neueste BeiträgeDavid H Nebinger:
No, that's pretty much a necessary starting point.
You're likely going to want to separate the 200 into different xml files and import them into the service.xml holder.
Another technique is to group tables per function group and create separate projects, but this can impose issues if the tables otherwise benefit from being together in one project.
Uffff, to much work for generate xml files from Informix 200 tables, our database is very big.
Thank you very much David.
Jack Bakker, geändert vor 7 Jahren.
RE: Service Builder - 200 tables existing database
Liferay Master Beiträge: 978 Beitrittsdatum: 03.01.10 Neueste Beiträge
Which version are you working with ? In v6.2 I have one portlet devoted to connecting to a non-portal sql db with a service.xml that references each entity/table needed. The service jar then can be shared in consumer portlets, or put in global classpath. In v7, services can be consumed in more flexible ways but on you to decide pros/cons of 200 xml vs 1, or somewhere in between.
J Marquez, geändert vor 7 Jahren.
RE: Service Builder - 200 tables existing database
New Member Beiträge: 6 Beitrittsdatum: 02.06.16 Neueste BeiträgeJack Bakker:
Which version are you working with ? In v6.2 I have one portlet devoted to connecting to a non-portal sql db with a service.xml that references each entity/table needed. The service jar then can be shared in consumer portlets, or put in global classpath. In v7, services can be consumed in more flexible ways but on you to decide pros/cons of 200 xml vs 1, or somewhere in between.
Hi!! Liferay 6.1.2-ce-ga3, thank you!