Jose Alvarez de Lara

Here is the spring-stateless-ejb.xml file,
<?xml version="1.0"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd"> <beans> <bean id="countryService" class="org.mysql.neo4j.ejb.CountryServiceImpl"/> </beans>

Best,

Thanks,
jose

I'm carrying a MySQL database to another Neo4j for which I read MySQL using Ejb and convert to a database Neo4j.
For this I use Spring. The problem is I can not instantiate the EJB because I get a NullPointerException.

These are the code and the configuration files,

The Business Interface
package org.mysql.neo4j.ejb; import java.util.List; import org.mysql.neo4j.entity.Country; public interface CountryService { public List<Country> findAll(); }

The Implementation class
package org.mysql.neo4j.ejb; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import org.mysql.neo4j.entity.Country; public class CountryServiceImpl implements CountryService { @PersistenceContext(unitName = "mysql-neo4j") private EntityManager em; protected EntityManager getEntityManager() { return em; } public CountryServiceImpl() { } public List<Country> findAll() { javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery(); cq.select(cq.from(Country.class)); return getEntityManager().createQuery(cq).getResultList(); } }

The EJB Remote Object
package org.mysql.neo4j.ejb; import java.rmi.RemoteException; import javax.ejb.CreateException; import javax.ejb.EJBHome; public interface CountryServiceHome extends EJBHome { public CountryServiceRemote create() throws CreateException, RemoteException; }

The Country Service EJB
package org.mysql.neo4j.ejb; import java.util.List; import javax.ejb.CreateException; import org.springframework.beans.factory.BeanFactory; import org.springframework.ejb.support.AbstractStatelessSessionBean; import org.mysql.neo4j.entity.Country; public class CountryServiceEjb extends AbstractStatelessSessionBean implements CountryService { private static final long serialVersionUID = 7343537339311230129L; private CountryService countryService; protected void onEjbCreate() throws CreateException { BeanFactory beanFactory = getBeanFactory(); countryService = (CountryService) beanFactory.getBean("countryService"); } public List<Country> findAll() { return countryService.findAll(); } }

ejb-jar.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd"> <ejb-jar> <enterprise-beans> <session> <ejb-name>CountryServiceEjb</ejb-name> <home> org.mysql.neo4j.ejb.CountryServiceHome </home> <remote> org.mysql.neo4j.ejb.CountryServiceRemote </remote> <ejb-class> org.mysql.neo4j.ejb.CountryServiceEjb </ejb-class> <session-type>Stateless</session-type> <transaction-type>Container</transaction-type> <env-entry> <env-entry-name>ejb/BeanFactoryPath</env-entry-name> <env-entry-type>java.lang.String</env-entry-type> <env-entry-value>spring-stateless-ejb</env-entry-value> </env-entry> </session> </enterprise-beans> </ejb-jar>

client-spring-stateless-ejb.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:jee="http://www.springframework.org/schema/jee" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.0.xsd"> <jee:remote-slsb id="countryServiceBean" jndi-name="ejb/countryService" business-interface="org.mysql.neo4j.ejb.CountryService" cache-home="true" lookup-home-on-startup="true" resource-ref="true"> <jee:environment> java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory java.naming.factory.url.pkgs=com.sun.enterprise.naming java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl </jee:environment> </jee:remote-slsb> </beans>

