[Building Sakai] Saving a site property in 2.8.x

[Erik Froese]

I had the same problem with the 5.1.16 driver with 5.5.10 as well.

On Tue, Nov 15, 2011 at 3:41 PM, Carl Hall <carl at hallwaytech.com> wrote:
> I poked Aaron about this and he's using 5.5.10 server with 5.1.16 driver.
> Makes me wonder if the 5.1.18 driver is problematic.
>
> On Tue, Nov 15, 2011 at 3:14 PM, Steve Swinsburg <steve.swinsburg at gmail.com>
> wrote:
>>
>> Hi Erik,
>> Could you raise this as a Jira? Something for us to look at for future
>> support of 5.5 perhaps.
>>
>> Cheers,
>> Steve
>>
>> Sent from my iPhone
>>
>> On 16/11/2011, at 5:35, Erik Froese <erik.froese at gmail.com> wrote:
>>
>> > I fixed it so I figured I'd report.
>> >
>> > I downgraded MySQL from 5.5.10 to 5.1.59 and started from a fresh
>> > database.
>> > I was using mysql-connector-java-5.1.18.
>> >
>> > Erik
>> >
>> > On Mon, Nov 14, 2011 at 5:30 PM, Erik Froese <erik.froese at gmail.com>
>> > wrote:
>> >> I'm trying to save a property on a Site object in Sakai 2.8.x and I
>> >> think I'm running into a unicode problem.
>> >>
>> >> First I set the property on a SiteEdit before it is sent through the
>> >> SiteService.
>> >>
>> >> // sEdit is a SiteEdit Object
>> >> ResourcePropertiesEdit rp = sEdit.getPropertiesEdit();
>> >> rp.addProperty(STATE_SITE_ACCESS_SHOPPING_ALLOWED_FUNCTIONS,
>> >> StringUtils.join(allowedFunctions, "|"));
>> >>
>> >> Later the sEdit is saved by calling SiteService.save(site). I'm
>> >> modifying the SiteAction class (yikes!) so its taking care of calling
>> >> save(sEdit)
>> >>
>> >> What should happen is we should see a statement issued to MySQL like
>> >> this:
>> >> insert into SAKAI_SITE_PROPERTY( SITE_ID, NAME, VALUE ) values
>> >> ("3b1c5adf-29b6-40b3-954f-a9f841a92411", "shopping-allowed-functions",
>> >> "annc.read|asn.read|calendar.read")
>> >>
>> >> What I see instead is this:
>> >>
>> >>  insert into SAKAI_SITE_PROPERTY( SITE_ID, NAME, VALUE ) values
>> >>
>> >> (x'33623163356164662D323962362D343062332D393534662D613966383431613932343131',x'73746174655F736974655F6163636573735F73686F7070696E675F616C6C6F7765645F66756E6374696F6E73',x'616E6E632E726561647C61736E2E726561647C63616C656E6461722E72656164')
>> >>
>> >> As far as I can tell this is caused by
>> >> BasicSqlService.prepareStatement setting the statement parameters
>> >> using setBytes.
>> >>
>> >> This causes the constraint violation since the SITE_ID doesn't match
>> >> anything in SAKAI_SITE.
>> >>
>> >> I see this in catalina.out
>> >> Caused by:
>> >> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
>> >> Cannot add or update a child row: a foreign key constraint fails
>> >> (`sakai`.`sakai_site_property`, CONSTRAINT
>> >> `sakai_site_property_ibfk_1` FOREIGN KEY (`SITE_ID`) REFERENCES
>> >> `SAKAI_SITE` (`SITE_ID`))
>> >>
>> >> Has anyone else run into this? Any pointers?
>> >>
>> >> Thanks
>> >>
>> >> Erik
>> >>
>> > _______________________________________________
>> > 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"
>
>