Re: Problem connecting to Ms Sql Server 2000

2001-06-23 Thread Joseph B. Ottinger 

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

RE: Problem connecting to Ms Sql Server 2000

2001-06-22 Thread elephantwalker 

Sergei,

Its probably the sun driver, I have had the same problems with Access, of
all things, with a standalone program. I would suggest using another
jdbc-odbc bridge besides sun's.  Use www.nogginware.com 's jdbc-odbc bridge,
its cheap, and it works. You can test it for free.

regards,

the elephantwalker



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Sergei Batiuk
Sent: Friday, June 22, 2001 2:13 PM
To: Orion-Interest
Subject: Problem connecting to Ms Sql Server 2000


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.