And here is the client,
package org.mysql.neo4j.sakilaimport; import java.io.File; import java.util.concurrent.TimeUnit; import org.mysql.neo4j.ejb.CountryService; import org.neo4j.graphdb.GraphDatabaseService; import org.neo4j.graphdb.Transaction; import org.neo4j.graphdb.factory.GraphDatabaseFactory; import org.neo4j.kernel.impl.util.FileUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.CommandLineRunner; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.EnableAutoConfiguration; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.boot.context.embedded.EmbeddedServletContainerFactory; import org.springframework.boot.context.embedded.tomcat.TomcatEmbeddedServletContainerFactory; import org.springframework.context.ApplicationContext; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.ComponentScan; import org.springframework.context.annotation.Configuration; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.data.neo4j.config.EnableNeo4jRepositories; import org.springframework.data.neo4j.config.Neo4jConfiguration; import org.springframework.data.neo4j.core.GraphDatabase; import org.springframework.data.neo4j.support.Neo4jTemplate; @SpringBootApplication public class SakilaImporter implements CommandLineRunner { @Configuration @EnableAutoConfiguration @ComponentScan(basePackages = "org.mysql.neo4j.domain") @EnableNeo4jRepositories(basePackages = "org.mysql.neo4j.repository") static class ApplicationConfig extends Neo4jConfiguration { public ApplicationConfig() { setBasePackage("org.mysql.neo4j.domain"); } @Bean static GraphDatabaseService graphDatabaseService() { return new GraphDatabaseFactory().newEmbeddedDatabase("mysql-neo4j.db"); } @Bean public Neo4jTemplate neo4jTemplate() { return new Neo4jTemplate(graphDatabaseService()); } @Bean public EmbeddedServletContainerFactory servletContainer() { TomcatEmbeddedServletContainerFactory factory = new TomcatEmbeddedServletContainerFactory(); factory.setPort(9000); factory.setSessionTimeout(10, TimeUnit.MINUTES); //factory.addErrorPages(new ErrorPage(HttpStatus.404, "/notfound.html")); return factory; } } @Autowired SakilaDbImportService importer; @Autowired GraphDatabase graphDatabase; public SakilaImporter() { @SuppressWarnings("resource") ApplicationContext context = new ClassPathXmlApplicationContext("client-spring-stateless-ejb.xml"); CountryService countryService = (CountryService) context.getBean("countryServiceBean"); importer.setCountryService(countryService); //context.close(); } public void run(String... args) throws Exception { Transaction tx = graphDatabase.beginTx(); try { final long start = System.currentTimeMillis(); String done = importer.importCountries(); final long time = System.currentTimeMillis() - start; System.out.println("Imported places took " + time + " ms."); tx.success(); } finally { tx.close(); } } public static void main(String[] args) throws Exception { FileUtils.deleteRecursively(new File("mysql-neo4j.db")); SpringApplication.run(SakilaImporter.class, args); } }

The application is deployed in Tomcat as a webapp. Here is the exception,
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sakilaImporter': Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mysql.neo4j.sakilaimport.SakilaImporter$$EnhancerBySpringCGLIB$$3ddc1b31]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'countryServiceBean': Invocation of init method failed; nested exception is javax.naming.NamingException: Lookup failed for 'ejb/countryService' in SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is javax.naming.NamingException: Unable to acquire SerialContextProvider for SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is java.lang.NullPointerException]] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1105) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1050) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:305) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:301) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:196) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:834) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:537) at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:686) at org.springframework.boot.SpringApplication.run(SpringApplication.java:320) at org.springframework.boot.SpringApplication.run(SpringApplication.java:957) at org.springframework.boot.SpringApplication.run(SpringApplication.java:946) at org.mysql.neo4j.sakilaimport.SakilaImporter.main(SakilaImporter.java:94) Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mysql.neo4j.sakilaimport.SakilaImporter$$EnhancerBySpringCGLIB$$3ddc1b31]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'countryServiceBean': Invocation of init method failed; nested exception is javax.naming.NamingException: Lookup failed for 'ejb/countryService' in SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is javax.naming.NamingException: Unable to acquire SerialContextProvider for SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is java.lang.NullPointerException]] at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:89) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1098) ... 16 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'countryServiceBean': Invocation of init method failed; nested exception is javax.naming.NamingException: Lookup failed for 'ejb/countryService' in SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is javax.naming.NamingException: Unable to acquire SerialContextProvider for SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is java.lang.NullPointerException]] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:305) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:301) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:196) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:753) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:834) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:537) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) at org.mysql.neo4j.sakilaimport.SakilaImporter.<init>(SakilaImporter.java:69) at org.mysql.neo4j.sakilaimport.SakilaImporter$$EnhancerBySpringCGLIB$$3ddc1b31.<init>(<generated>) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) ... 18 more Caused by: javax.naming.NamingException: Lookup failed for 'ejb/countryService' in SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is javax.naming.NamingException: Unable to acquire SerialContextProvider for SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is java.lang.NullPointerException]] at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:491) at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:438) at javax.naming.InitialContext.lookup(InitialContext.java:417) at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:155) at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87) at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152) at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:179) at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:104) at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:106) at org.springframework.ejb.access.AbstractRemoteSlsbInvokerInterceptor.lookup(AbstractRemoteSlsbInvokerInterceptor.java:99) at org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.refreshHome(AbstractSlsbInvokerInterceptor.java:121) at org.springframework.ejb.access.SimpleRemoteSlsbInvokerInterceptor.refreshHome(SimpleRemoteSlsbInvokerInterceptor.java:162) at org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.afterPropertiesSet(AbstractSlsbInvokerInterceptor.java:108) at org.springframework.ejb.access.SimpleRemoteStatelessSessionProxyFactoryBean.afterPropertiesSet(SimpleRemoteStatelessSessionProxyFactoryBean.java:101) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) ... 36 more Caused by: javax.naming.NamingException: Unable to acquire SerialContextProvider for SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.initial=com.sun.enterprise.naming.SerialInitContextFactory} [Root exception is java.lang.NullPointerException] at com.sun.enterprise.naming.impl.SerialContext.getProvider(SerialContext.java:334) at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:477) ... 51 more Caused by: java.lang.NullPointerException at com.sun.enterprise.naming.impl.SerialContext.getORB(SerialContext.java:347) at com.sun.enterprise.naming.impl.SerialContext.getProviderCacheKey(SerialContext.java:354) at com.sun.enterprise.naming.impl.SerialContext.getRemoteProvider(SerialContext.java:384) at com.sun.enterprise.naming.impl.SerialContext.getProvider(SerialContext.java:329) ... 52 more

Please, where am I getting wrong?

All the best,

Thanks,
jose

Take a look at this web, it seems that resolve my issue

Seam Data Validation

Thank you for your interesting.

Kind regards,
Jose

I get the following message,

Warning: This page calls for XML namespace http://jboss.com/products/seam/taglib declared with prefix s but no taglibrary exists for that namespace.

Whitch is the taglibrary?

Thanks,
Jose

Hi Herbert,

If I add a little hardcode like 'Helo world' I can see it.

It's the <s:link> tag what I cannot see

Thnaks,
Jose

Hi,

I am newbe with JBoss Seam. I am using 2.2.0 GA version. My problem is that I cannot display a JSF page.
When I invoke it I see a blank page. Here is my code,

Then bean (HomeBean),

@AutoCreate @Name("homeBean") @Scope(ScopeType.SESSION) public class HomeBean implements java.io.Serializable { private static final long serialVersionUID = 1L; @In private MailService mailService; private String baseUrl = null; public String send() { mailService.send("simple.xhtml", new MailUser("Aristoteles Lopez", "som-user@gmail.com")); return null; } public void setBaseUrl(String baseUrl) { this.baseUrl = baseUrl; } public String getBaseUrl() { if(null == baseUrl) baseUrl = ServletContexts.getInstance().getRequest().getScheme() + "://" + ServletContexts.getInstance().getRequest().getServerName() + ":" + ServletContexts.getInstance().getRequest().getServerPort() + ServletContexts.getInstance().getRequest().getContextPath(); return baseUrl; } }

The JSF page (index.xhtml),

<?xml version='1.0' encoding='UTF-8' ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:h="http://java.sun.com/jsf/html" xmlns:s="http://jboss.com/products/seam/taglib"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Index</title> </head> <body> <br/><br/> <center> <h:form> <s:link action="#{homeBean.send}" value="Send email"/> </h:form> </center> </body> </html>

I am thinking I have to do some declarations in the faces-config.xml file but I do not know what is it.

Please help.

Kind regards,
Jose

Hi,

There is a bug in my GF version.

Let you see the fix in [#GLASSFISH-16816]

Regards,
Jose

Hi,

I have an Oracle StoredFunctionCall method implemented in an EJB 3.1, all deployed
in GF 3.1.1

When I try to call the EJB from an Application Client Project I get the following
exception

javax.naming.CommunicationException: Communication exception for SerialContext[myEnv={java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory, java.naming.factory.url.pkgs=com.sun.enterprise.naming, java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl} [Root exception is java.rmi.RemoteException: CORBA NO_IMPLEMENT 1398079489 Maybe; nested exception is:
org.omg.CORBA.NO_IMPLEMENT: ----------BEGIN server-side stack trace----------
org.omg.CORBA.NO_IMPLEMENT: ADVERTENCIA: IOP01000001: Missing local value implementation vmcid: SUN minor code: 1 completed: Maybe
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:248)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:95)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.handleFullLogging(WrapperGenerator.java:387)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.access$400(WrapperGenerator.java:107)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator$2.invoke(WrapperGenerator.java:511)
at com.sun.corba.ee.spi.orbutil.proxy.CompositeInvocationHandlerImpl.invoke(CompositeInvocationHandlerImpl.java:99)
at $Proxy148.missingLocalValueImpl(Unknown Source)
at com.sun.corba.ee.impl.io.FVDCodeBaseImpl.implementation(FVDCodeBaseImpl.java:113)
at com.sun.org.omg.SendingContext._CodeBaseImplBase._invoke(_CodeBaseImplBase.java:99)
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:528)
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:199)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1624)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1486)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:990)
at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:214)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:742)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMessageMediatorImpl.java:539)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMessageMediatorImpl.java:2324)
at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:497)
at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:540)
Caused by: java.lang.ClassNotFoundException: session.__EJB31_Generated__ObtenerMaxIdPedidoUsuario__Intf____Bean__ (no security manager: RMI class loader disabled)
at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:375)
at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:165)
at java.rmi.server.RMIClassLoader$2.loadClass(RMIClassLoader.java:620)
at java.rmi.server.RMIClassLoader.loadClass(RMIClassLoader.java:202)
at java.rmi.server.RMIClassLoader.loadClass(RMIClassLoader.java:135)
at com.sun.corba.ee.impl.util.JDKBridge.loadClassM(JDKBridge.java:319)
at com.sun.corba.ee.impl.util.JDKBridge.loadClass(JDKBridge.java:228)
at com.sun.corba.ee.impl.javax.rmi.CORBA.Util.loadClass(Util.java:640)
at com.sun.corba.ee.impl.util.RepositoryId.getClassFromType(RepositoryId.java:577)
at com.sun.corba.ee.impl.io.ValueHandlerImpl.getClassFromType(ValueHandlerImpl.java:373)
at com.sun.corba.ee.impl.io.FVDCodeBaseImpl.implementation(FVDCodeBaseImpl.java:105)
... 12 more

