Hi, We have figured it out ourself:
<!DOCTYPE databases (View Source for full doctype...)> <database name="test" engine="mysql"> <driver class-name="org.gjt.mm.mysql.MysqlDataSource" url="jdbc:mysql://172.24.48.160:3306/test?user=root&password=password" /> <mapping href="mapping.xml" /> </database> bye. -----Original Message----- From: Jurgen Kobierczynski [mailto:[EMAIL PROTECTED]] Sent: woensdag 28 november 2001 11:50 To: [EMAIL PROTECTED] Subject: [castor-dev] Connection to MySQL to port 1306 ??? Hello, We're trying to create a persistent object mapped with Castor 0.9.3 on a MySQL 3.23.41-1 database with the mm.mysql-2.0.6.1 jdbc driver on RedHat 7.2. This is our database.xml which define the connection: <!DOCTYPE databases (View Source for full doctype...)> <database name="test" engine="mysql"> <data-source class-name="org.gjt.mm.mysql.MysqlDataSource"> <params user="root" password="password" port-number="3306" server-name="172.24.48.160" /> </data-source> <mapping href="mapping.xml" /> </database> On running our example we get an exception: "org.exolag.castor.jdo.PersistenceException: Nested Error: java.sql.SQLException: Cannot connect to MySQL server on 172.24.48.160:1306. Is there a MySQL server running on the machine/port?" We get this on two installations. We can solve this by changing the default port of MySQL to 1306, but I puzzled why this problem isn't reported jet on this mailinglist? A second question. Where do we have to put the mapping.xml and database.xml files, and how do we have to define this in the source? We have trouble with our example to lookup the files in the right directory, it works now, but I would like to know the right strategy to define and place files. Thanks, Jurgen Kobierczynski ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
