Terse Systems : How to kill startSQLRepository

February 06, 2005 16:45

ATG Dynamo

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">
    <table name="blog_category" type="primary" id-column-name="category">
      <property name="category" data-type="string" required="true">

      </property>
    </table>
  </item-descriptor>

</gsa-template>

yields

Exception in thread "main" java.lang.OutOfMemoryError

Yay.

« The old country | Home | A good JSP editor »

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.

Ben Menasha at 02/07/05 01:06

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

Will Sargent at 02/07/05 01:17

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.

Ben Menasha at 02/07/05 01:58

name
url