cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack O'Connor <>
Subject Re: getting started
Date Thu, 28 Jun 2007 15:35:17 GMT
Hey, problem has just been solved. It was an interesting problem; the 
java that comes with fedora core linux is different to Sun's java, and 
not fully compatible with every java application. The solution is to use 
JPackage to run 2 versions of java simultaneously (2 'alternatives'). 

Michael Gentry wrote:
> 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 <> 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:
>> org.objectstyle.cayenne.access.DataDomain@30ca22d1[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

View raw message