From mahout-user-return-1635-apmail-lucene-mahout-user-archive=lucene.apache.org@lucene.apache.org Wed Nov 04 17:28:18 2009 Return-Path: Delivered-To: apmail-lucene-mahout-user-archive@minotaur.apache.org Received: (qmail 14101 invoked from network); 4 Nov 2009 17:28:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Nov 2009 17:28:18 -0000 Received: (qmail 4383 invoked by uid 500); 4 Nov 2009 17:28:18 -0000 Delivered-To: apmail-lucene-mahout-user-archive@lucene.apache.org Received: (qmail 4319 invoked by uid 500); 4 Nov 2009 17:28:17 -0000 Mailing-List: contact mahout-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: mahout-user@lucene.apache.org Delivered-To: mailing list mahout-user@lucene.apache.org Received: (qmail 4309 invoked by uid 99); 4 Nov 2009 17:28:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Nov 2009 17:28:17 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of srowen@gmail.com designates 74.125.78.25 as permitted sender) Received: from [74.125.78.25] (HELO ey-out-2122.google.com) (74.125.78.25) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Nov 2009 17:28:15 +0000 Received: by ey-out-2122.google.com with SMTP id 22so1631312eye.3 for ; Wed, 04 Nov 2009 09:27:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=EaEGreqMKoHbNKO+6G0LJbzJzcVl7EN8FkvYsPj0KP8=; b=sZyGHF9CdiOThlXBAfLTqICdV5bU36u5csB8hqwzR6A5tzUirVK2HvWtlD5i2NoRAa nlJnwFCe47H4/haOp2R0v6Qb3FNnBSblNt5BN1fT4VooNmACn1dPSwt8p8N/UZKdQL68 e1FcvgeXtHrK97LC9TYUBYBAYcaNtPCAQzPFs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=ZTQeMn1zG3hBLpwBp0cPphl3HOAL9ma4nbQBY8eL9PLLJJj6n1IWs5r/hZqPVdmRQt vdCmU33fhTCoZMPAJB/oZTsaZV05XQn5QoIx5HOfBsYfv9IrrWgAiJzOwklLUlQJHH6F G652SkOoBC5LWpw6mE8Gbcdrgdl95S0BESvP0= MIME-Version: 1.0 Received: by 10.216.89.213 with SMTP id c63mr514064wef.211.1257355673936; Wed, 04 Nov 2009 09:27:53 -0800 (PST) In-Reply-To: <938CD96C-4C7B-48BD-A967-82E46941E108@googlemail.com> References: <938CD96C-4C7B-48BD-A967-82E46941E108@googlemail.com> Date: Wed, 4 Nov 2009 17:27:53 +0000 Message-ID: Subject: Re: GenericJDBCDataModel problem (getItems, getUsers) From: Sean Owen To: mahout-user@lucene.apache.org Content-Type: multipart/alternative; boundary=0016e6d464cc4d25b204778eee26 --0016e6d464cc4d25b204778eee26 Content-Type: text/plain; charset=UTF-8 If you are using some SPARQL-in-SQL system then you must be customizing a lot, at least the SQL queries. It is hard to help since all that is not project code. Are you so sure the queries being executed work? Have you looked at log output? What code version? No there should be no hidden exceptions - but some are logged not thrown where not possible. I would just debug, that will show the issue quickly. On Nov 4, 2009 5:04 PM, "Mirko" wrote: Hi, I have problems with the GenericJDBCDataModel. For me, the functions getUsers() and getItems() return nothing, although the SQL queries used in the functions definitely do return results. All other functions in the DataModel work as expected. The results of the queries used in getUsers() and getItems() look as follows: SQL result for GenericJDBCDataModel.GET_ITEMS_SQL_KEY: item_id ------------ itemID_A itemID_B itemID_C itemID_D itemID_E ... SQL result for GenericJDBCDataModel.GET_USERS_SQL_KEY item_id callret-1 user_id ---------------------------------------------- itemID_A 1 userID_X itemID_B 1 userID_Y itemID_C 1 userID_Z ... I think these results should be correct (Preferences are always 1 in my data). But the Iterables returned by both functions seem to be empty: GenericJDBCDataModel dm = new GenericJDBCDataModel(props); for ( Item item : dm.getItems()){ System.out.println(item.getID()); //Never reached } for ( User user : dm.getUsers()){ System.out.println(user.getID()); //Never reached } I should note that I query an OpenLink Virtuoso RDF store, which uses SPARQL queries enclosed in SQL queries. That means that 'columns' and 'tables' , and thus the variables DEFAULT_PREFERENCE_TABLE, DEFAULT_USER_ID_COLUMN, DEFAULT_ITEM_ID_COLUMN and DEFAULT_PREFERENCE_COLUMN of AbstractJDBCDataModel don't have any meaning. But as I understand the code, they are not required when using the GenericJDBCDataModel. Is it possible that some exception is thrown 'silently' in the AbstractJDBCDataModel? I have no idea where to look for the prob, so thanks for any hints.... Regards, Mirko --0016e6d464cc4d25b204778eee26--