Women in Technology

Hear us Roar



Article:
  ColdFusion MX on Mac OS X, Part 3
Subject:   Pointbase? And MySQL?
Date:   2003-01-15 06:45:51
From:   dicklacara
Response to: Pointbase? And MySQL?

I was able to connect to the MySQL & PB databases with SQL4X Manager J.


I gave you some wrong information in my previous post, the following is correct.



  1. Make a copy of the PointBase driver file and put it where SQLEX Manajer J can find it. Copy pbserver42RE.jar from:


    /Applications/JRun4/servers/cfmx1/cfusion/WEB-INF/cfusion/lib


    to:


    /Library/Java/Extensions

  2. Restart SQL4X Manager J, so it can locate the copied driver


  3. Setup a connection:


    Database Server: Generic JDBC
    Driver Installed: Yes


    The following can be copied from the cfsnippets DSN in the CFMX Administrator


    Display Name: cfsnippets


    JDBC Driver: com.pointbase.jdbc.jdbcUniversalDriver


    JDBC URL: jdbc:pointbase:cfsnippets,database.home=/Applications/JRun4/servers/cfmx1/cfusion/WEB-INF/cfusion/db


    USER: PBPUBLIC


    PASSWORD: PBPUBLIC


  4. Connect to the cfsnippets Database
  5. Open a new Navigator window to recognize the new connection
  6. Select the PBPUBLIC schema to view the cfsnippets schema


Dick

Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • Pointbase? And MySQL?
    2003-01-15 08:56:37  lolajl [View]

    Thanks! Followed the steps accordingly, there seems to be a problem in my ability to connect to the database, though. The problem line seems to be the JDBC URL. I doublechedked to make sure the path was correct. When I clicked on Connect, I got a java.sql.SQL.exception error: database does not exist. It seems to think that the database is somewhere else other than this directory. Checked db directory and cfsnippets does reside here as cfsnippts.dbn.
    • Pointbase? And MySQL?
      2003-01-15 12:06:50  dicklacara [View]

      Can you verify the cfsnippets database in the CFMX Administrator?

      If so, you should be able to copy the driver class and URL files from that definition to the corresponding fields in the SQL4X connection.

      Dick
      • Pointbase? And MySQL?
        2003-01-15 12:51:08  lolajl [View]

        Not sure what I'd done wrong before, but copying/pasting the paths worked like a charm. Thanks! I'm starting up a blog that will be devoted solely to Macs and CFMX, located at <http://www.lolajl.net/macfmx/>. It's up now but nothing much in there yet.