cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jotpe (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAY-1975) Unexpected null value when prefetching with Cayenne.objectForQuery
Date Wed, 03 Dec 2014 18:07:12 GMT

    [ https://issues.apache.org/jira/browse/CAY-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233254#comment-14233254
] 

jotpe commented on CAY-1975:
----------------------------

Clear...

Class:
{code}
public class HelperCayenne {
	public static void main(String[] args) {
		Logger LOG = Logger.getGlobal();
		
		int id = new Integer(System.getProperty("id"));

		ServerRuntime runtime = new ServerRuntime(
				GlobalProperties.CAYENNE_CONFIGURATION_FILE);
		ObjectContext context = runtime.getContext();
		
		String sql = "SELECT * FROM israelnationaltrail where id = #bind($currentId)";
		SQLTemplate query = new SQLTemplate(Israelnationaltrail.class, sql);
		query.setParameters(Collections.singletonMap("currentId", id));

		Israelnationaltrail israelnationaltrail = (Israelnationaltrail) Cayenne.objectForQuery(
				context, query);
		LOG.info("tags:"+new ArrayList<Tag>(israelnationaltrail.getTags()));
		
		query.addPrefetch("tags");

		israelnationaltrail = (Israelnationaltrail) Cayenne.objectForQuery(
				context, query);
		LOG.info("tags:"+new ArrayList<Tag>(israelnationaltrail.getTags()));

		runtime.shutdown();
	}
}
{code}

Log:
{noformat}
 287  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - +++ Connecting: SUCCESS.
 322  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - Detected and installed adapter: org.apache.cayenne.dba.postgres.PostgresAdapter
 323  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - --- transaction started.
 421  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - SELECT * FROM israelnationaltrail where id = ? [bind: 1:1128]
 469  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - === returned 1 row. - took 48 ms.
 471  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - +++ transaction committed.
 514  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - --- transaction started.
 529  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - SELECT DISTINCT "t0"."id", "t0"."name" FROM "public"."tag" "t0" JOIN "public"."join_inttag"
"t1" ON ("t0"."id" = "t1"."tag_id") WHERE "t1"."int_id" = ? [bind: 1->int_id:1128] - prepared
in 11 ms.
 533  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - === returned 1 row. - took 16 ms.
 533  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - +++ transaction committed.
 Dez 03, 2014 7:07:27 PM net.jotpe.HelperCayenne main
INFORMATION: tags:[class net.jotpe.data.Tag id:360 name:train]
537  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - --- transaction started.
 537  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - SELECT * FROM israelnationaltrail where id = ? [bind: 1:1128]
 539  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - === returned 1 row. - took 2 ms.
 539  [net.jotpe.HelperCayenne.main()] INFO  org.apache.cayenne.log.CommonsJdbcEventLogger
 - +++ transaction committed.
 Dez 03, 2014 7:07:27 PM net.jotpe.HelperCayenne main
{noformat}

> Unexpected null value when prefetching with Cayenne.objectForQuery
> ------------------------------------------------------------------
>
>                 Key: CAY-1975
>                 URL: https://issues.apache.org/jira/browse/CAY-1975
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Core Library
>    Affects Versions: 3.1
>            Reporter: jotpe
>              Labels: Prefetching, objectforquery
>
> Querying a select query with addPrefetch over Cayenne.objectForQuery results in receiving
null values for these prefetches. Without addPrefetch, the relations are loaded correctly.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message