Kamil Kuchta

I have problem to create some HQL query.
This is my object model. Hotel has list of Image.
@Entity public class Hotel { private Long id; private List<Image> images; @OneToMany(cascade=CascadeType.ALL) @JoinColumn(name="hotel_id") public List<Image> getImages() { return images; } public void setImages(List<Image> images) { this.images = images; } // id settet getter } @Entity public class Image { private Long id; private String name; @Column public String getName() { return name; } public void setName(String name) { this.name = name; } // id settet getter }

Standard SQL in this case is easy:
SELECT name FROM image WHERE image.hotel_id = 10;
But how to create HQL?
SELECT name FROM Image i WHERE i.hotel.id = 10; --failed, I know... no reference to hotel form image SELECT name FROM Image i, Hotel h WHERE h.images.id = i.id AND h.id = 10; --failed, illegal attempt to dereference collection SELECT name FROM Image i, Hotel h WHERE h.id = 10; --failed, No data type for node: org.hibernate.hql.ast.tree.IdentNode

Answer:
simpleJdbcTemplate.getJdbcOperations().execute("select my_function()");

I have to use SimpleJdbcTemplate to call stored postgresql procedure. It must be SimpleJdbcTemplate because my test class extends AbstractTransactionalJUnit4SpringContextTests which has simpleJdbcTemplate.

I found this:
this.jdbcTemplate.update("call SUPPORT.REFRESH_ACTORS_SUMMARY(?)", new Object[]{new Long(unionId)});
http://static.springsource.org/spring/docs/2.0.x/reference/jdbc.html#jdbc-JdbcTemplate-examples
but
simpleJdbcTemplate.update("call my_function(?)", new Object[]{new Long(unionId)})
doesn't work. Maybe is some detail wrong? Somewhere I met call package.my_function(?) but my function is in no package.

https://coderanch.com/t/60690/oa/Calling-Stored-Procedure-jdbcTemplate
doesn't work with simpleJdbcTemplate.

I would ask for using resources especially images.public interface Resources extends ClientBundle { @Source("resources/img/logo.png") ImageResource logo(); }<ui:with field='res' type='com.my.app.widgets.resources.Resources'/> <ui:image field='pic' resource='{res.logo}'/>doesn't work.

The only solution which I know is to store images in package com.my.app.widgets.resources and use
<ui:image field='pic' src='resources/logo.png'/>
which IMO is not very nice way of using images.
I would prefer to use resources= and prefix res set in <iu:with/> like in <g:Image field=.... resource=.../>
Is any way to use ui:images in more smartly way?

edit:
Added next day.
Is this question so hard or so stupid that nobody can answer - "Yes, this is the only way of using resources" or "No, you can use...."?

Writing numer of line in post, I mean line in this post. Now, after editing my first post this is line 43 which contains ctt.myMethod();
Apart from that, I added to MyClassTest in line 30 expect(Calendar.getInstance()).andReturn(now); but it nothing changes.

I don't have experience in testing that's why I'm asking for a help.

This is my example class which I have to test.
public class MyClass { private ArrayList<Something> somethingList; public MyClass (ArrayList<Something> somethingList) { this.somethingList = somethingList; } public void myMethod() { for (Something something : somethingList) { if (something.isVariableSet()) { Calendar expectedTime = something.getMyCalendar(); Calendar now = Calendar.getInstance(); if (now.after(expectedTime)) { File mf = something.getMyFile(); if (something.isReady()) { //new Thread(new MySpecialThread(mf)).start(); //I don't know how to test this... } } } } } }

I tried to make test case but it doesn't work. I have "Unexpected method call clone()" in line 39. and others when I do some changes.
But I think that my thinking is not correct at all....
public class MyClassTest { ArrayList<Something> somethingList = new ArrayList<Something>(); Something np1; Something np2; Something np3; @Before public void setUp(){ np1 = createMock(Something.class); np2 = createMock(Something.class); np3 = createMock(Something.class); somethingList.add(np1); somethingList.add(np2); somethingList.add(np3); } @Test public void testMyMethod() { MyClass ctt = new MyClass(somethingList); expect(np1.isVariableSet()).andReturn(true); Calendar expectedTime = createMock(Calendar.class); Calendar now = createMock(Calendar.class); //should I set // expectedTime.set(2011, 12, 12); // now.set(2010, 12, 17); //or not? expect(np1.getMyCalendar()).andReturn(expectedTime); expect(Calendar.getInstance()).andReturn(now); expect(now.after(expectedTime)).andReturn(true); File mf = createMock(File.class); expect(np1.getMyFile()).andReturn(mf); expect(np1.isReady()).andReturn(true); EasyMock.replay(np1); EasyMock.replay(expectedTime); EasyMock.replay(now); EasyMock.replay(mf); ctt.myMethod(); EasyMock.verify(np1); EasyMock.verify(expectedTime); EasyMock.verify(now); EasyMock.verify(mf); } }
Could you correct mistakes?
Thank you in advance.

I have to test method which reads data from XML file (using DOM). I wonder if I should (and how to) mock xml file.
When I'm testing method which uses data from database, I have to mock database connection and data from base. What when I use XML?

applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <tx:annotation-driven transaction-manager="transactionManager" /> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="annotatedClasses"> <list> <value>pl.diagno.model.vo.Person</value> <value>pl.diagno.model.vo.OrderGeneral</value> <value>pl.diagno.model.vo.OrderDetails</value> ... and others ... </list> </property> <property name="hibernateProperties"> <props> <prop key="show_sql">true</prop> <prop key="dialect">org.hibernate.dialect.Oracle10gDialect</prop> <prop key="hibernate.transaction.flush_before_completion">true</prop> <prop key="hibernate.transaction.auto_close_session">true</prop> <prop key="hibernate.use_sql_comments">true</prop> <prop key="hibernate.connection.release_mode">auto</prop> </props> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <!-- DAO BEANS --> <bean id="personDao" class="pl.diagno.dao.impl.PersonDAOImpl"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean id="orderDetailsDao" class="pl.diagno.dao.impl.OrderDetailsDAOImpl"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean id="orderGeneralDao" class="pl.diagno.dao.impl.OrderGeneralDAOImpl"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean id="testDao" class="pl.diagno.dao.impl.TestDAOImpl"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <!-- BO BEANS --> <bean id="orderBo" class="pl.diagno.bo.impl.OrderBOImpl"> <!-- autowire="byName" --> <property name="personDAO" ref="personDao" /> <property name="testDAO" ref="testDao" /> <property name="orderGeneralDAO" ref="orderGeneralDao" /> <property name="orderDetailsDAO" ref="orderDetailsDao" /> </bean> </beans>
In OrderDetails is a reference @ManyToOne to OrderGeneral.
The problem is that I can not save OrderGeneral and referenced on it OrderDetails in one method/transaction. This is my method:

@Transactional(readOnly = false, propagation = Propagation.REQUIRED) public void saveOrder(long personId, long clinicId, long testsId[]){ OrderGeneral orderGeneral = new OrderGeneral(); orderGeneral.setPerson(personDAO.load(personId)); orderGeneralDAO.save(orderGeneral); // save orderGeneral for(int i = 0; i<testsId.length; i++){ OrderDetails orderDetails = new OrderDetails(); orderDetails.setOrderGeneral(orderGeneral); //set orderGeneral orderDetails.setTest(testDAO.load(testsId[i])); orderDetailsDAO.save(orderDetails); //save orderDetails } }
Exception:
java.sql.BatchUpdateException: ORA-02291: integrity constraint (DIAGNO.ORDERDETAILS_ORDERGENERAL_FK) violated - parent key not found

OrderDetailsDAO is
public void save(final OrderDetails entity) { hibernateTemplate.saveOrUpdate(entity); hibernateTemplate.flush(); }

Unfortunatly the problem is not in mapping, I checked it several times, and what is more saving another two connected object (ex Person and City which doesn't exist in base) ends with the same exception (of course another parent key is not found).
I faced up this problem 2 months ago and I'm still fighting with it.
Please for help.

I have problem with @ManyToOne which generate that exception:
Caused by: org.hibernate.MappingException: Could not determine type for: pl.diagno.model.vo.City, for columns: [org.hibernate.mapping.Column(city)]
In Person is references to City and Street. When I remove these references it works.
I put in a lot of time reading many threads and finding solution but the most similar case is here:
http://forum.springsource.org/showthread.php?t=86745
But there the problem was in the lack of some setters.
package pl.diagno.model.vo; import java.util.Date; import javax.persistence.*; @Entity public class Person { @Id @GeneratedValue(strategy=GenerationType.SEQUENCE) private long id; private String name; private String surname; private String pesel; private Date birth_date; private String sex; private Boolean is_client; private Boolean is_member; private City city; private Street street; public Person(){} public Person(String name, String surname, City city, Street street, String pesel, Date birth_date, String sex, Boolean is_client, Boolean is_member){ this.name=name; this.surname=surname; this.city=city; this.street=street; this.pesel=pesel; this.birth_date=birth_date; this.sex=sex; this.is_client=is_client; this.is_member=is_member; } @Column public long getId() { return id; } public void setId(long id) { this.id = id; } @Column public String getName() { return name; } public void setName(String name) { this.name = name; } @Column public String getSurname() { return surname; } public void setSurname(String surname) { this.surname = surname; } @Column public String getPesel() { return pesel; } public void setPesel(String pesel) { this.pesel = pesel; } @Column public Date getBirth_date() { return birth_date; } public void setBirth_date(Date birthDate) { birth_date = birthDate; } @Column public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } @Column public Boolean getIs_client() { return is_client; } public void setIs_client(Boolean isClient) { is_client = isClient; } @Column public Boolean getIs_member() { return is_member; } public void setIs_member(Boolean isMember) { is_member = isMember; } @Column @ManyToOne(cascade = CascadeType.ALL, targetEntity = City.class) @JoinColumn(name="city_id") public City getCity() { return city; } public void setCity(City city) { this.city = city; } @Column @ManyToOne(cascade = CascadeType.ALL, targetEntity = Street.class) @JoinColumn(name="street_id") public Street getStreet() { return street; } public void setStreet(Street street) { this.street = street; } }
package pl.diagno.model.vo; import javax.persistence.*; @Entity public class City { @Id @GeneratedValue(strategy=GenerationType.SEQUENCE) private long id; private String name; public City(){} public City(String name){ this.name=name; } @Column public long getId() { return id; } public void setId(long id) { this.id = id; } @Column public String getName() { return name; } public void setName(String name) { this.name = name; } }
package pl.diagno.model.vo; import javax.persistence.*; @Entity public class Street { @Id @GeneratedValue(strategy=GenerationType.SEQUENCE) private long id; private String name; public Street(){} public Street(String name){ this.name=name; } @Column public long getId() { return id; } public void setId(long id) { this.id = id; } @Column public String getName() { return name; } public void setName(String name) { this.name = name; } }
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="annotatedClasses"> <list> <value>pl.diagno.model.vo.City</value> <value>pl.diagno.model.vo.Street</value> <value>pl.diagno.model.vo.Person</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</prop> <prop key="hibernate.connection.url">jdbc:oracle:thin:@xxx-90ac33161e0:1521:XE</prop> <prop key="hibernate.connection.username">diagno</prop> <prop key="hibernate.connection.password">1234</prop> <prop key="hibernate.default_schema">diagno</prop> <prop key="hibernate.connection.pool_size">10</prop> <prop key="show_sql">true</prop> <prop key="dialect">org.hibernate.dialect.OracleDialect</prop> <prop key="hibernate.hbm2ddl.auto">create-drop</prop> </props> </property> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@xxx-90ac33161e0:1521:XE" /> <property name="username" value="diagno" /> <property name="password" value="1234" /> </bean> </beans>
public static void main(String[] args) { ApplicationContext context = new ClassPathXmlApplicationContext( new String[] { "applicationContext.xml" }); }
Help appreciated!

Unfortunatly, there is no null...
If I get already existing city object, it works fine:
City c = new CityDAOImpl().getCity(new Long(14)); Person per = new Person("Somename", "somesurname", c); session.save(per);

but when the city object is going to be created w person in the same session it doesn't work
Person per = new Person("Kamil", "Jakis", new City("SomeCity")); session.save(per);

@Entity public class Person { @Id @GeneratedValue(strategy=GenerationType.SEQUENCE) private long id; private String name; private String surname; @ManyToOne(cascade = javax.persistence.CascadeType.ALL) @JoinColumn(name="city_id") private City city; public Person(){} public Person(String name, String surname, City city){ this.name=name; this.surname=surname; this.city=city; } public long getId() { return id; } public String getName() { return name; } public String getSurname() { return surname; } public City getCity() { return city; } public void setId(long id) { this.id = id; } public void setName(String name) { this.name = name; } public void setSurname(String surname) { this.surname = surname; } public void setCity(City city) { this.city = city; }
@Entity public class City { @Id @GeneratedValue(strategy=GenerationType.SEQUENCE) private long id; private String name; public City(String name){ this.name=name; } public long getId() { return id; } public String getName() { return name; } public void setId(long id) { this.id = id; } public void setName(String name) { this.name = name; } }
Person per = new Person("Kamil", "Jakis", new City("SomeCity")); session.save(per);

I don't know why, Hibernate can not find the primary key of the City which was inserted in the same session with Person. I'm using Oracle 10g.

Hibernate: select diagno.hibernate_sequence.nextval from dual
Hibernate: select diagno.hibernate_sequence.nextval from dual
Hibernate: insert into diagno.City (name, id) values (?, ?)
Hibernate: insert into diagno.Person (name, surname, city_id, id) values (?, ?, ?, ?)

Exception in thread "main" org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
.
.
Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (DIAGNO.PERSON_CITY_FK) violated - parent key not found

I want to use JavaMail which is a part of Java EE. I know that I can use standalone JavaMail librabry but it is not my purpose. I want to start using Java EE, and first use JavaMail classes.
I download and installed Java EE 6 SDK from
http://java.sun.com/javaee/downloads/index.jsp
Is it enough?

My question is, how can I use Java EE (for example use JavaMail classes) in Eclipse Classic WTP?
import.javax.mail.*; doesn't work. What should I do to import JavaMail from JEE platform?

I'm looking for video tutorials about Java EE 5. Something like tutorials from lynda.com but there is no tutorial about Java.
Of course, I know that some video tutorials suffer from a lack of quality... but in spite of this I want to try.

It turns out that I already had a getter getDwarfs() which returns a length of collection. When I changed bean name from dwarfs to dwarfsMap (and setter name setDwarfsMap) it started work. I think that that getter was a reason of my problems

How to inject TreeMap?
This map is fulfill in the application.
My beans
<bean id="dwarfs" class="java.util.TreeMap" /> <bean id="house" class="pl.edu.agh.snowwhite.logic.House"> <property name="dwarfs" ref="dwarfs"></property> </bean>
And setter in class House
public void setDwarfs(Map<String, Dwarf> dwarfs){ this.dwarfs=dwarfs; }
Exception
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'house' defined in file [snowWhiteBeans.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'dwarfs' of bean class [pl.edu.agh.snowwhite.logic.House]: Bean property 'dwarfs' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

And what with generic data information Map<String, Dwarf>? Should bean contain this generic information?