Ler Ping
|
| Posted: 03/20/2002, 4:09 AM |
|
Dear Codecharge,
I've searched your website for answers to this issue but most of them
pertain only to PHP. I'm using JSP with Oracle
I have a problem with JSP and Oracle. No data is displayed when I create a
page with codecharge. When I check to see if there are values in the
associated table using SQLPLus, there are the inserted values showing. The
only problem is that codecharge seems to be unable to extract the data from
the database for display. When I insert data via the generated page, the
data inserts successfully and shows up both on the codecharge generated page
and on the SQLPlus SQL selects statements along with the previously inserted
data via .the traditional INSERT statements keyed in manually. The JSP pages
just can't seem to display data that i have inserted in manually using SQL
lines.
Here are the statements I used to create table and insert data (* note. I've
already tried taking away dashes, adding quotation marks. Anything that
allows insertion like ID 3 can be inserted with 3 or '3', etc)
Create table AccessSSS
(
AccessSSS number(5) NOT NULL,
AccessRole varchar2(100) NOT NULL,
Primary Key (AccessSSS)
);
INSERT INTO AccessSSS ( AccessSSS, AccessRole )
VALUES ( '1', 'Member' );
INSERT INTO AccessSSS ( AccessSSS, AccessRole )
VALUES ( '2', 'Leader' );
So the values are there, but the jsp files don't show records that have
not been inserted via codecharge jsp files.
Yours,
Ler Ping
Help me out here please :C
|
|
|
 |
Adam Stock
|
| Posted: 03/20/2002, 11:32 AM |
|
Hi Ler,
We have users who generate JSP and use Oracle and I'm assuming that
everything works fine for them.
I recommend that you contact our support at http://support.codecharge.com
and provide information on your exact environment:
Which Java application server are you using? Which OS?
Adam
"Ler Ping" <mimaclit69@hotmail.com> wrote in message
news:a79u4l$scj$1@news.codecharge.com...
> Dear Codecharge,
>
> I've searched your website for answers to this issue but most of them
> pertain only to PHP. I'm using JSP with Oracle
>
> I have a problem with JSP and Oracle. No data is displayed when I create a
> page with codecharge. When I check to see if there are values in the
> associated table using SQLPLus, there are the inserted values showing. The
> only problem is that codecharge seems to be unable to extract the data
from
> the database for display. When I insert data via the generated page, the
> data inserts successfully and shows up both on the codecharge generated
page
> and on the SQLPlus SQL selects statements along with the previously
inserted
> data via .the traditional INSERT statements keyed in manually. The JSP
pages
> just can't seem to display data that i have inserted in manually using SQL
> lines.
>
> Here are the statements I used to create table and insert data (* note.
I've
> already tried taking away dashes, adding quotation marks. Anything that
> allows insertion like ID 3 can be inserted with 3 or '3', etc)
>
> Create table AccessSSS
> (
> AccessSSS number(5) NOT NULL,
> AccessRole varchar2(100) NOT NULL,
> Primary Key (AccessSSS)
> );
>
> INSERT INTO AccessSSS ( AccessSSS, AccessRole )
> VALUES ( '1', 'Member' );
>
> INSERT INTO AccessSSS ( AccessSSS, AccessRole )
> VALUES ( '2', 'Leader' );
>
> So the values are there, but the jsp files don't show records that have
> not been inserted via codecharge jsp files.
>
> Yours,
> Ler Ping
> Help me out here please :C
>
>
|
|
|
|
RonB
|
| Posted: 03/23/2002, 4:17 AM |
|
"Ler Ping" <mimaclit69@hotmail.com> schreef in bericht
news:a79u4l$scj$1@news.codecharge.com...
> Dear Codecharge,
>
> I've searched your website for answers to this issue but most of them
> pertain only to PHP. I'm using JSP with Oracle
>
> I have a problem with JSP and Oracle. No data is displayed when I create a
> page with codecharge. When I check to see if there are values in the
> associated table using SQLPLus, there are the inserted values showing. The
> only problem is that codecharge seems to be unable to extract the data
from
> the database for display. When I insert data via the generated page, the
> data inserts successfully and shows up both on the codecharge generated
page
> and on the SQLPlus SQL selects statements along with the previously
inserted
> data via .the traditional INSERT statements keyed in manually. The JSP
pages
> just can't seem to display data that i have inserted in manually using SQL
> lines.
>
> Here are the statements I used to create table and insert data (* note.
I've
> already tried taking away dashes, adding quotation marks. Anything that
> allows insertion like ID 3 can be inserted with 3 or '3', etc)
>
> Create table AccessSSS
> (
> AccessSSS number(5) NOT NULL,
> AccessRole varchar2(100) NOT NULL,
> Primary Key (AccessSSS)
> );
>
> INSERT INTO AccessSSS ( AccessSSS, AccessRole )
> VALUES ( '1', 'Member' );
>
> INSERT INTO AccessSSS ( AccessSSS, AccessRole )
> VALUES ( '2', 'Leader' );
>
> So the values are there, but the jsp files don't show records that have
> not been inserted via codecharge jsp files.
>
> Yours,
> Ler Ping
> Help me out here please :C
>
>
Oracle can be a bit of a hassle. I use php and odbc for designing and oci8
protocol for displaying on webserver.
The problem can be that odbc at design time works fine but the webserver
will not display the data.
Do you use the same user for design and go live stages?
If they differ you might have a grant problem. Try (in sql plus) grant
select on AccessSSS to username and do the same for update, insert and
delete (if you want those rights for the webuser) Try again to see if this
makes any difference. In my case i got Oracle to work right with php after
creating a specific user for the website (for example user: web) and then
giving select grants to that user for each table I needed on the intranet
pages. After this everything went fine. I now use the same user for design
and live stages to make sure I can acces the tables live that I choose in
design.
This might sound stupid but do you commit after inserting via sql plus? The
problem is you can acces the data in sqlplus but it wont show up on your
pages until you do a commit in sql plus. Only then the data will be
available via the database.(I'm sure you did this but sometimes the solution
is so simple we tend to overlook it 
When you do an insert via the generated page this is not a problem because
it will commit automatically after the completed insert statement.
RonB
|
|
|
|
|
