New Page 1

1. Login to the Application Server Control Console as administrator.

2. In the main page, click the J2EE Applications link.

3. In the J2EE page, click the default link.

4. In the default application page, click General page.

5. First , you should copy Paradox_JDBC30.jar file to $ORACLEAPPSERVER10.1.2/lib directory,

    then, click the Add Anothor Row button, and in the new textbox, input ../../../lib/Paradox_JDBC30.jar,

    then click the Apply button at the bottom of this page.

6. Then click the Data Source link in the default application page

7. The simplest method to create a new data source is select one data source and click Create Like button.

8. In the new data source properties page, input the follow property, then click the Apply button at the bottom of this page, it will restart this application server.

9. After do all, you can create a servlet or jsp to test this data source.
For example,

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import javax.sql.PooledConnection;
import java.sql.Statement;
public class TestServlet extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}

public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>Servlet1</title></head>");
out.println("<body>");
out.println("The servlet has received a POST or GET. This is the reply.");
String jndisrcname = "pgPool";
try {
Context ctx = new InitialContext();
com.hxtt.sql.HxttConnectionPoolDataSource a = (com.hxtt.sql.HxttConnectionPoolDataSource) ctx.lookup(jndisrcname);
PooledConnection aConn = a.getPooledConnection();
Statement aStat = aConn.getConnection().createStatement();
aStat.executeUpdate("create table if not exists XYZ(AINT INT)");
aStat.executeUpdate("insert into XYZ values (1)");
aStat.executeUpdate("insert into XYZ values (2)");
ResultSet rst = aStat.executeQuery("select * from xyz");
while (rst.next()) {
out.println(rst.getString(1)+ " ");
}
aConn.close();
out.println("Get DataSource:" + jndisrcname +" Successfully! ");
}
catch(Exception ee) {
out.println(jndisrcname + " Cannet get!"+ ee.getMessage() + " ");
}
out.println("</body></html>");
out.close();
}
}