How to kill startSQLRepository 3

Posted by wsargent Sun, 06 Feb 2005 22:45:00 GMT

In ATG, generating SQL from a database:

startSQLRepository.bat -s blog -m Blog -repository /blog/repository/BlogRepository -database oracle -outputSQL
with 
<gsa-template>



  <item-descriptor name="category" display-property="category">



&lt;table name="blog_category" type="primary" id-column-name="category"&gt;
  &lt;property name="category" data-type="string" required="true"&gt;

  &lt;/property&gt;
&lt;/table&gt;




  </item-descriptor>



</gsa-template>
yields 
Exception in thread "main" java.lang.OutOfMemoryError

Yay.

Comments

Leave a comment

  1. Ben Menasha about 20 hours later:

    You are defining a repository item property over a db column that is also the repository id. This is an undocumented no-no. I don’t know (or think) it’s the cause of the OutOfMemoryError, but it also causes problems in other areas.

  2. Will Sargent about 21 hours later:

    Hah. Works for me in production. All the categories are unique strings. And if it’s undocumented, how can it be a no-no?

  3. Ben Menasha about 21 hours later:

    I’m using long dead breancells here, but an exception occured in the TableInvalidationListener because the item property was defined to be a different datatype then the repositoryId. The property was defined as an integer. Or was it that we were changing the value of the property after item creation? damn, I don’t know anymore. Glad it works great.


Comments