I am not familiar with Oracle, but in mysql it allows you to set
constraints. :)
Martin Gainty wrote:
Musachy-
I just created this DB under Oracle
#####so I re-configed the pfile (path/initDBNAME.ora) with these params
#MCG change UNDO_MANAGEMENT to AUTO
UNDO_MANAGEMENT = AUTO
#either replace "%AVAILABLE_SID%" with your database name OR hardcode
as you see here
db_name=%AVAILABLE_SID%
sql>shutdown immediate
sql>startup nomount pfile = "path/initDBNAME.ora"
sql>create database startup logfile -
group 1 ('%ORACLE_HOME%\oradata\%AVAILABLE_SID%\redo1.log') size 10M, -
group 2 ('%ORACLE_HOME%\oradata\%AVAILABLE_SID%\redo2.log') size 10M, -
group 3 ('%ORACLE_HOME%\oradata\%AVAILABLE_SID%\redo3.log') size 10M -
character set WE8ISO8859P1 -
national character set utf8 -
datafile '%ORACLE_HOME%\oradata\%AVAILABLE_SID%\system.dbf' -
size 50M -
autoextend on -
next 10M maxsize unlimited -
extent management local -
sysaux datafile '%ORACLE_HOME%\oradata\%AVAILABLE_SID%\sysaux.dbf' -
size 10M -
autoextend on -
next 10M -
maxsize unlimited -
undo tablespace undo -
datafile '%ORACLE_HOME%\oradata\%AVAILABLE_SID%\undo.dbf' -
size 10M -
default temporary tablespace temp -
tempfile '%ORACLE_HOME%\oradata\%AVAILABLE_SID%\temp.dbf' -
size 10M;
sql>CREATE TABLE Person (ID NUMBER(4,1) PRIMARY KEY, firstName
VARCHAR(45) NOT NULL,lastName VARCHAR(45) NOT NULL);
I noticed at the end of SQL I see ENGINE=InnoDB
Could you indicate what ENGINE=InnoDB is supposed to accomplish???
Thanks,
Martin--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please
notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
----- Original Message ----- From: "Mansour" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <user@struts.apache.org>
Sent: Sunday, April 15, 2007 11:01 AM
Subject: Re: [OT] [RANT] Re: Preparable or interceptors - is there a
better mailing list than this ? some thing for total newbies.
Musachy Barroso wrote:
I was looking to encapsulate all the behavior of the account in an
account object. So the object updates its self.
I'd say must people don't use that pattern anymore.
I see. So I have to get away from OO in order to do this. I have to
create a class called services, that has methods like:
populate (Account acc)
and update(Account acc) and ...
That's fine with me. I was a C language programmer before, and
familiar with 1928 programming style, Where you pass a pointer to a
struct to a method and let it do the operation on it. :)
So, no point in doing things OO ?
That was my question. I have to go through all this coding and write
all
these extra classes to be able to update info. right ? And I have to
change the bussiness logic (AccountService) to suit this design.
It pays off to have a persistence layer, instead of mixing it up
with you
object model. I'm using JPA on top of Toplink and I'm quite happy
with it,
here is a tutorial, CRUD-like that you might want to take a look at:
I know it pays of, but do I have to learn and use many frameworks to
get a simple application working ?
http://struts.apache.org/2.x/docs/struts-2-spring-2-jpa-ajax.html
musachy
There must be a way to do this with going through all this extra
coding and framework.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
