Styjun

Additive group of local rings

My admission is revoked after accepting the admission offer

What's parked in Mil Moscow helicopter plant?

How to use @AuraEnabled base class method in Lightning Component?

Function to calculate red-edgeNDVI in Google Earth Engine

What is /etc/mtab in Linux?

All ASCII characters with a given bit count

Can I criticise the more senior developers around me for not writing clean code?

Is Diceware more secure than a long passphrase?

Is accepting an invalid credit card number a security issue?

Map material from china not allowed to leave the country

Is Bran literally the world's memory?

Do I need to protect SFP ports and optics from dust/contaminants? If so, how?

What if Force was not Mass times Acceleration?

std::is_constructible on incomplete types

Why is this method for solving linear equations systems using determinants works?

Would reducing the reference voltage of an ADC have any effect on accuracy?

Does Feeblemind produce an ongoing magical effect that can be dispelled?

Why didn't the Space Shuttle bounce back into space as many times as possible so as to lose a lot of kinetic energy up there?

The art of proof summarizing. Are there known rules, or is it a purely common sense matter?

How to translate "red flag" into Spanish?

What is the ongoing value of the Kanban board to the developers as opposed to management

"My boss was furious with me and I have been fired" vs. "My boss was furious with me and I was fired"

What *exactly* is electrical current, voltage, and resistance?

How to set a criteria with child table

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I need to have query like this:

select * from TABLE where Source_KEY in (1,2);

My Hibernate class is like this:

@Entity
@Table(name = "TABLE", schema = "SCH")
public class Table 
 private Long key;
 private Long id;
 private Source src;


Source is another entity class,
@Entity
@Table(name = "SOURCE", schema = "SCH")
public class Source
private Long Source_KEY;

Now i have written a criteria but it seems to have an issue.
Please can anyone advice on this.

private static final List<String> STAY_SOURCE_KEY = asList(1,2);

criteria.add(Restrictions.in("Source_KEY", STAY_SOURCE_KEY));

This should be a list of Source class but how to to that in criteria. It has
to form query like

select * from TABLE where Source_KEY in (1,2);

oracle hibernate criteria

share|improve this question

edited Mar 22 at 16:05

Pavel Smirnov

2,5711818

asked Mar 22 at 15:55

RahulRahul

3010

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Possible duplicate of Hibernate Criteria Join with 3 Tables
  
  – Peter Šály
  Mar 23 at 22:30
  

  
  
  
  

add a comment | 

0

I need to have query like this:

select * from TABLE where Source_KEY in (1,2);

My Hibernate class is like this:

@Entity
@Table(name = "TABLE", schema = "SCH")
public class Table 
 private Long key;
 private Long id;
 private Source src;


Source is another entity class,
@Entity
@Table(name = "SOURCE", schema = "SCH")
public class Source
private Long Source_KEY;

Now i have written a criteria but it seems to have an issue.
Please can anyone advice on this.

private static final List<String> STAY_SOURCE_KEY = asList(1,2);

criteria.add(Restrictions.in("Source_KEY", STAY_SOURCE_KEY));

This should be a list of Source class but how to to that in criteria. It has
to form query like

select * from TABLE where Source_KEY in (1,2);

oracle hibernate criteria

share|improve this question

edited Mar 22 at 16:05

Pavel Smirnov

2,5711818

asked Mar 22 at 15:55

RahulRahul

3010

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Possible duplicate of Hibernate Criteria Join with 3 Tables
  
  – Peter Šály
  Mar 23 at 22:30
  

  
  
  
  

add a comment | 

I need to have query like this:

select * from TABLE where Source_KEY in (1,2);

My Hibernate class is like this:

@Entity
@Table(name = "TABLE", schema = "SCH")
public class Table 
 private Long key;
 private Long id;
 private Source src;


Source is another entity class,
@Entity
@Table(name = "SOURCE", schema = "SCH")
public class Source
private Long Source_KEY;

Now i have written a criteria but it seems to have an issue.
Please can anyone advice on this.

private static final List<String> STAY_SOURCE_KEY = asList(1,2);

criteria.add(Restrictions.in("Source_KEY", STAY_SOURCE_KEY));

This should be a list of Source class but how to to that in criteria. It has
to form query like

select * from TABLE where Source_KEY in (1,2);

oracle hibernate criteria

share|improve this question

edited Mar 22 at 16:05

Pavel Smirnov

2,5711818

asked Mar 22 at 15:55

RahulRahul

3010

select * from TABLE where Source_KEY in (1,2);

@Entity
@Table(name = "TABLE", schema = "SCH")
public class Table 
 private Long key;
 private Long id;
 private Source src;


Source is another entity class,
@Entity
@Table(name = "SOURCE", schema = "SCH")
public class Source
private Long Source_KEY;

private static final List<String> STAY_SOURCE_KEY = asList(1,2);

criteria.add(Restrictions.in("Source_KEY", STAY_SOURCE_KEY));

select * from TABLE where Source_KEY in (1,2);

share|improve this question

edited Mar 22 at 16:05

Pavel Smirnov

2,5711818

asked Mar 22 at 15:55

RahulRahul

3010

share|improve this question

edited Mar 22 at 16:05

Pavel Smirnov

2,5711818

asked Mar 22 at 15:55

RahulRahul

3010

edited Mar 22 at 16:05

Pavel Smirnov

2,5711818

edited Mar 22 at 16:05

Pavel Smirnov

2,5711818

asked Mar 22 at 15:55

RahulRahul

3010

asked Mar 22 at 15:55

RahulRahul

3010

1 Answer
1

active

oldest

votes

1

You need to join table. Use

criteria.createAlias("src","s");
criteria.add(Restrictions.in("s.Source_KEY", STAY_SOURCE_KEY));

share|improve this answer

edited Mar 24 at 7:17

answered Mar 23 at 22:33

Peter ŠályPeter Šály

2,0852822

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55303456%2fhow-to-set-a-criteria-with-child-table%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

You need to join table. Use

criteria.createAlias("src","s");
criteria.add(Restrictions.in("s.Source_KEY", STAY_SOURCE_KEY));

share|improve this answer

edited Mar 24 at 7:17

answered Mar 23 at 22:33

Peter ŠályPeter Šály

2,0852822

add a comment | 

1

You need to join table. Use

criteria.createAlias("src","s");
criteria.add(Restrictions.in("s.Source_KEY", STAY_SOURCE_KEY));

share|improve this answer

edited Mar 24 at 7:17

answered Mar 23 at 22:33

Peter ŠályPeter Šály

2,0852822

add a comment | 

You need to join table. Use

criteria.createAlias("src","s");
criteria.add(Restrictions.in("s.Source_KEY", STAY_SOURCE_KEY));

share|improve this answer

edited Mar 24 at 7:17

answered Mar 23 at 22:33

Peter ŠályPeter Šály

2,0852822

criteria.createAlias("src","s");
criteria.add(Restrictions.in("s.Source_KEY", STAY_SOURCE_KEY));

share|improve this answer

edited Mar 24 at 7:17

answered Mar 23 at 22:33

Peter ŠályPeter Šály

2,0852822

answered Mar 23 at 22:33

Peter ŠályPeter Šály

2,0852822

answered Mar 23 at 22:33

Peter ŠályPeter Šály

2,0852822