Updating oracle db using servlet
Oracle Driver #DB_URL=jdbc:oracle:thin:@localhost:1871: User DB #DB_USERNAME=scott #DB_PASSWORD=tiger package com.batch; import When I executed above programs for Oracle database, the results were in line with My SQL processing results and Prepared Statement Batch processing was much faster than any other approach. Prepared Statement.execute Internal(Prepared Statement.java:1268) at com. Prepared Statement.execute Update(Prepared Statement.java:1541) at com. Prepared Statement.execute Update(Prepared Statement.java:1455) at com. Prepared Statement.execute Update(Prepared Statement.java:1440) at com. Prepared Statement.execute Batched Inserts(Prepared Statement.java:1008) at com.Let’s see how batch programs behave in case one of the queries throw exceptions. Mysql Data Truncation: Data truncation: Data too long for column 'name' at row 2 at com. Prepared Statement.execute Batch(Prepared Statement.java:908) at com.batch. JDBCBatch Exceptions.main(JDBCBatch Exceptions.java:37) Batch Update Exception: ORA-12899: value too large for column "SCOTT"."EMPLOYEE"."NAME" (actual: 12, maximum: 10) at driver.The first method is error prone, can cause you grief if apostrophes or quotes are present in the form parameters, and opens you up to SQL Injection hacks.[ January 21, 2008: Message edited by: Ben Souther ] Hi Ben, I am using the statement in the java class, I mean in the class which is able to access the oracle database and which is updating and also retrieving the data on to the console.
Hi, Ya servlet wont have the main method , thats the reason i thought placing the code to connect the database make no difference.programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums Hi everyone, The main aim is to use Html input text, which has to go into the oracle Data base through the servlet and create a table with different columns corresponding To the texts entered in the html and the output should be in the Jsp with the data inside the tables of the oracle database.What I did , I created a servlet and through the servlet I can connect the oracle database and create the tables and can retrive the data on the console.Try Googling for "JDBC Tutorial Prepared Statement" to find tutorials and example code.
[ January 21, 2008: Message edited by: Ben Souther ] Or learn about Prepared Statements.
But I want to connect through the Html to oracle through servlet and output in Jsp and I am using all this in eclipse and the server is tomcat.