Reinaldo Silva 13 Years Ago Just great!!!! now I can drop a lot of triggers on database that were just doing zero to NULL conversion. Please sign in to reply. Reply as... Cancel Jonas X. Yuan Reinaldo Silva 13 Years Ago Hi Reinaldo. Thanks. The fix patch for trunk version is ready at LPS-14863. Please sign in to reply. Reply as... Cancel
Jonas X. Yuan Reinaldo Silva 13 Years Ago Hi Reinaldo. Thanks. The fix patch for trunk version is ready at LPS-14863. Please sign in to reply. Reply as... Cancel
Denis Signoretto 13 Years Ago Hi Jonas,you wrote "Definitely this feature could be available for 5.2 and 6.0 as a fix patch." - Do you mean for EE Editions only or also as community plugin or patch? Thanks.Denis Please sign in to reply. Reply as... Cancel Jonas X. Yuan Denis Signoretto 13 Years Ago - Edited Hi Denis, Thanks. The fix patch is available for 5.2 and 6.0, both CE and EE. For 6.0.5 CE, you can find it at http://www.liferay.com/community/forums/-/message_boards/message/7244098.Which version are you using? Please sign in to reply. Reply as... Cancel sravan nethi Jonas X. Yuan 13 Years Ago hi jonas, can you tell me how can i change jsp in my portlet Please sign in to reply. Reply as... Cancel Jonas X. Yuan sravan nethi 13 Years Ago Hi Sravan, Thanks. You may refer to the book: Liferay Portal 5.2 Systems Developmenthttp://www.amazon.com/Liferay-Portal-5-2-Systems-Development/dp/1847194702Hope that it helps, Please sign in to reply. Reply as... Cancel
Jonas X. Yuan Denis Signoretto 13 Years Ago - Edited Hi Denis, Thanks. The fix patch is available for 5.2 and 6.0, both CE and EE. For 6.0.5 CE, you can find it at http://www.liferay.com/community/forums/-/message_boards/message/7244098.Which version are you using? Please sign in to reply. Reply as... Cancel sravan nethi Jonas X. Yuan 13 Years Ago hi jonas, can you tell me how can i change jsp in my portlet Please sign in to reply. Reply as... Cancel Jonas X. Yuan sravan nethi 13 Years Ago Hi Sravan, Thanks. You may refer to the book: Liferay Portal 5.2 Systems Developmenthttp://www.amazon.com/Liferay-Portal-5-2-Systems-Development/dp/1847194702Hope that it helps, Please sign in to reply. Reply as... Cancel
sravan nethi Jonas X. Yuan 13 Years Ago hi jonas, can you tell me how can i change jsp in my portlet Please sign in to reply. Reply as... Cancel Jonas X. Yuan sravan nethi 13 Years Ago Hi Sravan, Thanks. You may refer to the book: Liferay Portal 5.2 Systems Developmenthttp://www.amazon.com/Liferay-Portal-5-2-Systems-Development/dp/1847194702Hope that it helps, Please sign in to reply. Reply as... Cancel
Jonas X. Yuan sravan nethi 13 Years Ago Hi Sravan, Thanks. You may refer to the book: Liferay Portal 5.2 Systems Developmenthttp://www.amazon.com/Liferay-Portal-5-2-Systems-Development/dp/1847194702Hope that it helps, Please sign in to reply. Reply as... Cancel
Puj Z 13 Years Ago Great step forward!Will it also be possible to set a default value? For example if you want an integer-column to be 1 by default? Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago Hi Puj, Thanks. The feature you mentioned is not supported so far for now. I believe that it (ability to set a default value) is possible.Would you be able to share the details? Please sign in to reply. Reply as... Cancel Puj Z Jonas X. Yuan 13 Years Ago Hi Jonas,sure. Sometimes, especially if you migrate from an old database, the columns have a default value other than 0 which is supported by most databases when you define a column.For example imagine a workflow process, where the user suggest something (e.g. an entity) and you have to accept or reject it. The new entity is assigned the value of "1", and if it is rejected it is assigned "0", otherwise "2" for acceptance.How it is possible now, is that you have to set this default value ("1") for the attribute of your model in "entityModelImpl.java".It would be much nicer and cleaner if you can set this default value in service.xml. Something like:<column name="mycolumn" type="int" default-value="1" /> Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. This feature (constraint default value) would be useful.Maybe it is good to add an element (constraint-default-value) like "constraint-default-value="1" and implement the same in Service-Builder. Is this a good idea?In addition, Vilmos Kozma mentioned other features - "constraint-not-null", "foreign-key", explicit "max-length" - at https://www.liferay.com/community/forums/-/message_boards/message/7354601. These features would be useful, too.Your suggestions? Please sign in to reply. Reply as... Cancel Puj Z Jonas X. Yuan 13 Years Ago sounds great Jonas!This would service builder more flexible and would save us some work while implementing the models. Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. These new features are addressed in details athttp://issues.liferay.com/browse/LPS-15136Hope that it could receive more comments / suggestions before implementing Please sign in to reply. Reply as... Cancel
Jonas X. Yuan Puj Z 13 Years Ago Hi Puj, Thanks. The feature you mentioned is not supported so far for now. I believe that it (ability to set a default value) is possible.Would you be able to share the details? Please sign in to reply. Reply as... Cancel Puj Z Jonas X. Yuan 13 Years Ago Hi Jonas,sure. Sometimes, especially if you migrate from an old database, the columns have a default value other than 0 which is supported by most databases when you define a column.For example imagine a workflow process, where the user suggest something (e.g. an entity) and you have to accept or reject it. The new entity is assigned the value of "1", and if it is rejected it is assigned "0", otherwise "2" for acceptance.How it is possible now, is that you have to set this default value ("1") for the attribute of your model in "entityModelImpl.java".It would be much nicer and cleaner if you can set this default value in service.xml. Something like:<column name="mycolumn" type="int" default-value="1" /> Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. This feature (constraint default value) would be useful.Maybe it is good to add an element (constraint-default-value) like "constraint-default-value="1" and implement the same in Service-Builder. Is this a good idea?In addition, Vilmos Kozma mentioned other features - "constraint-not-null", "foreign-key", explicit "max-length" - at https://www.liferay.com/community/forums/-/message_boards/message/7354601. These features would be useful, too.Your suggestions? Please sign in to reply. Reply as... Cancel Puj Z Jonas X. Yuan 13 Years Ago sounds great Jonas!This would service builder more flexible and would save us some work while implementing the models. Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. These new features are addressed in details athttp://issues.liferay.com/browse/LPS-15136Hope that it could receive more comments / suggestions before implementing Please sign in to reply. Reply as... Cancel
Puj Z Jonas X. Yuan 13 Years Ago Hi Jonas,sure. Sometimes, especially if you migrate from an old database, the columns have a default value other than 0 which is supported by most databases when you define a column.For example imagine a workflow process, where the user suggest something (e.g. an entity) and you have to accept or reject it. The new entity is assigned the value of "1", and if it is rejected it is assigned "0", otherwise "2" for acceptance.How it is possible now, is that you have to set this default value ("1") for the attribute of your model in "entityModelImpl.java".It would be much nicer and cleaner if you can set this default value in service.xml. Something like:<column name="mycolumn" type="int" default-value="1" /> Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. This feature (constraint default value) would be useful.Maybe it is good to add an element (constraint-default-value) like "constraint-default-value="1" and implement the same in Service-Builder. Is this a good idea?In addition, Vilmos Kozma mentioned other features - "constraint-not-null", "foreign-key", explicit "max-length" - at https://www.liferay.com/community/forums/-/message_boards/message/7354601. These features would be useful, too.Your suggestions? Please sign in to reply. Reply as... Cancel Puj Z Jonas X. Yuan 13 Years Ago sounds great Jonas!This would service builder more flexible and would save us some work while implementing the models. Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. These new features are addressed in details athttp://issues.liferay.com/browse/LPS-15136Hope that it could receive more comments / suggestions before implementing Please sign in to reply. Reply as... Cancel
Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. This feature (constraint default value) would be useful.Maybe it is good to add an element (constraint-default-value) like "constraint-default-value="1" and implement the same in Service-Builder. Is this a good idea?In addition, Vilmos Kozma mentioned other features - "constraint-not-null", "foreign-key", explicit "max-length" - at https://www.liferay.com/community/forums/-/message_boards/message/7354601. These features would be useful, too.Your suggestions? Please sign in to reply. Reply as... Cancel Puj Z Jonas X. Yuan 13 Years Ago sounds great Jonas!This would service builder more flexible and would save us some work while implementing the models. Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. These new features are addressed in details athttp://issues.liferay.com/browse/LPS-15136Hope that it could receive more comments / suggestions before implementing Please sign in to reply. Reply as... Cancel
Puj Z Jonas X. Yuan 13 Years Ago sounds great Jonas!This would service builder more flexible and would save us some work while implementing the models. Please sign in to reply. Reply as... Cancel Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. These new features are addressed in details athttp://issues.liferay.com/browse/LPS-15136Hope that it could receive more comments / suggestions before implementing Please sign in to reply. Reply as... Cancel
Jonas X. Yuan Puj Z 13 Years Ago - Edited Hi Puj, Thanks. These new features are addressed in details athttp://issues.liferay.com/browse/LPS-15136Hope that it could receive more comments / suggestions before implementing Please sign in to reply. Reply as... Cancel
Muhammad Asif 12 Years Ago I would like to ask that whenever we run service builder it generates<generate class="assigned" /> for all the entities. How can I change this and the service builder starts generateing the code as <generate class="increment" />Regards,Asif Please sign in to reply. Reply as... Cancel Jonas Yuan Muhammad Asif 12 Years Ago Hi Asif, Apologies to miss your post.Yes, you can change the code to "<generate class="increment" />" with your own implementation. This is doable, but not recommended.Hope that it helps,Jonas Please sign in to reply. Reply as... Cancel Dirk Ulrich Jonas Yuan 12 Years Ago This convert-null capability looks slightly close to my issue related to create trigger statements in tables.sql (in my case for a MySQL database). Is there a way to place CREATE TRIGGER statements in tables.sql by ServiceBuilder?I can put it into tables.sql manually and I get a code completion help from ServiceBuilder (in Eclipse Indigo) for the syntax of creating such a trigger statement but it is not exceuted on Liferay start which means that the tables are created while the trigger is not. See http://www.liferay.com/de/community/forums/-/message_boards/message/11944604 as well. Please sign in to reply. Reply as... Cancel
Jonas Yuan Muhammad Asif 12 Years Ago Hi Asif, Apologies to miss your post.Yes, you can change the code to "<generate class="increment" />" with your own implementation. This is doable, but not recommended.Hope that it helps,Jonas Please sign in to reply. Reply as... Cancel Dirk Ulrich Jonas Yuan 12 Years Ago This convert-null capability looks slightly close to my issue related to create trigger statements in tables.sql (in my case for a MySQL database). Is there a way to place CREATE TRIGGER statements in tables.sql by ServiceBuilder?I can put it into tables.sql manually and I get a code completion help from ServiceBuilder (in Eclipse Indigo) for the syntax of creating such a trigger statement but it is not exceuted on Liferay start which means that the tables are created while the trigger is not. See http://www.liferay.com/de/community/forums/-/message_boards/message/11944604 as well. Please sign in to reply. Reply as... Cancel
Dirk Ulrich Jonas Yuan 12 Years Ago This convert-null capability looks slightly close to my issue related to create trigger statements in tables.sql (in my case for a MySQL database). Is there a way to place CREATE TRIGGER statements in tables.sql by ServiceBuilder?I can put it into tables.sql manually and I get a code completion help from ServiceBuilder (in Eclipse Indigo) for the syntax of creating such a trigger statement but it is not exceuted on Liferay start which means that the tables are created while the trigger is not. See http://www.liferay.com/de/community/forums/-/message_boards/message/11944604 as well. Please sign in to reply. Reply as... Cancel
Advait Trivedi 9 Years Ago Hi Jonas,Can we get a patch for this feature for 6.2.10.1 EE GA1 ? We'd like to use this feature but its not available in this EE version. Please sign in to reply. Reply as... Cancel
David Lee 9 Years Ago Hi,Not sure if this was address but what if the primary key has null values? Is there a way to make a column both a primary key as well as having null value? When I do, I get errors for datasets that have null value. How to make service.xml work with columns with null data that I want to be part of my compound primary key? Thanks! Please sign in to reply. Reply as... Cancel
Varun Arya 7 Years Ago Hi Jonas,I am facing the same issue. I am using liferay 6.2. But neither <column name="parentId" type="long" convert-null="false" /> solve my issue nor <column name="parentId" type="Long" convert-null="false" /> this. It always saving 0. Please sign in to reply. Reply as... Cancel