JSP and database

Hi all

I know the basic of JSP and how to access database for a single table. But I have to write a JSP program which can access 40 tables and if I want to insert, update and delete from one table, the same would take place in all columns which are present in another table. I want to know how to do it and I would really appreciate if anybody provides me source code or any link that will help me. For this I am using tomcat-4.1.31 and oracle 9i.

Thanks in Advance

Regards

Vijai

[511 byte] By [kvijaia] at [2007-10-2 4:47:56]

«« ImageReader.getImageTypes() incorrect
»» java.lang.NoClassDefFoundError

# 1

You could try using stored procedures within oracle. Then only make one call from jsp. That way you can also make sure you have a correct SQL transaction end to end.

floriana at 2007-7-16 0:52:41 >

top of Java-index,Enterprise & Remote Computing,Web Tier APIs...

# 2

thanx florianactually i was told to make an API in JSP which can be used for this purpose. Is it not possible on this way? thanxvijai

kvijaia at 2007-7-16 0:52:41 >

# 3

yes that of course is another way.

floriana at 2007-7-16 0:52:41 >

# 4

hi plz help me i am waiting for reply

kvijaia at 2007-7-16 0:52:41 >

# 5

I dont know how Oracle works with regard to enforcing referential integrity, you may well find a way to get Oracle to do this for you. Otherwise you are going to need to write all the sql yourself. If you are stuck with sql have a look at http://www.w3schools.com/sql/default.asp

angrycata at 2007-7-16 0:52:41 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

JSP and database

Enterprise & Remote Computing New Topic

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified