EJB3 EntityManager Find

2008-03-06

@In("myEntityManager")
private EntityManager em;

...

MyObject myObject = em.find(MyObject.class, myObjectPrimaryKey);

ejb ql

2008-01-17

SELECT SUM(p.orderTransaction.transAmount) FROM Payment AS p JOIN p.memberPaymentMethod AS mpm JOIN mpm.paymentMethod AS pm JOIN p.orderTransaction AS ot WHERE ot.currency.currencyCode = 'GBP' AND mpm.creationDate >= '01/01/2008' AND mpm.creationDate <= '01/07/2009' AND (p.authorisationCode IS NOT NULL OR pm.paymentMethodId NOT IN (8,4))

EJB QL Query Example

2008-01-16

SELECT
SUM(p.orderTransaction.transAmount)
FROM
Payment AS p
JOIN
p.memberPaymentMethod AS mpm
JOIN
mpm.paymentMethod AS pm
JOIN
p.orderTransaction as ot
WHERE
ot.currency.currencyCode = 'GBP'
AND
mpm.creationDate >= '01/01/2008'
AND
mpm.creationDate <= '01/07/2009'
AND
(p.authorisationCode IS NOT NULL OR pm.paymentMethodId NOT IN (8,4))

Setting up JBOSS Seam

2007-11-30

from a command prompt/shell within the jboss-seam directory type the following:

[path...]\jboss-seam-2.0.0.GA>seam setup
Buildfile: [path...]\jboss-seam-2.0.0.GA\seam-gen\build.xml
init:
setup:
[echo] Welcome to seam-gen :-)
[input] Enter your Java project workspace (the directory that contains your Seam projects) [c:/development/eclipse_w orkspace/] [[path...]/workspace/]
[input] Enter your JBoss home directory [[path...]/jboss-seam-2.0.0.GA] [[path...]/jboss -seam-2.0.0.GA]
[input] Enter the project name [systemadmin] [systemadmin]
[echo] Accepted project name as: systemadmin
[input] Select a RichFaces skin (not applicable if using ICEFaces) [blueSky] ([blueSky], classic, ruby, wine, deepMa rine, emeraldTown, sakura, DEFAULT)
[input] Is this project deployed as an EAR (with EJB components) or a WAR (with no EJB support) [ear] ([ear], war, )
[input] Enter the Java package name for your session beans [uk.co.iblocks.projectName.data] [uk.co.iblocks.projectName.data]
[input] Enter the Java package name for your entity beans [uk.co.iblocks.projectName.data] [uk.co.iblocks.projectName.data]
[input] Enter the Java package name for your test cases [uk.co.iblocks.projectName.test] [uk.co.iblocks.projectName.test]
[input] What kind of database are you using? [mssql] (hsql, mysql, oracle, postgres, [mssql], db2, sybase, enterpri sedb, h2)
[input] Enter the Hibernate dialect for your database [org.hibernate.dialect.SQLServerDialect] [org.hibernate.dialec t.SQLServerDialect]
[input] Enter the filesystem path to the JDBC driver jar [[path...] \jtds-1.2.jar] [[path...]\jtds-1.2.jar]
[input] Enter JDBC driver class for your database [net.sourceforge.jtds.jdbc.Driver] [net.sourceforge.jtds.jdbc.Driv er]
[input] Enter the JDBC URL for your database [jdbc:jtds:sqlserver://dbserver:8080/projectName] [jdbc:jtds:sqlserver://dbserver:8080/projectName]
[input] Enter database username [username] [username]
[input] Enter database password [password] [password]
[input] Enter the database schema name (it is OK to leave this blank) [databaseName] [databaseName]
[input] Enter the database catalog name (it is OK to leave this blank) [databaseTable] [databaseTable]
[input] Are you working with tables that already exist in the database? [y] ([y], n, )
[input] Do you want to drop and recreate the database tables and data in import.sql each time you deploy? [n] (y, [ n], )
[input] Enter your ICEfaces home directory (leave blank to omit ICEfaces) [] []
[delete] Deleting: [path...]\jboss-seam-2.0.0.GA\seam-gen\build.properties
[propertyfile] Creating new property file: [path...]\jboss-seam-2.0.0.GA\seam-gen\build.properties
[echo] Installing JDBC driver jar to JBoss server
[echo] Type 'seam create-project' to create the new project
BUILD SUCCESSFUL
Total time: 2 minutes 26 seconds

seam new-project

seam generate-entities