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

    Object[] row1 = (Object[]) list.get(0);
    assertTrue( row1[0]==foo && row1[1]==foo2 );


    s.find("select foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.string from Foo foo where foo.foo.foo.foo.string = 'bar'");
    if ( ! (getDialect() instanceof HSQLDialect) ) s.find("select foo.string from Foo foo where foo.foo.foo.foo = foo.foo.foo");
    s.find("select foo.string from Foo foo where foo.foo.foo = 'bar' and foo.foo.foo.foo = 'baz'");
    s.find("select foo.string from Foo foo where foo.foo.foo.foo.string = 'a' and foo.foo.string = 'b'");

View Full Code Here

    assertTrue( row1[0]==foo && row1[1]==foo2 );


    s.find("select foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.string from Foo foo where foo.foo.foo.foo.string = 'bar'");
    if ( ! (getDialect() instanceof HSQLDialect) ) s.find("select foo.string from Foo foo where foo.foo.foo.foo = foo.foo.foo");
    s.find("select foo.string from Foo foo where foo.foo.foo = 'bar' and foo.foo.foo.foo = 'baz'");
    s.find("select foo.string from Foo foo where foo.foo.foo.foo.string = 'a' and foo.foo.string = 'b'");

View Full Code Here


    s.find("select foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.string from Foo foo where foo.foo.foo.foo.string = 'bar'");
    if ( ! (getDialect() instanceof HSQLDialect) ) s.find("select foo.string from Foo foo where foo.foo.foo.foo = foo.foo.foo");
    s.find("select foo.string from Foo foo where foo.foo.foo = 'bar' and foo.foo.foo.foo = 'baz'");
    s.find("select foo.string from Foo foo where foo.foo.foo.foo.string = 'a' and foo.foo.string = 'b'");


    s.find("from Bar bar, foo in elements(bar.baz.fooArray)");

View Full Code Here

    s.find("select foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.string from Foo foo where foo.foo.foo.foo.string = 'bar'");
    if ( ! (getDialect() instanceof HSQLDialect) ) s.find("select foo.string from Foo foo where foo.foo.foo.foo = foo.foo.foo");
    s.find("select foo.string from Foo foo where foo.foo.foo = 'bar' and foo.foo.foo.foo = 'baz'");
    s.find("select foo.string from Foo foo where foo.foo.foo.foo.string = 'a' and foo.foo.string = 'b'");


    s.find("from Bar bar, foo in elements(bar.baz.fooArray)");

View Full Code Here

    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo = 'bar'");
    s.find("select foo from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.string from Foo foo where foo.foo.foo.foo.string = 'bar'");
    if ( ! (getDialect() instanceof HSQLDialect) ) s.find("select foo.string from Foo foo where foo.foo.foo.foo = foo.foo.foo");
    s.find("select foo.string from Foo foo where foo.foo.foo = 'bar' and foo.foo.foo.foo = 'baz'");
    s.find("select foo.string from Foo foo where foo.foo.foo.foo.string = 'a' and foo.foo.string = 'b'");


    s.find("from Bar bar, foo in elements(bar.baz.fooArray)");


    //s.find("from Baz as baz where baz.topComponents[baz].name = 'bazzz'");

View Full Code Here

    s.find("select foo from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.foo.string from Foo foo where foo.foo.foo = 'bar'");
    s.find("select foo.foo.foo.string from Foo foo where foo.foo.foo.foo.string = 'bar'");
    if ( ! (getDialect() instanceof HSQLDialect) ) s.find("select foo.string from Foo foo where foo.foo.foo.foo = foo.foo.foo");
    s.find("select foo.string from Foo foo where foo.foo.foo = 'bar' and foo.foo.foo.foo = 'baz'");
    s.find("select foo.string from Foo foo where foo.foo.foo.foo.string = 'a' and foo.foo.string = 'b'");


    s.find("from Bar bar, foo in elements(bar.baz.fooArray)");


    //s.find("from Baz as baz where baz.topComponents[baz].name = 'bazzz'");

