Just an FYI, I'm lying. I was accessing the wrong table (instead of the
duplicate). I knew I had to be committed.
Trenton D. Adams
Systems Analyst/Web Software Engineer
Navy Penguins at your service!
Athabasca University
(780) 675-6195
:wq!
----- "Trenton D. Adams" <[EMAIL PROTECTED]> wrote:
> Hi Guys.
>
> I have a basic update like so...
> <update id="updateStudent" parameterClass="java.util.Map">
> UPDATE system.tmpk_charset
> SET spriden_last_name = #lastName#,
> spriden_first_name = #firstName#
> WHERE spriden_id = #studentID#
> </update>
>
> I have a basic transaction manager like so, where the destination.url
> is in database.properties...
> <transactionManager type="JDBC" commitRequired="i set this to true
> or false with no affect">
> <dataSource type="SIMPLE">
> <property name="JDBC.Driver"
> value="oracle.jdbc.driver.OracleDriver"/>
> <property name="JDBC.ConnectionURL"
> value="${destination.url}"/>
> <property name="JDBC.Username" value="user"/>
> <property name="JDBC.Password" value="pass"/>
> </dataSource>
> </transactionManager>
>
> I have code like so...
> List<Student> students =
> sourceMapper.queryForList("getStudents", null);
>
> Map parameters;
> parameters = new Hashtable();
> for (Student student: students)
> {
> parameters.clear();
> parameters.put("studentID", student.getStudentID());
> parameters.put("firstName", "Bob");
> parameters.put("lastName", "Bob");
> destinationMapper.startTransaction();
> destinationMapper.update("updateStudent",
> parameters);
> destinationMapper.commitTransaction();
> System.out.println("spriden_id: " +
> student.getStudentID());
> System.out.println("spriden_first_name: " +
> student.getFirstName());
> System.out.println("spriden_last_name: " +
> student.getLastName());
> }
>
> And guess what, the students are not having their first and last names
> set to "Bob". Why? FYI: If I try and insert a value to large for the
> column, it fails miserably (ORA-01401: inserted value too large for
> column), so the update is obviously running, but why is it not being
> committed? Or, perhaps it is I who needs to be committed?
>
> I would also like to use DBCP, but I'm going with SIMPLE because this
> wasn't working with DBCP either.
>
> I also tried putting transaction stuff around.
>
> Thanks.
>
> Trenton D. Adams
> Systems Analyst/Web Software Engineer
> Navy Penguins at your service!
> Athabasca University
> (780) 675-6195
> :wq!
>
> __
> This communication is intended for the use of the recipient to
> whom it
> is addressed, and may contain confidential, personal, and or
> privileged
> information. Please contact us immediately if you are not the
> intended
> recipient of this communication, and do not copy, distribute, or
> take
> action relying on it. Any communications received in error, or
> subsequent reply, should be deleted or destroyed.
> ---
