java - How to create custom query for CollectionOfElements -

java - How to create custom query for CollectionOfElements -

September 15, 2012

I have a problem creating a custom query.

These are the same entities:

  @Entiree Public Class Application Process {@CollectionOfElements Personal Set & lt; Templates & gt; DefaultTemplates; // more field}

and template.Java @Embeddable @EqualsAndHashCode (exit = {"used"}) applies the public class template Comparable & lt; Templates & gt; {@ Private personal process application process; @ Personal Private Boolean used = boolean.value (wrong); Public template () () {} Get the public application process public process process () {Return application process; } @column (drains = false) @notnew public string getName () {return name; } @column (Nalabel = true) public boolean is used () {used; } To compare public differences (template o) {return getName (). Compare (o.getName ()); }}

I want to make an update statement. I have tried these two attempts:

int v = entityManager.createQuery ("Update ApplicationProcess_defaultTemplatesT t.used = true" + "Where t.applicationProcess.id =: apId") . SetParameter ("ApId", ap.getId ()) .executeUpdate ();

ApplicationProcess_defaultTemplates is not mapped [Update ApplicationProcess_defaultTemplatesTy t.used = true WHERE t.applicationProcess.id =: apId]
< P> and I have tried

int v = entityManager.createQuery ("Update Template t set t.used = true" + "WHERE t.applicationProcess.id =: apId"). SetParameter ("apId", Ap.getId ()) .executeUpdate ();

with the same error:

The template is not mapped [Update Template T set t.used = true WHERE t.applicationProcess.id =: Apid]

Any ideas?

UPDATE

I have decided to make it the original query

int v = entityManager.createNativeQuery ("Update ApplicationProcess_defaultTemplates T set t.used = true where t.ApplicationProcess_id =: apId "). SetParameter ("apid", ap.getId ()). ExecuteUpdate ();

What you want to do is not possible in HQL: as are the embedded objects , They can not appear in the section of the HQ questions. And you need this to make that object update.

So you have two possibilities:

Use either a SQL query (be careful)

For a unit, your template class Reactor

Comments

Post a Comment

Popular Posts

Unable to get a fresh ASP.NET MVC project running with Visual Studio 2008 -

This is a very basic question. I'm asking this silly about this, but I'm stuck something else and hopefully That something here can save me some time. So I open VS2008, to download the new ASP.NET MVC web application and click OK I want to prepare a test project. I debug my new MVC project to hit F5 then I enable the debugging to the web. I choose to modify the config file. It goes where I get a page load error. Firefox can not establish a connection to the server on the local host: 57323. Do I have to do something special for Vista? Or I should do something with IIS Thanks for helping a noob 6/30/2009 update OK, I think that I VS2008 may need to be reinstalled with the ASP.NET Development Server port. I have tried to do everything that I have suggested. I've marked Default.aspx as the start page. I tried to open it in Firefox / IE 8 / and Chrome. I tried to uninstall / reinstall ASP.NET MVC, which was not working. I tried telnetting with Putin with a local ho...

delphi - Mouseover hint for TChart series value -

I am using a TChart in Delphi 7, and I want to display charts sometime. I am using the following code to set the chain value to a database query: chart1.FreeAllSeries; Chart1.SeriesList.Clear; Chart1.AddSeries (TBarSeries.Create (self)); TBarSeries (chart1.Series [0]) BarStyle :. = BsRectGradient; Stop starting with Query 1; Executed; While EOF does not start chart1.Series [0]. Add (field 'flags' ('sum_actual_days'), Field Astrstring ('contract_no')); the upcoming; End; End; Each time (value) is now showing both the label below the bar and in a yellow rectangle above the bar. Rather than repeating the amount of label twice, I have some additional information from the query that I would like to show above the bar rather than the label (or, preferably, as a mouseover signal). Can it be done with TChart? And how ...? This can be done with a TChart using the onMouseMeave event of the chart. Something like this should start with you: Process TForm...

sql - Incorrect syntax near the keyword 'table' -

I'm getting this error what I'm doing is trying to get data from a table and a db and Keep it in another DB and table. The tables are not exactly the same, I am using a FETCH cursor, so I get the first line from the DB1 table and then keep each column value in the declared variable. Then I run an assembly statement in db2 table and get the next value. All of these are working properly because it runs properly, but in the end I get this error, Wrong syntax near the keyword 'table'. In the entire transaction details, an attempt / catch with the error of expression in the Cat block, apart from this, I do not know what is the reason for it. Here is the code added to prevent additional result set at SET NOCOUNT - Interfering with the SELECT statement. Set nosenate on; TRY begin transaction sets ITENDITY column off --TURN identity_insert [dB] start [dbo] [TEST] all CONSTRAINTS table --TURN [dB] change [dbo] [TEST] NOCHECK barrier All -.... Insert statement here @...

Powered by Blogger