Hi,
Your entry lists jdbc/axis and nor jdbc/neotest.
So either add a data source for neotest or use the axis one defined
Regards
Quoting John McCosker <[EMAIL PROTECTED]>:
> Hi,
>
> I have a bean instantiated within my web service that connects to a dsn,
> however I am having some difficulty at the moment.
>
> I am trying to connect to MSSQL server using jtds,
> I followed this procedure from apache site under JNDI Datasource HOW-TO,
>
> 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/axis"
> auth="Container"
> type="javax.sql.DataSource"/>
>
> <ResourceParams name="jdbc/axis">
> <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/MyWebService?autoReconnect=true<
> /value>
> </parameter>
> </ResourceParams>
> </Context>
>
> this is my bean, it is just a test table at the moment,
> I only want to select data and dump it to a log file,
>
> package com.leocate.database;
>
> import javax.naming.*;
> import javax.sql.*;
> import java.sql.*;
>
> import com.leocate.logging.NeoFaultLogging;
> import com.leocate.logging.NeoTraceLogging;
>
> public class NeoTestConnection {
>
> private NeoTraceLogging traceLogger;
>
> public NeoTestConnection(){}
>
> public void connectToDsn(){
> try{
> this.traceLogger = new
> NeoTraceLogging("c:\\webserviceLogs\\logs\\jdbcsuccess.log");
> Context ctx = new InitialContext();
> if(ctx==null){
> NeoFaultLogging logger = new
> NeoFaultLogging("c:\\webserviceLogs\\logs\\jdbcfault.log");
> logger.writeFault(new Exception("No
> Connection"),"jndi connection");
> }
> DataSource ds =
> (DataSource)ctx.lookup("java:comp/env/jdbc/neotest");
> if(ds!=null){
> Connection conn = ds.getConnection();
> if(conn!=null){
> Statement stmt =
> conn.createStatement();
> ResultSet rst =
> stmt.executeQuery("select a,b,c,d,e,f,g,h,i,j,k from NeoTestTable");
> if(rst.next()){
>
> traceLogger.writeLog(rst.getString(1));
>
> traceLogger.writeLog(rst.getString(2));
>
> traceLogger.writeLog(rst.getString(3));
>
> traceLogger.writeLog(rst.getString(4));
>
> traceLogger.writeLog(rst.getString(5));
>
> traceLogger.writeLog(rst.getString(6));
>
> traceLogger.writeLog(rst.getString(7));
>
> traceLogger.writeLog(rst.getString(8));
>
> traceLogger.writeLog(rst.getString(9));
>
> traceLogger.writeLog(rst.getString(10));
>
> traceLogger.writeLog(rst.getString(11));
>
> traceLogger.writeLog(rst.getString(12));
> }
> conn.close();
> traceLogger.saveLog();
> }
> }
> }catch(Exception e){
> NeoFaultLogging logger = new
> NeoFaultLogging("c:\\webserviceLogs\\logs\\jdbcfault.log");
> logger.writeFault(e,"dsn connection fault");
> }finally{
> try{traceLogger.recoverClose();}catch(Exception
> rc){}
> }
> }
>
> }
>
> however I get this error,
> ============================================================================
> ==
> dsn connection fault
> Details :
> date / time : Thu Nov 18 09:51:49 GMT 2004
> ----
> javax.naming.NameNotFoundException: Name neotest 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: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)
> ----
>
> thanks for any help or advice,
>
> jp.
>
