Thought inc.

The Dynamic O/R Mapping Company
     

CocoBase Technical Support Forums
For access to developer site with software download and doc's, please request CocoBase download and password
will be emailed to you. Response to posts will appear when answered by THOUGHT Support team.
NOTE:You must register separately with forum in order to post your questions, please click on register icon below.
Home   Frequently Asked Questions   Search   Edit your profile   Registration is free!  
Email This Page to Someone!
Show a Printable Version
CocoBase Enterprise O/R Forums > CocoBase Questions
Mysql connection failed
< Previous Thread     Next Thread >
Author
Thread    Post New Thread     Post A Reply
plasante
Member

Registered: Sep 2004
Posts: 2

Hi I'm trying to establish a connection to Mysql from the CocoAdmin facility but it fails each time. It says that I must set the CLASSPATH. I know how to set the CLASSPATH but what jar file should I specify?
Regards.

09-11-2004 12:20 PM
Click Here to See the Profile for plasante    Find more posts by plasante        Edit/Delete Message    Reply w/Quote    IP: Logged
admin
Administrator

Registered: Apr 2001
Posts: 19

CocoBase uses the 'system' classpath. On windows you do this through the Control panel to permanently set the value. In unix typically this is done in one of the .* startup profiles.

On windows to 'temporarily' set the classpath simply open a command prompt and cd to the CocoBase home, set the classpath and launch CocoAdmin. This set of commands can also be captured into a startup batch script. An example using the 3.0.8 of mysql jdbc would look like

cd %COCO_HOME%\demos
set CLASSPATH=c:\mysql-connector-java-3.0.8-stable\mysql-connector-java-3.0.8-stable-bin.jar;%CLASSPATH%
cocoadmin.bat

This directory structure and jar file will vary from version to version, etc. To test and confirm if you have added the jdbc driver correctly to your classpath you can use the javap command which can be found in your <jdk_home>\bin folder. An example of this would look like:

javap org.gjt.mm.mysql.Driver

If the class is in the classpath, the system will dump its method signatures. If the classpath isn't setup correctly, you'll get a class not found error. This is a great way to debug your classpath before ever launching CocoAdmin.

Does that help?

THOUGHT Support

09-13-2004 12:06 PM
Click Here to See the Profile for admin    Find more posts by admin        Edit/Delete Message    Reply w/Quote    IP: Logged
All times are PST (US)    Post New Thread     Post A Reply
Forum Jump:
< Previous Thread     Next Thread >

Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author. Messages can be deleted by their author.
Posts: HTML code is OFF. Smilies are OFF. vB code is OFF. [IMG] code is OFF.

Admin Options:
Open / Close Thread
Move Thread
Delete Thread
Edit Thread

< Contact Us - THOUGHT Inc. >

Copyright © Jelsoft Enterprises Limited 2000.
Copyright 2001 All Rights Reserved, THOUGHT Inc.