Marilyn Miers
|
| Posted: 03/19/2002, 7:03 AM |
|
Dear codecharge and kind helpers all around,
Hello there! I've (finally) connected to my Oracle database and the final
hour was near. But alas, when i Compiled my JSp files, the grids appeared,
the titles appeared, but the data was not retrieved. Checked through SQLPlus
and the data has been successfully inserted via .sql files prior to
compiling the code (eg. select * from Endorse; does return the 2 values i
inserted into the table using an sql file with isnert stables and successful
row inserted messages ). Back to the JSP file, which has been properly
connected to attempt to retrive values from Endorse for editing...and
nothing appears. Just a "NO RECORDS" thingy.
When I attempt to insert a new record into the table, it successfully
appears.! But only the newly inserted record shows, not the previously
inserted ones. As in for example...
Current database has ID1, value= Yes. ID2, value=No. When i compile the JSp
i see neither of these. But i can insert ID3, value=Maybe and when the page
refreshes, ID3 does appear in the Grid, but the other two don't.!
Checking throguh SQLplus, the new record has been added successfully. And
all 3 records from ID 1 to 3 are there.
Now when i try to experiment around by making the ID field in the RECORD JSP
a hidden field, i get the following error (i.e. I'm supposed to get an error
becasue the ID field is a NOT NULL value, so i just wanted to get the error
to see what was wrong)
And the error was weird. it had
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SCOTT"."EVALUATE"."EVALUATIONID")
Now, my tables that were created do have the fields Evalute, and
EvaluationID, but why is CodeCharge attempting to insert SCOTT inside when
scott is simply my login name? Is there any reason for this? I only have two
fields to fill in, not three.
Can anyone explain to me how to successfully retrieve records that have
already been inserted into the database prior to using codecharge and why is
it so that the scott value is there?
Thanks!
|
|
|
 |
Rogers D. Stephens
|
| Posted: 03/20/2002, 5:53 AM |
|
I'm using CodeCharge w/ JSPs and Oracle and have it working. I will
post a link to my ccs project file later today. I'm using the Oracle
JDBC thin driver and (I believe) the odbc driver for development mode.
Oracle qualifies tables by owner user id (which can be a good thing)
which is where scott is coming from. This error and subsequent
qualification to the scott user is coming from oracle not cc.
Marilyn Miers wrote:
>
> Dear codecharge and kind helpers all around,
>
> Hello there! I've (finally) connected to my Oracle database and the final
> hour was near. But alas, when i Compiled my JSp files, the grids appeared,
> the titles appeared, but the data was not retrieved. Checked through SQLPlus
> and the data has been successfully inserted via .sql files prior to
> compiling the code (eg. select * from Endorse; does return the 2 values i
> inserted into the table using an sql file with isnert stables and successful
> row inserted messages ). Back to the JSP file, which has been properly
> connected to attempt to retrive values from Endorse for editing...and
> nothing appears. Just a "NO RECORDS" thingy.
> When I attempt to insert a new record into the table, it successfully
> appears.! But only the newly inserted record shows, not the previously
> inserted ones. As in for example...
>
> Current database has ID1, value= Yes. ID2, value=No. When i compile the JSp
> i see neither of these. But i can insert ID3, value=Maybe and when the page
> refreshes, ID3 does appear in the Grid, but the other two don't.!
>
> Checking throguh SQLplus, the new record has been added successfully. And
> all 3 records from ID 1 to 3 are there.
>
> Now when i try to experiment around by making the ID field in the RECORD JSP
> a hidden field, i get the following error (i.e. I'm supposed to get an error
> becasue the ID field is a NOT NULL value, so i just wanted to get the error
> to see what was wrong)
>
> And the error was weird. it had
> java.sql.SQLException: ORA-01400: cannot insert NULL into
> ("SCOTT"."EVALUATE"."EVALUATIONID")
>
> Now, my tables that were created do have the fields Evalute, and
> EvaluationID, but why is CodeCharge attempting to insert SCOTT inside when
> scott is simply my login name? Is there any reason for this? I only have two
> fields to fill in, not three.
>
> Can anyone explain to me how to successfully retrieve records that have
> already been inserted into the database prior to using codecharge and why is
> it so that the scott value is there?
>
> Thanks!
|
|
|
|
|
