Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updation error while using a foreign data source

428416Nov 8 2004 — edited Nov 9 2004

Hi All,

I am trying to connect to SQL server 2000, from my BC4J driven swing application. i am using Oracle containers for Java (Development Suite)

Going by the steps detailed in
"SQL Server Walkthrough" on OTN, i have tested with two drivers:
1) Microsoft SQL Server 2000 JDBC driver
2) DataDirect JDBC driver.

In both the cases, the resulting application runs well for inserts and deletes, but FAILS WHILE UPDATION.

The following error is displayed while using the datadirect for updates.

(oracle.jbo.DMLException) JBO-26041: Failed to post data to database during "Update": SQL Statement " UPDATE dbo.BR_CATEGORY BrCategory SET CATEGORY_NAME=? WHERE CATEGORY_CODE=?".
----- LEVEL 1: DETAIL 0 -----
(java.sql.SQLException) [DataDirect][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near 'BrCategory'.

A similar errror is displayed for the Microsoft JDBC driver as well.

What could be the cause?
Thanks,
Sumit

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2004

Added on Nov 8 2004

#application-development-in-java, #jdeveloper-and-adf

5 comments

174 views