0 Replies Latest reply on Aug 20, 2007 9:34 AM by Juergen Melzer

    MSSQL Integration with SEAM/Tomcat 5.5

    Juergen Melzer Newbie

      Hi there everyone,

      I tried my helloworld example from Michael Yuan's book, which does work under Tomcat 5.5 and HSQL-DB, to configure for MS SQL Server.

      Im am working with Seam 1.2.1.GA.

      My MS SQL Server driver is the current driver from Microsoft (sqljdbc.jar) for MSSQL 2000/2005 and used to work pretty well. I copied that file to the WEB-INF/lib directory.

      Since DB Configuration takes place in the jboss-beans*.xml files, I changed my jboss-beans.xml to the following:

      <?xml version="1.0" encoding="UTF-8"?>

      <deployment xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="urn:jboss:bean-deployer bean-deployer_1_0.xsd"
      xmlns="urn:jboss:bean-deployer">


      com.microsoft.sqlserver.jdbc.SQLServerDriver
      jdbc:sqlserver://localhost:1433;databaseName=tomcatejb3;user=sa;password=sa;
      sa
      sa
      java:/DefaultDS
      0
      10
      1000
      100000













      ================================================
      My persistence.xml looks like this:


      <persistence-unit name="helloworld">
      org.hibernate.ejb.HibernatePersistence
      <jta-data-source>java:/DefaultDS</jta-data-source>









      </persistence-unit>


      ================================================
      Im am using a very easy facelets page, named test.jspx:

      <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
      <jsp:root xmlns:jsp="http://java.sun.com/JSP/Page"
      xmlns:ui="http://java.sun.com/jsf/facelets"
      xmlns:h="http://java.sun.com/jsf/html"
      xmlns:f="http://java.sun.com/jsf/core"
      xmlns:s="http://jboss.com/products/seam/taglib"
      version="2.0">

      <ui:composition>









      <h:inputText value="#{test.text}"></h:inputText>





      </ui:composition>
      </jsp:root>

      ================================================
      This page uses an Controller (testimpl.java) class, which looks like that:

      import static javax.persistence.PersistenceContextType.EXTENDED;

      import javax.ejb.Remove;
      import javax.ejb.Stateful;
      import javax.persistence.EntityManager;
      import javax.persistence.PersistenceContext;

      import org.jboss.seam.annotations.Destroy;
      import org.jboss.seam.annotations.Name;


      @Stateful
      @Name("test")
      public class testimpl implements test {

      String text;

      @PersistenceContext (type=EXTENDED)
      private EntityManager em;

      public String getText()
      {
      String s;
      s = (String)em.createQuery("select MIN(p.name) from Person p").getSingleResult();
      //s = "test";
      return s;
      }


      @Remove @Destroy
      public void destroy() {}
      }

      ================================================
      This class ist derived from the interface test.java:
      import javax.ejb.Local;

      @Local
      public interface test
      {
      public String getText();
      public void destroy ();
      }

      ================================================
      When I try that, I receive following message:
      org.jboss.seam.InstantiationException: Could not instantiate Seam component: test

      Complete trace:
      SCHWERWIEGEND: Error Rendering View[/test.jspx]
      org.jboss.seam.InstantiationException: Could not instantiate Seam component: test
      at org.jboss.seam.Component.newInstance(Component.java:1740)
      at org.jboss.seam.Component.getInstance(Component.java:1643)
      at org.jboss.seam.Component.getInstance(Component.java:1610)
      at org.jboss.seam.jsf.SeamVariableResolver.resolveVariable(SeamVariableResolver.java:53)
      at com.sun.faces.el.VariableResolverChainWrapper.getValue(VariableResolverChainWrapper.java:100)
      at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:135)
      at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
      at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:65)
      at com.sun.el.parser.AstValue.getValue(AstValue.java:106)
      at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:192)
      at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
      at javax.faces.component.UIOutput.getValue(UIOutput.java:173)
      at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:189)
      at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:320)
      at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:200)
      at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:829)
      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:894)
      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:890)
      at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:571)
      at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
      at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:248)
      at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
      at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
      at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
      at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:60)
      at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
      at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
      at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
      at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79)
      at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
      at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: javax.naming.NameNotFoundException: testimpl not bound
      at org.jnp.server.NamingServer.getBinding(NamingServer.java:529)
      at org.jnp.server.NamingServer.getBinding(NamingServer.java:537)
      at org.jnp.server.NamingServer.getObject(NamingServer.java:543)
      at org.jnp.server.NamingServer.lookup(NamingServer.java:267)
      at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:626)
      at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:588)
      at javax.naming.InitialContext.lookup(InitialContext.java:392)
      at org.jboss.seam.Component.instantiateSessionBean(Component.java:1107)
      at org.jboss.seam.Component.instantiate(Component.java:1093)
      at org.jboss.seam.Component.newInstance(Component.java:1736)
      ... 48 more

      ================================================
      I really had a hard time finding out how to configure my seam application for Tomcat/MSSQL and never got it to run.

      I really appreciate any help on that issue.

      I right now need to get a project going, this is just the beginning...
      So I need to find the missing puzzle asap.

      Thanks for everything,


      J. Melzer