EJB news-app How-to

Fri, 11 Aug 2000 07:14:04 -0700

Hi,
 
I have seen your receipe on the orion-interest mailing list to make the news-app demo work and
of course I tried to follow it because that was the only good tutorial I got so far ...
 
I manage to set my database source : hypersonic
The only tip was to change the name of the driver : from "hsql.hDriver" to "org.hsql.jdbcDriver".
 
I am getting now a problem with the auto creation of the table : com_evermind_ejb_NewsItem.
When I start the orion server, I don�t get any auto-deploying of the news-ejb stuff and any auto-creation
of the table.
 
Did i forget to set something somewhere ?
 
My data-sources.xml file looks like this:
 
<data-source
  name="Default data-source"
   class="com.evermind.sql.ConnectionDataSource"
   location="jdbc/DefaultDS"
   pooled-location="jdbc/DefaultPooledDS"
   xa-location="jdbc/xa/DefaultXADS"
   ejb-location="jdbc/DefaultEJBDS"
   url="jdbc:HypersonicSQL:defaultdb"
   connection-driver="org.hsql.jdbcDriver"
   username="sa"
  password=""
   schema="./database-schemas/hypersonic.xml"
 />
</data-sources>
 
My server.xml file looks like this:
 
<application-server application-directory="../applications" deployment-directory="../application-deployments"> 
 <rmi-config path="./rmi.xml"/>
 <!-- JMS-server config link, uncomment to activate the JMS service --> <!-- <jms-config path="./jms.xml" /> -->
 <principals path="./principals.xml"/>
 <log><file path="../log/server.log"/></log> 
 <global-application name="default" path="application.xml"/>
 <application name="orion-primer" path="E:\orionserver\boulot\orion-primer\rel\orion-primer.ear"/>
 <application name="interest" path="E:\orionserver\boulot\interest\rel\interest.ear"/>
 <application name="news" path="..\applications\news.ear" /> 
 <global-web-app-config path="global-web-application.xml"/> 
 <web-site path="./default-web-site.xml"/>
 <!-- Compiler, activate this to specify an alternative compiler such as jikes for EJB/JSP compiling. -->
 <!-- <compiler executable="jikes" classpath="/myjdkdir/jre/lib/rt.jar" /> -->
</application-server>
 
I have heard about a <ejb-config> tag but I don�t see any in the server.xml document ...
If  i have to add one, what should I put inside ??
 
 
 
 
The error I get when i run the application:
 
com.evermind.server.rmi.OrionRemoteException: Database error: Table not found: COM_EVERMIND_EJB_NEWSITEM in statement [select id, submitter, text, locale, date_, subject, parent from com_evermind_ejb_NewsItem where 0 = parent]

	at EntityHomeWrapper1.findByParent(EntityHomeWrapper1.java:1526)

	at com.evermind.ejb.NewsSessionEJB.getChildren(NewsSessionEJB.java:44)

	at StatefulSessionBeanWrapper11.getChildren(StatefulSessionBeanWrapper11.java:66)

	at /news.jsp._jspService(/news.jsp.java:80) (JSP page line 26)

	at com.evermind.server.http.EvermindHttpJspPage.service(JAX)

	at com.evermind.server.http.HttpApplication.tb(JAX)

	at com.evermind.server.http.JSPServlet.service(JAX)

	at com.evermind.server.http.df.o3(JAX)

	at com.evermind.server.http.df.forward(JAX)

	at com.evermind.server.http.dm.o9(JAX)

	at com.evermind.server.http.dm.o8(JAX)

	at com.evermind.util.e.run(JAX)

	Nested exception is:

java.sql.SQLException: Table not found: COM_EVERMIND_EJB_NEWSITEM in statement [select id, submitter, text, locale, date_, subject, parent from com_evermind_ejb_NewsItem where 0 = parent]

	at org.hsql.Trace.getError(Trace.java:124)

	at org.hsql.jdbcResultSet.<init>(jdbcResultSet.java:1790)

	at org.hsql.jdbcConnection.executeStandalone(jdbcConnection.java:690)

	at org.hsql.jdbcConnection.execute(jdbcConnection.java:541)

	at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)

	at org.hsql.jdbcStatement.executeQuery(jdbcStatement.java:37)

	at org.hsql.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.java:99)

	at com.evermind.sql.aj.executeQuery(JAX)

	at com.evermind.sql.aj.executeQuery(JAX)

	at EntityHomeWrapper1.findByParent(EntityHomeWrapper1.java:1390)

	at com.evermind.ejb.NewsSessionEJB.getChildren(NewsSessionEJB.java:44)

	at StatefulSessionBeanWrapper11.getChildren(StatefulSessionBeanWrapper11.java:66)

	at /news.jsp._jspService(/news.jsp.java:80) (JSP page line 26)

	at com.evermind.server.http.EvermindHttpJspPage.service(JAX)

	at com.evermind.server.http.HttpApplication.tb(JAX)

	at com.evermind.server.http.JSPServlet.service(JAX)

	at com.evermind.server.http.df.o3(JAX)

	at com.evermind.server.http.df.forward(JAX)

	at com.evermind.server.http.dm.o9(JAX)

	at com.evermind.server.http.dm.o8(JAX)

	at com.evermind.util.e.run(JAX)
 
Any help will be appreciated.
Thank you.
Jean-Guillaume
 
 
 

Reply via email to