Out of the box.... it will not run Oracle, only PostgreSQL for now.
(but it could easily. I must rely on DB to gen ID becuase I want to
place a large load on this, some of my clients go beyong 10,000
councrent users and treading issues abound. If you would elimiate
basicPortal becuase it does not support Oracle, than I would make it
a priority to add that code. Most clients are ok with the "kit"
nature of basicPortal for now)
--- In [EMAIL PROTECTED], "Daniel Jaffa" <[EMAIL PROTECTED]> wrote:
> Thx for the code, but that is not really what i am after. The
question is will the 80% of the code for the basicPortal be
> able to run on Oracle. It looks like the BasicPortal is expecting
the database to autogenerate the sequance numbers for you.
>
> ----- Original Message -----
> From: netsql
> To: [EMAIL PROTECTED]
> Sent: Wednesday, August 14, 2002 9:26 PM
> Subject: [mvc-programmers] Re: new build of basicPortal
>
>
> One of my client has this DAO for Oracle:
> public BigDecimal getNextPK(String tabName)
> {
>
> try
> {
> String cmd = "Select " + tabName + "_seq.nextval
nextPK
> from dual";
> RowSet cr = getRowSet();
> cr.setCommand(cmd);
> BBug.log(cr.getCommand());
> exec();
> return cr.getBigDecimal("nextPK");
> }
> catch (SQLException e) {BBug.log(e);
> return null; }
> }
>
> hth
>
> "Vic C." <
> --- In [EMAIL PROTECTED], "Daniel Jaffa" <[EMAIL PROTECTED]> wrote:
> > First off, i love this idea, and when i get this install at my
job
> will be very happy.
> >
> > Sorry for such a short question before. Looking at the code
that
> will create the tables it seems as if you
> > are expecting the database to auto generate sequence numbers
for
> you. This does not work in Oracle.
> >
> > Changing around the sql statements is not big deal, but does
the
> internal code know the difference between db that auto-generate
> sequence numbers or not.
> > http://web.umr.edu/~oramaint/usage/serial-numbers.html
> >
> >
> > create table "base_content" (
> > "id" serial primary key,
> > "image_small" bytea,
> > "field_n3" numeric(20, 2)
> > );
> >
> > insert into "base_content"
> >
>
("headline_title", "short_code", "category_page", "category_section",
> "link_url", "link_display", "source_code", "source_email", "meta_k
eyw
> ords" , "approved_flag" )
> > values
> > ('Java Developers go for dime a
>
dozen', 'MAIN', 'cheap1','Headlines', 'http://www.theserverside.com',
> 'theserverside.com', 'load', '[EMAIL PROTECTED]','java, linux','Y');
> >
> > So a basic question is has the basicPortal been tested in
Oracle.
> >
------------------------ Yahoo! Groups Sponsor ---------------------~-->
4 DVDs Free +s&p Join Now
http://us.click.yahoo.com/pt6YBB/NXiEAA/RN.GAA/NhFolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
_______________________________________________
MVC-Programmers mailing list
[EMAIL PROTECTED]
http://www.netbean.net/mailman/listinfo/mvc-programmers
