List of createSQLQuery() Examples

Examples of createSQLQuery()

com.liferay.portal.kernel.dao.orm.Session.createSQLQuery()
org.hibernate.Session.createSQLQuery()
Create a new instance of SQLQuery for the given SQL query string. @param queryString a SQL query @return SQLQuery @throws HibernateException
org.hibernate.StatelessSession.createSQLQuery()
Create a new instance of SQLQuery for the given SQL query string. Entities returned by the query are detached. @param queryString a SQL query @return SQLQuery @throws HibernateException
org.hibernate.classic.Session.createSQLQuery()
Create a new instance of Query for the given SQL string. @deprecated will be replaced with a more Query like interface in later release @param sql a query expressed in SQL @param returnAlias a table alias that appears inside {} in the SQL string @param returnClass the returned persistent class
org.hibernate.search.FullTextSession.createSQLQuery()

Examples of org.hibernate.StatelessSession.createSQLQuery()

        int failureCount = 0;
        while (failureCount < MAX_NUMBER_OF_FAILURES) {
            try {
                StatelessSession session = getSQLSession(config);
                session.getTransaction().begin();
                org.hibernate.Query nativeQuery = session.createSQLQuery(this.deleteQuery);
                nativeQuery.executeUpdate();
                session.getTransaction().commit();
                closeSQLSession(session);
                log.info("- " + migrationTable.toString() + " - Cleaned -");
            } catch (Exception e) {

View Full Code Here

Examples of org.hibernate.StatelessSession.createSQLQuery()

        when(mockHibernateSession.getSessionFactory()).thenReturn(mockSessionFactory);
        StatelessSession mockStatelessSession = mock(StatelessSession.class);
        when(mockSessionFactory.openStatelessSession()).thenReturn(mockStatelessSession);


        org.hibernate.SQLQuery mockQuery = mock(org.hibernate.SQLQuery.class);
        when(mockStatelessSession.createSQLQuery(any(String.class))).thenReturn(mockQuery);


        when(mockQuery.uniqueResult()).thenReturn("1000");


        ScrollableDataSource mockDataSource = mock(ScrollableDataSource.class);
        PowerMockito.whenNew(ScrollableDataSource.class)

View Full Code Here

Examples of org.hibernate.StatelessSession.createSQLQuery()

        when(mockHibernateSession.getSessionFactory()).thenReturn(mockSessionFactory);
        StatelessSession mockStatelessSession = mock(StatelessSession.class);
        when(mockSessionFactory.openStatelessSession()).thenReturn(mockStatelessSession);


        org.hibernate.SQLQuery mockQuery = mock(org.hibernate.SQLQuery.class);
        when(mockStatelessSession.createSQLQuery(any(String.class))).thenReturn(mockQuery);


        when(mockQuery.uniqueResult()).thenReturn("1000");


        ScrollableDataSource mockDataSource = mock(ScrollableDataSource.class);
        PowerMockito.whenNew(ScrollableDataSource.class).withArguments(eq(mockEntityManager), eq(databaseType), any())

View Full Code Here

Examples of org.hibernate.StatelessSession.createSQLQuery()

        when(mockHibernateSession.getSessionFactory()).thenReturn(mockSessionFactory);
        StatelessSession mockStatelessSession = mock(StatelessSession.class);
        when(mockSessionFactory.openStatelessSession()).thenReturn(mockStatelessSession);


        org.hibernate.SQLQuery mockQuery = mock(org.hibernate.SQLQuery.class);
        when(mockStatelessSession.createSQLQuery(any(String.class))).thenReturn(mockQuery);


        when(mockQuery.uniqueResult()).thenReturn("1000");


        ScrollableDataSource mockDataSource = mock(ScrollableDataSource.class);
        PowerMockito.whenNew(ScrollableDataSource.class)

View Full Code Here

Examples of org.hibernate.StatelessSession.createSQLQuery()

        when(mockHibernateSession.getSessionFactory()).thenReturn(mockSessionFactory);
        StatelessSession mockStatelessSession = mock(StatelessSession.class);
        when(mockSessionFactory.openStatelessSession()).thenReturn(mockStatelessSession);


        org.hibernate.SQLQuery mockQuery = mock(org.hibernate.SQLQuery.class);
        when(mockStatelessSession.createSQLQuery(any(String.class))).thenReturn(mockQuery);


        when(mockQuery.uniqueResult()).thenReturn("1000");


        ScrollableDataSource mockDataSource = mock(ScrollableDataSource.class);
        PowerMockito.whenNew(ScrollableDataSource.class).withArguments(eq(mockEntityManager), eq(databaseType), any())

View Full Code Here

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


    Session session = sessionFactory_.openSession();
    final long startTime = System.currentTimeMillis();
    try{
      session.beginTransaction();
      Query dbQuery = session.createSQLQuery(query);
      
      dbQuery.setBoolean("resAdminAction", resourceAdminAction);
      dbQuery.setString("resId", Long.toString(resourceableId));
      if (begin != null) {
        dbQuery.setDate("createdAfter", begin);

View Full Code Here

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

    Transaction t = s.beginTransaction();


    List l = s.createQuery("from Vehicle").list();
    assertEquals(l.size(),4);


    s.createSQLQuery( "insert into PICKUP (id, vin, owner) select id, vin, owner from Car" ).executeUpdate();


    l = s.createQuery("from Vehicle").list();
    assertEquals(l.size(),5);


    t.commit();

View Full Code Here

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

    assertEquals(l.size(),5);


    t.commit();
    t = s.beginTransaction();


    s.createSQLQuery( "delete from TRUCK" ).executeUpdate();


    l = s.createQuery("from Vehicle").list();
    assertEquals(l.size(),4);


    Car c = (Car) s.createQuery( "from Car where owner = 'Kirsten'" ).uniqueResult();

View Full Code Here

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

    c.setOwner("NotKirsten");
    assertEquals(0,s.getNamedQuery( "native-delete-car" ).setString( 0, "Kirsten" ).executeUpdate());
    assertEquals(1,s.getNamedQuery( "native-delete-car" ).setString( 0, "NotKirsten" ).executeUpdate());
    
    
    assertEquals(0,s.createSQLQuery( "delete from SUV where owner = :owner" ).setString( "owner", "NotThere" ).executeUpdate());
    assertEquals(1,s.createSQLQuery( "delete from SUV where owner = :owner" ).setString( "owner", "Joe" ).executeUpdate());
    s.createSQLQuery( "delete from PICKUP" ).executeUpdate();


    l = s.createQuery("from Vehicle").list();
    assertEquals(l.size(),0);

View Full Code Here

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

    assertEquals(0,s.getNamedQuery( "native-delete-car" ).setString( 0, "Kirsten" ).executeUpdate());
    assertEquals(1,s.getNamedQuery( "native-delete-car" ).setString( 0, "NotKirsten" ).executeUpdate());
    
    
    assertEquals(0,s.createSQLQuery( "delete from SUV where owner = :owner" ).setString( "owner", "NotThere" ).executeUpdate());
    assertEquals(1,s.createSQLQuery( "delete from SUV where owner = :owner" ).setString( "owner", "Joe" ).executeUpdate());
    s.createSQLQuery( "delete from PICKUP" ).executeUpdate();


    l = s.createQuery("from Vehicle").list();
    assertEquals(l.size(),0);

View Full Code Here

0 1 2 3 4 5

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.