Skip to content

WebService JNDI Setting tomcat

Jump to bottom
neois edited this page Feb 4, 2020 · 2 revisions

  1. Server.xml

    <GlobalNamingResources>
    <Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>
          <Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
                maxActive="20" maxIdle="10" maxWait="-1" name="datasource_name" username="user"  password="pass" type="javax.sql.DataSource"
                url="jdbc:sqlserver://xxxx:portnumber;DatabaseName=dbname" defaultAutoCommit="false"/>
</GlobalNamingResources>

  2. tomcat context.xml copy to resource/META-INT/ and add below <ResourceLink global="datasource_name" name="datasourcename" type="javax.sql.DataSource"/>

  3. sample page Connection conn = null; ResultSet rs = null; PreparedStatement pstmt = null; String str =""; Context ctx = new InitialContext(); Context envCtx = (Context)ctx.lookup("java:comp/env"); DataSource ds = (DataSource)envCtx.lookup("datasource_gms"); conn = ds.getConnection(); pstmt = conn.prepareStatement("select getdate()"); rs = pstmt.executeQuery(); while(rs.next()){ str = rs.getString(1); } System.out.println(str);

 — JEUS 인 경우 web.xml에 아래 추가 <resource-ref> <description>Datasource Contents Server</description> <res-ref-name>JNDI_name</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>

Clone this wiki locally