That's not a problem with your entity bean - that's a problem with your
choice of JDBC drivers. The JdbcOdbc can't handle multiple
threads. Solution: get a better driver.
On Sat, 23 Jun 2001, Sergei Batiuk wrote:
> Hey people,
>
> I am having trouble connecting to MS SQL 2000 from my entity bean. I have an
> ODBC data source set up for the database, and connect to it using
> sun.jdbc.odbc.JdbcOdbc driver. I get the following:
> java.rmi.RemoteException: java.sql.SQLException: [Microsoft][ODBC SQL Server
> Driver]Connection is busy with results for another hstmt
> at
> Manager_StatelessSessionBeanWrapper0.getNewsItemsCount(Manager_StatelessSess
> ionBeanWrapper0.java:209)
> at /n/news-all.jsp._jspService(/n/news-all.jsp.java:78) (JSP page line 27)
> at com.orionserver.http.OrionHttpJspPage.service(JAX)
> at com.evermind.server.http.HttpApplication.xj(JAX)
> at com.evermind.server.http.JSPServlet.service(JAX)
> at com.evermind.server.http.d3.sw(JAX)
> at com.evermind.server.http.d3.include(JAX)
> at com.evermind.server.http.EvermindPageContext.include(JAX)
> at /n/index.jsp._jspService(/n/index.jsp.java:182)
> at com.orionserver.http.OrionHttpJspPage.service(JAX)
> at com.evermind.server.http.HttpApplication.xj(JAX)
> at com.evermind.server.http.JSPServlet.service(JAX)
> at com.evermind.server.http.d3.sw(JAX)
> at com.evermind.server.http.d3.su(JAX)
> at com.evermind.server.http.ef.s1(JAX)
> at com.evermind.server.http.ef.do(JAX)
> at com.evermind.util.f.run(JAX)
>
> What is going on?
> Best regards,
> Sergei.
>
>
>
-----------------------------------------------------------
Joseph B. Ottinger [EMAIL PROTECTED]
http://adjacency.org/ IT Consultant