----------END server-side stack trace---------- vmcid: SUN minor code: 1 completed: Maybe]
at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:542)
at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:455)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at Main.getMaxId(Main.java:34)
at Main.main(Main.java:17)
Caused by: java.rmi.RemoteException: CORBA NO_IMPLEMENT 1398079489 Maybe; nested exception is:
org.omg.CORBA.NO_IMPLEMENT: ----------BEGIN server-side stack trace----------
org.omg.CORBA.NO_IMPLEMENT: ADVERTENCIA: IOP01000001: Missing local value implementation vmcid: SUN minor code: 1 completed: Maybe
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:248)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:95)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.handleFullLogging(WrapperGenerator.java:387)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.access$400(WrapperGenerator.java:107)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator$2.invoke(WrapperGenerator.java:511)
at com.sun.corba.ee.spi.orbutil.proxy.CompositeInvocationHandlerImpl.invoke(CompositeInvocationHandlerImpl.java:99)
at $Proxy148.missingLocalValueImpl(Unknown Source)
at com.sun.corba.ee.impl.io.FVDCodeBaseImpl.implementation(FVDCodeBaseImpl.java:113)
at com.sun.org.omg.SendingContext._CodeBaseImplBase._invoke(_CodeBaseImplBase.java:99)
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:528)
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:199)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1624)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1486)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:990)
at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:214)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:742)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMessageMediatorImpl.java:539)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMessageMediatorImpl.java:2324)
at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:497)
at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:540)
Caused by: java.lang.ClassNotFoundException: session.__EJB31_Generated__ObtenerMaxIdPedidoUsuario__Intf____Bean__ (no security manager: RMI class loader disabled)
at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:375)
at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:165)
at java.rmi.server.RMIClassLoader$2.loadClass(RMIClassLoader.java:620)
at java.rmi.server.RMIClassLoader.loadClass(RMIClassLoader.java:202)
at java.rmi.server.RMIClassLoader.loadClass(RMIClassLoader.java:135)
at com.sun.corba.ee.impl.util.JDKBridge.loadClassM(JDKBridge.java:319)
at com.sun.corba.ee.impl.util.JDKBridge.loadClass(JDKBridge.java:228)
at com.sun.corba.ee.impl.javax.rmi.CORBA.Util.loadClass(Util.java:640)
at com.sun.corba.ee.impl.util.RepositoryId.getClassFromType(RepositoryId.java:577)
at com.sun.corba.ee.impl.io.ValueHandlerImpl.getClassFromType(ValueHandlerImpl.java:373)
at com.sun.corba.ee.impl.io.FVDCodeBaseImpl.implementation(FVDCodeBaseImpl.java:105)
... 12 more

