Hi all, I'm looking to switch a basic Lift install to use MySQL. I see that this has been addressed on the wiki (http://wiki.liftweb.net/index.php/ HowTo_configure_lift_with_MySQL), though it involves hardcoding the connection details in Boot.scala. I'd like something easier to deploy to various machines.
The thread following Jörn's announcement of the wiki page on MySQL is useful (http://groups.google.com/group/liftweb/browse_thread/thread/ bd4e74b68e8aa2a9/9eb2c2ef39442d63) but none of them mention using properties files, which I understand from this mailing list (e.g. http://groups.google.com/group/liftweb/browse_thread/thread/49eb17b5dd6fc46a) is the best way store database settings. So, I created src/main/resources/props/peter.db.xml: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd";> <properties> <comment></comment> <entry key="db.driver">com.mysql.jdbc.Driver</entry> <entry key="db.url">jdbc:mysql://localhost/mydb</entry> <entry key="db.user">myusername</entry> <entry key="db.password">mypassword</entry> </properties> Unfortunately, the property file does appear to be loaded, as the DBVendor code in Boot.scala generated by the lift-archetype-basic archetype falls back to its derby defaults. Do you have any idea what I'm doing wrong? Not having any experience with Java, I wouldn't be surprised if it's something as simple as getting the properties XML wrong... Thanks for your help! Peter --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---
