Examples of org.hibernate.classic.Session.find()

org.hibernate.classic.Session.find()
Execute a query. @deprecated use {@link #createQuery}. {@link Query#list()} @param query a query expressed in Hibernate's query language @return a distinct list of instances (or arrays of instances) @throws HibernateException

      s.find("from Baz baz inner join baz.fooSet where '1' in (from baz.fooSet foo where foo.string is not null)");
      s.find("from Baz baz where 'a' in elements(baz.collectionComponent.nested.foos) and 1.0 in elements(baz.collectionComponent.nested.floats)");
      s.find("from Baz baz where 'b' in elements(baz.collectionComponent.nested.foos) and 1.0 in elements(baz.collectionComponent.nested.floats)");
    }


    s.find("from Foo foo join foo.foo where foo.foo in ('1','2','3')");
    if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");

View Full Code Here

      s.find("from Baz baz where 'a' in elements(baz.collectionComponent.nested.foos) and 1.0 in elements(baz.collectionComponent.nested.floats)");
      s.find("from Baz baz where 'b' in elements(baz.collectionComponent.nested.foos) and 1.0 in elements(baz.collectionComponent.nested.floats)");
    }


    s.find("from Foo foo join foo.foo where foo.foo in ('1','2','3')");
    if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");

View Full Code Here

      s.find("from Baz baz where 'b' in elements(baz.collectionComponent.nested.foos) and 1.0 in elements(baz.collectionComponent.nested.floats)");
    }


    s.find("from Foo foo join foo.foo where foo.foo in ('1','2','3')");
    if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");

View Full Code Here

    }


    s.find("from Foo foo join foo.foo where foo.foo in ('1','2','3')");
    if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");

View Full Code Here


    s.find("from Foo foo join foo.foo where foo.foo in ('1','2','3')");
    if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");


    s.find("from Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null");

View Full Code Here

    s.find("from Foo foo join foo.foo where foo.foo in ('1','2','3')");
    if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");


    s.find("from Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo.foo where foo1.string is not null");

View Full Code Here

    if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");


    s.find("from Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo foo2 left join foo1.foo.foo foo3 where foo1.string is not null");

View Full Code Here

    s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");


    s.find("from Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo foo2 left join foo1.foo.foo foo3 where foo1.string is not null");

View Full Code Here

    s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");


    s.find("from Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo foo2 left join foo1.foo.foo foo3 where foo1.string is not null");


    s.find("select foo.formula from Foo foo where foo.formula > 0");

View Full Code Here

    s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
    s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");


    s.find("from Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo.foo where foo1.string is not null");
    s.find("from Foo foo1 left join foo1.foo foo2 left join foo1.foo.foo foo3 where foo1.string is not null");


    s.find("select foo.formula from Foo foo where foo.formula > 0");


    int len = s.find("from Foo as foo join foo.foo as foo2 where foo2.id >'a' or foo2.id <'a'").size();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.