----------END server-side stack trace---------- vmcid: SUN minor code: 1 completed: Maybe
at com.sun.corba.ee.impl.javax.rmi.CORBA.Util.mapSystemException(Util.java:311)
at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:213)
at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
at com.sun.corba.ee.impl.presentation.rmi.codegen.CodegenStubBase.invoke(CodegenStubBase.java:227)
at com.sun.enterprise.naming.impl._SerialContextProvider_DynamicStub.lookup(com/sun/enterprise/naming/impl/_SerialContextProvider_DynamicStub.java)
at com.sun.enterprise.naming.impl.SerialContext.lookup(SerialContext.java:505)
... 4 more
Caused by: org.omg.CORBA.NO_IMPLEMENT: ----------BEGIN server-side stack trace----------
org.omg.CORBA.NO_IMPLEMENT: ADVERTENCIA: IOP01000001: Missing local value implementation vmcid: SUN minor code: 1 completed: Maybe
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:248)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:95)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.handleFullLogging(WrapperGenerator.java:387)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.access$400(WrapperGenerator.java:107)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator$2.invoke(WrapperGenerator.java:511)
at com.sun.corba.ee.spi.orbutil.proxy.CompositeInvocationHandlerImpl.invoke(CompositeInvocationHandlerImpl.java:99)
at $Proxy148.missingLocalValueImpl(Unknown Source)
at com.sun.corba.ee.impl.io.FVDCodeBaseImpl.implementation(FVDCodeBaseImpl.java:113)
at com.sun.org.omg.SendingContext._CodeBaseImplBase._invoke(_CodeBaseImplBase.java:99)
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:528)
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:199)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1624)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1486)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:990)
at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:214)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:742)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMessageMediatorImpl.java:539)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMessageMediatorImpl.java:2324)
at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:497)
at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:540)
Caused by: java.lang.ClassNotFoundException: session.__EJB31_Generated__ObtenerMaxIdPedidoUsuario__Intf____Bean__ (no security manager: RMI class loader disabled)
at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:375)
at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:165)
at java.rmi.server.RMIClassLoader$2.loadClass(RMIClassLoader.java:620)
at java.rmi.server.RMIClassLoader.loadClass(RMIClassLoader.java:202)
at java.rmi.server.RMIClassLoader.loadClass(RMIClassLoader.java:135)
at com.sun.corba.ee.impl.util.JDKBridge.loadClassM(JDKBridge.java:319)
at com.sun.corba.ee.impl.util.JDKBridge.loadClass(JDKBridge.java:228)
at com.sun.corba.ee.impl.javax.rmi.CORBA.Util.loadClass(Util.java:640)
at com.sun.corba.ee.impl.util.RepositoryId.getClassFromType(RepositoryId.java:577)
at com.sun.corba.ee.impl.io.ValueHandlerImpl.getClassFromType(ValueHandlerImpl.java:373)
at com.sun.corba.ee.impl.io.FVDCodeBaseImpl.implementation(FVDCodeBaseImpl.java:105)
... 12 more

