If your username is peter, put a file in src/main/resources/props named
peter.props
In that file, place the following lines:
db.driver=*the_name_name_of_your_driver*
db.url=*the_url_to_access_your_database*
db.user=*the_username*
db.password=*the_db_password*
test.me=true
**
**
Add the following line to Boot.scala:
println(Props.get("test.me")
When you run your app Full(true) should appear on the console and the
correct db settings should be picked up.
Thanks,
David
**
On Thu, Jun 18, 2009 at 3:49 PM, Peter Robinett <pe...@bubblefoundry.com>wrote:
>
> 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
>
> >
>
--
Lift, the simply functional web framework http://liftweb.net
Beginning Scala http://www.apress.com/book/view/1430219890
Follow me: http://twitter.com/dpp
Git some: http://github.com/dpp
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
