Re: clean.db.schema and JDBC driver
"Barry Benowitz" <[email protected]> Thu, 4 Oct 2007 09:07:04 -0400
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============0973896604== Content-class: urn:content-classes:message Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C80687.7630861B" This is a multi-part message in MIME format. ------_=_NextPart_001_01C80687.7630861B Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thie fix for this was to fill out the property in the build-db.xml for hibernate.connection.driver_class to com.mysql.jdbc.Driver =20 The next error is=20 =20 java.sql.SQLException: no suitable Driver for At org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:323) =20 I have tried with the newer 5.0.7 version and the older 3.1 version that is checked into the repo. And both report the same error. =20 Barry =20 =20 ________________________________ From: Barry Benowitz=20 Sent: Wednesday, October 03, 2007 2:11 PM To: '[email protected]' Subject: RE: [Xplanner-devel] clean.db.schema and JDBC driver =20 Please forgive if this is the wrong terminology, but I notice all the properties in build-db.xml called "hibernate.connection.*" are all blank, including user password and driver class. Do these need to be edited first?=20 =20 Thanks, =20 Barry =20 =20 ________________________________ From: xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org [mailto:xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] On Behalf Of Barry Benowitz Sent: Wednesday, October 03, 2007 12:04 PM To: [email protected] Subject: Re: [Xplanner-devel] clean.db.schema and JDBC driver =20 Thanks, but that didn't work either :-( =20 =20 ________________________________ From: xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org [mailto:xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] On Behalf Of Pike, Gordon Sent: Wednesday, October 03, 2007 11:56 AM To: [email protected] Subject: Re: [Xplanner-devel] clean.db.schema and JDBC driver =20 Have tried putting the driver in the classpath of Ant, like in the lib directory of your Ant installation? =20 ________________________________ From: Barry Benowitz [mailto:[email protected]]=20 Sent: Wednesday, October 03, 2007 8:48 AM To: [email protected] Subject: [Xplanner-devel] clean.db.schema and JDBC driver Greetings all, =20 I am trying to do my first build in preparation for an evaluation of xplanner. I have set up the idea IDE and I have been following the steps in the document for the first build. However, when I run the ant target clean.db.schema I get the following error: Class Not Found: JDBC Driver could not be loaded.=20 =20 I have placed the mysql-conector-java*.jar file that is in the repository in my $CATALINA_HOME/lib/webapps directory and made sure that it is included in the CLASSPATH of the IDE and I don't know where else to check. Please Help! =20 =20 Thanks, =20 Barry =20 ------_=_NextPart_001_01C80687.7630861B Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" = name=3D"PersonName"/> <!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal; font-family:Arial; color:windowtext;} span.EmailStyle18 {mso-style-type:personal; font-family:Arial; color:navy;} span.EmailStyle19 {mso-style-type:personal; font-family:Arial; color:navy;} span.EmailStyle20 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Thie fix for this was to fill out = the property in the build-db.xml for </span></font><font size=3D2 = color=3Dnavy face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"; color:navy'>hibernate.connection.driver_class</span></font><font = size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial; color:navy'> to </span></font><font size=3D2 color=3Dnavy = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New";color:navy'>com.mysql.jdbc.Driver<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New";color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>The next error = is</span></font><font size=3D2 color=3Dnavy face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family: "Courier New";color:navy'> <o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New";color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New";color:navy'>java.sql.SQLException: no suitable Driver for<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New";color:navy'> At = org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:323)<o= :p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New";color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>I have tried with the newer 5.0.7 = version and the older 3.1 version that is checked into the repo. And both report = the same error.<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Barry<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> Barry = Benowitz <br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October = 03, 2007 2:11 PM<br> <b><span style=3D'font-weight:bold'>To:</span></b> '<st1:PersonName = w:st=3D"on">[email protected]</st1:PersonName>'<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> RE: = [Xplanner-devel] clean.db.schema and JDBC driver</span></font><o:p></o:p></p> </div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Please forgive if this is the wrong terminology, but I notice all the properties in build-db.xml called = “</span></font><font size=3D2 color=3Dnavy face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family: "Courier New";color:navy'>hibernate.connection.*</span></font><font = size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial; color:navy'>” are all blank, including user password and driver = class. Do these need to be edited first? <o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Thanks,<o:p></o:p></span></font></p>= <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Barry<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org [mailto:xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] <b><span style=3D'font-weight:bold'>On Behalf Of </span></b>Barry Benowitz<br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October = 03, 2007 12:04 PM<br> <b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName = w:st=3D"on">[email protected]</st1:PersonName><br> <b><span style=3D'font-weight:bold'>Subject:</span></b> Re: = [Xplanner-devel] clean.db.schema and JDBC driver</span></font><o:p></o:p></p> </div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Thanks, but that didn’t work = either </span></font><font size=3D2 color=3Dnavy face=3DWingdings><span = style=3D'font-size:10.0pt;font-family: Wingdings;color:navy'>L</span></font><font size=3D2 color=3Dnavy = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span= ></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org = [mailto:xplanner-devel-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] <b><span style=3D'font-weight:bold'>On Behalf Of </span></b>Pike, = Gordon<br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October = 03, 2007 11:56 AM<br> <b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName = w:st=3D"on">[email protected]</st1:PersonName><br> <b><span style=3D'font-weight:bold'>Subject:</span></b> Re: = [Xplanner-devel] clean.db.schema and JDBC driver</span></font><o:p></o:p></p> </div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:blue'>Have tried putting the driver in = the classpath of Ant, like in the lib directory of your Ant = installation?</span></font><o:p></o:p></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'> <o:p></o:p></span></font></p> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabIndex=3D-1> </span></font></div> <p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><b><font size=3D2 = face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</spa= n></font></b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt;font-family:Tahoma'> Barry Benowitz [mailto:[email protected]] <br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October = 03, 2007 8:48 AM<br> <b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName = w:st=3D"on">[email protected]</st1:PersonName><br> <b><span style=3D'font-weight:bold'>Subject:</span></b> [Xplanner-devel] clean.db.schema and JDBC driver</span></font><o:p></o:p></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>Greetings all,<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>I am trying to do my first build in preparation for = an evaluation of xplanner. I have set up the idea IDE and I have been = following the steps in the document for the first build. However, when I run the = ant target clean.db.schema I get the following error: Class Not = Found: JDBC Driver could not be loaded. <o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>I have placed the mysql-conector-java*.jar file that = is in the repository in my $CATALINA_HOME/lib/webapps directory and made sure = that it is included in the CLASSPATH of the IDE and I don’t know where = else to check. Please Help!<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>Thanks,<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>Barry<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> </div> </body> </html> ------_=_NextPart_001_01C80687.7630861B-- --===============0973896604== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ --===============0973896604== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Xplanner-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xplanner-devel --===============0973896604==--