Code example for Session

 */ 
public class NativeQueryTest extends AbstractJPATest { 
	@Test
	public void testJpaStylePositionalParametersInNativeSql() { 
		Session s = openSession();
		s.beginTransaction();
		s.createSQLQuery( "select NAME from EJB3_ITEM where ITEM_ID = ?1" ).setParameter( "1", new Long( 123 ) ).list();
		s.getTransaction().commit();
		s.close();
	} 
}