Feels good to have a real database running on my mac - thanks very much for the port.

I am now trying to move a Java app that previously worked from FileMaker to MySQL but cannot even get the driver (caucho) to register - ClassNotFound.

I'm working in ProjectBuilder and am still unfamiliar in its ways but have tried everything I can think of (other than trying other Drivers) to get the .jar to register.

I'm sure there's an obvious solution, although after two days I still can't see it.

[absmiths]

In general, to add jar files to the classpath in Project Builder you call "Add Framework" from the "Project" menu. The problem with JDBC is that the code will compile even if the class is not in the classpath. Try changing your code to this:

void main(...)
{
// do this to allow the compiler to verify that the drivers are in the
// classpath
Class c = jdbc.Driver.class;
// normal JDBC driver register method - loads class by name so
// compiler can't verify it.
Class.forName("jdbc.Driver");
}

Once your code runs and compiles successfully, you can remove the first class lookup since it's only purpose was to check the classpath.

BTW, if you get an error other than ClassNotFoundException or NoClassDefFoundError, then the classpath is correct. Some drivers are compiled as package private, so the first call will throw an IllegalAccessException. If you get that, your classpath is good.

[This message has been edited by absmiths (edited 04-07-2001).]

[DaGuy]

I had a relatively easy time with following MySQL JDBC driver:
http://www.worldserver.com/mm.mysql/

It also has excellent introductory documentation.