[Building Sakai] SITEASSOC_CONTEXT_ASSOCIATION and TAGGABLE_LINK

[DAVID ROLDAN MARTINEZ]

Hmmm....Then I don't understand what can be happening...

If TAGGLABLE_LINK is not linked with legacy assignments, why our installation is trying to access that table?

Any idea?

Thanks a lot!!
David
________________________________________
De: Anthony Whyte [arwhyte at umich.edu]
Enviado el: martes, 12 de julio de 2011 17:09
Para: DAVID ROLDAN MARTINEZ
CC: Developers Sakai-Dev; Maurer Christopher
Asunto: Re: [Building Sakai] SITEASSOC_CONTEXT_ASSOCIATION and TAGGABLE_LINK

There is a hibernate mapping for TAGGABLE_LINK in the taggable project.  It along with the rest of the taggable stuff was removed from assignments back in March 2008 (fix version Sakai 2.6.0) according to https://jira.sakaiproject.org/browse/SAK-13237.

/taggable/trunk/taggable-hbm/hbm/src/java/org/sakaiproject/taggable/impl/LinkImpl.hbm.xml

The only explicit reference to TAGGABLE_LINK in a *.sql conversion script involves a test script for assignment2.  See assignment2/selenium-test/sakaitrunk-db.sql.

Cheers,

Anthony

--
-- Table structure for table `TAGGABLE_LINK`
--

DROP TABLE IF EXISTS `TAGGABLE_LINK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TAGGABLE_LINK` (
  `LINK_ID` varchar(36) NOT NULL,
  `VERSION` int(11) NOT NULL,
  `ACTIVITY_REF` varchar(255) NOT NULL,
  `TAG_CRITERIA_REF` varchar(255) NOT NULL,
  `RUBRIC` text,
  `RATIONALE` text,
  `EXPORT_STRING` int(11) NOT NULL,
  `VISIBLE` bit(1) NOT NULL,
  `LOCKED` bit(1) NOT NULL,
  PRIMARY KEY (`LINK_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TAGGABLE_LINK`
--

LOCK TABLES `TAGGABLE_LINK` WRITE;
/*!40000 ALTER TABLE `TAGGABLE_LINK` DISABLE KEYS */;
/*!40000 ALTER TABLE `TAGGABLE_LINK` ENABLE KEYS */;
UNLOCK TABLES;




On Jul 12, 2011, at 10:40 AM, Maurer, Christopher Wayne wrote:

David,
I remember a bunch of strange issues with some past conversion scripts as
well.  I forget what the final outcome was, as stuff went in and out of
the conversion scripts based on various errors from folks running the
conversion.  But those tables are related to OSP Matrix/Assignments (1 and
2) integration.

Rows are created in the SITEASSOC_CONTEXT_ASSOCIATION table when you
associate sites (currently done through a link in the Matrix tool).
(as as aside, we will eventually investigate the duplication of
functionality of this with the site linking that came in 2.7)

To get records in TAGGABLE_LINK, you'd have to first make the above
mentioned site association, then, you can link an assignment to a matrix
cell (provided that you have created an assignment and a matrix!).

Chris

On 7/12/11 10:12 AM, "DAVID ROLDAN MARTINEZ" <darolmar at upvnet.upv.es<mailto:darolmar at upvnet.upv.es>>
wrote:


             Hi,

Short description: Does anybody know what these tables are used for?

Detailed description:

We are on the process of migration from 2.6 to 2.8 and I've found two
strange issues:
* SITEASSOC_CONTEXT_ASSOCIATION is created at
sakai_2_7_0_oracle_conversion.sql. I can create the table but it's empty.
I've tried creating new objects (Assignments and Announcements) but it
seems no to do nothing (no row is inserted in this table), though
enabling hibernate.show_sql I've seen that Sakai tries to SELECT rows
each that display assignment list. Does anybody know the aim of this
table? where rows should be inserted?

* TAGGLABLE_LINK. I haven't found this table at any of the migration
scripts. However, when deleting as assignment tries to delete rows from
it and, as it not exists, Oracle lauches an exception and the assignment
can not be deleted. To top it off, Sakai locks the assignment and nobody
can do anything with it. Searching in the code, I've found that is
referenced in taggable module but, unfortunately, I don't know what's the
intent of this module. To try to figure out when this table is created, I
was thinking about to run migration scripts 2.6 -> 2.7 -> 2.8 and then
set auto.ddl before to start Tomcat but I'm not sure if this will help.
Any idea?

I absolutely appreciate any suggestion, idea, etc. I'm really stuck with
this. :(

Thank you very much in advance.

Cheers,
 David
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to
sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of
"unsubscribe"

_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"