Marilyn Miers
|
| Posted: 03/19/2002, 4:23 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!
|
|
|
 |
|
