here's the error i'm getting:
javax.servlet.UnavailableException: Initializing application data source
DBNAME
at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j
ava:1091)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3420)
at
org.apache.catalina.core.StandardContext.reload(StandardContext.java:2567)
at
org.apache.catalina.servlets.ManagerServlet.reload(ManagerServlet.java:802)
at
org.apache.catalina.servlets.HTMLManagerServlet.reload(HTMLManagerServlet.ja
va:501)
at
org.apache.catalina.servlets.HTMLManagerServlet.doGet(HTMLManagerServlet.jav
a:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:551)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
at java.lang.Thread.run(Thread.java:536)
then from thereafter it says that i have an Invalid DataSource. Where do you
have your mssqlserver jars? i have mine in WEB-INF/lib. and there are three
of them - mssqlserver.jar, msbase.jar, msutil.jar.
claire
----- Original Message -----
From: "Srikanth Gubba" <[EMAIL PROTECTED]>
To: "'Claire Wall'" <[EMAIL PROTECTED]>; "Struts Users Mailing List"
<[EMAIL PROTECTED]>
Sent: Friday, February 27, 2004 1:18 PM
Subject: RE: microsoft sqlserver driver & struts
> Hi,
>
> I am using the same datasource configuration as you do:
> <data-source type="org.apache.commons.dbcp.BasicDataSource"
key="BkEdDbFls">
> <set-property property="driverClassName"
> value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
> <set-property property="url"
>
>
value="jdbc:microsoft:sqlserver://**.***.***.***:1433;DatabaseName=tesstdb"
> />
> <set-property property="username"
> value="***" />
> <set-property property="password"
> value="***" />
> <set-property property="maxActive"
> value="10" />
> <set-property property="maxWait"
> value="5000" />
> <set-property property="defaultAutoCommit"
> value="true" />
> <set-property property="defaultReadOnly"
> value="false" />
> </data-source>
>
> and in the code ,
> DataSource dataSource = (DataSource)
> context.getAttribute("BkEdDbFls");
>
> Hope this helps. Can u give me what error message u r receiving.
>
> Srikanth.
>
> -----Original Message-----
> From: Claire Wall [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 27, 2004 5:34 AM
> To: Struts Users Mailing List
> Subject: microsoft sqlserver driver & struts
>
>
> Hi,
>
> I am trying to use microsoft's jdbc driver with my struts application, but
> to no avail. Here is my datasource definition:
>
> <data-source key="DB" type="org.apache.commons.dbcp.BasicDataSource">
> <set-property property="description" value="My SqlServer pool"/>
> <set-property property="driverClassName"
> value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
> <set-property property="url"
> value="jdbc:microsoft:sqlserver://SERVERNAME:1433;DatabaseName=DBNAME"/>
> <set-property property="username" value="xxx"/>
> <set-property property="password" value="xxx"/>
> <set-property property="maxActive" value="20"/>
> <set-property property="maxCount" value="20"/>
> <set-property property="minCount" value="2"/>
> <set-property property="maxWait" value="5000"/>
> <set-property property="defaultAutoCommit" value="false"/>
> <set-property property="defaultReadOnly" value="false"/>
> </data-source>
>
> I have the required jars located in the WEB-INF/lib of my application
which
> is running on Tomcat 4.1.29. When i try to connect to the database using
> this driver from a test class, it connects no problem so i know that the
url
> and driver class name are correct. So the problem must be the type of
> DataSource which I am to use. Does anybody know which datasource to use
with
> Microsoft's sqlserver driver? I tried using the DataSource that is in the
> mssqlserver jar but this didnt work either.
>
> The error that I get is an Invalid DataSource.
>
> Any help would be really appreciated!
>
> Thanks
> Claire
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
