Hello,

I'm having problem in setting up SQL server data import handler for Jetty 
container.

in data config xml I have set up jndi as below:

<dataConfig>

                <dataSource type="JdbcDataSource" 
jndiName="java:comp/env/jdbc/tssindex" autoCommit="true" />

And I have jetty-env.xml inside WEB-INF as below:

<New id="SQLSERVER" class="org.eclipse.jetty.plus.jndi.Resource">
     <Arg></Arg>
     <Arg>java:comp/env/jdbc/tssindex</Arg>
     <Arg>
        <New class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
           <Set name="User">XXXX</Set>
           <Set name="Password">XXXX</Set>
           <Set name="DatabaseName">XXXX</Set>
           <Set name="ServerName">XXXX</Set>
           <Set name="PortNumber">1433</Set>
        </New>
     </Arg>
    </New>

In Web.xml I have below:

<resource-ref>
     <description>MyDB datasource reference</description>
     <res-ref-name>java:comp/env/jdbc/tssindex</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
</resource-ref>


Once I start importing, I'm getting below exception:

javax.naming.NameNotFoundException; remaining name 'env/jdbc/tssindex'
                at 
org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:540)
                at 
org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:571)


Please guide/correct me the right approach for configuring JNDI for SQL server 
database.


Thanks and Regards,
Srinivas Kashyap

Reply via email to