Dave Alvarado

Hi,

I'm using Spring 3.1.1.RELEASE, Hibernate 4.1.0.Final, and JBoss 7.1.3 AS. I have a Hibernate entity with this field …

@Entity ... public class User implements Comparable<User>, Serializable { … @OneToMany(fetch=FetchType.EAGER, cascade=CascadeType.ALL) @JoinTable(name = "user_address", joinColumns = @JoinColumn(name = "user_id"), inverseJoinColumns = @JoinColumn(name = "address_id")) private Set<Address> addresses;

I would like to reference the first address in the field and so through JSTL I tried doing this:

<div>Email: ${user.addresses[0].email}</div>

However I get the exception …

javax.el.PropertyNotFoundException: The class 'org.hibernate.collection.internal.PersistentSet' does not have the property '0'. javax.el.BeanELResolver.getBeanProperty(BeanELResolver.java:661) javax.el.BeanELResolver.getValue(BeanELResolver.java:290) javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) org.apache.el.parser.AstValue.getValue(AstValue.java:169) org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189) org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:935) org.apache.jsp.WEB_002dINF.views.teacher.profile_jsp._jspService(profile_jsp.java:93) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:847) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253) javax.servlet.http.HttpServlet.service(HttpServlet.java:847) org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:238) org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:262) org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1180) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:950) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) javax.servlet.http.HttpServlet.service(HttpServlet.java:734) javax.servlet.http.HttpServlet.service(HttpServlet.java:847) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322) org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184) org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155) org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

Is it possible to access the first address object? Thanks, - Dave

Hi,

I'm using Eclipse Juno on mac 10.7.5. I'm trying to recover from a workspace crash. I want to import an existing Maven project, but when I got to File -> Import, "Existing Maven Project" isn't part of the list of options. I went to verify if the M2E plugin was installed and indeed it is. I get the error

Cannot complete the request. See the error log for details. "m2e - slf4j over logback logging (Optional)" will be ignored because it is already installed. "m2e - Maven Integration for Eclipse" will be ignored because it is already installed.

when I go to "Help" -> "Install New Software", select the URL "Maven Integration for Eclipse - http://download.eclipse.org/technology/m2e/releases/1.0/1.0.200.20111228-1245"; and check the box for "Maven Integration for Eclipse". Any ideas how to make Eclipse recognize my Maven project?

Hi,

I'm using JBoss 7.1.1.Final and am building a WAR application using Spring 3.1.1.RELEASE and Hibernate 4.1.5.Final. The Hibernate version is a slight upgrade from what module JBoss provides. My question is, are there performance (or other) disadvantages of doing this? I would prefer not to install a new module in JBoss because there may be other applications running that depend on the Hibernate version taht ships with JBoss.

Thanks for your feedback, - Dave

Hi,

I'm using JBoss AS 7.1.1.Final. Is there a JNDI JTA transaction manager that Jboss provides that I can use with my Spring 3.1.1.RELEASE application? Where is it and what's it called? I'm using Spring 3.1's persistence.xml-less configuration for my application but I'm getting errors about not being able to find a transaction manager. Here's my Spring config …

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="packagesToScan" value="org.mainco.subco" /> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"/> </property> <property name="dataSource" ref="dataSource"/> <property name="jpaPropertyMap" ref="jpaPropertyMap" /> </bean> <util:map id="jpaPropertyMap"> <entry key="show_sql" value="true" /> <entry key="dialect" value="org.hibernate.dialect.MySQLDialect" /> <entry key="hibernate.hbm2ddl.auto" value="validate" /> <entry key="hibernate.cache.region.factory_class" value="org.hibernate.cache.ehcache.EhCacheRegionFactory"/> <entry key="hibernate.cache.provider_class" value="org.hibernate.cache.EhCacheProvider"/> <entry key="hibernate.cache.use_second_level_cache" value="true" /> <entry key="hibernate.cache.use_query_cache" value="false" /> <entry key="hibernate.generate_statistics" value="false" /> </util:map> <bean id="entityManager" class="org.springframework.orm.jpa.support.SharedEntityManagerBean"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <!-- Application properties --> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:application.properties</value> </list> </property> <property name="ignoreUnresolvablePlaceholders" value="true" /> </bean> <jee:jndi-lookup jndi-name="java:jboss/datasources/MySqlDS" id="dataSource" expected-type="javax.sql.DataSource"/> <tx:jta-transaction-manager /> … <tx:annotation-driven transaction-manager="transactionManager" />

