ROWID is indeed a pseudo-column that isn't even stable, to my knowledge. I've always know it as a 0-based index over the rows returned from a query.
As of 9i, at least, Oracle insisted that you implement auto-incrementing columns manually using a sequence and an associated trigger. I presume that they have a good reason for this, perhaps related to replication or something. It's a hassle. Kris On Mon, Aug 10, 2009 at 4:26 PM, Derek Chen-Becker<dchenbec...@gmail.com> wrote: > OK, I think that I've at least figured out the cause of the exception. The > Oracle driver is set to use ROWID for primary keys and long indices. As far > as I can tell from the Oracle docs, ROWID is a pseudo-column and shouldn't > really be used as a column type in table creation DDL. The Boolean > conversion appears to be working correctly, so now I just need to figure out > the best way to abstract auto-increment column creation. > > Derek > > On Mon, Aug 10, 2009 at 1:51 AM, Jon Kleiser <jon.klei...@usit.uio.no> > wrote: >> >> Hi, >> >> Here's the contents of my default.props file: >> >> db.driver = oracle.jdbc.OracleDriver >> db.url = jdbc:oracle:thin:@myserver.site.no:1540:mydatabase >> db.user = myuser >> db.password = xxx >> >> The file is located in todo/src/main/webapp/WEB-INF/classes/props/ >> >> /Jon >> >> >> On 8/10/09 5:01 AM, Derek Chen-Becker wrote: >>> >>> Or at least the JDBC connection URL that you're using (no passwords or >>> username needed). >>> >>> On Sun, Aug 9, 2009 at 8:25 AM, Derek Chen-Becker <dchenbec...@gmail.com >>> <mailto:dchenbec...@gmail.com>> wrote: >>> >>> Please send me the props file. I want to duplicate exactly (as much >>> as possible) what you're doing. >>> >>> Derek >>> >>> >>> On Sat, Aug 8, 2009 at 2:14 PM, Jon Kleiser <jon.klei...@usit.uio.no >>> <mailto:jon.klei...@usit.uio.no>> wrote: >>> >>> Hi Derek, >>> >>> The attached file should be identical to the project I use for >>> the Oracle >>> testing, except that the file specifying the Oracle connection >>> (was it >>> default.props?) is missing. I have it on my PPC Mac, not here. I >>> guess you >>> know how to create that file and where to put it. If you're not >>> sure, let >>> me know, and I'll send you the info early Monday (or later). >>> >>> /Jon > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
