[Building Sakai] Updating SQL database directly

[Nguni Phakela]

I have always went to this link:
http://source.sakaiproject.org/release/kernel/1.2.2/apidocs/

But it would definitely help to be able to just have it locally.

Thanx. :-D

Nguni


On Wed, Jan 30, 2013 at 4:25 PM, Mark J. Norton
<markjnorton at earthlink.net>wrote:

>  The UserDirectoryService is part of the Sakai kernel.  Download this
> from SVN:  https://source.sakaiproject.org/svn/kernel/tags/kernel-1.1.0/(or whatever version you are running)
>
> Cd into that directory and run "mvn javadoc:javadoc".  The JavaDoc results
> will be located in kernel-1.1.0/target/site/apidocs.  Load the index.htm
> file into a browser and you'll have all the technical documentation you
> need to make this work.
>
> - Mark Norton
>
>
>
> On 1/30/2013 9:10 AM, Nguni Phakela wrote:
>
> Thank you Mark. I wasn't sure if there was another approach to this. I
> will try that.
>
>  Cheers,
> Nguni
>
>
>  On Wed, Jan 30, 2013 at 3:56 PM, Mark J. Norton <
> markjnorton at earthlink.net> wrote:
>
>>  Why do this with a direct database operations?  This is what the User
>> service is supposed to handle.  Get an instance of the
>> UserDirectoryService, get a UserEdit instance for the user id.  Set the EID
>> and commit it.
>>
>> - Mark Norton
>>
>>
>> On 1/30/2013 4:02 AM, Nguni Phakela wrote:
>>
>>  Hi,
>>
>>  I have the following code to update a table:
>>
>>  conn = dataSource.getConnection();
>> String updateString = "update SAKAI_USER_ID_MAP set EID = ?  where
>> USER_ID = ?";
>>  PreparedStatement updateOptions = conn.prepareStatement(updateString);
>>
>>  System.out.println(updateOptions.toString());
>>
>>  updateOptions.setString(1, studentNumber);
>> updateOptions.setString(2, user.getId());
>>
>>  System.out.println(updateOptions.toString());
>>
>>  int rowsUpdated = updateOptions.executeUpdate();
>>
>>  System.out.println("Number of rows updated: " + rowsUpdated);
>>
>>
>>  I'm getting the following output:
>>  com.mysql.jdbc.JDBC4PreparedStatement at 77c03963: update
>> SAKAI_USER_ID_MAP set EID = ** NOT SPECIFIED **  where USER_ID = ** NOT
>> SPECIFIED **
>> com.mysql.jdbc.JDBC4PreparedStatement at 77c03963: update SAKAI_USER_ID_MAP
>> set EID = 'xxxxxx'  where USER_ID = 'xxxxxxxxx-d0fb-4824-aa45-f65e5ecad515'
>>
>>  The executeUpdate() seems to not be executing, and the printout for the
>> number of rows updated
>> also seems to not be executing.
>>
>>  What could I be missing?
>>
>>  Cheers
>>
>>  --
>> Nguni Phakela
>>
>>
>>  _______________________________________________
>> sakai-dev mailing listsakai-dev at collab.sakaiproject.orghttp://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"
>>
>
>
>
>  --
> Nguni Phakela
>
>
>


-- 
Nguni Phakela
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130130/a58c67b8/attachment.html