[Eclipse+JBoss+MySQL] Datasource
Hello,
how i can use a datasource in JBoss IDE inside eclipse?
i've understood this 3 steps
1) make mysql-ds.xml
<datasources>
<local-tx-datasource>
<jndi-name>MyDS</jndi-name>
<connection-url>jdbc:mysql://localhost/community</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>admin</user-name>
<password>admin</password>
</local-tx-datasource>
</datasources>
2) insert in web.xml
<resource-ref>
...
<res-auth>Container</res-auth>
...
</resource-ref>
3) in my webapplication, i do
InitialContext cnt=new InitialContext();
datasource ds= (datasource)cnt.lookup("nome jndi");
Connection conn= ds.getConnection();
...
Can you explai me in detail, please?
Regard
Hi
I test this:
1.- CREATE XML FILE DATASOURCE[
create the file mysql-ds-xml
by example:
<datasources>
<local-tx-datasource>
<jndi-name>MySQLJNDI</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/egov</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></password>
<max-pool-size>50</max-pool-size>
<min-pool-size>20</min-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements>true</track-statements>
</local-tx-datasource>
</datasources>
my db is in MySQL
this file copy to
{JBOSS_HOME}\server\default\deploy
2.- COPY DRIVER TO
copy your driver to
{JBOSS_HOME}\server\default\lib
my driver is
mysql-connector-java-3.0.17-ga-bin.jar
3.- CREATE JSP FILE
by example
<%@page contentType="text/html" import="java.net.*,java.util.*,org.jboss.jmx.adaptor.model.*,
java.io.*,java.sql.*,javax.sql.*,javax.naming.*"%>
<html>
<head>
<title>JBoss->MySQL Test </title>
<link rel="stylesheet" href="style_master.css" type="text/css">
<meta http-equiv="cache-control" content="no-cache">
</head>
<body>
<%
InitialContext ctx = new InitialContext();
DatabaseMetaData dm = null;
DataSource ds = (DataSource)
ctx.lookup("java:/MySQLJNDI");
Connection conn = null;
Statement stmt = null;
try {
conn = ds.getConnection();
dm =conn.getMetaData();
out.println("Connected to-> database version "+dm.getDatabaseProductVersion());
}catch (Exception sqlex) {
out.println(sqlex.getMessage());
}finally{
conn.close();
}
%>
</body>
</html>
and copy to:
<%@page contentType="text/html" import="java.net.*,java.util.*,org.jboss.jmx.adaptor.model.*,
java.io.*,java.sql.*,javax.sql.*,javax.naming.*"%>
<html>
<head>
<title>JBoss->MySQL Test </title>
<link rel="stylesheet" href="style_master.css" type="text/css">
<meta http-equiv="cache-control" content="no-cache">
</head>
<body>
<%
InitialContext ctx = new InitialContext();
DatabaseMetaData dm = null;
DataSource ds = (DataSource)
ctx.lookup("java:/MySQLJNDI");
Connection conn = null;
Statement stmt = null;
try {
conn = ds.getConnection();
dm =conn.getMetaData();
out.println("Connected to-> database version "+dm.getDatabaseProductVersion());
}catch (Exception sqlex) {
out.println(sqlex.getMessage());
}finally{
conn.close();
}
%>
</body>
</html>
4.- STARTUP SERVICES
run JBoss
run MySQL
and
type the next URL
http://localhost:8080/jmx-console/test.jsp
OKI DOKY
BYE
