I think you can update the link in the Shindig wiki topic about rel database integration at https://cwiki.apache.org/SHINDIG/index.html#Index-HowdoIintegratearelationaldatabasewithShindig%253F
It already has a comment about being need for an update. <https://cwiki.apache.org/SHINDIG/index.html#Index-HowdoIintegratearelationaldatabasewithShindig%253F>- Henry On Wed, Jul 14, 2010 at 8:10 AM, Evgeny Bogdanov <evgeny.bogda...@epfl.ch>wrote: > Well, here is a first post how to use mysql database with java shindig. > > http://vohtaski.blogspot.com/2010/07/java-shindig-how-to-add-your-own-social.html > > Next post will be about connecting my own social database with shindig, > that I am doing now :) > > If you find it useful, I can create a wiki page for it. > I also have a patch that does all the mentioned in post changes. > Should I upload it to jira or some other place? > > Evgeny > > > On 13.07.10 21:56, John Hjelmstad wrote: > >> I'd be interested to see the Shindig Wiki, or some other official/easy to >> find documentation (seems like Wiki is the consensus at this point >> however? >> what do others think?) updated with such information as well. >> >> Many thanks, >> John >> >> On Tue, Jul 13, 2010 at 12:29 PM, Henry Saputra<henry.sapu...@gmail.com >> >wrote: >> >> >> >>> HI Evgeny, >>> >>> A blog about this would be great. I be a lot other developers also >>> interested to hook up Shindig with their database. >>> >>> - Henry >>> >>> On Tue, Jul 13, 2010 at 12:49 AM, Evgeny Bogdanov >>> <evgeny.bogda...@epfl.ch>wrote: >>> >>> >>> >>>> Thanks Franck for your help! >>>> >>>> It seems as I found a solution (At least now I am able to login to the >>>> database :)) >>>> I had to move all dependencies from samples/pom.xml to social/pom.xml, >>>> if I only put dependency in social/pom.xml on artifactId = samples, >>>> it didn't find the needed classes. >>>> >>>> I will write a blog post on how and what I did, maybe it will >>>> be useful for somebody. >>>> >>>> Evgeny >>>> >>>> >>>> On 12.07.10 18:25, franck tankoua wrote: >>>> >>>> >>>> >>>>> Hi Evgeny. I have my own guice module based on JPA. >>>>> >>>>> >>>>> On Mon, Jul 12, 2010 at 5:56 PM, Evgeny Bogdanov< >>>>> >>>>> >>>> evgeny.bogda...@epfl.ch >>> >>> >>>> wrote: >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >>>>>> The same problem is with a branches/2.0.x/ >>>>>> >>>>>> Franck, How did you add your own Guice JPA? >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> this is from my web.xml >>>>> >>>>> <context-param> >>>>> <param-name>guice-modules</param-name> >>>>> <param-value> >>>>> org.apache.shindig.common.PropertiesModule: >>>>> org.apache.shindig.gadgets.DefaultGuiceModule: >>>>> com.packagepath.MyJPAModule: >>>>> org.apache.shindig.gadgets.oauth.OAuthModule >>>>> </param-value> >>>>> </context-param> >>>>> >>>>> >>>>> >>>>> Did you also register it in web.xml >>>>> >>>>> >>>>> >>>>> >>>>>> and added a module into profile "all" in shindig/pom.xml? >>>>>> >>>>>> Actually I did not add anythinig to the "all" in the pom.xml. >>>>>> >>>>>> >>>>>> >>>>>> >>>>> Basically I am not using shindig-server but my own application web.xml >>>>> >>>>> >>>> to >>> >>> >>>> which I have add the shindig guice modules. >>>>> >>>>> So I am not sure what you are trying to achieve but may be by >>>>> explaining >>>>> me >>>>> I can share better my experience with the JPA implementation. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>> Or did you add some dependencies? >>>>>> >>>>>> I think I know what is going on. i have download a fresh shindig from >>>>>> trunk >>>>>> >>>>>> >>>>>> >>>>>> >>>>> and I have done what you have said. It does not work either. It looks >>>>> >>>>> >>>> like >>> >>> >>>> you have forgot this in your stacktrace. >>>>> >>>>> 2010-07-12 18:21:32.312:INFO::No Transaction manager found - if your >>>>> webapp >>>>> requires one, please configure one. >>>>> >>>>> After you configure the transaction manager it should not trash >>>>> anymore. >>>>> >>>>> hope it helps >>>>> >>>>> Sure I have added dependencies to hibernate >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>> On 12.07.10 15:59, franck tankoua wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> http://svn.apache.org/repos/asf/shindig/branches/2.0.x/ >>>>>>> <http://svn.apache.org/repos/asf/shindig/branches/2.0.x/> >>>>>>> >>>>>>> On Mon, Jul 12, 2010 at 3:49 PM, Evgeny Bogdanov< >>>>>>> evgeny.bogda...@epfl.ch >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>>> wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>>> Where do you take shindig 2.0 release (I can't find it)? Or do you >>>>>>>> >>>>>>>> >>>>>>> mean >>> >>> >>>> trunk here? >>>>>>>> >>>>>>>> >>>>>>>> On 12.07.10 15:18, franck tankoua wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>> I am using my own JPA implementation and the shindig 2.0 release. >>>>>>>>> things work fine so far. >>>>>>>>> >>>>>>>>> I will try to add JPAModule and let you know. which version of >>>>>>>>> >>>>>>>>> >>>>>>>> shindig >>> >>> >>>> are >>>>>>>>> you using? the trunk version ? >>>>>>>>> >>>>>>>>> On Mon, Jul 12, 2010 at 2:38 PM, Evgeny Bogdanov< >>>>>>>>> evgeny.bogda...@epfl.ch >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>>> Thank you Franck for helping! >>>>>>>>>> >>>>>>>>>> still the same >>>>>>>>>> Does it work for you? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 12.07.10 14:27, franck tankoua wrote: >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> what if you remove the space line before JPASocialModule? >>>>>>>>>>> >>>>>>>>>>> On Mon, Jul 12, 2010 at 2:25 PM, Evgeny Bogdanov< >>>>>>>>>>> evgeny.bogda...@epfl.ch >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>>> wrote: >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>>> On 12.07.10 14:19, franck tankoua wrote: >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>>> Just out of curiosity. which version are you using? >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> Do you mean shindig? (latest trunk shindig) >>>>>>>>>>>> $ mvn --version >>>>>>>>>>>> Apache Maven 2.2.0 (r788681; 2009-06-26 15:04:01+0200) >>>>>>>>>>>> Java version: 1.6.0_20 >>>>>>>>>>>> Java home: >>>>>>>>>>>> /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home >>>>>>>>>>>> Default locale: en_US, platform encoding: MacRoman >>>>>>>>>>>> OS name: "mac os x" version: "10.6.4" arch: "x86_64" Family: >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> "mac" >>> >>> >>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>>> could you paste also the web.xml param-value for your >>>>>>>>>>>>> param-name >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> * >>> >>> >>>> guice-modules* . >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> <context-param> >>>>>>>>>>>> <param-name>guice-modules</param-name> >>>>>>>>>>>> <param-value> >>>>>>>>>>>> org.apache.shindig.common.PropertiesModule: >>>>>>>>>>>> org.apache.shindig.gadgets.DefaultGuiceModule: >>>>>>>>>>>> org.apache.shindig.social.core.config.SocialApiGuiceModule: >>>>>>>>>>>> org.apache.shindig.social.sample.SampleModule: >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> org.apache.shindig.social.opensocial.jpa.spi.JPASocialModule: >>> >>> >>>> org.apache.shindig.gadgets.oauth.OAuthModule: >>>>>>>>>>>> org.apache.shindig.common.cache.ehcache.EhCacheModule: >>>>>>>>>>>> org.apache.shindig.sample.shiro.ShiroGuiceModule: >>>>>>>>>>>> >>>>>>>>>>>> org.apache.shindig.sample.container.SampleContainerGuiceModule: >>>>>>>>>>>> org.apache.shindig.extras.ShindigExtrasGuiceModule: >>>>>>>>>>>> org.apache.shindig.extras.as.ActivityStreamsGuiceModule >>>>>>>>>>>> </param-value> >>>>>>>>>>>> </context-param> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>>> On Mon, Jul 12, 2010 at 2:04 PM, Evgeny Bogdanov< >>>>>>>>>>>>> evgeny.bogda...@epfl.ch >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>>> Probably misunderstood you before ... >>>>>>>>>>>>>> I did now: >>>>>>>>>>>>>> $cd java/samples >>>>>>>>>>>>>> $mvn >>>>>>>>>>>>>> Build Successful >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On 12.07.10 13:02, franck tankoua wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>>> were you able to successfully run mvn at /java/samples level? >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Mon, Jul 12, 2010 at 12:57 PM, Evgeny Bogdanov >>>>>>>>>>>>>>> <evgeny.bogda...@epfl.ch>wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Sorry for spamming but I still can't get a working version. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> This is what I did based on the suggestions here. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 1) I've checked out a latest shindig version. >>>>>>>>>>>>>>>> 2) I added a Guice module >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>> "org.apache.shindig.social.opensocial.jpa.spi.JPASocialModule:" >>> >>> >>>> into java/server/src/main/webapp/WEB-INF/web.xml >>>>>>>>>>>>>>>> 3) I added java/samples into shindig/pom.xml for profile >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> "all" >>> >>> >>>> <profile> >>>>>>>>>>>>>>>> <id>all</id> >>>>>>>>>>>>>>>> <activation> >>>>>>>>>>>>>>>> <activeByDefault>true</activeByDefault> >>>>>>>>>>>>>>>> </activation> >>>>>>>>>>>>>>>> <modules> >>>>>>>>>>>>>>>> <module>features</module> >>>>>>>>>>>>>>>> <module>java/common</module> >>>>>>>>>>>>>>>> <module>java/gadgets</module> >>>>>>>>>>>>>>>> <module>java/social-api</module> >>>>>>>>>>>>>>>> <module>java/samples</module> >>>>>>>>>>>>>>>> <module>java/server</module> >>>>>>>>>>>>>>>> <module>extras</module> >>>>>>>>>>>>>>>> </modules> >>>>>>>>>>>>>>>> </profile> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 4) I compile the code with command >>>>>>>>>>>>>>>> mvn package -Dmaven.test.skip >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 5) Than I go to the java/server and run "mvn jetty:run" >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> However it can't find a class >>>>>>>>>>>>>>>> org.apache.shindig.social.opensocial.jpa.spi.JPASocialModule >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> java.lang.RuntimeException: >>>>>>>>>>>>>>>> java.lang.ClassNotFoundException: >>>>>>>>>>>>>>>> org.apache.shindig.social.opensocial.jpa.spi.JPASocialModule >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>> org.apache.shindig.common.servlet.GuiceServletContextListener.contextInitialized(GuiceServletContextListener.java:63) >>> >>> >>>> I would be very happy if somebody could help or give a hint >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> on >>> >>> >>>> what >>>>>>>>>>>>>>>> I >>>>>>>>>>>>>>>> am >>>>>>>>>>>>>>>> doing wrong >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Thanks in advance >>>>>>>>>>>>>>>> Evgeny >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> . >> >> >> >