Internal Website Search

51-100 of 200 results

UPDATE SET Queries in JPA/JPQL

provide an alternative way of updating entity objects. Unlike SELECT queries, which are used ... - the executeUpdate method returns the number of objects that have been modified by the query. Selective Update ... , which is essential for updating selected entity objects, is supported. For example, the following

JPA Queries

;(e.g. " SELECT c FROM Country" ). Criteria Query API Building dynamic queries with a structure ... are organized in this reference into three groups. SELECT and ORDER BY elements (including tuples): FROM clause

JPA Query API

for both Query and TypedQuery : Query q1 = em. createQuery (" SELECT c FROM Country c"); TypedQuery q2 = em. createQuery (" SELECT c FROM Country c", Country.class); In the above code, the same JPQL query

Setting and Tuning of JPA Queries

.findAll", query =" SELECT c FROM Country c",      hints ={@ QueryHint (name

JPA Query Expressions (JPQL / Criteria)

Query expressions are the foundations on which JPQL and criteria queries are built. Every query consists of clauses - SELECT , FROM, WHERE, GROUP BY, HAVING and ORDER BY, and each clause consists of JPQL / Criteria query expressions. Atomic Expressions The atomic query expressions are: JPQL

Literals in JPQL and Criteria Queries

to enable selective retrieval by type . In JPQL an entity type literal is written simply as the name

Step 5: Design a BIRT Report Chart