I did a search through the JBOss configs for anything called "TransactionManager," but no dice. Here's how I define my datasource in JBoss' $JBOSS_HOME/standalone/conf/standalone.xml file …

<datasources> <datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true" use-java-context="true"> <connection-url>jdbc:mysql://localhost:3306/mydb</connection-url> <driver>mysql</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>10</min-pool-size> <max-pool-size>100</max-pool-size> <prefill>true</prefill> </pool> <security> <user-name>mydb</user-name> <password>mydb</password> </security> <statement> <prepared-statement-cache-size>32</prepared-statement-cache-size> <share-prepared-statements>true</share-prepared-statements> </statement> </datasource> <drivers> <driver name="mysql" module="com.mysql"/> </drivers> </datasources>

Thanks for any guidance, - Dave

Hi,

I'm building a WAR using Spring 3.1.1.RELEASE, Hibernate 4.1.0.Final, JPA 2.0, and deploying to JBoss 7.1.1.Final. I'm noticing some errors that occur in my JBoss environment that don't occur in my unit tests and I want to eliminate a couple of factors. Is there a way to mock the JBoss transaction manager when running Spring JUnit tests? I use this application context when I deploy my application:

<!-- JNDI name for EntityManagerFactory is defined in src/main/resources/META-INF/persistence.xml --> <jee:jndi-lookup jndi-name="java:jboss/springboard/myclientpersistence" id="entityManagerFactory" expected-type="javax.persistence.EntityManagerFactory" /> <bean id="entityManager" class="org.springframework.orm.jpa.support.SharedEntityManagerBean"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <jee:jndi-lookup jndi-name="java:jboss/datasources/MySqlDS" id="dataSource" expected-type="javax.sql.DataSource"/> <tx:jta-transaction-manager /> <tx:annotation-driven />

but in my JUnit environment, I use a different context:

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="org.h2.Driver" /> <property name="url" value="jdbc:h2:~/myclientclient-test" /> <property name="username" value="" /> <property name="password" value="" /> </bean> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"/> </property> <property name="persistenceXmlLocation" value="classpath:META-INF/test-persistence.xml"/> <property name="persistenceUnitName" value="testingDatabase"/> <property name="dataSource" ref="dataSource"/> </bean> <bean id="sharedEntityManager" class="org.springframework.orm.jpa.support.SharedEntityManagerBean"> <property name="entityManagerFactory" ref="entityManagerFactory"/> </bean> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory"/> </bean> <tx:annotation-driven /> <jdbc:embedded-database id="embedded" type="H2"/> <jdbc:initialize-database data-source="dataSource"> <jdbc:script location="classpath:db-test-data.sql"/> </jdbc:initialize-database>

I would like my tests to mirror as closely as possible what will happen when I deploy. Thanks, -

Yeah, I think so. I tried setting the timeout attribute on the "@Transactional" method of my service class ...

