Ionut Putinei

Greenhorn
+ Follow
since Oct 11, 2009
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Ionut Putinei

HI,

Can e servlet or jsp that does someting in database(dml) be written in such a manner that i can identify from database the source of the sql?

thanks


hi

i am trying to insert some values in a table:
table definition:



CREATE TABLE "JOHN"."ARTICOLE" ( "ART_NO" NUMBER(6), "DESCR" VARCHAR2(30) NOT NULL , "DEPT_NO" NUMBER(1), "SUPPL_ID" NUMBER(6), "LAST_REC_DAY" DATE, "LAST_SALE_DAY" DATE, "SELL_PR" NUMBER(10, 2), CONSTRAINT "ARTNOCHECK" CHECK (ART_NO>0) VALIDATE , CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPT_NO") REFERENCES "JOHN"."DEPARTMENT" ("DEPT_NO") VALIDATE , PRIMARY KEY ("ART_NO") VALIDATE ) TABLESPACE "USERS" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

when i press a button it supose to do:

public String button1_action() {
if (articoleDataProvider.canAppendRow()) {
try {
RowKey rowKey = articoleDataProvider.appendRow();
articoleDataProvider.setCursorRow(rowKey);
articoleDataProvider.setValue("ARTICOLE.ART_NO",
rowKey, codArt1.getText());
articoleDataProvider.setValue("ARTICOLE.DESCR",
rowKey, denumireArt1.getText());
articoleDataProvider.setValue("ARTICOLE.DEPT_NO",
rowKey, numarDept1.getText());
articoleDataProvider.setValue("ARTICOLE.SELL_PR",
rowKey, sellPr1.getText());
articoleDataProvider.commitChanges();

} catch (Exception e) {
error("NU am putut adauga articolul: " + e);
articoleDataProvider.refresh();
return null;
}
} else {
error("Cannot append trip types");
return null;
}
//clear fields
codArt1.setText(null);
denumireArt1.setText(null);
numarDept1.setText(null);
sellPr1.setText(null);
return null;
}

thw first error i get is that i cant insert into field art_no: java.lang.IllegalArgumentException: ARTICOLE.ART_NO

thank you
14 years ago
JSF
Hi,

Can you plese tell how to get started with jsf programming?Do i need to learn other stuffs before jumping into this?
I study myself without help from teacher/instructor.Currently i am studying jsp,servlet and jdbc


Thanks

Ionut

14 years ago
JSF