[Building Sakai] CLOG for 2.8
Omer Piperdi
omer at rice.edu
Thu Jul 21 11:00:11 PDT 2011
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!
>
>
More information about the sakai-dev
mailing list