getting started

From: Jack O'Connor (jo418..ristol.ac.uk)
Date: Wed Jun 27 2007 - 17:33:28 EDT

  • Next message: Andrus Adamchik: "Re: getting started"

    Hi, I'm new to Cayenne and have just joined a work group that use it.
    Their system is still using Cayenne 1.2.3, so that is the version I
    downloaded and unpacked in /home/program_files (in my fresh Fedora 7
    Linux installation). They are using the MySQL db, so I also acquired a
    JDBC driver (called MySQL Connector/J) and unpacked that in
    /home/program_files.

    Following the tutorial, I setup Eclipse, then begin working with
    Cayenne. After setting CAYENNE_HOME=/home/program_files/cayenne-1.2.3

    I open Cayenne by running:
    cd [cayenne_distro_dir]/lib/modeler
    java -jar cayenne-modeler.jar

    Then in Tools>Preferences>ClassPath, I add the file
    /home/program_files/mysql-connector-java-3.0.17-ga/mysql-connector-java-3.0.17-ga-bin.jar

    Then in Tools>Preferences>Local DataSources, I click New... and create:
    Name: DataSource0
    Adapter: org.objectstyle.cayenne.dba.mysql.MySQLAdapter

    Then change DB URL to jdbc:mysql://localhost/jackdb (where jackdb is the
    name of a MySQL DB I have created), and Enter my Username and Password
    for it. Now, if I click Test..., I get:
    Error connecting to DB: Invalid authorization specification message form
    server: "Access denied for user 'nobody..localhost' (using password: NO)"

    If I continue, and click save, then "New Project", the main window is
    divided into 2 parts as in the tutorial; on the right is the normal
    default screen as in the tutorial, but on the left is on long line:
    org.objectstyle.cayenne.access.DataDomai..0ca22d1[name=UntitledDomain]

    NB/ each time I go back into Tools>Preferences>Local DataSources, DB URL
    has reset to jdbc:mysql://localhost/database, and Username and Password
    are blank again.

    I would really appreciate any ideas!
    Thanks
    Jack



    This archive was generated by hypermail 2.0.0 : Wed Jun 27 2007 - 17:34:27 EDT