Performing Inserts, Updates, and Deletes tutorial on Oracle database
Noticed quite a few threads on this. Tried the tutorial on oracle database. The workaround was simple. To exclude the table name
firstPersonId = personDataProvider.getValue("PERSON.PERSONID");
personDD.setSelected(firstPersonId);
Instead:
personDD.setSelected(personDataProvider.getValue("PERSONID"));
The following has the tutorial zip files for different databases (including oracle)
Flavors of CRUD Tutorial projects against all Supported Databases
http://blogs.sun.com/sakthi/
[529 byte] By [
Rradhikaa] at [2007-11-27 2:23:16]
# 2
I am assuming you have some sort of integer Primary key in your oracle (9i?) tables.. e.g. Oracle: (create table abc (myID not null Integer, etc..)
If so, what did JSC 2.1 show as the "myID" datatype...was it "BigDecimal"
I am still unable to get the CIUD tutorial to work w/Oracle ... every thing works except the insert.. I get this "...BigDecimal error..
Your response and Any help would be greatly appreciated.
Thanks
# 4
Does the environment that is working fine include Oracle or Derby?
The CUID Tutorial using the app server and derby work ok..
It is when the I switch data providers to oracle that causes the "add" to fail..
I have not deployed to SJSWS 7.x... maybe I should try it...
Let me know which combination is working fine.
Thanks
...
# 5
sir i am also use oracle 10g and fasing same problem "BigDecimal"
i have column sno that datatype number but in Sun Java Studio Creator i see property that show "BigDecimal"
not show number
my main problem is
i want pass parameter in sessionbeans query such as my user give data in textbox,listbox,checkbox i replace that value in variable either integer,string,number and pass in sessionbean query
please give me idea how i pass my user input in query as parameter
your response and Any help would be greatly appreciated.
Thanks
thank's
aamir
