[Building Sakai] Using YAFT with Sakai 2.6.2 demo

[Adrian Fish]

Here's the ddl for the two tables mentioned:

CREATE TABLE YAFT_PREFERENCES (USER_ID VARCHAR(99) NOT NULL, SITE_ID 
VARCHAR(99) NOT NULL,EMAIL_ALERTS VARCHAR(24) NOT NULL, VIEW_MODE 
VARCHAR(16) NOT NULL, PRIMARY KEY(USER_ID,SITE_ID))

CREATE TABLE YAFT_DISCUSSION_UNSUBS (DISCUSSION_ID CHAR(36) NOT 
NULL,USER_ID VARCHAR(99) NOT NULL,PRIMARY KEY(DISCUSSION_ID,USER_ID))

There may well be some HSQL incompatible SQL in these and that may be 
the problem.

Cheers,

Adrian.

Yzelle, Sonette wrote:
> This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
>
> Hi Michael,
>
> Maybe I am going to ask stupid questions that you have already tried, but I am just trouble-shooting!
> Does the sakai user you are using have permissions to create tables?
> When you go in to the database can you do a manual describe on the tables? Do they exist or don't they.
> If they exist maybe you just need some grants for a specific db user to those tables.
> If they don't exist I think you must check if your db user is allowed to create tables.
>
> If none of the above is working maybe we can ask Adrian if he has a HypersonicSQL script to create the yaft database?  We only had one table missing so it was easy to go through DefaultSqlGenerator.java to get the schema for that table.
>
> Maybe we can even suggest this to the Sakai community that all tools must be accompanied by a script to create tables for a tool manually?  I know some tools do have manual scripts.  This would also help Unisa because our autoddl is always set to false.
>
> Regards
> Sonette
>
> -----Original Message-----
> From: Michael Chale [mailto:mike.chale at warrington.ufl.edu]
> Sent: 28 June 2010 02:25 PM
> To: Yzelle, Sonette; Adrian Fish
> Cc: sakai-dev at collab.sakaiproject.org
> Subject: RE: [Building Sakai] Using YAFT with Sakai 2.6.2 demo
>
> Hi,
>
> The errors I'm getting start with:
> * ERROR main org.sakaiproject.yaft.impl.YaftPersistenceManager - Caught exception whilst setting up tables. Rolling back ...
> * Table not found in statement [SELECT * FROM YAFT_PREFERENCES]
> * Table not found in statement [SELECT DISCUSSION_ID FROM YAFT_DISCUSSION_UNSUBS]
> * and so on.
>
> If I knew how to manually create the tables in the HypersonicSQL db I would, but I haven't found that information yet (nor do I know the table schemas.)
>
>
>   Michael Chale
>   Software Developer
>   Web, Data, and Communication Services
>
> -----Original Message-----
> From: Yzelle, Sonette [mailto:SYzelle at unisa.ac.za]
> Sent: Monday, June 28, 2010 7:40 AM
> To: Adrian Fish; Michael Chale
> Cc: sakai-dev at collab.sakaiproject.org
> Subject: RE: [Building Sakai] Using YAFT with Sakai 2.6.2 demo
>
> This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
>
> Hi,
>
> Yaft is working 100% for Unisa on Sakai 2.6.2 on our production environment.
>
> We did experience problems with the yaft tables, 1 tables were not created.  We also had to create grants for another table. We use Oracle database.
> The tool deployed successfully we only picked up the missing tables when we started
> using the tool.  I ended up giving a script to the DBA to create the table.
>
> What was the error message you were getting again?  Sorry can't remember but I did see the e-mail.
>
> Regards
> Sonette
>
>
>   

-- 
==================================
Adrian Fish
Software Engineer
Centre for e-Science
Bowland Tower South C Floor
Lancaster University
Lancaster
LA1 4YW
email: a.fish at lancaster.ac.uk

http://confluence.sakaiproject.org/display/YAFT/Yaft
http://confluence.sakaiproject.org/display/BLOG/Home
http://confluence.sakaiproject.org/display/AGORA/Home

-------------- next part --------------
A non-text attachment was scrubbed...
Name: a_fish.vcf
Type: text/x-vcard
Size: 289 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100628/a89376fd/attachment.vcf