Another Mysql 4.1 and CFusion DSn error issue

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Another Mysql 4.1 and CFusion DSn error issue

    I have followed the instructions on getting this to work.

    I installed the .jar file in C:\CFusionMX\wwwroot\WEB-INF\lib

    This is the .jar file name: mysql-connector-java-3.0.16-ga-bin.jar

    I went to the CFM Admin and selected the - Java and JVM Settings page.

    This is the Class path I entered there:
    C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.16-ga-bin.jar

    the info i am using for the DSN setup:

    Selected Other for the Driver-

    JDBC URL: jdbc:mysql://localhost/fairfares
    Driver Class: com.mysql.jdbc.Driver

    I have entered the valid username and password.

    here is the error I am getting.

    -------------------------------------------------------------
    Connection verification failed for data source: fairfaresdata
    []java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    The root cause was that: java.lang.ClassNotFoundException:
    com.mysql.jdbc.Driver
    ---------------------------------------------------------------------

    I need help. This is driving me mad.



    CCFusion Guest

  2. Similar Questions and Discussions

    1. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
      When i try to start my mysql server, i get this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'...
    2. MySQL Date issue
      Anyone else have this issue? I've got a query that pulls dates out of a MySQL db, and often times the date fields have "0000-00-00" in the date...
    3. Frequent Error in cfusion-error.log
      Running: CFMX 6.1 in J2EE mode on JRun I have the following error appear frequently in my cfusion-error.log file: 04/29 18:01:36 error Error in...
    4. PHP and mySQL issue
      I have been working with some open source code modifying a program to become what I needed. It uses a php type interface and then inserts...
    5. Date issue in php and mysql
      On Mon, 25 Aug 2003 12:59:19 +0200 "Ricki Susic" <rickFJERNDETTEi@webfabrikken.net> wrote: You will have to be a little more specific about...
  3. #2

    Default Re: Another Mysql 4.1 and CFusion DSn error issue

    Have you verified your server can resolve 'localhost'? Also you may try to add
    the port on which MySQL is set up to listen on, ie
    jdbc:mysql://localhost:3306/fairfares. The database must also exist ofcourse.
    If this doesn't help re-check the path to the .jar etc.

    sTg Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139