On Tue, Nov 24, 2009 at 6:24 AM, opyate <[email protected]> wrote: > Hi David, > > I did work around this by putting the schemas in my search path. > Edit postgresql.conf and add the following: > search_path = '"$user",public,schema1,schema2,schemaN' > > As for this being a bug... did you intend for Mapper to support > schemas on the CRUD side?
The support for schemas in schemifier was a special-case fix for, if I remember correctly, something relating to H2 and the way H2 user names are related to something. I think the short answer is that we're not going to explicitly support schemas in Mapper. If you need a more complete ORM, please use JPA. Sorry. > If so, I'd be happy to create a repro. > BUT it can quite easily be reproduced by taking an existing project > and moving an existing table into a schema: > > $ psql yourdb > yourdb=# create schema someschema; > CREATE SCHEMA > yourdb=# alter table user set schema someschema; > ALTER TABLE > > Now relaunch your app, and you'll see some issues with the user table. > Previously I had to alter my User companion object like so: > > override def dbTableName = "someschema.user" > > ...for Mapper to issue the correct queries to the database. > > Thanks, > Juan > > > > On Nov 19, 6:23 pm, David Pollak <[email protected]> > wrote: > > On Tue, Nov 17, 2009 at 10:50 AM, opyate <[email protected]> wrote: > > > Hello Lifters, > > > > > I overrode newSuperConnection like so: > > > > > --START-- > > > object DBVendor extends ConnectionManager { > > > def newConnection(name: ConnectionIdentifier): Box[Connection] > > > = { > > > try { > > > Class.forName(dbDriver) > > > val dm = DriverManager.getConnection(dbConnString, > > > dbUser, dbPass) > > > Full(dm) > > > } catch { > > > case e => { > > > e.printStackTrace > > > Empty > > > } > > > } > > > } > > > def releaseConnection(conn: Connection) {conn.close} > > > > > override def newSuperConnection(name: ConnectionIdentifier): > > > Box[SuperConnection] = { > > > val c: Connection = newConnection(name).open_! > > > def release = () => releaseConnection(c) > > > Full(new SuperConnection(c, release, Full(schema) )) > > > } > > > } > > > --END-- > > > > > ...where "schema" is defined beforehand. > > > > > Now, I have to read/write to a Postgres table which is in a schema, > > > e.g. "schemaname.tablename" > > > > > When I run my Lift code, I get the following exception: > > > > > Caught and thrown by: > > > Message: org.postgresql.util.PSQLException: ERROR: relation > > > "tablename" does not exist > > > > schemaName is used in Schemifier, but not in query construction. > > > > If this is a bug, please create a repro example (something we can use to > > test) and open a ticket. > > > > Thanks, > > > > David > > > > > > > > > > > > > > > > > However, if I change the model from this: > > > > > override def dbTableName = "tablename" > > > > > to this: > > > > > override def dbTableName = "schemaname.tablename" > > > > > ...then things start working, but this is obviously not the intended > > > way to achieve this, right? > > > > > Please let me know what I'm doing wrong. > > > > > Thanks, > > > Juan > > > > > -- > > > > > You received this message because you are subscribed to the Google > Groups > > > "Lift" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<liftweb%[email protected]> > <liftweb%[email protected]<liftweb%[email protected]>> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/liftweb?hl=. > > > > -- > > Lift, the simply functional web frameworkhttp://liftweb.net > > Beginning Scalahttp://www.apress.com/book/view/1430219890 > > Follow me:http://twitter.com/dpp > > Surf the harmonics > > -- > > You received this message because you are subscribed to the Google Groups > "Lift" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<liftweb%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/liftweb?hl=en. > > > -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics -- You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/liftweb?hl=en.
