Two silly questions: 1) Can you connect using the mysql command prompt? 2) Can you connect using another tool (there are many DB plugins for Eclipse) that uses a jdbc: type connection string?
Thanks, /dev/mrg On 6/27/07, Jack O'Connor <[EMAIL PROTECTED]> wrote:
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: [EMAIL PROTECTED] 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
