Hi all,

I've noticed a couple of SQL-generation problems when using lift
(1.0.2) with oracle (10.2, and using latest drivers).

Firstly, schemify fails on adding a column to a model:
INFO - ALTER TABLE table_name ADD COLUMN label VARCHAR(1000)
ERROR - Failed to Boot
java.sql.SQLException: ORA-00904: : invalid identifier

The correct syntax for this in oracle is:
ALTER TABLE table_name ADD label VARCHAR(1000)

Is this due to the oracle drivers not handling jdbc-standard sql?


Secondly, a CRUDify generated object list generates "ORA-00933: SQL
command not properly ended".
What's the best way to log SQL executed by mapper?


Thanks!
Paul

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to