Re: [Lift] Re: Oracle DB connection in 1.1-m7
It should be in place now. Can you verify that it's working for you? On Fri, Nov 27, 2009 at 6:49 PM, Derek Chen-Becker dchenbec...@gmail.comwrote: http://reviewboard.liftweb.net/r/129/ I'll check this in to master in the morning. On Fri, Nov 27, 2009 at 8:53 AM, Derek Chen-Becker dchenbec...@gmail.comwrote: I should have a fix in 30 minutes or so. On Thu, Nov 26, 2009 at 9:56 AM, Mathias Sulser s...@suls.org wrote: I think the MappedBoolean isn't properly done in the OracleDriver: scala User.findAll(By(User.superUser, false)) java.sql.SQLException: Invalid column type at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical (OraclePreparedStatement.java:9168) at ora... And if you look at the generated DDL: CREATE TABLE USERS ( ... SUPERUSER decimal(22), ... ); Any hints on how to solve this? Btw, it's a 10g data base On Nov 26, 4:14 pm, Mathias Sulser s...@suls.org wrote: All right. Figuring out the proper JDBC string was all. Schemifyer seems to then pick the right driver and produce DDL for the specific DB. Great stuff. On Nov 26, 3:17 pm, suls s...@suls.org wrote: Hi, I see that there is a DriverType and OracleDriver in 1.1-m7 but again I don't know how to connect the dots. How would a DB.defineConnectionManager method call that uses an oracle db look like? Thanks, suls -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@googlegroups.com. To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.comliftweb%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/liftweb?hl=en. -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@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.
Re: [Lift] Re: Oracle DB connection in 1.1-m7
I should have a fix in 30 minutes or so. On Thu, Nov 26, 2009 at 9:56 AM, Mathias Sulser s...@suls.org wrote: I think the MappedBoolean isn't properly done in the OracleDriver: scala User.findAll(By(User.superUser, false)) java.sql.SQLException: Invalid column type at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical (OraclePreparedStatement.java:9168) at ora... And if you look at the generated DDL: CREATE TABLE USERS ( ... SUPERUSER decimal(22), ... ); Any hints on how to solve this? Btw, it's a 10g data base On Nov 26, 4:14 pm, Mathias Sulser s...@suls.org wrote: All right. Figuring out the proper JDBC string was all. Schemifyer seems to then pick the right driver and produce DDL for the specific DB. Great stuff. On Nov 26, 3:17 pm, suls s...@suls.org wrote: Hi, I see that there is a DriverType and OracleDriver in 1.1-m7 but again I don't know how to connect the dots. How would a DB.defineConnectionManager method call that uses an oracle db look like? Thanks, suls -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@googlegroups.com. To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.comliftweb%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/liftweb?hl=en. -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@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.
Re: [Lift] Re: Oracle DB connection in 1.1-m7
http://reviewboard.liftweb.net/r/129/ I'll check this in to master in the morning. On Fri, Nov 27, 2009 at 8:53 AM, Derek Chen-Becker dchenbec...@gmail.comwrote: I should have a fix in 30 minutes or so. On Thu, Nov 26, 2009 at 9:56 AM, Mathias Sulser s...@suls.org wrote: I think the MappedBoolean isn't properly done in the OracleDriver: scala User.findAll(By(User.superUser, false)) java.sql.SQLException: Invalid column type at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical (OraclePreparedStatement.java:9168) at ora... And if you look at the generated DDL: CREATE TABLE USERS ( ... SUPERUSER decimal(22), ... ); Any hints on how to solve this? Btw, it's a 10g data base On Nov 26, 4:14 pm, Mathias Sulser s...@suls.org wrote: All right. Figuring out the proper JDBC string was all. Schemifyer seems to then pick the right driver and produce DDL for the specific DB. Great stuff. On Nov 26, 3:17 pm, suls s...@suls.org wrote: Hi, I see that there is a DriverType and OracleDriver in 1.1-m7 but again I don't know how to connect the dots. How would a DB.defineConnectionManager method call that uses an oracle db look like? Thanks, suls -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@googlegroups.com. To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.comliftweb%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/liftweb?hl=en. -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@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.
[Lift] Re: Oracle DB connection in 1.1-m7
All right. Figuring out the proper JDBC string was all. Schemifyer seems to then pick the right driver and produce DDL for the specific DB. Great stuff. On Nov 26, 3:17 pm, suls s...@suls.org wrote: Hi, I see that there is a DriverType and OracleDriver in 1.1-m7 but again I don't know how to connect the dots. How would a DB.defineConnectionManager method call that uses an oracle db look like? Thanks, suls -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@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.
[Lift] Re: Oracle DB connection in 1.1-m7
I think the MappedBoolean isn't properly done in the OracleDriver: scala User.findAll(By(User.superUser, false)) java.sql.SQLException: Invalid column type at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical (OraclePreparedStatement.java:9168) at ora... And if you look at the generated DDL: CREATE TABLE USERS ( ... SUPERUSER decimal(22), ... ); Any hints on how to solve this? Btw, it's a 10g data base On Nov 26, 4:14 pm, Mathias Sulser s...@suls.org wrote: All right. Figuring out the proper JDBC string was all. Schemifyer seems to then pick the right driver and produce DDL for the specific DB. Great stuff. On Nov 26, 3:17 pm, suls s...@suls.org wrote: Hi, I see that there is a DriverType and OracleDriver in 1.1-m7 but again I don't know how to connect the dots. How would a DB.defineConnectionManager method call that uses an oracle db look like? Thanks, suls -- You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to lift...@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.