----------END server-side stack trace---------- vmcid: SUN minor code: 1 completed: Maybe
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sun.corba.ee.impl.protocol.giopmsgheaders.MessageBase.getSystemException(MessageBase.java:900)
at com.sun.corba.ee.impl.protocol.giopmsgheaders.ReplyMessage_1_2.getSystemException(ReplyMessage_1_2.java:131)
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.getSystemExceptionReply(CorbaMessageMediatorImpl.java:637)
at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.processResponse(CorbaClientRequestDispatcherImpl.java:499)
at com.sun.corba.ee.impl.protocol.CorbaClientRequestDispatcherImpl.marshalingComplete(CorbaClientRequestDispatcherImpl.java:373)
at com.sun.corba.ee.impl.protocol.CorbaClientDelegateImpl.invoke(CorbaClientDelegateImpl.java:273)
at org.omg.CORBA.portable.ObjectImpl._invoke(ObjectImpl.java:457)
at com.sun.org.omg.SendingContext._CodeBaseStub.implementation(_CodeBaseStub.java:63)
at com.sun.corba.ee.impl.encoding.CachedCodeBase.implementation(CachedCodeBase.java:119)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.getClassFromString(CDRInputStream_1_0.java:2292)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1095)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:935)
at com.sun.corba.ee.impl.encoding.CDRInputObject.read_value(CDRInputObject.java:525)
at com.sun.corba.ee.impl.corba.TCUtility.unmarshalIn(TCUtility.java:289)
at com.sun.corba.ee.impl.corba.AnyImpl.read_value(AnyImpl.java:605)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_any(CDRInputStream_1_0.java:775)
at com.sun.corba.ee.impl.encoding.CDRInputObject.read_any(CDRInputObject.java:482)
at com.sun.corba.ee.impl.javax.rmi.CORBA.Util.readAny(Util.java:452)
at com.sun.corba.ee.impl.presentation.rmi.DynamicMethodMarshallerImpl$10.read(DynamicMethodMarshallerImpl.java:299)
at com.sun.corba.ee.impl.presentation.rmi.DynamicMethodMarshallerImpl.readResult(DynamicMethodMarshallerImpl.java:483)El MaxId es null

at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:203)
... 8 more

Here is the main method of the Application Client Project within an ear project,

