axis-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From smcar...@spansurf.com
Subject RE: Connecting to a dsn
Date Thu, 18 Nov 2004 14:17:23 GMT
Hi,

I need to see your current code connectToDsn in your client. Also, ensure you 
have a database configured in MYSql with the name neotest on a database server 
called devserver running on port 1433

If you are running all your code on the same machine (database, tomcat, client) 
try using localhost instead of devserver.

Regards

Steven McArdle 

Quoting John McCosker <J.McCosker@andronics.com>:

> Thanks,
> 
> I did the following, I'm getting an error which is quite specific now,
> " Name jdbc is not bound in this Context " maybe it might ring a bell,
> 
> another thing I changed was,
> from
> <value>jdbc:jtds:sqlserver://devserver:1433/webServiceName?autoReconnect=tru
> e</value>
> to
> apache reflects this,
> <value>jdbc:jtds:sqlserver://devserver:1433/neotest?autoReconnect=true</valu
> e>
> 
> I had the first method because I found a user in AXIS archives had a similar
> problem and used
> the first method, so Im a little confused as which one is right in this
> situation. However
> I can't seem to apply his findings as a sloution to my problem, mmm... must
> try harder....
> 
> I have tested both ways but get the same stack dump.
> 
> jp.
> 
> ===================
> updated server.xml
> 
> <Context path="/axis" docBase="axis" debug="5" reloadable="true"
> crossContext="true">
> 	
> 	  		<Logger
> className="org.apache.catalina.logger.FileLogger" 
> 					prefix="localhost_neotest_log."
> suffix=".txt"
> 	             	timestamp="true"/>
> 	
> 			<Resource name="jdbc/neotest"
> 			          auth="Container"
> 			          type="javax.sql.DataSource"/>
> 	
> 	  		<ResourceParams name="jdbc/neotest">
> 			    <parameter>
> 			      <name>factory</name>
> 	
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> 			    </parameter>
> 	
> 			    <!-- Maximum number of dB connections in pool.
> Make sure you
> 			         configure your mysqld max_connections large
> enough to handle
> 			         all of your db connections. Set to 0 for no
> limit.
> 			         -->
> 			    <parameter>
> 			      <name>maxActive</name>
> 			      <value>10</value>
> 			    </parameter>
> 	
> 			    <!-- Maximum number of idle dB connections to
> retain in pool.
> 			         Set to 0 for no limit.
> 			         -->
> 			    <parameter>
> 			      	<name>maxIdle</name>
> 			      	<value>5</value>
> 			    </parameter>
> 	
> 			    <!-- Maximum time to wait for a dB connection to
> become available
> 			         in ms, in this example 10 seconds. An
> Exception is thrown if
> 			         this timeout is exceeded.  Set to -1 to
> wait indefinitely.
> 			         -->
> 			    <parameter>
> 			      	<name>maxWait</name>
> 			     	<value>10000</value>
> 			    </parameter>
> 	
> 			    <!-- MySQL dB username and password for dB
> connections  -->
> 			    <parameter>
> 			     	<name>username</name>
> 			     	<value>sa</value>
> 			    </parameter>
> 			    <parameter>
> 			     	<name>password</name>
> 			     	<value></value>
> 			    </parameter>
> 	
> 			    <!-- Class name JDBC driver (tds)-->
> 			    <parameter>
> 			       <name>driverClassName</name>
> 	
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> 			    </parameter>
> 	
> 			    <!-- The JDBC connection url for connecting to
> your MySQL dB.
> 			         The autoReconnect=true argument to the url
> makes sure that the
> 			         mm.mysql JDBC Driver will automatically
> reconnect if mysqld closed the
> 			         connection.  mysqld by default closes idle
> connections after 8 hours.
> 			         -->
> 			    <parameter>
> 			      	<name>url</name>
> 	
> <value>jdbc:jtds:sqlserver://devserver:1433/neotest?autoReconnect=true</valu
> e>
> 			    </parameter>
> 	  		</ResourceParams>
> 		</Context>
> 
> ======================
> new stack trace dump
> 
> jndi connection
> Details :
> date / time : Thu Nov 18 11:50:51 GMT 2004
> ----
> javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
> 	at org.apache.naming.NamingContext.lookup(NamingContext.java:811)
> 	at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
> 	at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
> 	at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
> 	at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
> 	at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
> 	at
> org.apache.naming.SelectorContext.lookup(SelectorContext.java:183)
> 	at javax.naming.InitialContext.lookup(InitialContext.java:347)
> 	at
> com.leocate.database.NeoTestConnection.connectToDsn(NeoTestConnection.java:3
> 6)
> 	at
> com.leocate.trends.TrendsContentHandler.endDocument(TrendsContentHandler.jav
> a:64)
> 	at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown
> Source)
> 	at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown
> Source)
> 	at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
> 	at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
> 	at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown
> Source)
> 	at
> org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatc
> h(Unknown Source)
> at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
> 	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
> Source)
> 	at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
> 	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
> 	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
> 	at
> com.leocate.trends.RegisterTrendsContentHandler.parseXmlSrc(RegisterTrendsCo
> ntentHandler.java:70)
> 	at
> com.leocate.spreadSheets.SpreadSheetContentHandler.endDocument(SpreadSheetCo
> ntentHandler.java:70)
> 	at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown
> Source)
> 	at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown
> Source)
> 	at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
> 	at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
> 	at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown
> Source)
> 	at
> org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatc
> h(Unknown Source)
> 	at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
> 	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
> Source)
> 	at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
> 	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
> 	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
> 	at
> com.leocate.spreadSheets.ContentHandlerPublishingBean.parseXmlSrc(ContentHan
> dlerPublishingBean.java:69)
> 	at
> com.leocate.spreadSheets.ExcelPublishingService.createSpreadSheet(ExcelPubli
> shingService.java:34)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
> )
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
> .java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:324)
> 	at org.apache.axis.providers.java.RPCProvider.invokeMethod(Unknown
> Source)
> 	at org.apache.axis.providers.java.RPCProvider.processMessage(Unknown
> Source)
> 	at org.apache.axis.providers.java.JavaProvider.invoke(Unknown
> Source)
> 	at org.apache.axis.strategies.InvocationStrategy.visit(Unknown
> Source)
> 	at org.apache.axis.SimpleChain.doVisiting(Unknown Source)
> 	at org.apache.axis.SimpleChain.invoke(Unknown Source)
> 	at org.apache.axis.server.AxisServer.invoke(Unknown Source)
> 	at org.apache.axis.transport.http.AxisServlet.doPost(Unknown Source)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> 	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.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:2422)
> 	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:163
> )
> 	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:199)
> 	at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
> 	at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:700)
> 	at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
> 	at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:683)
> 	at java.lang.Thread.run(Thread.java:536)
> 
>  
> 
> 
> 
> 





Mime
View raw message