JDBC (UNCLASSIFIED)

["Samara, Fadi N Mr ACSIM/ASPEX" <Fa...@hqda.army.mil>]

Classification:  UNCLASSIFIED 
Caveats: NONE
 
Hey list,

I am new to Beehive.  I am trying out the petstore example.  I got the app
to talk my Oracle 10g database.
When I try to insert an address for a newly created account, it errors out
with an unexpected Database Exception.

The reason this is happening is because I cannot setup the addersses table
correctly.  The ADDRESSES table
Contains the ADDRESSID field which should be auto-generated.
I created a sequence in Oracle to take care of this, but in the insert
statement in the java class file, for some reason I cannot call that
sequence.

Any of you came across this ? Any clues

Thanks in advance

Fadi
 
Classification:  UNCLASSIFIED 
Caveats: NONE

Re: JDBC (UNCLASSIFIED)

[Chad Schoettger <ch...@gmail.com>]

If you can provide the portion of the code which is failing I will take a
look and see if I can determine what is causing the problem.

 - Chad

On 1/23/06, Samara, Fadi N Mr ACSIM/ASPEX <Fa...@hqda.army.mil> wrote:
>
> Classification:  UNCLASSIFIED
> Caveats: NONE
>
> Hey list,
>
> I am new to Beehive.  I am trying out the petstore example.  I got the app
> to talk my Oracle 10g database.
> When I try to insert an address for a newly created account, it errors out
> with an unexpected Database Exception.
>
> The reason this is happening is because I cannot setup the addersses table
> correctly.  The ADDRESSES table
> Contains the ADDRESSID field which should be auto-generated.
> I created a sequence in Oracle to take care of this, but in the insert
> statement in the java class file, for some reason I cannot call that
> sequence.
>
> Any of you came across this ? Any clues
>
> Thanks in advance
>
> Fadi
>
> Classification:  UNCLASSIFIED
> Caveats: NONE
>
>