ubuntu-diver

Connection Pool MySQL

Quelle: http://proxool.sourceforge.net

1) Als Java-Applikation:

ProxoolTest.java:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.logicalcobwebs.proxool.ProxoolException;
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;


public class ProxoolTest {


public void test(){
try {
JAXPConfigurator.configure("src/db.xml", false);
} catch (ProxoolException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
Connection connection = null;
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
try {
connection = DriverManager.getConnection("proxool.xml-test");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

if (connection != null) {
System.out.println("Got connection :)");
} else {
System.out.println("Didn't get connection, which probably means that no Driver accepted the URL");
}

} catch (ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
// Check to see we actually got a connection before we
// attempt to close it.
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}


}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
ProxoolTest ptest = new ProxoolTest();
ptest.test();

}

}

db.xml

xml-test
jdbc:mysql://localhost:3306/test
org.gjt.mm.mysql.Driver




10
select CURRENT_DATE



2.) als Web-Applikation

web.xml

PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"/WEB-INF/dtds/web-app_2_3.dtd">

proxool

Admin
org.logicalcobwebs.proxool.admin.servlet.AdminServlet



Admin
/admin




test.jsp
<%@page import="java.sql.*"%>
<%
Connection connection = null;
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");

connection = DriverManager.getConnection(
"proxool.test:org.gjt.mm.mysql.Driver:jdbc:mysql://localhost:3306/test",
"root",
""
);
} catch (Exception e) {
out.println(e);
}
out.println("OK");
%>