6 Replies Latest reply: Sep 24, 2008 3:37 PM by 843785 RSS

    help with com.mysql.jdbc.Driver

    843785
      Hi all

      I am new to working with java. I am working off of my laptop (pc -vista) and
      am trying to connect to a database on a server I have, mac osx 10.x.

      First question: I would install com.mysql.jdbc.Driver on the same server as
      the MySql server correct?

      Second and more important question: I have multiple pages
      printed out on installing this driver but I just cannot follow it. I am not
      very good in terminal(mac) and the install seems terminal based.
      Can someone please try to explain to me in laymen terms what needs to
      be done?

      thanks alot
      Marcus
        • 1. Re: help with com.mysql.jdbc.Driver
          843785
          marcusam wrote:
          Hi all

          I am new to working with java. I am working off of my laptop (pc -vista) and
          am trying to connect to a database on a server I have, mac osx 10.x.

          First question: I would install com.mysql.jdbc.Driver on the same server as
          the MySql server correct?
          No, you need access to that jar from your client.

          >
          Second and more important question: I have multiple pages
          printed out on installing this driver but I just cannot follow it. I am not
          very good in terminal(mac) and the install seems terminal based.
          Can someone please try to explain to me in laymen terms what needs to
          be done?

          thanks alot
          Marcus
          "installing" the JDBC driver just means placing it in the client's classpath.
          • 2. Re: help with com.mysql.jdbc.Driver
            843785
            how do you determine class path (pc) that is being used?
            is there a standard for client or is it based on prefernce?

            thanks again
            Marcus
            • 3. Re: help with com.mysql.jdbc.Driver
              843785
              well, you said: "I am working off of my laptop (pc -vista) and am trying to connect to a database" - so I assume you are writing some sort of client code, right? However you're running that will determine what its CLASSPATH is.
              • 4. Re: help with com.mysql.jdbc.Driver
                843785
                sorry for my lack of knowledge

                client code = all on one machine?

                I wanted to access a database that was on a totally different machine, with a java application.
                is this not very doable - or realistic?

                i found enviroment variables for CLASSPATH that are pointing inside 'jre1.6.0_07'
                but i also have 'jdk1.6.0_07' - should the development kit be the one i use? - sorry

                back to original question - so would i just move the .jar file into
                \jre1.6.0_02\lib\ext\ or something of that sort

                thanks alot
                Marcus
                • 5. Re: help with com.mysql.jdbc.Driver
                  843785
                  marcusam wrote:
                  sorry for my lack of knowledge

                  client code = all on one machine?
                  No, client code = the code you use to access your DB server.

                  >
                  I wanted to access a database that was on a totally different machine, with a java application.
                  is this not very doable - or realistic?
                  It's completely doable.
                  i found enviroment variables for CLASSPATH that are pointing inside 'jre1.6.0_07'
                  but i also have 'jdk1.6.0_07' - should the development kit be the one i use? - sorry

                  back to original question - so would i just move the .jar file into
                  \jre1.6.0_02\lib\ext\ or something of that sort

                  thanks alot
                  Marcus
                  Yes, you can move the jar into the ext directory if you wish. How are you running your java application? What are you typing/clicking on?
                  • 6. Re: help with com.mysql.jdbc.Driver
                    843785
                    i know how (kind of) to compile it with javac and java in dos

                    but i am using TextPad and just using that to compile
                    and run