From pgaltieri at gmail.com Fri Jun 5 20:09:59 2015 Content-Type: multipart/mixed; boundary="===============7936742811048821776==" MIME-Version: 1.0 From: Paolo Galtieri To: users at lists.fedoraproject.org Subject: Problems with tomcat on F12 Date: Tue, 08 Dec 2009 18:00:56 -0700 Message-ID: <785883560912081700i2a8a8981s6b32d7abecfbdd7@mail.gmail.com> --===============7936742811048821776== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable I'm having problems with tomcat connecting to a mysql database The following file works when placed in directory tests under tomcat's /usr/share/tomcat6/webapps/ROOT/tests directory <%@page language=3D"java" contentType=3D"text/html"%> <%@page import=3D"java.sql.*"%> JDBC test <% Class.forName("com.mysql.jdbc.Driver"); Connection conn =3D DriverManager.getConnection( "jdbc:mysql://localhost:3306/shop", "root", "password"); Statement stmt =3D conn.createStatement(); ResultSet rs =3D stmt.executeQuery("select * from books"); %><% ResultSetMetaData resMetaData =3D rs.getMetaData(); int nCols =3D resMetaData.getColumnCount(); %><% for (int kCol =3D 1; kCol <=3D nCols; kCol++) { out.print(""); } %><% while (rs.next()) { %><% for (int kCol =3D 1; kCol <=3D nCols; kCol++) { out.print(""); } %><% } %>
" + resMetaData.getColumnName(kCol) + "
" + rs.getString(kCol) + "
<% conn.close(); %> and accessed as http://localhost:8080/tests/jdbc.jsp However, if I deploy a war file with the following web.xml file eshop ShopServlet ShopServlet eshop.ShopServlet base /eshop/shop imageURL /eshop/images/ jdbcDriver com.mysql.jdbc.Driver dbURL jdbc:mysql://localhost:3306/shop dbUserName root dbPassword password ShopServlet /shop/* I get the following error: Could not connect to DB: No suitable driver found for I've searched the various forums on mysql and I see this problem reported many times before, but was never able to find and answer. Does anybody know what I'm doing wrong? Thanks, Paolo --===============7936742811048821776== Content-Type: text/html MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" SSYjMzk7bSBoYXZpbmcgcHJvYmxlbXMgd2l0aCB0b21jYXQgY29ubmVjdGluZyB0byBhIG15c3Fs IGRhdGFiYXNlPGJyPjxicj5UaGUgZm9sbG93aW5nIGZpbGUgd29ya3Mgd2hlbiBwbGFjZWQgaW4g ZGlyZWN0b3J5IHRlc3RzIHVuZGVyIHRvbWNhdCYjMzk7cyAvdXNyL3NoYXJlL3RvbWNhdDYvd2Vi YXBwcy9ST09UL3Rlc3RzIGRpcmVjdG9yeTxicj48YnI+Jmx0OyVAcGFnZSBsYW5ndWFnZT0mcXVv dDtqYXZhJnF1b3Q7IGNvbnRlbnRUeXBlPSZxdW90O3RleHQvaHRtbCZxdW90OyUmZ3Q7PGJyPgom bHQ7JUBwYWdlIGltcG9ydD0mcXVvdDtqYXZhLnNxbC4qJnF1b3Q7JSZndDs8YnI+Jmx0O2h0bWwm Z3Q7Jmx0O2hlYWQmZ3Q7Jmx0O3RpdGxlJmd0O0pEQkMgdGVzdCZsdDsvdGl0bGUmZ3Q7Jmx0Oy9o ZWFkJmd0OyZsdDtib2R5Jmd0Ozxicj4mbHQ7JTxicj7CoCBDbGFzcy5mb3JOYW1lKCZxdW90O2Nv bS5teXNxbC5qZGJjLkRyaXZlciZxdW90Oyk7PGJyPsKgIENvbm5lY3Rpb24gY29ubiA9IERyaXZl ck1hbmFnZXIuZ2V0Q29ubmVjdGlvbig8YnI+CsKgwqDCoMKgwqAgJnF1b3Q7amRiYzpteXNxbDov L2xvY2FsaG9zdDozMzA2L3Nob3AmcXVvdDssICZxdW90O3Jvb3QmcXVvdDssICZxdW90O3Bhc3N3 b3JkJnF1b3Q7KTs8YnI+wqAgU3RhdGVtZW50IHN0bXQgPSBjb25uLmNyZWF0ZVN0YXRlbWVudCgp Ozxicj7CoCBSZXN1bHRTZXQgcnMgPSBzdG10LmV4ZWN1dGVRdWVyeSgmcXVvdDtzZWxlY3QgKiBm cm9tIGJvb2tzJnF1b3Q7KTs8YnI+wqAgJSZndDsmbHQ7dGFibGUgYm9yZGVyPSAmcXVvdDsxJnF1 b3Q7Jmd0OyZsdDslPGJyPgrCoCBSZXN1bHRTZXRNZXRhRGF0YSByZXNNZXRhRGF0YSA9IHJzLmdl dE1ldGFEYXRhKCk7PGJyPsKgIGludCBuQ29scyA9IHJlc01ldGFEYXRhLmdldENvbHVtbkNvdW50 KCk7PGJyPsKgICUmZ3Q7Jmx0O3RyJmd0OyZsdDslPGJyPsKgIGZvciAoaW50IGtDb2wgPSAxOyBr Q29sICZsdDs9IG5Db2xzOyBrQ29sKyspIHs8YnI+wqDCoMKgIG91dC5wcmludCgmcXVvdDsmbHQ7 dGQmZ3Q7Jmx0O2ImZ3Q7JnF1b3Q7ICsgcmVzTWV0YURhdGEuZ2V0Q29sdW1uTmFtZShrQ29sKSAr ICZxdW90OyZsdDsvYiZndDsmbHQ7L3RkJmd0OyZxdW90Oyk7PGJyPgrCoMKgwqAgfTxicj7CoCAl Jmd0OyZsdDsvdHImZ3Q7Jmx0OyU8YnI+wqAgd2hpbGUgKHJzLm5leHQoKSkgezxicj7CoMKgwqAg JSZndDsmbHQ7dHImZ3Q7Jmx0OyU8YnI+wqDCoMKgIGZvciAoaW50IGtDb2wgPSAxOyBrQ29sICZs dDs9IG5Db2xzOyBrQ29sKyspIHs8YnI+wqDCoMKgwqDCoCBvdXQucHJpbnQoJnF1b3Q7Jmx0O3Rk Jmd0OyZxdW90OyArIHJzLmdldFN0cmluZyhrQ29sKSArICZxdW90OyZsdDsvdGQmZ3Q7JnF1b3Q7 KTs8YnI+CsKgwqDCoMKgwqAgfTxicj7CoMKgwqAgJSZndDsmbHQ7L3RyJmd0OyZsdDslPGJyPsKg wqDCoCB9PGJyPsKgICUmZ3Q7Jmx0Oy90YWJsZSZndDsmbHQ7JTxicj7CoCBjb25uLmNsb3NlKCk7 PGJyPsKgICUmZ3Q7PGJyPiZsdDsvYm9keSZndDsmbHQ7L2h0bWwmZ3Q7PGJyPjxicj5hbmQgYWNj ZXNzZWQgYXMgPGJyPjxicj48YSBocmVmPSJodHRwOi8vbG9jYWxob3N0OjgwODAvdGVzdHMvamRi Yy5qc3AiPmh0dHA6Ly9sb2NhbGhvc3Q6ODA4MC90ZXN0cy9qZGJjLmpzcDwvYT48YnI+Cjxicj5I b3dldmVyLCBpZiBJIGRlcGxveSBhIHdhciBmaWxlIHdpdGggdGhlIGZvbGxvd2luZyB3ZWIueG1s IGZpbGU8YnI+PGJyPiZsdDs/eG1sIHZlcnNpb249JnF1b3Q7MS4wJnF1b3Q7IGVuY29kaW5nPSZx dW90O0lTTy04ODU5LTEmcXVvdDs/Jmd0Ozxicj4mbHQ7d2ViLWFwcCBpZD0mcXVvdDtXZWJBcHBf SUQmcXVvdDsgdmVyc2lvbj0mcXVvdDsyLjUmcXVvdDs8YnI+wqAgeG1sbnM9JnF1b3Q7PGEgaHJl Zj0iaHR0cDovL2phdmEuc3VuLmNvbS94bWwvbnMvajJlZSI+aHR0cDovL2phdmEuc3VuLmNvbS94 bWwvbnMvajJlZTwvYT4mcXVvdDs8YnI+CsKgIHhtbG5zOnhzaT0mcXVvdDs8YSBocmVmPSJodHRw Oi8vd3d3LnczLm9yZy8yMDAxL1hNTFNjaGVtYS1pbnN0YW5jZSI+aHR0cDovL3d3dy53My5vcmcv MjAwMS9YTUxTY2hlbWEtaW5zdGFuY2U8L2E+JnF1b3Q7PGJyPsKgIHhzaTpzY2hlbWFMb2NhdGlv bj0mcXVvdDs8YSBocmVmPSJodHRwOi8vamF2YS5zdW4uY29tL3htbC9ucy9qMmVlIj5odHRwOi8v amF2YS5zdW4uY29tL3htbC9ucy9qMmVlPC9hPiA8YSBocmVmPSJodHRwOi8vamF2YS5zdW4uY29t L3htbC9ucy9qMmVlL3dlYi1hcHBfMl81LnhzZCI+aHR0cDovL2phdmEuc3VuLmNvbS94bWwvbnMv ajJlZS93ZWItYXBwXzJfNS54c2Q8L2E+JnF1b3Q7Jmd0Ozxicj4KwqDCoMKgICZsdDtkaXNwbGF5 LW5hbWUmZ3Q7ZXNob3AmbHQ7L2Rpc3BsYXktbmFtZSZndDs8YnI+wqDCoMKgICZsdDtzZXJ2bGV0 Jmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDtkZXNjcmlwdGlvbiZndDs8YnI+wqDCoMKgIMKgwqDC oCAmbHQ7L2Rlc2NyaXB0aW9uJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDtkaXNwbGF5LW5hbWUm Z3Q7U2hvcFNlcnZsZXQmbHQ7L2Rpc3BsYXktbmFtZSZndDs8YnI+wqDCoMKgIMKgwqDCoCAmbHQ7 c2VydmxldC1uYW1lJmd0O1Nob3BTZXJ2bGV0Jmx0Oy9zZXJ2bGV0LW5hbWUmZ3Q7PGJyPgrCoMKg wqAgwqDCoMKgICZsdDtzZXJ2bGV0LWNsYXNzJmd0O2VzaG9wLlNob3BTZXJ2bGV0Jmx0Oy9zZXJ2 bGV0LWNsYXNzJmd0Ozxicj7CoMKgwqAgwqAgJmx0O2luaXQtcGFyYW0mZ3Q7PGJyPsKgwqDCoCDC oMKgwqAgJmx0O3BhcmFtLW5hbWUmZ3Q7YmFzZSZsdDsvcGFyYW0tbmFtZSZndDs8YnI+wqDCoMKg IMKgwqDCoCAmbHQ7cGFyYW0tdmFsdWUmZ3Q7L2VzaG9wL3Nob3AmbHQ7L3BhcmFtLXZhbHVlJmd0 Ozxicj7CoMKgwqAgwqDCoMKgICZsdDsvaW5pdC1wYXJhbSZndDs8YnI+CsKgwqDCoCDCoCAmbHQ7 aW5pdC1wYXJhbSZndDs8YnI+wqDCoMKgIMKgwqDCoCAmbHQ7cGFyYW0tbmFtZSZndDtpbWFnZVVS TCZsdDsvcGFyYW0tbmFtZSZndDs8YnI+wqDCoMKgIMKgwqDCoCAmbHQ7cGFyYW0tdmFsdWUmZ3Q7 L2VzaG9wL2ltYWdlcy8mbHQ7L3BhcmFtLXZhbHVlJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDsv aW5pdC1wYXJhbSZndDs8YnI+wqDCoMKgIMKgICZsdDtpbml0LXBhcmFtJmd0Ozxicj7CoMKgwqAg wqDCoMKgICZsdDtwYXJhbS1uYW1lJmd0O2pkYmNEcml2ZXImbHQ7L3BhcmFtLW5hbWUmZ3Q7PGJy PgrCoMKgwqAgwqDCoMKgICZsdDtwYXJhbS12YWx1ZSZndDtjb20ubXlzcWwuamRiYy5Ecml2ZXIm bHQ7L3BhcmFtLXZhbHVlJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDsvaW5pdC1wYXJhbSZndDs8 YnI+wqDCoMKgIMKgICZsdDtpbml0LXBhcmFtJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDtwYXJh bS1uYW1lJmd0O2RiVVJMJmx0Oy9wYXJhbS1uYW1lJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDtw YXJhbS12YWx1ZSZndDtqZGJjOm15c3FsOi8vbG9jYWxob3N0OjMzMDYvc2hvcCZsdDsvcGFyYW0t dmFsdWUmZ3Q7PGJyPgrCoMKgwqAgwqDCoMKgICZsdDsvaW5pdC1wYXJhbSZndDs8YnI+wqDCoMKg IMKgICZsdDtpbml0LXBhcmFtJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDtwYXJhbS1uYW1lJmd0 O2RiVXNlck5hbWUmbHQ7L3BhcmFtLW5hbWUmZ3Q7PGJyPsKgwqDCoCDCoMKgwqAgJmx0O3BhcmFt LXZhbHVlJmd0O3Jvb3QmbHQ7L3BhcmFtLXZhbHVlJmd0Ozxicj7CoMKgwqAgwqDCoMKgICZsdDsv aW5pdC1wYXJhbSZndDs8YnI+wqDCoMKgIMKgICZsdDtpbml0LXBhcmFtJmd0Ozxicj4KwqDCoMKg IMKgwqDCoCAmbHQ7cGFyYW0tbmFtZSZndDtkYlBhc3N3b3JkJmx0Oy9wYXJhbS1uYW1lJmd0Ozxi cj7CoMKgwqAgwqDCoMKgICZsdDtwYXJhbS12YWx1ZSZndDtwYXNzd29yZCZsdDsvcGFyYW0tdmFs dWUmZ3Q7PGJyPsKgwqDCoCDCoMKgwqAgJmx0Oy9pbml0LXBhcmFtJmd0Ozxicj7CoMKgwqAgwqAg Jmx0Oy9zZXJ2bGV0Jmd0Ozxicj7CoMKgwqAgJmx0O3NlcnZsZXQtbWFwcGluZyZndDs8YnI+wqDC oMKgIMKgwqDCoCAmbHQ7c2VydmxldC1uYW1lJmd0O1Nob3BTZXJ2bGV0Jmx0Oy9zZXJ2bGV0LW5h bWUmZ3Q7PGJyPgrCoMKgwqAgwqDCoMKgICZsdDt1cmwtcGF0dGVybiZndDsvc2hvcC8qJmx0Oy91 cmwtcGF0dGVybiZndDs8YnI+wqDCoMKgIMKgICZsdDsvc2VydmxldC1tYXBwaW5nJmd0Ozxicj7C oCAmbHQ7L3dlYi1hcHAmZ3Q7PGJyPjxicj5JIGdldCB0aGUgZm9sbG93aW5nIGVycm9yOjxicj48 YnI+Q291bGQgbm90IGNvbm5lY3QgdG8gREI6IE5vIHN1aXRhYmxlIGRyaXZlciBmb3VuZCBmb3I8 YnI+PGJyPkkmIzM5O3ZlIHNlYXJjaGVkIHRoZSB2YXJpb3VzIGZvcnVtcyBvbiBteXNxbCBhbmQg SSBzZWUgdGhpcyBwcm9ibGVtIHJlcG9ydGVkIG1hbnkgdGltZXMgYmVmb3JlLCBidXQgd2FzIG5l dmVyIGFibGUgdG8gZmluZCBhbmQgYW5zd2VyLjxicj4KPGJyPkRvZXMgYW55Ym9keSBrbm93IHdo YXQgSSYjMzk7bSBkb2luZyB3cm9uZz88YnI+PGJyPlRoYW5rcyw8YnI+UGFvbG88YnI+Cg== --===============7936742811048821776==--