blob: 660f5d2551225ad3cc8409ee4a75869fd2f1caf6 [file] [log] [blame]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD>
<!-- $PAGETITLE -->
<TITLE>OpenEJB - MySQL</TITLE>
<LINK href="http://incubator.apache.org/openejb/default.css" rel="stylesheet" type="text/css">
<LINK href="http://incubator.apache.org/openejb/style.css" rel="stylesheet" type="text/css">
<LINK rel="SHORTCUT ICON" href="http://incubator.apache.org/openejb/images/favicon.ico">
<SCRIPT language="JavaScript" src="http://cwiki.apache.org/confluence/pages/viewpage.action?spaceKey=OPENEJB&title=functions.js" type="text/javascript"></SCRIPT>
<META http-equiv="Content-Type" content="text/html;charset=UTF-8"></HEAD>
<BODY bgcolor="#ffffff" link="#6763a9" vlink="#6763a9" topmargin="0" bottommargin="0" leftmargin="0" marginheight="0" marginwidth="0">
<A name="top"></A>
<TABLE border="0" cellpadding="0" cellspacing="0" width="100%" height="400">
<TR>
<TD width="20" valign="top" align="left" bgcolor="#7270c2"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="1" border="0"></TD>
<TD width="95" valign="top" align="left" bgcolor="#7270c2"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="1" border="0"></TD>
<TD width="7" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" border="0" width="1" height="1"></TD>
<TD width="40" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="40" height="6" border="0"></TD>
<TD width="100%" valign="top" align="left" bgcolor="#5A5CB8"><IMG src="http://incubator.apache.org/openejb/images/top_2.gif" width="430" height="6" border="0"></TD>
<TD width="120" valign="top" align="left" bgcolor="#E24717"><IMG src="http://incubator.apache.org/openejb/images/top_3.gif" width="120" height="6" border="0"></TD>
</TR>
<TR>
<TD width="20" bgcolor="#7270c2" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" border="0" width="1" height="1"></TD>
<TD width="95" bgcolor="#7270c2" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" border="0" width="1" height="1"></TD>
<TD width="7" bgcolor="#ffffff" valign="top" align="left"></TD>
<TD width="40" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="1" border="0"></TD>
<TD id="breadcrumbs" width="100%" valign="middle" align="left">
<!-- $TOP_NAV_BAR -->
<SPAN id="Content">
<A href="index.html" title="Index">Index</A> | <A href="news.html" title="News">News</A> | <A href="faq.html" title="FAQ">FAQ</A> | <A href="download.html" title="Download">Download</A> | <A href="mailing-lists.html" title="Mailing Lists">Lists</A> | <SPAN class="nobr"><A href="http://issues.apache.org/jira/browse/OPENEJB" title="Visit page outside Confluence" rel="nofollow">Issues<SUP><IMG class="rendericon" src="http://cwiki.apache.org/confluence/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"></SUP></A></SPAN>
</SPAN>
<IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="2" border="0"></TD>
<TD width="120" height="20" valign="top" align="left">&nbsp;</TD>
</TR>
<TR>
<TD width="20" bgcolor="#7270c2" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="20" height="3" border="0"></TD>
<TD width="95" bgcolor="#7270c2" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/line_sm.gif" width="105" height="3" border="0"></TD>
<TD width="7" bgcolor="#a9a5de" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/line_sm.gif" width="7" height="3" border="0"></TD>
<TD width="40" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/line_light.gif" width="40" height="3" border="0"></TD>
<TD width="100%" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/line_light.gif" width="430" height="3" border="0"></TD>
<TD width="120" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" border="0" width="1" height="1"></TD>
</TR>
<TR>
<TD bgcolor="#7270c2" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="20" height="10" border="0"></TD>
<TD id="leftColumn" valign="top" style="padding-top: 0px;">
<SPAN id="Content">
<H3><A name="Navigation-Overview"></A>Overview</H3>
<UL class="alternate" type="square">
<LI><A href="index.html" title="Index">Home</A></LI>
<LI><A href="news.html" title="News">News</A></LI>
<LI><A href="faq.html" title="FAQ">FAQ</A></LI>
<LI><A href="download.html" title="Download">Download</A></LI>
<LI><A href="examples.html" title="Examples">Examples</A></LI>
<LI><A href="mailing-lists.html" title="Mailing Lists">Mailing Lists</A></LI>
<LI><A href="source-code.html" title="Source Code">Source Code</A></LI>
</UL>
<H3><A name="Navigation-General"></A>General</H3>
<UL class="alternate" type="square">
<LI><A href="deploy-tool.html" title="Deploy Tool">Deployment</A></LI>
<LI><A href="startup.html" title="Startup">Startup</A></LI>
<LI><A href="validation-tool.html" title="Validation Tool">Validation</A></LI>
<LI><A href="webadmin.html" title="Webadmin">Webadmin</A></LI>
</UL>
<H3><A name="Navigation-Configuration"></A>Configuration</H3>
<UL class="alternate" type="square">
<LI><A href="configuration.html" title="Configuration">General</A></LI>
<LI><A href="deployments.html" title="Deployments">Deployments</A></LI>
<LI><A href="containers.html" title="Containers">Containers</A></LI>
<LI><A href="castor-cmp.html" title="Castor CMP">Castor CMP</A></LI>
</UL>
<H3><A name="Navigation-Servers"></A>Servers</H3>
<UL class="alternate" type="square">
<LI><A href="local-server.html" title="Local Server">Local</A></LI>
<LI><A href="remote-server.html" title="Remote Server">Remote</A></LI>
</UL>
<H3><A name="Navigation-Integrations"></A>Integrations</H3>
<UL class="alternate" type="square">
<LI><A href="tomcat.html" title="Tomcat">Tomcat</A></LI>
<LI><A href="geronimo.html" title="Geronimo">Geronimo</A></LI>
<LI><A href="webobjects.html" title="WebObjects">WebObjects</A></LI>
</UL>
<H3><A name="Navigation-Community"></A>Community</H3>
<UL class="alternate" type="square">
<LI><A href="team.html" title="Team">Team</A></LI>
<LI><A href="help.html" title="Help">Help</A></LI>
<LI><A href="articles.html" title="Articles">Articles</A></LI>
<LI><A href="annoyances.html" title="Annoyances">Annoyances</A></LI>
<LI><SPAN class="nobr"><A href="index.html" title="Visit page outside Confluence" rel="nofollow">Wiki<SUP><IMG class="rendericon" src="http://cwiki.apache.org/confluence/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"></SUP></A></SPAN></LI>
<LI><SPAN class="nobr"><A href="irc://irc.freenode.net/#openejb" title="Visit page outside Confluence" rel="nofollow">IRC<SUP><IMG class="rendericon" src="http://cwiki.apache.org/confluence/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"></SUP></A></SPAN></LI>
</UL>
</SPAN>
<H3 class="heading3">Feeds</H3>
<TABLE border="0" cellspacing="4px">
<TR>
<TD align="right">
<A href="http://cwiki.apache.org/confluence/spaces/rss.action?key=OPENEJB&newPages=false"><IMG src="http://incubator.apache.org/openejb/images/rss.gif" border="0"></A><BR>
</TD>
<TD align="left">
<A href="http://cwiki.apache.org/confluence/spaces/rss.action?key=OPENEJB&newPages=false">Site</A>
</TD>
</TR>
<TR>
<TD align="right">
<A href="http://cwiki.apache.org/confluence/spaces/blogrss.action?key=OPENEJB"><IMG src="http://incubator.apache.org/openejb/images/rss.gif" border="0"></A>
</TD>
<TD align="left">
<A href="http://cwiki.apache.org/confluence/spaces/blogrss.action?key=OPENEJB">News</A>
</TD>
</TR>
</TABLE>
</TD>
<TD width="7" bgcolor="#a9a5de" valign="top" align="left">&nbsp;</TD>
<TD width="40" valign="top" align="left">&nbsp;</TD>
<TD rowspan="4" width="100%" valign="top">
<TABLE cols="1" rows="2" border="0" cellpadding="0" cellspacing="0" width="100%">
<TR>
<TD valign="top" align="left"><BR>
<TABLE cols="3" rows="1" border="0" cellpadding="0" cellspacing="0" width="100%">
<TR>
<TD valign="top" width="200" align="left">
<A href="http://openejb.org/">
<IMG border="0" hspace="0" src="http://incubator.apache.org/openejb/images/logo_openejb.gif" vspace="0">
</A>
</TD>
<TD align="right" valign="middle" style="padding:0px;margin:0px;">
<TABLE style="padding:0px;margin:0px;">
<TR>
<TD>
<A href="http://www.apache.org/">
<IMG src="http://www.apache.org/images/asf-logo.gif" border="0">
</A>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR>
</TD>
</TR>
<TR>
<TD valign="top" align="left">
<IMG border="0" height="7" hspace="0" src="http://incubator.apache.org/openejb/images/dotTrans.gif"><BR>
<DIV id="page_title">
<TABLE width="100%">
<TR>
<TD>
<!-- $TITLE -->
MySQL
</TD>
<TD align="right" style="padding-left:0px;"><A style="color:#999;font-size:small;font-weight:normal;" href="http://cwiki.apache.org/confluence/pages/editpage.action?spaceKey=OPENEJB&title=MySQL">[ edit ]</A></TD>
<TD align="right" width="25">
<SCRIPT type="text/javascript" language="javascript">
document.write('<a href="http://cwiki.apache.org/confluence/pages/viewpage');
document.write('.action?pageId=26507&decorator=printable">');
</SCRIPT>
<IMG src="http://cwiki.apache.org/confluence/images/icons/print_16.gif" height="16" width="16" border="0" align="absmiddle" title="Print"></A>
</TD>
</TR>
</TABLE>
</DIV>
<IMG border="0" height="1" hspace="0" src="http://incubator.apache.org/openejb/images/dotTrans.gif"></TD>
</TR>
</TABLE>
<P>
<!-- $BODY -->
<DIV id="PageContent">
<DIV class="pagecontent">
<DIV class="wiki-content">
<H1><A name="MySQL-HowdoIsetupOpenEJBtouseMySQL%3F"></A>How do I setup OpenEJB to use MySQL?</H1>
<P>Here are my config files for getting the CMP entity example to work. Note that the mm driver is no longer available from sourceforge and must now be directly downloaded from www.mysql.com and that the driver name has changed. The config files below use the new driver package/name and work with MySQL 4.0.3 beta on Windows2000.</P>
<P>The SQL statement used to create the employee table was:</P>
<DIV class="code"><DIV class="codeContent">
<PRE class="code-java">create table employee (
id integer primary key auto_increment,
first_name varchar(15),
last_name varchar(15),
email varchar(30)
);</PRE>
</DIV></DIV>
<DIV class="code"><DIV class="codeHeader"><B>openejb.conf</B></DIV><DIV class="codeContent">
<PRE class="code-xml"><SPAN class="code-tag">&lt;?xml version=<SPAN class="code-quote">&quot;1.0&quot;</SPAN>?&gt;</SPAN>
<SPAN class="code-tag">&lt;openejb&gt;</SPAN>
<SPAN class="code-tag">&lt;Container id=<SPAN class="code-quote">&quot;Default CMP Container&quot;</SPAN> ctype=<SPAN class="code-quote">&quot;CMP_ENTITY&quot;</SPAN>&gt;</SPAN>
Global_TX_Database c:/java/j2ee/openejb/hello_world_cmp/conf/hello.cmp_global_database.xml
Local_TX_Database c:/java/j2ee/openejb/hello_world_cmp/conf/hello.cmp_local_database.xml
<SPAN class="code-tag">&lt;/Container&gt;</SPAN>
<SPAN class="code-tag">&lt;Deployments jar=<SPAN class="code-quote">&quot;c:/java/j2ee/openejb/hello_world_cmp/employee.jar&quot;</SPAN>/&gt;</SPAN>
<SPAN class="code-tag">&lt;Connector id=<SPAN class="code-quote">&quot;Default JDBC Database&quot;</SPAN>&gt;</SPAN>
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://localhost/openejb_cmp_example
UserName cso4309
Password
<SPAN class="code-tag">&lt;/Connector&gt;</SPAN>
<SPAN class="code-tag">&lt;SecurityService id=<SPAN class="code-quote">&quot;Default Security Service&quot;</SPAN>/&gt;</SPAN>
<SPAN class="code-tag">&lt;TransactionService id=<SPAN class="code-quote">&quot;Default Transaction Manager&quot;</SPAN>/&gt;</SPAN> <SPAN class="code-tag">&lt;/openejb&gt;</SPAN></PRE>
</DIV></DIV>
<DIV class="code"><DIV class="codeHeader"><B>hello.cmp_global_database.xml</B></DIV><DIV class="codeContent">
<PRE class="code-xml"><SPAN class="code-tag">&lt;?xml version=<SPAN class="code-quote">&quot;1.0&quot;</SPAN>?&gt;</SPAN>
<SPAN class="code-tag">&lt;database name=<SPAN class="code-quote">&quot;Global_TX_Database&quot;</SPAN> engine=<SPAN class="code-quote">&quot;mysql&quot;</SPAN>&gt;</SPAN>
<SPAN class="code-tag">&lt;jndi name=<SPAN class="code-quote">&quot;java:comp/env/jdbc/openejb_cmp_example&quot;</SPAN> /&gt;</SPAN>
<SPAN class="code-tag">&lt;mapping href=<SPAN class="code-quote">&quot;c:/java/j2ee/openejb/hello_world_cmp/conf/hello.cmp_or_mapping.xml&quot;</SPAN> /&gt;</SPAN>
<SPAN class="code-tag">&lt;/database&gt;</SPAN></PRE>
</DIV></DIV>
<DIV class="code"><DIV class="codeHeader"><B>hello.cmp_local_database.xml</B></DIV><DIV class="codeContent">
<PRE class="code-xml"><SPAN class="code-tag">&lt;?xml version=<SPAN class="code-quote">&quot;1.0&quot;</SPAN>?&gt;</SPAN>
<SPAN class="code-tag">&lt;database name=<SPAN class="code-quote">&quot;Local_TX_Database&quot;</SPAN> engine=<SPAN class="code-quote">&quot;mysql&quot;</SPAN> &gt;</SPAN>
&lt;driver class-name=<SPAN class="code-quote">&quot;com.mysql.jdbc.Driver&quot;</SPAN>
url=<SPAN class="code-quote">&quot;jdbc:mysql://localhost/openejb_cmp_example&quot;</SPAN>&gt;
<SPAN class="code-tag">&lt;param name=<SPAN class="code-quote">&quot;user&quot;</SPAN> value=<SPAN class="code-quote">&quot;cso4309&quot;</SPAN> /&gt;</SPAN>
<SPAN class="code-tag">&lt;param name=<SPAN class="code-quote">&quot;password&quot;</SPAN> value=&quot;&quot; /&gt;</SPAN>
<SPAN class="code-tag">&lt;/driver&gt;</SPAN>
<SPAN class="code-tag">&lt;mapping href=<SPAN class="code-quote">&quot;c:/java/j2ee/openejb/hello_world_cmp/conf/hello.cmp_or_mapping.xml&quot;</SPAN> /&gt;</SPAN>
<SPAN class="code-tag">&lt;/database&gt;</SPAN></PRE>
</DIV></DIV>
<DIV class="code"><DIV class="codeHeader"><B>hello.cmp_or_mapping.xml</B></DIV><DIV class="codeContent">
<PRE class="code-xml"><SPAN class="code-tag">&lt;?xml version=<SPAN class="code-quote">&quot;1.0&quot;</SPAN>?&gt;</SPAN>
<SPAN class="code-tag">&lt;mapping&gt;</SPAN>
<SPAN class="code-tag">&lt;class name=<SPAN class="code-quote">&quot;org.acme.employee.EmployeeBean&quot;</SPAN> identity=<SPAN class="code-quote">&quot;id&quot;</SPAN> key-generator=<SPAN class="code-quote">&quot;IDENTITY&quot;</SPAN>&gt;</SPAN>
<SPAN class="code-tag">&lt;map-to table=<SPAN class="code-quote">&quot;employee&quot;</SPAN>/&gt;</SPAN>
<SPAN class="code-tag">&lt;field name=<SPAN class="code-quote">&quot;id&quot;</SPAN> type=<SPAN class="code-quote">&quot;integer&quot;</SPAN> direct=<SPAN class="code-quote">&quot;true&quot;</SPAN>&gt;</SPAN>
<SPAN class="code-tag">&lt;sql name=<SPAN class="code-quote">&quot;id&quot;</SPAN> type=<SPAN class="code-quote">&quot;integer&quot;</SPAN>/&gt;</SPAN>
<SPAN class="code-tag">&lt;/field&gt;</SPAN>
<SPAN class="code-tag">&lt;field name=<SPAN class="code-quote">&quot;firstname&quot;</SPAN> type=<SPAN class="code-quote">&quot;string&quot;</SPAN> direct=<SPAN class="code-quote">&quot;true&quot;</SPAN>&gt;</SPAN>
<SPAN class="code-tag">&lt;sql name=<SPAN class="code-quote">&quot;first_name&quot;</SPAN> type=<SPAN class="code-quote">&quot;varchar&quot;</SPAN> dirty=<SPAN class="code-quote">&quot;check&quot;</SPAN>/&gt;</SPAN>
<SPAN class="code-tag">&lt;/field&gt;</SPAN>
<SPAN class="code-tag">&lt;field name=<SPAN class="code-quote">&quot;lastname&quot;</SPAN> type=<SPAN class="code-quote">&quot;string&quot;</SPAN> direct=<SPAN class="code-quote">&quot;true&quot;</SPAN>&gt;</SPAN>
<SPAN class="code-tag">&lt;sql name=<SPAN class="code-quote">&quot;last_name&quot;</SPAN> type=<SPAN class="code-quote">&quot;varchar&quot;</SPAN> dirty=<SPAN class="code-quote">&quot;check&quot;</SPAN>/&gt;</SPAN>
<SPAN class="code-tag">&lt;/field&gt;</SPAN>
<SPAN class="code-tag">&lt;field name=<SPAN class="code-quote">&quot;email&quot;</SPAN> type=<SPAN class="code-quote">&quot;string&quot;</SPAN> direct=<SPAN class="code-quote">&quot;true&quot;</SPAN>&gt;</SPAN>
<SPAN class="code-tag">&lt;sql name=<SPAN class="code-quote">&quot;email&quot;</SPAN> type=<SPAN class="code-quote">&quot;varchar&quot;</SPAN> dirty=<SPAN class="code-quote">&quot;check&quot;</SPAN>/&gt;</SPAN>
<SPAN class="code-tag">&lt;/field&gt;</SPAN>
<SPAN class="code-tag">&lt;/class&gt;</SPAN>
<SPAN class="code-tag">&lt;/mapping&gt;</SPAN></PRE>
</DIV></DIV>
<H1><A name="MySQL-WherecanigettheMySQLJDBCdriver%3F"></A>Where can i get the MySQL JDBC driver?</H1>
<P>The mm driver is no longer available from sourceforge, the new driver is called Connector/J and must now be directly downloaded from www.mysql.com at <SPAN class="nobr"><A href="http://www.mysql.com/downloads/api-jdbc-stable.html" title="Visit page outside Confluence" rel="nofollow">http://www.mysql.com/downloads/api-jdbc-stable.html<SUP><IMG class="rendericon" src="http://cwiki.apache.org/confluence/images/icons/linkext7.gif" height="7" width="7" align="absmiddle" alt="" border="0"></SUP></A></SPAN> </P>
</DIV>
</DIV>
</DIV>
</P>
</TD>
</TR>
<TR height="5">
<TD width="20" height="5" bgcolor="#7270c2" valign="top" align="left">&nbsp;</TD>
<TD width="95" height="5" bgcolor="#7270c2" valign="top">&nbsp;</TD>
<TD width="7" height="5" bgcolor="#a9a5de" valign="top" align="left">&nbsp;</TD>
<TD width="40" height="5" valign="top" align="left">&nbsp;</TD>
<TD width="120" height="5" valign="top" align="left">&nbsp;</TD>
</TR>
<TR>
<TD width="20" height="5" bgcolor="#7270c2" valign="top" align="left">&nbsp;</TD>
<TD width="95" bgcolor="#7270c2" valign="BOTTOM" align="left">&nbsp;</TD>
<TD width="7" bgcolor="#a9a5de" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="25" border="0"></TD>
<TD width="40" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="25" border="0"></TD>
<TD width="120" valign="top" align="left">&nbsp;</TD>
</TR>
<TR>
<TD width="20" height="5" bgcolor="#7270c2" valign="top" align="left">&nbsp;</TD>
<TD width="95" bgcolor="#7270c2" valign="BOTTOM" align="left">&nbsp;</TD>
<TD width="7" bgcolor="#a9a5de" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="25" border="0"></TD>
<TD width="40" valign="top" align="left"><IMG src="http://incubator.apache.org/openejb/images/dotTrans.gif" width="1" height="25" border="0"></TD>
<TD width="120" valign="top" align="left">&nbsp;</TD>
</TR>
<TR height="5">
<TD width="20" rowspan="2" height="100%" bgcolor="#7270c2" valign="bottom" align="left"><IMG src="http://incubator.apache.org/openejb/images/stripes1.gif" width="20" height="125" border="0"></TD>
<TD width="95" rowspan="2" height="100%" bgcolor="#7270c2" valign="bottom" align="left"><IMG src="http://incubator.apache.org/openejb/images/stripe105.gif" width="105" height="125" border="0"></TD>
<TD width="7" rowspan="2" height="100%" bgcolor="#a9a5de" valign="top" align="left">&nbsp;</TD>
<TD width="40" height="100%" valign="top" align="left">&nbsp;</TD>
<TD width="120" height="100%" valign="top" align="left">&nbsp;</TD>
</TR>
<TR height="5">
<TD width="40" height="25" valign="top" align="left">&nbsp;</TD>
<TD width="100%" height="25" valign="bottom" align="left"><BR>
<BR>
<IMG src="http://incubator.apache.org/openejb/images/line_light.gif" border="0" width="430" height="3"><BR>
<P>
</P>
<SPAN class="bodyGrey">
<SMALL><NOTICE><!-- $FOOTER -->
Apache OpenEJB is an project of The Apache Software Foundation (ASF)
</NOTICE> <BR>
&nbsp;<BR>
Powered by <A href="http://atlassian.com/">Atlassian</A> <A href="http://atlassian.com/confluence/">Confluence</A>.
</SMALL>
</SPAN>
<P>
</P>
</TD>
<TD width="120" height="25" valign="top" align="left">&nbsp;</TD>
</TR>
</TABLE>
</BODY>
</HTML>