In this step we will add a simple chart to the report: Open the [New Chart] dialog box by dragging a  Chart from the [Palette] window and dropping it on the report design (.rptdesign) layout. In the [ Select Chart Type] tab select Tube as the chart type and click Next . In the [ Select Data

Java EE 6 JPA Tutorial - NetBeans Project

project in NetBeans: Select   File Open Project... . Select the  guestbook-jee6 directory and click  Open Project . Run the project: Select   Run Run Main Project... (or  F6

Step 4: Create an ObjectDB Data Set

and selecting New Data Set . Select the data source that was created in the previous step (e.g. ObjectDB ... value in a specified range: SELECT p.x as x, p.y as y FROM Point p WHERE p.x BETWEEN :low AND :high Use

Spring MVC JPA Tutorial - NetBeans Project

: Select   File Open Project... . Select the  guestbook-spring directory and click  Open Project . Run the project: Select   Run Run Main Project... (or  F6 ). Choose or define

Step 6: Set the Spring XML

editor (by right clicking and selecting   Open With Text Editor or by double click ... that file: Right click the WEB-INF node in the [Package Explorer] window, select   New Other... XML

Step 4: Add a Servlet Class

In this step we will add a servlet to manage guestbook web requests: Open the [Create Servlet] dialog box by right clicking the guest package node (in the [Package Explorer] window),  selecting ... of guests: List guestList = em.createQuery( " SELECT g FROM Guest g", Guest.class).getResultList

Step 3: Add a Context Listener Class

] dialog box by right clicking the guest package node (in the [Package Explorer] window), selecting New ... as the class name - use exactly that case sensitive class name. Click Next and then Select

Step 1: Create a Maven Web Project

We start by creating a new Maven-WTP dynamic web project in Eclipse: Open the [New Project] dialog box, e.g. by using  File New Project... Select   Maven Maven Project and click  ... ; maven-archetype-webapp as a filter, select   maven-archetype-webapp in the artifact list and click

Step 6: Set the Spring XML

clicking and selecting Edit or by double click and then moving to the XML tab in the editor window ... , select New Other... and then choose the XML category, XML Document and click Next . Enter spring

Step 1: Create a Maven Web Project

We start by creating a new Maven web project in NetBeans: Open the [New Project] dialog box, e.g. by using File New Project... Select Maven Maven Web Application and click Next . Choose a Project Name (e.g. Guestbook ) and select Java EE 5. Enter Maven Group Id (e.g. com.objectdb.tutorial.spring

Step 1: Create a Java EE 6 Web Project

We start by creating a new Java EE dynamic web project in Eclipse: Open the [New Project] dialog box, e.g. by using File New Project... Select Web Dynamic Web Project and click Next . Choose a Project Name (e.g. Guestbook ). Select GlassFish Server Open Source Edition 3 (Java EE 6) as the Target

Step 2: Entity Class and Persistence Unit

) and selecting New Entity Class ... (or New Other... Persistence Entity Class and clicking Next ). Enter ... clicking and selecting Edit or by double click and then moving to the Source or XML tab in

Step 3: Define an EJB Session Bean

node (in the [Projects] window), selecting New Other... Java EE (or Enterprise JavaBeans) Session ... getAllGuests() { TypedQuery query = em.createQuery( " SELECT g FROM Guest g ORDER BY g.id", Guest.class

Step 3: Define a Spring DAO Component

clicking the guest package node (in the [Projects] window under Source Packages) and selecting New ... () { TypedQuery query = em.createQuery( " SELECT g FROM Guest g ORDER BY g.id", Guest.class); return

Step 3: Create an ObjectDB Data Source

Connections to the database are represented in BIRT as data sources. To create an ObjectDB data source: Open the [New Data Source] dialog box by right clicking the Data Sources node in the [Data Explorer] window and selecting   New Data Source . Select ObjectDB Data Source from the list

Step 6: Design a BIRT Report Table

) layout. Set the column number to 2 , number of details to 1 , select the data set (e.g. Points by X ... in the [Navigator] window and selecting Report Run Report :  

Step 2: Entity Class and Persistence Unit

) and selecting   New Entity Class ... (or  New Other... Persistence Entity Class and clicking ... a text editor (by right clicking and selecting Edit or by double click and then moving to the XML

Step 3: Define a Spring DAO Component

clicking the guest package node (in the [Package Explorer] window) and selecting   New Class ... getAllGuests() { TypedQuery query = em.createQuery( " SELECT g FROM Guest g ORDER BY g.id", Guest.class); return

Step 2: Create a Project and a Report

To use BIRT we need to create a BIRT Report project in Eclipse: Open the [New Project] dialog box, e.g. by using File New Project... Select Business Intelligence and Reporting Tools Report Project ... project: Right click the Reports node in the [Navigator] and select New Report . Enter the report

Step 1: Create a Web Project

We start by creating a new Eclipse Dynamic Web Project: Open the [New Project] dialog box, e.g. by using File New Project... Select Web Dynamic Web Project and click Next . Choose a Project Name (e.g. Guestbook ). Select Apache Tomcat v6.0 as the Target runtime. Note: You may have to add Tomcat 6

Step 3: Add a Context Listener Class

File] dialog box by right clicking the guest package node (in the [Projects] window) and selecting New Other... Select Web Web Application Listener and click Next . Enter GuestListener as the class name

Step 1: Create a Java Project

Project] dialog box: Select Java Project and click Next . Choose a Project Name (e.g. Tutorial ) and click Next . In the Libraries tab, click Add External JARs... and select the objectdb.jar file from

Step 3: Define an EJB Session Bean

node (in the [Package Explorer] window) and selecting New Class . The package name should be guest ... ); } // Retrieves all the guests: public List getAllGuests() { TypedQuery query = em.createQuery( " SELECT g FROM

Step 4: Add a Servlet Class

In this step we will add a servlet to manage guestbook web requests: Open the [New Servlet] dialog box by right clicking the guest package node (in the [Projects] window) and selecting New Servlet ... .getTransaction().commit(); } // Display the list of guests: List guestList = em.createQuery( " SELECT g FROM

Step 5: Add a JSP Page

In this step we will add the JSP that generates the guestbook HTML output: Open the [New JSP File] dialog box by right clicking the WEB-INF node under the Web Pages node (in the [Projects] window) and selecting New JSP ... Enter guest as the jsp file name - use exactly that case sensitive class

Step 4: Run the Application

You can run the application now by right clicking the Main node (in the [Projects] window) and selecting Run File . The expected output in the [Output] window, is: Total Points: 1000 Average X: 499.5 (0,0) (1,1) (2,2) (3,3) : : (998,998) (999,999) When you run the application for the first time

Step 4: Add a Controller Class

In this step we will add a Spring Controller to manage guestbook web requests: Open the [New Java Class] dialog box by right clicking the guest package node (in the [Package Explorer] window) and selecting   New Class . The package name should be  guest . Enter  GuestController as

Step 2: Define a JPA Entity Class

To store objects in an ObjectDB database using JPA we need to define an entity class: Right click on the project in the [Package Explorer] window and select New Class . Enter tutorial as the package name (case sensitive). Enter Point as the class name (case sensitive). Click Finish to create

Step 2: Define a JPA Entity Class

To store objects in an ObjectDB database using JPA we need to define an entity class: Open the [New Java Class] dialog box, e.g. by right clicking the tutorial package node (in the [Projects] window) and selecting New Java Class ... Enter Point as the class name - use exactly that case sensitive

Step 6: Run the Java EE 6 Application

You can run the application now by right clicking the GuestServlet node (in the [Project Explorer] window) and selecting Run As Run on Server Finish : Since we are using ObjectDB in embedded mode - the database file is created under the GlassFish directory (e.g. at domains\domain1\eclipseApps

Step 5: Add a JSP Page

In this step we will add the JSP that generates the guestbook page output: Open the [New JSP File] dialog box by right clicking the Web Pages node (in the [Projects] window) and selecting New JSP ... Enter guest as the jsp file name - use exactly that case sensitive class name. Click Finish

Step 4: Run the Application

You can now run the application by right clicking the Main.java file (in the [ Package Explorer ] window) and selecting Run As Java Application . The expected output in the Eclipse [Console] window, is: Total Points: 1000 Average X: 499.5 (0,0) (1,1) (2,2) (3,3) : : (998,998) (999,999

Step 6: Run the Web Application

You can run the application now by right clicking the GuestServlet node (in the [Project Explorer] window) and selecting Run As Run on Server Finish : Since we are using ObjectDB in embedded mode - the database file is created under the Tomcat directory. You can stop the Tomcat server and open

Step 3: Add a Main Class

In this step we will add a main class to the project to store and retrieve Point objects from the database: Right click the tutorial package in the [Package Explorer] window and select New Class . The package name should be tutorial . Enter Main as the class name (case sensitive). Click Finish

Step 4: Add a Controller Class

In this step we will add a Spring Controller to manage guestbook web requests: Open the [New Java Class] dialog box by right clicking the guest package node (in the [Projects] window) and selecting New Java Class ... Enter GuestController as the class name - use exactly that case sensitive class

Step 2: Define a JPA Entity Class

To store objects in an ObjectDB database using JPA we need to define an entity class: Open the [New Java Class] dialog box, e.g. by right clicking the project node (in the [Package Explorer] window) and selecting New Class . Enter guest as the package name - use exactly that case sensitive package

Step 6: Run the Java EE 6 Application

You can run the application now by right clicking the  GuestServlet node (in the [Projects] window), selecting   Run File , and then clicking  OK (no need to change the servlet execution URI). Since we are using ObjectDB in embedded mode - the database file is created

Step 6: Run the Web Application

You can run the application now by right clicking the GuestServlet node (in the [Projects] window), selecting Run File , and then clicking  OK (no need to change the servlet execution URI). Since we are using ObjectDB in embedded mode - the database file is created under the Tomcat directory

Step 5: Add a JSP Page

In this step we will add the JSP that generates the guestbook page output: Open the [New JSP File] dialog box by right clicking the Web Pages node (in the [Projects] window) and selecting New JSP ... Enter guest as the jsp file name - use exactly that case sensitive class name. Click Finish

Step 5: Add a JSP Page

In this step we will add the JSP that generates the guestbook page output: Open the [New JSP File] dialog box by right clicking the WebContent node (in the [Package Explorer] window), selecting   New Other... Web JSP File and clicking  Next . Enter  guest as the jsp file name

[ODB1] Chapter 3 - Persistent Classes

, int , long , float and double . Selected classes in package java.lang : Boolean , Byte , Short , Character , Integer , Long , Float , Double , Number and String . Selected classes in package java

[ODB1] Chapter 7 - JDOQL Queries

. When a more selective retrieval is needed, JDOQL (JDO Query Language) is used. JDOQL for JDO is like ... "this.verified" is a valid query filter. It selects all the objects with the true value in that field

[ODB1] Chapter 6 - Persistent Objects

one by one. If more selective retrieval is needed, a Query can be used to retrieve only objects

[ODB1] Chapter 8 - ObjectDB Server

(what is known as "a man in the middle attack"). The server, on the other hand, might be less selective