public class Main { private ObtenerMaxIdPedidoUsuario obtenerMaxIdPedidoUsuario; public static void main(String[] args) { // TODO Auto-generated method stub Main myMain = new Main(); try { System.out.println("El MaxId es " + myMain.getMaxId()); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } /* (non-Java-doc) * @see java.lang.Object#Object() */ public Main() { super(); } private String getMaxId() throws Exception{ try{ obtenerMaxIdPedidoUsuario = (ObtenerMaxIdPedidoUsuario) new InitialContext(). lookup("java:global/AlmacenEAR/AlmacenEJB/ObtenerMaxIdPedidoUsuario"); return obtenerMaxIdPedidoUsuario.ObtenerMaxId(); } catch(NamingException ex) { ex.printStackTrace(); } return null; } }

And this is the EJB,

@Stateless public class ObtenerMaxIdPedidoUsuario implements java.io.Serializable { private static final long serialVersionUID = 1L; /** * Default constructor. */ public ObtenerMaxIdPedidoUsuario() { // TODO Auto-generated constructor stub } public String ObtenerMaxId() throws Exception { final Logger logger = Logger.getLogger("ObtenerMaxIdPedidoUsuario"); EntityManagerFactory emf = Persistence.createEntityManagerFactory("AlmacenJPA"); EntityManager em = emf.createEntityManager(); try { JpaEntityManager jpaEntityManager = JpaHelper.getEntityManager(em); Session session = jpaEntityManager.getActiveSession(); StoredFunctionCall call = new StoredFunctionCall(); call.setProcedureName("ALMACEN.fn_Obtener_MaxId"); ValueReadQuery query = new ValueReadQuery(); query.setCall(call); return (String) session.executeQuery(query); } catch (Exception ex) { logger.severe("ERROR: " + ex.getMessage()); throw ex; } } }

I know that the StoredFunctionCall musts return a Number value, but this is a test.
In my web app I have it returning a Long value, that is in fact what I need. The problem
is that I get an exception about can't cast from java.lang.String to java.lang.Long.

I do not know what is happening so I need to know what is the String value for debuging.

Kind regards,
Jose

Hi

It is happening something estrange in my Oracle database. I have to ways of getting the
ID_PEDIDOUSUARIO. One of them is as follows,

em.persist(pedidoUsuario);
em.flush();
return pedidoUsuario.getIdPedidousuario();

The other one is calling a StoredFunctionCall that gets the last Id inserted in the database.
The estrange thing is that in both cases I get a value one unit less than the real Id (PK).
I mean if the inserted Id (PK) has value of ‘n’ I get in both cases ‘n-1’. And that is the
reason I am getting NullPointerException for the first inserting.

But one thing that I cannot understand is that if I execute the Function from inside an Oracle
management tool I get the correct value so there must be something wrong during the execution
of the EJBs.

Any suggestion about this issue should be really appreciated.

Kind regards,
Jose

Hi,

Let's go on tomorrow. Now is 23:30 pm in Madrid (Spain) and I am a little bit tired.
I like your way of working. I think we can resolve this issue.

Thanks a lot,
Jose

Hi Piotr,

You say,

>>By the way - is this (assigning of an ID and reading it back) all what you want to achieve right now?

Yes, that is all.


I do not understand why the sequence generator returns pu.getPedidousuario 106 value when the PK in the table Pedido_Usuario (ID_PEDIDOUSUARIO)
is 107 value. This is the reasson why I prefer to get it calling a SP or a Function. But even in those cases I get a NullPointer.

I am in conversation with James Sutherland from EclipseLink by the mailing list but all the help should be really appreciated.

In fact this is all I need to end my web app.

Kind regards,
Jose

Hi Piotr,

First of all thanks for your interesting.

About your questios,

1)What is the "StoredProcedure" class and "JpaEntityManager"?

I took the code from another example that I have.

2)What does 'pedidoUsuarioFacade.create(order); ' do?

It persist an entity PedidoUsuario.

3)How is your entity annotated?

Here is the code snippet of the entities I manage in ManejadorPedido session bean,

@Entity @Table(name="PEDIDO_USUARIO") @NamedQueries({ @NamedQuery(name = "PedidoUsuario.findMaxId", query = "SELECT MAX(c.idPedidousuario) FROM PedidoUsuario c"), // manually created @NamedQuery(name = "PedidoUsuario.findByIdUsuario", query = "SELECT c FROM PedidoUsuario c WHERE c.idUsuario = :idUsuario"), // manually created @NamedQuery(name = "PedidoUsuario.findByTotal", query = "SELECT c FROM PedidoUsuario c WHERE c.total = :total"), @NamedQuery(name = "PedidoUsuario.findByNumeroConfirmacion", query = "SELECT c FROM PedidoUsuario c WHERE c.numeroConfirmacion = :numeroConfirmacion")}) public class PedidoUsuario implements Serializable { private static final long serialVersionUID = 1L; @Id @SequenceGenerator(name="PEDIDO_USUARIO_SEQUENCE_GENERATOR", sequenceName="PEDIDO_USUARIO_SEQ", allocationSize=1) @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="PEDIDO_USUARIO_SEQUENCE_GENERATOR") @Column(name="ID_PEDIDOUSUARIO") private long idPedidousuario; @Column(name="FECHA_PEDIDO") private Date fechaPedido; @Column(name="ID_USUARIO") private BigDecimal idUsuario; @Column(name="NUMERO_CONFIRMACION") private BigDecimal numeroConfirmacion; private BigDecimal total; public PedidoUsuario() { } public long getIdPedidousuario() { return this.idPedidousuario; } public void setIdPedidousuario(long idPedidousuario) { this.idPedidousuario = idPedidousuario; } public Date getFechaPedido() { return this.fechaPedido; } public void setFechaPedido(Date fechaPedido) { this.fechaPedido = fechaPedido; } public BigDecimal getIdUsuario() { return this.idUsuario; } public void setIdUsuario(BigDecimal idUsuario) { this.idUsuario = idUsuario; } public BigDecimal getNumeroConfirmacion() { return this.numeroConfirmacion; } public void setNumeroConfirmacion(BigDecimal numeroConfirmacion) { this.numeroConfirmacion = numeroConfirmacion; } public BigDecimal getTotal() { return this.total; } public void setTotal(BigDecimal total) { this.total = total; } }

@Entity @Table(name="PIEZA_PEDIDA") @NamedQueries({ @NamedQuery(name = "PiezaPedida.findByPedidoUsuarioId", query = "SELECT o FROM PiezaPedida o WHERE o.id.idPedidousuario = :idPedidousuario"), @NamedQuery(name = "PiezaPedida.findByPiezaId", query = "SELECT o FROM PiezaPedida o WHERE o.id.idPieza = :idPieza"), @NamedQuery(name = "PiezaPedida.findByCantidad", query = "SELECT o FROM PiezaPedida o WHERE o.cantidad = :cantidad")}) public class PiezaPedida implements Serializable { private static final long serialVersionUID = 1L; @EmbeddedId private PiezaPedidaPK id; private BigDecimal cantidad; public PiezaPedida() { } public PiezaPedidaPK getId() { return this.id; } public void setId(PiezaPedidaPK id) { this.id = id; } public BigDecimal getCantidad() { return this.cantidad; } public void setCantidad(BigDecimal cantidad) { this.cantidad = cantidad; } }

@Embeddable public class PiezaPedidaPK implements Serializable { //default serial version id, required for serializable classes. private static final long serialVersionUID = 1L; @Column(name="ID_PEDIDOUSUARIO") private long idPedidousuario; @Column(name="ID_PIEZA") private long idPieza; public PiezaPedidaPK() { } public long getIdPedidousuario() { return this.idPedidousuario; } public void setIdPedidousuario(long idPedidousuario) { this.idPedidousuario = idPedidousuario; } public long getIdPieza() { return this.idPieza; } public void setIdPieza(long idPieza) { this.idPieza = idPieza; } public boolean equals(Object other) { if (this == other) { return true; } if (!(other instanceof PiezaPedidaPK)) { return false; } PiezaPedidaPK castOther = (PiezaPedidaPK)other; return (this.idPedidousuario == castOther.idPedidousuario) && (this.idPieza == castOther.idPieza); } public int hashCode() { final int prime = 31; int hash = 17; hash = hash * prime + ((int) (this.idPedidousuario ^ (this.idPedidousuario >>> 32))); hash = hash * prime + ((int) (this.idPieza ^ (this.idPieza >>> 32))); return hash; } }

I am not sure if this is the information you are asking me. If not let me know it.

Kind regards,
Jose

Hi,

I am newbe in this question so I need help.

Kind regards,
Jose

Hi,

I am developping a JPA, EJB and JSF 2.0 web app. I persist an entity PedidoUsuario and afetr it I want to get its PK in
the corresponding table ALMACEN.PEDIDO_USUARIO. To persist the entity I use an special EJB that calls another EJBs.

Here is the EJB,

@Stateless @TransactionManagement(TransactionManagementType.CONTAINER) public class ManejadorPedido { @PersistenceContext(unitName = "AlmacenJPA") private EntityManager em; @Resource private SessionContext context; @EJB private PedidoUsuarioFacade pedidoUsuarioFacade; @EJB private PiezaPedidaFacade piezaPedidaFacade; @EJB private ObtenerMaxIdPedidoUsuario obtenerMaxIdPedidoUsuario; @TransactionAttribute(TransactionAttributeType.REQUIRED) public long placeOrder(Usuario usuario, ShoppingCart cart) { try { //Usuario usuario = addUsuario(nombre, apellidos, email, telefono, username, password); PedidoUsuario pedido = addPedido(usuario, cart); long orderId = obtenerMaxIdPedidoUsuario.ObtenerMaxId(); addPedidoItems(orderId, cart); return orderId; } catch (Exception e) { e.printStackTrace(); context.setRollbackOnly(); return 0L; } } /* private Usuario addUsuario(String nombre, String apellidos, String email, String telefono, String username, String password) { Usuario usuario = new Usuario(); usuario.setNombre(nombre); usuario.setApellidos(apellidos); usuario.setEmail(email); usuario.setTelefono(telefono); usuario.setUsername(username); usuario.setPassword(password); em.persist(usuario); return usuario; } */ private PedidoUsuario addPedido(Usuario usuario, ShoppingCart cart) { // set up customer order PedidoUsuario order = new PedidoUsuario(); order.setIdUsuario(new BigDecimal(usuario.getIdUsuario())); java.util.Date utilDate = Calendar.getInstance().getTime(); java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime()); order.setFechaPedido(sqlDate); cart.calculateTotal(); order.setTotal(BigDecimal.valueOf(cart.getTotal())); // create confirmation number Random random = new Random(); int i = random.nextInt(999999999); order.setNumeroConfirmacion(new BigDecimal(i)); //em.persist(order); pedidoUsuarioFacade.create(order); return order; } private void addPedidoItems(long orderId, ShoppingCart cart) { //em.flush(); List<ShoppingCartItem> items = cart.getItems(); // iterate through shopping cart and create OrderedProducts for (ShoppingCartItem scItem : items) { long idPieza = scItem.getPieza().getIdPieza(); // set up primary key object PiezaPedidaPK piezaPedidaPK = new PiezaPedidaPK(); piezaPedidaPK.setIdPedidousuario(orderId); piezaPedidaPK.setIdPieza(idPieza); // create ordered item using PK object PiezaPedida itemPedido = new PiezaPedida(); itemPedido.setId(piezaPedidaPK); // set quantity itemPedido.setCantidad(new BigDecimal(scItem.getCantidad())); //em.persist(itemPedido); piezaPedidaFacade.create(itemPedido); } } }

The problem is in the method placeOrder(Usuario usuario, ShoppingCart cart) when I try to get the PK of the persisted PedidoUsuario.
For it I use an EJB that implements a StoredProcedureCall. Why? The reason why is that if I use JPQL, being the PK type of sequence
it returns me a wrong PK. So I guessed it could be resolved attacking the database directly.

Here is the EJB,

@Stateless public class ObtenerMaxIdPedidoUsuario implements Serializable { private static final long serialVersionUID = 1L; /** * Default constructor. */ public ObtenerMaxIdPedidoUsuario() { // TODO Auto-generated constructor stub } public long ObtenerMaxId() throws Exception { final Logger logger = Logger.getLogger("ObtenerMaxIdPedidoUsuario"); EntityManagerFactory emf = Persistence.createEntityManagerFactory("AlmacenJPA"); EntityManager em = emf.createEntityManager(); try { JpaEntityManager jpaEntityManager = JpaHelper.getEntityManager(em); Session session = jpaEntityManager.getActiveSession(); StoredProcedureCall call = new StoredProcedureCall(); call.setProcedureName("ALMACEN.OBTENER_MAX_ID_PEDIDO_USUARIO"); call.addNamedOutputArgument("RESULT"); ValueReadQuery query = new ValueReadQuery(); query.setCall(call); return (Long)session.executeQuery(query); } catch (Exception ex) { logger.severe("ERROR: " + ex.getMessage()); throw ex; } } }

being the SP as follows,

CREATE OR REPLACE PROCEDURE ALMACEN.OBTENER_MAX_ID_PEDIDO_USUARIO (result OUT NUMBER) IS BEGIN SELECT MAX(ID_PEDIDOUSUARIO) INTO result FROM PEDIDO_USUARIO; EXCEPTION WHEN NO_DATA_FOUND THEN result := 0; END; /

But it fails. The EJB method ObtenerMaxId() returns a NullPointerException.

Maybe I am wrong in the code of the SP or maybe in the EJBs, I do not know.

Please help.

Hi Martin,

I have saved the Concurrency tutorial in my favourite’s folder of the browser.

It is clear I have to study about this stuff.

Regarding the method I have changed my code that means
I do not going to need it any longer.

Kind regards,
Jose