Your question is somewhat unclear. Assuming &quot;Category&quot; is a root entity and &quot;2,3&quot; are ids (or values of some property of the category&quot;) you can exclude them using the following:

    Criteria criteria = ...; // obtain criteria from somewhere, like session.createCriteria() 
    criteria.add(
      Restrictions.not(
         // replace &quot;id&quot; below with property name, depending on what you&#39;re filtering against
        Restrictions.in(&quot;id&quot;, new long[] {2, 3})
      )
    );

Same can be done with `DetachedCriteria`.     


For the new Criteria since version Hibernate 5.2:

	CriteriaBuilder criteriaBuilder = getSession().getCriteriaBuilder();
	CriteriaQuery&lt;Comment&gt; criteriaQuery = criteriaBuilder.createQuery(Comment.class);

	List&lt;Long&gt; ids = new ArrayList&lt;&gt;();
    ids.add(2L);
    ids.add(3L);

	Root&lt;Comment&gt; root = getRoot(criteriaQuery);
	Path&lt;Object&gt; fieldId = root.get(&quot;id&quot;);
	Predicate in = fieldId.in(ids);
	Predicate predicate = criteriaBuilder.not(in);

	criteriaQuery
	        .select(root)
	        .where(predicate);

	List&lt;Comment&gt; list = getSession()
	        .createQuery(criteriaQuery)
	        .getResultList();

     Session session=(Session) getEntityManager().getDelegate();
            Criteria criteria=session.createCriteria(RoomMaster.class);
    //restriction used or inner restriction ...
            criteria.add(Restrictions.not(Restrictions.in(&quot;roomNumber&quot;,new String[] { &quot;GA8&quot;, &quot;GA7&quot;})));
            criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
            List&lt;RoomMaster&gt; roomMasters=criteria.list();




In most examples I see the following setup of IBOutlets:

&lt;pre&gt;&lt;code&gt;

(Example A)

FooController.h:

@interface FooController : UIViewController {
    UILabel *fooLabel;
}

@property (nonatomic, retain) IBOutlet UILabel *fooLabel;

@end

FooController.m:

@implementation FooController

@synthesize fooLabel;

@end

&lt;/code&gt;&lt;/pre&gt;


But this works also fine (notice: no property and no synthesize):

&lt;pre&gt;&lt;code&gt;

(Example B)

FooController.h:

@interface FooController : UIViewController {
    IBOutlet UILabel *fooLabel;
}

@end

FooController.m:

@implementation FooController

@end

&lt;/code&gt;&lt;/pre&gt;

