• Welcome to KonaKart Community Forum. Please login or sign up.
 

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - p.cornelissen

1
Worked like a charm!

Thanks Heidi
2
Thanks Heidi!
I'll try that tomorrow, when I'm back at work.
3
Hi!

I am experiencing the same problem. Deployment on jboss 4.2 works, but 5.0.x throws the errors mentioned in the first post.
Is there a solution yet?
4
Hi!

Quote from: jerolimov on February 11, 2009, 01:06:15 pm
...
In both lines the single quote (') around the value colum (around 1.0000 and 1.1036) must be removed.

Instead of:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2','1.0000', sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2','1.1036', sysdate);

It must be:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2',1.0000, sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2',1.1036, sysdate);


I'd suggest to use the to_number function, so you can provide the number and the number format, so you won't get into trouble with different NLS settings.