@Service("myService") public class MyServiceImpl implements MyService { @Transactional(timeout = 20) public void run(final Map<Integer, Order> orders) {

but this doesn't work (I set it to a low value to test it stuff would actually time out, but it didn't).

Hi,

I'm using JPA 2.0, Hibernate 4.1.0.Final, Spring 3.1.1.RELEASE, and JUnit 4.8.1. I'm confused about why a JUnit test is NOT failing. I have this test

@RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration({ "classpath:test-context.xml" }) public class ProductDaoTest extends AbstractTransactionalJUnit4SpringContextTests { ... @Test public void testDeleteWithNonexistentEntity() { final String id = m_testProps.getProperty("test.product.id"); Product product = m_productDao.findById(id); Assert.assertNotNull("A pre-condition of this test is that a product exist with id \"" + id + "\".", product); m_productDao.delete(product); // Now try and delete it again. m_productDao.delete(product); entityManager.flush(); } // testDeleteWithNonexistentEntity

My code for deleting an entity is

protected boolean delete(Object obj) { boolean ret = false; if (obj != null) { m_entityManager.remove(obj); ret = true; } // if return ret; }

Shouldn't the second call to "delete" result in some kind of exception since the entity was removed in the first call? My flush mode is set to AUTO (the default) and below is how I configure my entity manager in my JUnit Spring application context and persistence.xml. Why isn't the second delete call failing?

<?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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:util="http://www.springframework.org/schema/util" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:jaxws="http://cxf.apache.org/jaxws" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd"> <!-- Enable annotation driven controllers, validation etc... --> <mvc:annotation-driven /> <context:component-scan base-package="org.mainco" /> <!-- Define test properties --> <util:properties id="applicationProperties" location="classpath:test.properties" /> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="org.hsqldb.jdbcDriver"/> <property name="url" value="jdbc:hsqldb:mem:lycea" /> <property name="username" value="sa" /> <property name="password" value="" /> </bean> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"/> </property> <property name="persistenceXmlLocation" value="classpath:META-INF/test-persistence.xml"/> <property name="persistenceUnitName" value="orgTestingDatabase"/> <property name="dataSource" ref="dataSource"/> </bean> <bean id="sharedEntityManager" class="org.springframework.orm.jpa.support.SharedEntityManagerBean"> <property name="entityManagerFactory" ref="entityManagerFactory"/> </bean> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory"/> </bean> <tx:annotation-driven /> <jdbc:embedded-database id="embedded" type="HSQL"/> <jdbc:initialize-database data-source="dataSource"> <jdbc:script location="classpath:db-test-data.sql"/> </jdbc:initialize-database> </beans>

and here is the persistence.xml file

<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> <persistence-unit name="orgTestingDatabase" transaction-type="RESOURCE_LOCAL"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <shared-cache-mode>ENABLE_SELECTIVE</shared-cache-mode> <properties> <property name="hibernate.ejb.cfgfile" value="/hsql_hibernate.cfg.xml" /> </properties> </persistence-unit> </persistence>

Oh, no, I'm creating a web application (WAR) and am currently using Spring "@Transactional" annotation to declare which of my service methods (service class is declared with Spring's @Service annotation) I want treated as transactions. Here's how i declare my transaction manager in my spring application context ...

<!-- JNDI name for EntityManagerFactory is defined in src/main/resources/META-INF/persistence.xml --> <jee:jndi-lookup jndi-name="java:jboss/subco/mypersistence" id="entityManagerFactory" expected-type="javax.persistence.EntityManagerFactory" /> <bean id="entityManager" class="org.springframework.orm.jpa.support.SharedEntityManagerBean"> <property name="entityManagerFactory" ref="entityManagerFactory"/> </bean> <tx:jta-transaction-manager />

and here's my persistence.xml file ...

<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> <persistence-unit name="myclientunit"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <jta-data-source>java:jboss/datasources/MySqlDS</jta-data-source> <properties> <property name="hibernate.ejb.cfgfile" value="/hibernate.cfg.xml" /> <property name="jboss.entity.manager.factory.jndi.name" value="java:jboss/myco/mypersistence" /> <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" /> </properties> </persistence-unit> </persistence>

Hi,

I'm using JBoss 7.1.1. on Mac 10.7.5. While I was able to find how to set the transaction timeout on a global basis, is it possible to put some kind of configuration into my WAR file to tell JBoss I want a specific transaction timeout for my application? I'm using Spring 3.1.1.RELEASE and Hibernate 4.1.0.Final.

Thanks, - Dave

Good deal. Thanks for clarifying.

What port is in use, though? The error messages don't provide enough information. I know it isn't 8080, b/c I can't telnet into that port. -

Thanks but there are a couple of problems with that approach. In your clause, you are asking for products in contracts, but those two lists contain different objects. A contract has a product, and I'd like to know of the given list of products, what contracts contain a product that match.

Also, I'm trying to use the more generic JPA API, using entityManager, and so I'm trying to eliminate any Hibernate-specific APIs.

> Now, is your question about how to find the users who have contracts related to the products in this list?

Yes, that's what I want. I think I'm close. I have ...

final CriteriaBuilder builder = m_entityManager.getCriteriaBuilder(); final CriteriaQuery<User> criteria = builder.createQuery(User.class); final Root<User> user = criteria.from(User.class); ... criteria.where(user.get("contracts").in(products));

but I can't figure out how to write the last line. The above dodsn't work because "contracts" are different objects than "products".

Hi,

I'm using JPA 2.0 and Hibernate 4.1.0.Final. I'm curious how I would write a specific entity manager query. I have a domain object

@Entity @Table(name = "sb_user", uniqueConstraints = {@UniqueConstraint(columnNames={"USER_NAME","URL"})} ) @Cacheable public class User implements Serializable { … @OneToMany(fetch = FetchType.EAGER) @JoinTable(name = "pre_user_contracts", joinColumns = @JoinColumn(name = "user_id"), inverseJoinColumns = @JoinColumn(name = "contract_id")) private Set<Contract> contracts;

and then the Contract domain object has

@Entity @Table(name = "pre_contract", uniqueConstraints = {@UniqueConstraint(columnNames={"OPPORTUNITY_ID","PRODUCT_ID"})} ) @Cacheable public class Contract { … @OneToOne(fetch = FetchType.EAGER, targetEntity = Product.class) @JoinColumn(name = "PRODUCT_ID") @NotNull private Product product;

Given a java.util.List of Products, how do I construct a query asking for Users who have at least one contract tied to a product in the given list?

Thanks, - Dave

Hi,

I'm using JBoss AS 7.1.0.Final on Mac 10.7.5. Occasionally, I'll try and restart JBoss, and I'll fail with the below error ("bind failed: Address already in use"). Below is output from the console …

Daves-MacBook-Pro:bin davea$ sudo sh shutdown.sh The controller is not available at localhost:9999 You are disconnected at the moment. Type 'connect' to connect to the server or 'help' for the list of supported commands. Daves-MacBook-Pro:bin davea$ sudo sh standalone.sh standalone.sh: line 114: 63600 Abort trap: 6 "$JAVA" -d32 $JAVA_OPTS -version > /dev/null 2>&1 ========================================================================= JBoss Bootstrap Environment JBOSS_HOME: /opt/jboss-as-7.1.0.Final JAVA: java JAVA_OPTS: -server -XX:+UseCompressedOops -XX:+TieredCompilation -Xms64m -Xmx512m -XX:MaxPermSize=256m -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true -Djboss.server.default.config=standalone.xml -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n ========================================================================= ERROR: transport error 202: bind failed: Address already in use ERROR: JDWP Transport dt_socket failed to initialize, TRANSPORT_INIT(510) JDWP exit error AGENT_ERROR_TRANSPORT_INIT(197): No transports initialized [../../../src/share/back/debugInit.c:690] FATAL ERROR in native method: JDWP No transports initialized, jvmtiError=AGENT_ERROR_TRANSPORT_INIT(197) standalone.sh: line 178: 63610 Abort trap: 6 "java" -D"[Standalone]" -server -XX:+UseCompressedOops -XX:+TieredCompilation -Xms64m -Xmx512m -XX:MaxPermSize=256m -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true -Djboss.server.default.config=standalone.xml -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n "-Dorg.jboss.boot.log.file=/opt/jboss-as-7.1.0.Final/standalone/log/boot.log" "-Dlogging.configuration=file:/opt/jboss-as-7.1.0.Final/standalone/configuration/logging.properties" -jar "/opt/jboss-as-7.1.0.Final/jboss-modules.jar" -mp "/opt/jboss-as-7.1.0.Final/modules" -jaxpmodule javax.xml.jaxp-provider org.jboss.as.standalone -Djboss.home.dir="/opt/jboss-as-7.1.0.Final"

The server log has this message

08:20:12,966 ERROR [org.jboss.remoting.remote.connection] (Remoting "daves-macbook-pro:MANAGEMENT" read-1) JBREM000200: Remote connection failed: java.io.IOException: Received an invalid message length of 369295616

What else should I be doing to restart my server successfully? - Dave