Are there any downsides of defining IBOutlets as in Example B? Like memory leaks? Seems to work fine and I prefer to not expose the IBOutlets as public properties as they are not used as such, they are only used in the controller implementation. Defining it in three places without a real need does not strike me as very DRY (Don&#39;t Repeat Yourself).

Does an IBOutlet needs to be a property &amp; synthesized?

When I write math in LaTeX I often need to perform simple arithmetic on numbers in my LaTeX source, like `515.1544 + 454 = ???`.

I usually copy-paste the LaTeX code into Google to get the result, but I still have to manually change the syntax, e.g.

&gt; \frac{154,7}{25} - (289 - \frac{1337}{42})

must be changed to

&gt; 154,7/25 - (289 - 1337/42)

It seems trivial to write a program to do this for the most commonly used operations.
Is there a calculator which understand this syntax?

EDIT:
I know that doing this *perfectly* is impossible (because of the halting problem). Doing it for the simple cases I need is trivial. \frac, \cdot, \sqrt and a few other tags would do the trick. The program could just return an error for cases it does not understand.

Is there a calculator with LaTeX-syntax?

I have list of category. I need a list of category by excluding 2,3 row. Can we achieve through hibernate by using Criteria and Restriction?

How to achieve &quot;not in&quot; by using Restrictions and criteria in Hibernate?

<p>I have list of category. I need a list of category by excluding 2,3 row. Can we achieve through hibernate by using Criteria and Restriction?</p>


In Hibernate 3, is there a way to do the equivalent of the following MySQL limit in HQL?

    select * from a_table order by a_table_column desc limit 0, 20;

I don&#39;t want to use setMaxResults if possible. This definitely was possible in the older version of Hibernate/HQL, but it seems to have disappeared.


How do you do a limit query in JPQL or HQL?

I am having trouble setting the type of a String, it goes like

	public void setTextDesc(String textDesc) {
		this.textDesc = textDesc;
	}

	@Column(name=&quot;DESC&quot;)
	@Lob
	public String getTextDesc() {
		return textDesc;
	}

and it didn&#39;t work, I checked the mysql schema and it remains varchar(255), I also tried, 

	@Column(name=&quot;DESC&quot;, length=&quot;9000&quot;)
	
or

	@Column(name=&quot;DESC&quot;)
	@Type(type=&quot;text&quot;)
	
I am trying to make the type to be TEXT, any idea would be well appreciated!

Text Field using Hibernate Annotation

I&#39;m essentially looking for a &quot;@Ignore&quot; type annotation with which I can stop a particular field from being persisted. How can this be achieved?

What is the easiest way to ignore a JPA field during persistence?

This (should) be a rather simple thing to do, however I am struggling.

I want a table to be generated like this:
&lt;pre&gt;
id 
organizationNumber 
name
&lt;/pre&gt;

However, when I look in the database, I see that the ordering is wrong. Does anybody know how I can force hibernate/jpa to generate the table with correct ordering? 

&lt;pre&gt;
desc Organization;
+--------------------+--------------+------+-----+---------+----------------+
| Field              | Type         | Null | Key | Default | Extra          |
+--------------------+--------------+------+-----+---------+----------------+
| id                 | bigint(20)   | NO   | PRI | NULL    | auto_increment | 
| name               | varchar(255) | NO   |     | NULL    |                | 
| organizationNumber | varchar(255) | NO   | UNI | NULL    |                | 
+--------------------+--------------+------+-----+---------+----------------+
&lt;/pre&gt;

This is how my entity bean looks like: 

    @Entity
    @NamedQuery(name = &quot;allOrganizations&quot;, query = &quot;SELECT org FROM Organization org order by name&quot;)
    public class Organization {
    
    	private Long id;
    	private String organizationNumber;
    	private String name;
    
    	public Organization() {
    	}
    
    	public Organization(String name) {
    		this.name = name;
    	}
    
    	@Id
    	@GeneratedValue
    	public Long getId() {
    		return id;
    	}
    
    	@SuppressWarnings(&quot;unused&quot;)
    	private void setId(Long id) {
    		this.id = id;
    	}
    
    	@NotEmpty
    	@Column(unique=true, nullable=false)
    	public String getOrganizationNumber() {
    		return organizationNumber;
    	}
           public void setOrganizationNumber(String organizationNumber) {
    		this.organizationNumber = organizationNumber;
    	}
    
    	
    	@NotEmpty
    	@Column(nullable=false)
    	public String getName() {
    		return name;
    	}
    
    	public void setName(String name) {
    		this.name = name;
    	}
    	
    	@Override
    	public String toString() {
    		return this.name + &quot; &quot; + this.organizationNumber;
    	}
    }



Wrong ordering in generated table in jpa

I have a thick client, java swing application with a schema of 25 tables and ~15 JInternalFrames (data entry forms for the tables).  I need to make a design choice of straight JDBC or ORM (hibernate with spring framework in this case) for DBMS interaction.  Build out of the application will occur in the future.

Would hibernate be overkill for a project of this size?  An explanation of either yes or no answer would be much appreciated (or even a different approach if warranted).

TIA.

Hibernate or JDBC

I have been using Hibernate Restrictions in JPA 1.0 ( Hibernate driver ). There is defined `Restrictions.ilike(&quot;column&quot;,&quot;keyword&quot;, MatchMode.ANYWHERE)` which tests if the keyword matching the column anywhere and it is case-insensitive. 

Now, I am using JPA 2.0 with EclipseLink as driver so I have to use &quot;Restrictions&quot; build-in JPA 2.0. I found `CriteriaBuilder` and method `like`, I have also found out how to make it matching anywhere ( although it is aweful and manual ), but still I haven&#39;t figured out how to do it case-insensitive.

There is my current aweful solution:

    CriteriaBuilder builder = em.getCriteriaBuilder();
    CriteriaQuery&lt;User&gt; query = builder.createQuery(User.class);
    EntityType&lt;User&gt; type = em.getMetamodel().entity(User.class);
    Root&lt;User&gt; root = query.from(User.class);
   
    // Where   
    // important passage of code for question  
    query.where(builder.or(builder.like(root.get(type.getDeclaredSingularAttribute(&quot;username&quot;, String.class)), &quot;%&quot; + keyword + &quot;%&quot;),
            builder.like(root.get(type.getDeclaredSingularAttribute(&quot;firstname&quot;, String.class)), &quot;%&quot; + keyword + &quot;%&quot;),
            builder.like(root.get(type.getDeclaredSingularAttribute(&quot;lastname&quot;, String.class)), &quot;%&quot; + keyword + &quot;%&quot;)
            ));

    // Order By
    query.orderBy(builder.asc(root.get(&quot;lastname&quot;)),
                builder.asc(root.get(&quot;firstname&quot;)));

    // Execute
    return em.createQuery(query).
                setMaxResults(PAGE_SIZE + 1).
                setFirstResult((page - 1) * PAGE_SIZE).
                getResultList();

**Questions:**

Is there any function like in Hibernate driver? 

Am I using the JPA 2.0 criteria correctly? This is awkward and uncomfortable solution in compare to Hibernate Restrictions.

Or can anybody help me how to change my solution to be case-insensitive, please?

Thanks a lot.


JPA2: Case-insensitive like matching anywhere

Consider the following JPQL query:

    SELECT foo FROM Foo foo
    INNER JOIN FETCH foo.bar bar
    WHERE bar.baz = :baz

I&#39;m trying to translate this into a Criteria query. This is as far as I have gotten:

    CriteriaBuilder cb = em.getCriteriaBuilder();
    CriteriaQuery&lt;Foo&gt; cq = cb.createQuery(Foo.class);
    Root&lt;Foo&gt; r = cq.from(Foo.class);
    Fetch&lt;Foo, Bar&gt; fetch = r.fetch(Foo_.bar, JoinType.INNER);
    Join&lt;Foo, Bar&gt; join = r.join(Foo_.bar, JoinType.INNER);
    cq.where(cb.equal(join.get(Bar_.baz), value);

The obvious problem here is that I am doing the same join twice, because `Fetch&lt;Foo, Bar&gt;` doesn&#39;t seem to have a method to get a `Path`.
Is there any way to avoid having to join twice? Or do I have to stick with good old JPQL with a query as simple as that?

How to properly express JPQL &quot;join fetch&quot; with &quot;where&quot; clause as JPA 2 CriteriaQuery?

How would I achieve this using Hibernate Restrictions?

    (((A=&#39;X&#39;) and (B in(&#39;X&#39;,Y))) or ((A=&#39;Y&#39;) and (B=&#39;Z&#39;)))


Hibernate Criteria Restrictions AND / OR combination

I am looking for a hibernate criteria to get following:

Dokument.class
is mapped to Role
roleId

Role.class
has a ContactPerson
contactId

Contact.class
FirstName
LastName

I want to search for First or LastName on the Contact class and retrieve a list of Dokuments connected.

I have tried something like this:

    session.createCriteria(Dokument.class)
    .setFetchMode(&quot;role&quot;,FetchMode.JOIN)
    .setFetchMode(&quot;contact&quot;,FetchMode.JOIN)
    .add(Restrictions.eq(&quot;LastName&quot;,&quot;Test&quot;)).list();

I get an error could not resolve property &quot;LastName&quot; for class &quot;Dokument&quot;

Can someone explain why the join searches on Dokument and not on all joined tables? Thanks in advance for all the help!

Content Type	Original Author	Original Content on Stackoverflow
Question	Shashi	View Question on Stackoverflow
Solution 1 - Hibernate	ChssPly76	View Answer on Stackoverflow
Solution 2 - Hibernate	FreeOnGoo	View Answer on Stackoverflow
Solution 3 - Hibernate	sourav	View Answer on Stackoverflow

How to achieve "not in" by using Restrictions and criteria in Hibernate?

Hibernate Problem Overview

Hibernate Solutions

Solution 1 - Hibernate

Solution 2 - Hibernate

Solution 3 - Hibernate

Is there a calculator with LaTeX-syntax?

Does an IBOutlet needs to be a property & synthesized?

Attributions