You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by John Lindley <jl...@yahoo.com> on 2005/06/15 08:15:33 UTC
Unable to connect to Access DB using service startup
Hi everyone, I am trying to connect to an Access database while running Tomcat 5.0.28. I have the
ODBC node defined under the System DSN and when I start Tomcat manually, everything works fine.
However, when I start Tomcat from the service, everything works fine, except for the page
connecting to the database. I get the following error:
2005-06-14 23:13:06 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
com.borland.dx.dataset.DataSetException: General error
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)
at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)
at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
at com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown Source)
at com.borland.dx.sql.dataset.o.a(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.f(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at com.cri.common.dataAccess.DataSourceBase.setBound(DataSourceBase.java:281)
at com.cri.common.dataAccess.DataSourceNode.getDataSource(DataSourceNode.java:139)
at com.cri.common.dataAccess.DataAccessManager.isDataSourceAvailable(DataAccessManager.java:485)
at com.cri.utility.EConExplorer.dataSourceAvailabilityForContentObject(EConExplorer.java:2805)
at com.cri.utility.EConExplorer.displayContentObject(EConExplorer.java:2829)
at com.cri.utility.EConExplorer.processViewLocalContentObject(EConExplorer.java:1331)
at com.cri.utility.EConExplorer.initializeComponent(EConExplorer.java:2527)
at com.cri.utility.EConExplorer.process(EConExplorer.java:364)
at org.apache.jsp.jsp.usr.LeftPane_jsp._jspService(LeftPane_jsp.java:55)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)
Can anyone point me in the right direction to solve this? Thanks!
John Lindley
__________________________________
Discover Yahoo!
Have fun online with music videos, cool games, IM and more. Check it out!
http://discover.yahoo.com/online.html
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Differences between service startup and batch startup
Posted by John Lindley <jl...@yahoo.com>.
I tried checking the box to allow interaction with the desktop, but it didn't seem to make a
difference. It's just so strange that it works completely fine when started from the batch file,
but not the service?
John
--- Jason Bainbridge <jb...@gmail.com> wrote:
> On 6/20/05, John Lindley <jl...@yahoo.com> wrote:
> > I have noticed a difference between starting Tomcat 5.0.28 using the service and the batch
> file.
> > When I run startup.bat, everything seems to be running fine. I have an ODBC node defined,
> > connecting to an Access database, and I have no trouble retrieving the data through Tomcat.
> > However, when I start Tomcat using the Windows service, Tomcat comes up without any errors,
> but I
> > cannot retrieve the data from the database. I get the following error:
> >
> >
> > 2005-06-18 23:13:06 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw
> exception
> > com.borland.dx.dataset.DataSetException: General error
>
> May be you need to check the "Allow interact with desktop" (or
> whatever it is) option on the Logon details for the Windows Service?
>
> Regards,
> --
> Jason Bainbridge
> http://kde.org - webmaster@kde.org
> Personal Site - http://jasonbainbridge.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Differences between service startup and batch startup
Posted by John Lindley <jl...@yahoo.com>.
I was finally able to get this working. I'm not sure if it's a bug, but when I enter in the user
information on the Log On tab of the Tomcat service interface, it doesn't seem to actually apply
the information to the Windows service. I finally tried entering the same info into the Windows
service interface and then it worked fine.
John
--- Jason Bainbridge <jb...@gmail.com> wrote:
> On 6/20/05, John Lindley <jl...@yahoo.com> wrote:
> > I have noticed a difference between starting Tomcat 5.0.28 using the service and the batch
> file.
> > When I run startup.bat, everything seems to be running fine. I have an ODBC node defined,
> > connecting to an Access database, and I have no trouble retrieving the data through Tomcat.
> > However, when I start Tomcat using the Windows service, Tomcat comes up without any errors,
> but I
> > cannot retrieve the data from the database. I get the following error:
> >
> >
> > 2005-06-18 23:13:06 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw
> exception
> > com.borland.dx.dataset.DataSetException: General error
>
> May be you need to check the "Allow interact with desktop" (or
> whatever it is) option on the Logon details for the Windows Service?
>
> Regards,
> --
> Jason Bainbridge
> http://kde.org - webmaster@kde.org
> Personal Site - http://jasonbainbridge.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Differences between service startup and batch startup
Posted by Jason Bainbridge <jb...@gmail.com>.
On 6/20/05, John Lindley <jl...@yahoo.com> wrote:
> I have noticed a difference between starting Tomcat 5.0.28 using the service and the batch file.
> When I run startup.bat, everything seems to be running fine. I have an ODBC node defined,
> connecting to an Access database, and I have no trouble retrieving the data through Tomcat.
> However, when I start Tomcat using the Windows service, Tomcat comes up without any errors, but I
> cannot retrieve the data from the database. I get the following error:
>
>
> 2005-06-18 23:13:06 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
> com.borland.dx.dataset.DataSetException: General error
May be you need to check the "Allow interact with desktop" (or
whatever it is) option on the Logon details for the Windows Service?
Regards,
--
Jason Bainbridge
http://kde.org - webmaster@kde.org
Personal Site - http://jasonbainbridge.com
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Differences between service startup and batch startup
Posted by John Lindley <jl...@yahoo.com>.
I have noticed a difference between starting Tomcat 5.0.28 using the service and the batch file.
When I run startup.bat, everything seems to be running fine. I have an ODBC node defined,
connecting to an Access database, and I have no trouble retrieving the data through Tomcat.
However, when I start Tomcat using the Windows service, Tomcat comes up without any errors, but I
cannot retrieve the data from the database. I get the following error:
2005-06-18 23:13:06 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
com.borland.dx.dataset.DataSetException: General error
I am wondering if it has to do with the user accounts. I know that in the Tomcat service
configuration, you can specify the account to log on as. I have tried entering in my account
info, but it doesn't seem to make a difference. Plus, the ODBC node is defined as a system node,
which should be available to all users.
Anyway, if anyone can offer any ideas, I would greatly appreciate it. Thanks.
John
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org