Inserting Lots of Data into an Oracle Database with webMethods

, ,
1

Hi all

I have a problem that I hope someone can help me with. I need to insert a large quantity of data into an Oracle database using webMethods on Win2000. The database has several LONG VARCHAR2 fields. In the Oracle database, these fields should hold up to 2 gigabytes each, but when I try to insert the data using the webMethods $dbalias (URL is jdbc:oracle:thin:@bbe:1521:orcl) I get the following error:
Data size bigger than max size for this type: 7568

I’m wondering if the jdbc driver has some kind of data limit, and if so, how does one get around it?

Any help would be appreciated.

Nancy

2

Hi, Nancy.

You may want to read over these threads. They cover similar problems and present workarounds.

    [*]BLOBs --[url="http://www.wmusers.com/wmusers/messages/117/488.shtml"]http://www.wmusers.com/wmusers/messages/117/488.shtml[/url] [*]More on BLOBs -- [url="http://www.wmusers.com/wmusers/messages/117/941.shtml"]http://www.wmusers.com/wmusers/messages/117/941.shtml[/url] [*]Large Database Fields -- [url="http://www.wmusers.com/wmusers/messages/117/784.shtml"]http://www.wmusers.com/wmusers/messages/117/784.shtml[/url] [*]Oracle and Binary data -- [url="http://www.wmusers.com/wmusers/messages/117/1014.shtml"]http://www.wmusers.com/wmusers/messages/117/1014.shtml[/url] [/list]

    Thanks.

3

Thanks, Dan.

I did look over those postings. I don’t need to store a BLOB or CLOB of binary data, I’m just inserting text.

After some experimentation, I discovered that the thin client (jdbc:oracle:thin) is the problem. I switched to a Type 2 driver, (jdbc:oracle:oci8) and everything worked!

I didn’t need to write any java code, just set up the data record and used the pub.db:insert in the WmDB package.