<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    honzeland

    記錄點滴。。。

    常用鏈接

    統(tǒng)計

    Famous Websites

    Java

    Linux

    P2P

    最新評論

    How do I use DataSources with Tomcat?

    ZZ from: http://wiki.apache.org/tomcat/UsingDataSources

    When developing J2EE web applications, the task of database connection management can be daunting. Best practice involves using a J2EE DataSource to provide connection pooling, but configuring DataSources in web application servers and connecting your application to them is often a cumbersome process and poorly documented.

    The usual procedure requires the application developer to set up a DataSource in the web application server, specifying the driver class, JDBC URL (connect string), username, password, and various pooling options. Then, the developer must reference the DataSource in his application's web.xml configuration file, and then access it properly in his servlet or JSP. Particularly during development, setting all of this up is tedious and error-prone.

    With Tomcat 5.5, the process is vastly simplified. Tomcat allows you to configure DataSources for your J2EE web application in a context.xml file that is stored in your web application project. You don't have to mess with configuring the DataSource separately in the Tomcat server.xml, or referencing it in your application's web.xml file. Here's how:

    Install the JDBC Driver

    Install the .jar file(s) containing the JDBC driver in Tomcat's common/lib folder. You do not need to put them in your application's WEB-INF/lib folder. When working with J2EE DataSources, the web application server manages connections for your application.

    Create META-INF/context.xml

    In the root of your web app directory structure, create a folder named META-INF (all caps). Inside that folder, create a file named context.xml that contains a Resource like this:

    <?xml version="1.0" encoding="UTF-8"?>

    <Context>

    <Resource name="jdbc/WallyDB" auth="Container"
    type="javax.sql.DataSource" username="wally" password="wally"
    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost;DatabaseName=mytest;SelectMethod=cursor;"
    maxActive="8"
    />

    </Context>

    This example shows how to configure a DataSource for a SQL Server database named mytest located on the development machine. Simply edit the Resource name, driverClassName, username, password, and url to provide values appropriate for your JDBC driver.

    Access the DataSource in Your Application

    From a Servlet

    Here's how you might access the data in a servlet:

      InitialContext ic = new InitialContext();
    DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/WallyDB");
    Connection c = ds.getConnection();
    ...
    c.close();

    Notice that, when doing the DataSource lookup, you must prefix the JNDI name of the resource with java:comp/env/

    Sample Project

    Here's a sample web application project that shows where all the files go. This one shows how to access data from from a JSP page: datasourcedemo.war

    Known-Working examples for other Databases

        <Resource name="jdbc/denali" auth="Container" type="javax.sql.DataSource"
    username="denali" url="jdbc:postgresql://localhost:5432/demo"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory"
    driverClassName="org.postgresql.Driver"
    maxActive="20" maxIdle="10"/>
        <Resource name="jdbc/ccsdatasource" auth="Container" type="javax.sql.DataSource"
    username="ccs" password="secret" url="jdbc:mysql://localhost:3306/ccs"
    driverClassName="com.mysql.jdbc.Driver"
    maxActive="20" maxIdle="10"/>

    Please Note

    This technique is Tomcat-specific. If you deploy your web application to another application server (or even an older version of Tomcat), you will need to configure the database according to your application server's documentation, and reference it in your application's web.xml.



    posted on 2007-07-26 16:22 honzeland 閱讀(627) 評論(1)  編輯  收藏 所屬分類: Tomcat

    評論

    # re: How do I use DataSources with Tomcat? 2007-12-18 14:59 Andreas

    InitialContext ic = new InitialContext(); DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/WallyDB"); Connection c = ds.getConnection();
    ---------------------------------------
    建立了連接以后我想定義一個Struct類型的變量,來與Oracle中的Object來進(jìn)行映射。但是會出現(xiàn)錯誤。
    StructDescriptor st = new StructDescriptor("ObjectNameInOracle",c);
    error marshalling return; nested exception is:
    java.io.NotSerializableException: oracle.jdbc.driver.T4CConnection

    謝謝,Email:dutguoyi@hotmail.com

      回復(fù)  更多評論   


    只有注冊用戶登錄后才能發(fā)表評論。


    網(wǎng)站導(dǎo)航:
     
    主站蜘蛛池模板: 亚洲欧洲无码AV不卡在线| 美女视频黄a视频全免费网站色| 亚洲国产免费综合| 免费人成激情视频| 一级做a爰片性色毛片免费网站 | 蜜桃成人无码区免费视频网站| 亚洲中文字幕无码一久久区| EEUSS影院WWW在线观看免费| 国产亚洲AV手机在线观看| 中国国产高清免费av片| 国产AV无码专区亚洲AV男同| 久久亚洲免费视频| 亚洲国产午夜精品理论片| 免费无码又黄又爽又刺激 | 美美女高清毛片视频黄的一免费 | 国产香蕉九九久久精品免费| 亚洲一区二区三区高清在线观看| 日韩中文字幕免费| 亚洲精品国产精品乱码在线观看| 黄床大片免费30分钟国产精品| 女人18毛片特级一级免费视频 | 好爽又高潮了毛片免费下载| 激情小说亚洲图片| 亚洲精品高清无码视频| 18女人腿打开无遮掩免费| 亚洲色大网站WWW永久网站| 免费人成在线观看视频播放| 国产免费爽爽视频在线观看| 亚洲国产精品无码久久久| 国产免费人成视频在线观看| 亚洲色大成网站www永久| 日韩免费a级毛片无码a∨| 黄色毛片免费网站| 亚洲成av人在线视| 性盈盈影院免费视频观看在线一区| 少妇亚洲免费精品| 亚洲欧洲校园自拍都市| 亚洲国产成人久久综合碰| 十八禁无码免费网站| 亚洲国产成人久久精品软件| 国产成人亚洲综合无码精品|