View Full Code Here

    s.find("select foo.foo.foo.string from Foo foo where foo.foo.foo.foo.string = 'bar'");
    if ( ! (getDialect() instanceof HSQLDialect) ) s.find("select foo.string from Foo foo where foo.foo.foo.foo = foo.foo.foo");
    s.find("select foo.string from Foo foo where foo.foo.foo = 'bar' and foo.foo.foo.foo = 'baz'");
    s.find("select foo.string from Foo foo where foo.foo.foo.foo.string = 'a' and foo.foo.string = 'b'");


    s.find("from Bar bar, foo in elements(bar.baz.fooArray)");


    //s.find("from Baz as baz where baz.topComponents[baz].name = 'bazzz'");


    if ( (getDialect() instanceof DB2Dialect) && !(getDialect() instanceof DerbyDialect) ) {
      s.find("from Foo foo where lower( foo.foo.string ) = 'foo'");

View Full Code Here

    s.find("from Bar bar, foo in elements(bar.baz.fooArray)");


    //s.find("from Baz as baz where baz.topComponents[baz].name = 'bazzz'");


    if ( (getDialect() instanceof DB2Dialect) && !(getDialect() instanceof DerbyDialect) ) {
      s.find("from Foo foo where lower( foo.foo.string ) = 'foo'");
      s.find("from Foo foo where lower( (foo.foo.string || 'foo') || 'bar' ) = 'foo'");
      s.find("from Foo foo where repeat( (foo.foo.string || 'foo') || 'bar', 2 ) = 'foo'");
      s.find("from Bar foo where foo.foo.integer is not null and repeat( (foo.foo.string || 'foo') || 'bar', (5+5)/2 ) = 'foo'");
      s.find("from Bar foo where foo.foo.integer is not null or repeat( (foo.foo.string || 'foo') || 'bar', (5+5)/2 ) = 'foo'");
    }

View Full Code Here


    //s.find("from Baz as baz where baz.topComponents[baz].name = 'bazzz'");


    if ( (getDialect() instanceof DB2Dialect) && !(getDialect() instanceof DerbyDialect) ) {
      s.find("from Foo foo where lower( foo.foo.string ) = 'foo'");
      s.find("from Foo foo where lower( (foo.foo.string || 'foo') || 'bar' ) = 'foo'");
      s.find("from Foo foo where repeat( (foo.foo.string || 'foo') || 'bar', 2 ) = 'foo'");
      s.find("from Bar foo where foo.foo.integer is not null and repeat( (foo.foo.string || 'foo') || 'bar', (5+5)/2 ) = 'foo'");
      s.find("from Bar foo where foo.foo.integer is not null or repeat( (foo.foo.string || 'foo') || 'bar', (5+5)/2 ) = 'foo'");
    }
    if (getDialect() instanceof SybaseDialect) {

View Full Code Here

    //s.find("from Baz as baz where baz.topComponents[baz].name = 'bazzz'");


    if ( (getDialect() instanceof DB2Dialect) && !(getDialect() instanceof DerbyDialect) ) {
      s.find("from Foo foo where lower( foo.foo.string ) = 'foo'");
      s.find("from Foo foo where lower( (foo.foo.string || 'foo') || 'bar' ) = 'foo'");
      s.find("from Foo foo where repeat( (foo.foo.string || 'foo') || 'bar', 2 ) = 'foo'");
      s.find("from Bar foo where foo.foo.integer is not null and repeat( (foo.foo.string || 'foo') || 'bar', (5+5)/2 ) = 'foo'");
      s.find("from Bar foo where foo.foo.integer is not null or repeat( (foo.foo.string || 'foo') || 'bar', (5+5)/2 ) = 'foo'");
    }
    if (getDialect() instanceof SybaseDialect) {  
      s.iterate("select baz from Baz as baz join baz.fooArray foo group by baz order by sum(foo.float)");

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.