[Lift] Re: Testing Help for Oracle?
The column type for the MappedDateTime is TIMESTAMP by default, so it should save hour, minute, second, etc. Are you using an existing schema or using Schemifier to generate it? If it's the latter, can you provide a code snippet showing where you set the timestamp on your mapper instance? As for the second one, can you give us a code snippet and a stack trace showing the exception? Also, would you mind keeping this on the mailing list for now so that if other people run into similar issues we at least have some history. Thanks, Derek On Wed, Mar 4, 2009 at 8:11 AM, radoslaw.holewa radoslaw.hol...@gmail.comwrote: On 2 Mar, 18:42, Derek Chen-Becker dchenbec...@gmail.com wrote: This sounds like a bug. I'm guessing that you mean the object's primary key field isn't updated after save, correct? According to the docs: http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/jdb... Oracle's driver should support auto-generated keys, which is what we use in Mapper. Can you confirm that what I'm saying is what you're seeing? First of all, sorry for late answer. Yes, you're right the primary key wasn't set, I made small workaround and it works fine. I've found other problems, this time with timestamps mapping and boolean mapping. In the first case my MappedDateTime field had database representation without hours, minutes etc. In the second case my JDBC driver has thrown exception when I was trying to save MappedBoolean value to database. Cheers, Radek --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[Lift] Re: Testing Help for Oracle?
Doesn't Oracle use Sequences? On Mon, Mar 2, 2009 at 6:42 PM, Derek Chen-Becker dchenbec...@gmail.comwrote: This sounds like a bug. I'm guessing that you mean the object's primary key field isn't updated after save, correct? According to the docs: http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/jdbcvers.htm#CHDEGDHJ Oracle's driver should support auto-generated keys, which is what we use in Mapper. Can you confirm that what I'm saying is what you're seeing? Thanks, Derek On Mon, Mar 2, 2009 at 8:56 AM, radoslaw.holewa radoslaw.hol...@gmail.com wrote: On 20 Lut, 01:50, Debby Meredith de...@jafco.com wrote: Folks, We're looking for some most excellent people to volunteer to test the Oracle 10g JDBC driver in lift-mapper as soon as possible. Any hands going up out there? Perhaps Greg Meredith, who has a wonderful last name if I do say so myself, would like to sign up? Anyone else? Thanks in advance! Hi, I'm using Lift mapper in one of my projects and my database is Oracle 10g. Unfortunately I have some problems with primary keys. After I save my object it's primary key is not set. I tested it with MySQL and H2 database and everything went well. So, my question is: do you have any solution for setting primary key after object is saved? Of course using oracle database :) Cheers, Radek -- Viktor Klang Senior Systems Analyst --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[Lift] Re: Testing Help for Oracle?
It does, but according the their JDBC compatibility page (link below), the JDBC driver should support getGeneratedKeys. Derek On Mon, Mar 2, 2009 at 11:41 AM, Viktor Klang viktor.kl...@gmail.comwrote: Doesn't Oracle use Sequences? On Mon, Mar 2, 2009 at 6:42 PM, Derek Chen-Becker dchenbec...@gmail.comwrote: This sounds like a bug. I'm guessing that you mean the object's primary key field isn't updated after save, correct? According to the docs: http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/jdbcvers.htm#CHDEGDHJ Oracle's driver should support auto-generated keys, which is what we use in Mapper. Can you confirm that what I'm saying is what you're seeing? Thanks, Derek On Mon, Mar 2, 2009 at 8:56 AM, radoslaw.holewa radoslaw.hol...@gmail.com wrote: On 20 Lut, 01:50, Debby Meredith de...@jafco.com wrote: Folks, We're looking for some most excellent people to volunteer to test the Oracle 10g JDBC driver in lift-mapper as soon as possible. Any hands going up out there? Perhaps Greg Meredith, who has a wonderful last name if I do say so myself, would like to sign up? Anyone else? Thanks in advance! Hi, I'm using Lift mapper in one of my projects and my database is Oracle 10g. Unfortunately I have some problems with primary keys. After I save my object it's primary key is not set. I tested it with MySQL and H2 database and everything went well. So, my question is: do you have any solution for setting primary key after object is saved? Of course using oracle database :) Cheers, Radek -- Viktor Klang Senior Systems Analyst --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[Lift] Re: Testing Help for Oracle?
I downloaded Oracle XE 10 this weekend and set up a VM to run it on. If I can get some work on the book done I'm going to try to get it set up and then I can do some more direct troubleshooting to verify that the Mapper support for Oracle is all functional. Derek On Mon, Mar 2, 2009 at 12:03 PM, Derek Chen-Becker dchenbec...@gmail.comwrote: It does, but according the their JDBC compatibility page (link below), the JDBC driver should support getGeneratedKeys. Derek On Mon, Mar 2, 2009 at 11:41 AM, Viktor Klang viktor.kl...@gmail.comwrote: Doesn't Oracle use Sequences? On Mon, Mar 2, 2009 at 6:42 PM, Derek Chen-Becker dchenbec...@gmail.comwrote: This sounds like a bug. I'm guessing that you mean the object's primary key field isn't updated after save, correct? According to the docs: http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/jdbcvers.htm#CHDEGDHJ Oracle's driver should support auto-generated keys, which is what we use in Mapper. Can you confirm that what I'm saying is what you're seeing? Thanks, Derek On Mon, Mar 2, 2009 at 8:56 AM, radoslaw.holewa radoslaw.hol...@gmail.com wrote: On 20 Lut, 01:50, Debby Meredith de...@jafco.com wrote: Folks, We're looking for some most excellent people to volunteer to test the Oracle 10g JDBC driver in lift-mapper as soon as possible. Any hands going up out there? Perhaps Greg Meredith, who has a wonderful last name if I do say so myself, would like to sign up? Anyone else? Thanks in advance! Hi, I'm using Lift mapper in one of my projects and my database is Oracle 10g. Unfortunately I have some problems with primary keys. After I save my object it's primary key is not set. I tested it with MySQL and H2 database and everything went well. So, my question is: do you have any solution for setting primary key after object is saved? Of course using oracle database :) Cheers, Radek -- Viktor Klang Senior Systems Analyst --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
