Service-builder foreignkeys and column length

[Puj Z, modifié il y a 13 années.]

Hi,

I have not found anything regarding defining forein keys when using service builder. Is there a way to do that? If not, what is the reason? Because technically it doesn't seem to be difficult.

Another thing I have not found is how to define length for columns (for example with the type "String"). A default value of 75 is generated when a column is created in mysqll (varchar(75)) and then we have to manually change this, which is not an ideal way because the whole table is replaced after running service.xml later.

Is there any solutions\workarounds for this? Any help would rescue a desperate man!

[Henrique Simoes de Andrade, modifié il y a 13 années.]

Hi,

Foreign keys: I have the same problem.

Columns length: locate portlet-model-hints.xml in your project, there you can define length and other things for columns. Example:

		<field name="kaleoNodeName" type="String">
			<hint name="max-length">200</hint>
		</field>

HTH

[Puj Z, modifié il y a 13 années.]

Hi Henrique,

thanks, but the problem is this file is being overwritten if you run service-builder again, right?

Is there any persistent solution?

[Henrique Simoes de Andrade, modifié il y a 13 années.]

ehe no... this file is not overwritten.

You can edit without problem, there is a wiki http://www.liferay.com/community/wiki/-/wiki/1071674/Customize+DB+Column+Sizes/maximized with some tips about model-hints.

When run ant build-service, these changes aren't discarted.

Take a look here: http://www.liferay.com/community/wiki/-/wiki/1071674/Service+Builder+and+Liferay+Database+Table+Creation/maximized and here http://www.liferay.com/web/guest/community/forums/-/message_boards/message/3857549

[Puj Z, modifié il y a 13 années.]

Hi Henrique,

Thanks! I was not able to find this article, very useful!

I hope someone can also provide an answer on foreign-keys in Service-builder.

[Puj Z, modifié il y a 13 années.]

While searching, I stumbled upon some news claiming that service-builder in liferay6.1 will offer many to many relationship. If anyone has more info on this, please share.

[Scott Rabon, modifié il y a 13 années.]

Try looking in the DTD file of the service.xml file. There is a lot of helpful info in there. The URL is http://www.liferay.com/dtd/liferay-service-builder_6_0_0.dtd.

[Deepak pal, modifié il y a 6 années.]

thanks, but the problem is this file is being overwritten if you run service-builder again, right?

Is there any persistent solution?

Hi Puj Z,
Can you provide me solution how we can icrease coulomn size of a table. And if i run service builder it should be remain same . Actually facing problem when i run build service then all the changage done by me lost and default size set 75 varchar.

Thanks for any suggetion.

[Piyush Ramani, modifié il y a 11 années.]

Thanks it really helpful to me..