crazy effect when altering type

From: Christian \ <Christian.Gulich_at_IN.Stud.TU-Ilmenau.de>
Date: Mon, 19 Jul 2004 21:46:04 +0200
Message-ID: <cdh85d$2gg$1@piggy.rz.tu-ilmenau.de>

Hi,

I want to add some attributes and methods to the intermedia type ORDSys.ORDVideo. After doing this with a statement like that there arises a curious problem.

ALTER TYPE ORDSys.ORDVideo ADD ATTRIBUTE (

   attr1 Sys.anytype,
   attr2 number,
...

);
/

ALTER TYPE ORDSys.ORDVideo

   ADD member procedure myproc
   as language java
   name 'MyClass.myproc()',
...

;

Just after adding the new attributes my management console shows every method of ORDVideo twice! Additionally, JPublisher can't generate correct classes any more.
For the method "writesource(...)" for example, it generates something like this before altering the type:

public OrdVideo writetosource (

     byte[] ctx[],
     Integer startpos,
     Integer numbytes[],
     byte[] buffer) throws SQLException {

...

}

After altering it generates 2!!! methods with incorrect signatures like this:

public OrdVideo writetosource_1 (

     byte[] ctx[],
     byte[] ctx[],
     Integer startpos,
     Integer startpos) throws SQLException {

...

}

public OrdVideo writetosource_2 (

     byte[] ctx[],
     byte[] ctx[],
     Integer startpos,
     Integer startpos) throws SQLException {

...

}

SQLJ can't compile these methods, of course. They have duplicate parameter names.

If I try to alter ORDVideo to not final, to be able to create subtypes, there is the same effect.

Does anybody know, what could be the reason?

Thanks, Christian Received on Mon Jul 19 2004 - 14:46:04 CDT