[Building Sakai] CLOG for 2.8
Adrian Fish
a.fish at lancaster.ac.uk
Fri Jul 22 03:07:57 PDT 2011
I've added the change into trunk. r75720. Do an update and you'll get it.
Thanks for the testing Omer.
Cheers,
Adrian.
On 21/07/2011 19:00, Omer Piperdi wrote:
> Also TINYINT needs to be NUMBER..
>
> Here is the diff and it is working for us.
>
> Index: impl/src/java/org/sakaiproject/clog/impl/sql/SQLGenerator.java
> ===================================================================
> --- impl/src/java/org/sakaiproject/clog/impl/sql/SQLGenerator.java
> (revision 519)
> +++ impl/src/java/org/sakaiproject/clog/impl/sql/SQLGenerator.java
> (revision 530)
> @@ -141,7 +141,7 @@
> statement.append(KEYWORDS + " " + VARCHAR + "(255), ");
> statement.append(ALLOW_COMMENTS + " " + INT + ", ");
> statement.append(VISIBILITY + " " + VARCHAR + "(16) NOT NULL, ");
> - statement.append("CONSTRAINT post_pk PRIMARY KEY (" + POST_ID + ")");
> + statement.append("CONSTRAINT clog_post_pk PRIMARY KEY (" + POST_ID + ")");
> statement.append(")");
> return statement.toString();
> }
> Index: impl/src/java/org/sakaiproject/clog/impl/sql/OracleSQLGenerator.java
> ===================================================================
> ---
> impl/src/java/org/sakaiproject/clog/impl/sql/OracleSQLGenerator.java
> (revision 519)
> +++
> impl/src/java/org/sakaiproject/clog/impl/sql/OracleSQLGenerator.java
> (revision 530)
> @@ -4,6 +4,7 @@
> public OracleSQLGenerator() {
> BLOB = "BLOB";
> BIGINT = "NUMBER";
> + TINYINT = "NUMBER";
> TIMESTAMP = "TIMESTAMP";
> VARCHAR = "VARCHAR2";
> TEXT = "LONG";
>
> Thanks
> Omer
>
> On 7/21/2011 12:15 PM, Omer Piperdi wrote:
>> Yes.. I also have blogger installed for our legacy sites.. which is also
>> using post_pk as a constraint.. I am changing constraint to clog_post_pk
>> and see if that fix the problem...
>>
>> Thanks
>> Omer
>>
>> On 7/21/2011 10:50 AM, Omer Piperdi wrote:
>>> I am getting something like this in catalina.out..
>>>
>>> 2011-07-21 10:40:47,780 INFO main
>>> org.sakaiproject.clog.impl.ClogManagerImpl - Registering Clog functions ...
>>> 2011-07-21 10:40:47,780 INFO main
>>> org.sakaiproject.clog.impl.ClogManagerImpl - Registered Clog functions ...
>>> 2011-07-21 10:40:48,544 ERROR main
>>> org.sakaiproject.clog.impl.PersistenceManager - Caught exception whilst
>>> setting up tables. Message: ORA-02264: name already used by an existing
>>> constraint
>>> . Rolling back ...
>>> 2011-07-21 10:40:48,545 ERROR main
>>> org.sakaiproject.clog.impl.PersistenceManager - Failed to setup the tables
>>>
>>>
>>> Thanks
>>> Omer
>>>
>>> On 7/21/2011 8:38 AM, Adrian Fish wrote:
>>>> Hi Omer,
>>>>
>>>> Could you send me your catalina.out? If you shut down tomcat, delete the
>>>> file then start tomcat, the full horror should be apparent in the log :)
>>>>
>>>> It may well be bad ORACLE syntax; I mainly test on MYSQL.
>>>>
>>>> Cheers,
>>>>
>>>> Adrian.
>>>>
>>>> On 21/07/2011 04:02, Steve Swinsburg wrote:
>>>>> Hi Omer,
>>>>>
>>>>> I mean on startup. When Sakai starts, if auto.ddl is activated it will attempt to create the tables and give you an error if it can't.
>>>>>
>>>>> The error below is because it couldn't. Perhaps the SQL is incorrect in which case it would be a bug.
>>>>>
>>>>> cheers,
>>>>> Steve
>>>>>
>>>>>
>>>>>
>>>>> On 21/07/2011, at 12:30 PM, Omer A Piperdi wrote:
>>>>>
>>>>>> Tool installed just fine.. When I 'Create new post'.. I get
>>>>>>
>>>>>> INFO: EntityEncodingManager: No entities to format (json) and output for ref (/clog-post)
>>>>>> 2011-07-20 11:44:59,461 ERROR http-8443-Processor14 org.sakaiproject.clog.tool.entityprovider.ClogPostEntityProvider - Caught exception whilst getting posts.java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
>>>>>>
>>>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
>>>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
>>>>>> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
>>>>>> at oracle.jdbc.driv
>>>>>>
>>>>>> I don't see any table starting with 'CLOG' in database.. I am on Oracle 10.2.4 by the way..
>>>>>>
>>>>>> Thanks
>>>>>> Omer
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 7/20/2011 5:51 PM, Steve Swinsburg wrote:
>>>>>>> Hi Omer,
>>>>>>>
>>>>>>> What to the logs say?
>>>>>>>
>>>>>>> Cheers,
>>>>>>> Steve
>>>>>>>
>>>>>>>
>>>>>>> Sent from my iPad
>>>>>>>
>>>>>>> On 21/07/2011, at 3:10, Omer Piperdi<omer at rice.edu> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I have deployed the CLOG trunk
>>>>>>>> https://source.sakaiproject.org/contrib/clog/trunk/
>>>>>>>> with our 2.8 install..
>>>>>>>>
>>>>>>>> Even though I have auto.ddl=true in sakai.properties.. I don't see any CLOG tables created in the database.. Did I miss any setting or I need to run something sql manually?
>>>>>>>>
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Omer
>>>>>>>>
>>>>>>>> On 7/18/2011 7:11 PM, Steve Swinsburg wrote:
>>>>>>>>> And if you want to manage your own binary deployer pom (like we do for additional tools), you can use a profile that is always active.
>>>>>>>>>
>>>>>>>>> Then you can just add and remove blocks for each tool you want to drop in:
>>>>>>>>> https://source.sakaiproject.org/svn//msub/anu.edu.au/alliance/2.8.x/extra-deploy/binary-overlays/pom.xml
>>>>>>>>>
>>>>>>>>> cheers,
>>>>>>>>> Steve
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 19/07/2011, at 12:48 AM, Anthony Whyte wrote:
>>>>>>>>>
>>>>>>>>>> Modify the core-deploy pom.xml as follows:
>>>>>>>>>>
>>>>>>>>>> 1. choose<profile> <id> = full
>>>>>>>>>>
>>>>>>>>>> 2. Add a clean.target
>>>>>>>>>>
>>>>>>>>>> <properties>
>>>>>>>>>> <clean.targets>
>>>>>>>>>> components/accountvalidator-pack;
>>>>>>>>>> . . .
>>>>>>>>>> components/clog-pack;
>>>>>>>>>> . . .
>>>>>>>>>> components/sitestats-component
>>>>>>>>>> </clean.targets>
>>>>>>>>>> <deploy.target>tomcat-overlay</deploy.target>
>>>>>>>>>> </properties>
>>>>>>>>>>
>>>>>>>>>> 3. Add to<dependencies>
>>>>>>>>>>
>>>>>>>>>> <dependency>
>>>>>>>>>> <groupId>org.sakaiproject.clog</groupId>
>>>>>>>>>> <artifactId>clog-assembly</artifactId>
>>>>>>>>>> <version>0.9.1-SNAPSHOT</version>
>>>>>>>>>> <classifier>tomcat-overlay</classifier>
>>>>>>>>>> <type>zip</type>
>>>>>>>>>> </dependency>
>>>>>>>>>>
>>>>>>>>>> Note: the above provides Clog trunk binaries, currently snapshot (e.g., unstable by definition) for your build. The Clog trunk version is itself dependent on snapshot artifacts, including kernel-1.3.0-SNAPSHOT.
>>>>>>>>>>
>>>>>>>>>> Cheers,
>>>>>>>>>>
>>>>>>>>>> Anth
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Jul 18, 2011, at 10:24 AM, Jez Cope wrote:
>>>>>>>>>>
>>>>>>>>>>> Aha, Clog binary sounds useful - I use quilt to maintain local
>>>>>>>>>>> modifications against the codebase and it would be great to fold in clog
>>>>>>>>>>> as just another patch to the pom.
>>>>>>>>>>>
>>>>>>>>>>> I'm not very familiar with Maven - what's the correct syntax to add clog
>>>>>>>>>>> to the core-deploy project?
>>>>>>>>>>>
>>>>>>>>>>> Thanks,
>>>>>>>>>>> Jez
>>>>>>>>>>>
>>>>>>>>>>> Steve Swinsburg wrote:
>>>>>>>>>>>> Hi Omer,
>>>>>>>>>>>>
>>>>>>>>>>>> Use trunk for now. We've recently committed a number of fixes to trunk because 0.9 was unusable for us. That said there should be another tag coming soon. Also, clog is available as a binary so you can just add a pom block to the core-deploy project.
>>>>>>>>>>>>
>>>>>>>>>>>> Cheers
>>>>>>>>>>>> Steve
>>>>>>>>>>>>
>>>>>>>>>>>> Sent from my iPhone
>>>>>>>>>>>>
>>>>>>>>>>>> On 15/07/2011, at 2:49, Omer Piperdi<omer at rice.edu> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> I am wondering if I should use 0.9 tag or trunk for CLOG with our Sakai 2.8.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Thanks for any suggestion.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Omer
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> sakai-dev mailing list
>>>>>>>>>>>>> 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"
>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>> sakai-dev mailing list
>>>>>>>>>>>> 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"
>>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> sakai-dev mailing list
>>>>>>>>>>> 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"
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>> _______________________________________________
>>>>>>>>>> sakai-dev mailing list
>>>>>>>>>> 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"
>>>>>>>>> _______________________________________________
>>>>>>>>> sakai-dev mailing list
>>>>>>>>> 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"
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>> _______________________________________________
>>>>> sakai-dev mailing list
>>>>> 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"
>>>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> 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"
>>>
>>>
>>>
>>>
>> _______________________________________________
>> sakai-dev mailing list
>> 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"
>>
>> !DSPAM:2294,4e285ea1144541155312003!
>>
>>
> _______________________________________________
> sakai-dev mailing list
> 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"
>
--
==================================
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/CLOG/Home
http://confluence.sakaiproject.org/display/BBB/Home
More information about the sakai-dev
mailing list