티베로 Tomcat 연동

/tomcat9/lib/ 디렉토리에 tibero6-jdbc-14.jar 파일 업로드
(C:\TmaxData\tibero6\client\lib\jar폴더에 있는 jar파일)

 

1) server.xml 파일 등록
<GlobalNamingResources>
    ...
    <!-- test db -->
    <Resource name="jdbc/sbbmsdb"
              global="jdbc/sbbmsdb"
              auth="Container"
              type="javax.sql.DataSource"
              driverClassName="com.tmax.tibero.jdbc.TbDriver"
              url="jdbc:tibero:thin:@127.0.0.1:10629:test_db"
              username="admin"
              password="admin12345"
              maxActive="20"
              maxIdle="20"
              minIdle="5"
              maxWait="3000"
              validationQuery="SELECT 1 FROM DUAL"
              validationInterval="30000"
              />

 

2) context.xml 

<Context>
   ...
    <ResourceLink name="jdbc/sbbmsdb"
                  global="jdbc/sbbmsdb"
                  auth="Container"
                  type="javax.sql.DataSource" />

</Context>

 

3) 소스 context-datasource.xml 

<beans>
    ...    
   <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
      <property name="jndiName" value="java:/comp/env/jdbc/sbbmsdb" />
   </bean>

</beans>