{"version":"1.0","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/cypher256/","blog_title":"cypher256's blog","width":"100%","description":"Oracle 10g\u3002S2JDBC \u306e SQL \u81ea\u52d5\u751f\u6210\u3067 leftOuterJoin \u3067 OneToMany \u306e\u7d50\u5408\u3092\u3057\u3066\u3001\u30da\u30fc\u30b8\u30f3\u30b0\u6307\u5b9a\u3059\u308b\u3068\u300cORA-00918: \u5217\u306e\u5b9a\u7fa9\u304c\u672a\u78ba\u5b9a\u3067\u3059\u3002\u300d\u304c\u767a\u751f\u3002\u4f7f\u3044\u65b9\u304c\u307e\u305a\u3044\u3093\u3067\u3057\u3087\u3046\u304b\uff1f \u8abf\u67fb\u4e2d\u3067\u3059\u3002 List<TCmp> oyaList = jdbcManager .from(TOya.class) .leftOuterJoin(\"tKoList\") .limit(10) .offset(2) .getResultList(); \u4e0b\u8a18\u306e\u767a\u884c\u3055\u308c\u3066\u3044\u308b SQL \u3092\u898b\u308b\u3068\u3001\u526f\u554f\u3044\u5408\u308f\u305b\u3067\u540c\u3058\u30ab\u30e9\u30e0\u540d\u304c\u3042\u308b\u305f\u3081\u3001\u767a\u751f\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002\u5225\u540d\u3068\u306a\u308b\u3088\u3046\u306b a\u2026","image_url":null,"provider_name":"Hatena Blog","published":"2008-04-13 00:00:00","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fcypher256.hatenablog.com%2Fentry%2F20080413%2Fp1\" title=\" SQL \u81ea\u52d5\u751f\u6210\u306e\u7d50\u5408\uff0b\u30da\u30fc\u30b8\u30f3\u30b0\u300c\u5217\u306e\u5b9a\u7fa9\u304c\u672a\u78ba\u5b9a\u300d\u3067\u30cf\u30de\u308a\u4e2d - cypher256&#39;s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://cypher256.hatenablog.com/entry/20080413/p1","blog_url":"https://cypher256.hatenablog.com/","author_name":"cypher256","type":"rich","categories":["S2JDBC"],"title":" SQL \u81ea\u52d5\u751f\u6210\u306e\u7d50\u5408\uff0b\u30da\u30fc\u30b8\u30f3\u30b0\u300c\u5217\u306e\u5b9a\u7fa9\u304c\u672a\u78ba\u5b9a\u300d\u3067\u30cf\u30de\u308a\u4e2d"}