Re: Communication Error Weblogic 10 Oracle 10 Driver

David Cloutier wrote:

> Hi, 
> We have just upgraded to from Oracle 9 to Orable 10 and are have a really
weird error when inserting in only one table: 
> 
> [BEA][Oracle JDBC Driver]Communication error: The stream provided does not
contain the number of bytes specified. 
> 
> We are using a Datasource connection from Weblogic 10 with the Weblogic
Driver.
> 
> When I use the Oracle thin driver I do not get this error.
> 
> Driver Class Name: weblogic.jdbcx.oracle.OracleDataSource
> 
> Also, this problem only occurs when I'm trying to insert into a specific
table, and we had no problems before our upgrade:
> 
> CREATE TABLE PROPERTY_VALUE
> (
>   PROPERTY_VALUE_ID  NUMBER(15)                 NOT NULL,
>   PROPERTY_KEY_ID    NUMBER(15)                 NOT NULL,
>   ENTITY_ID          NUMBER(15)                 NOT NULL,
>   PROPERTY_TYPE      NUMBER(1)                  DEFAULT 0                  
  NOT NULL,
>   CREATION_DATE      DATE                       DEFAULT SYSDATE            
  NOT NULL,
>   MODIFIED_DATE      DATE                       DEFAULT SYSDATE            
  NOT NULL,
>   BOOLEAN_VALUE      NUMBER(1)                  DEFAULT 0,
>   DATETIME_VALUE     DATE,
>   DOUBLE_VALUE       NUMBER                     DEFAULT 0,
>   LONG_VALUE         NUMBER(20)                 DEFAULT 0,
>   TEXT_VALUE         VARCHAR2(4000 BYTE),
>   BLOB_VALUE         BLOB
> )
> 
> Please help.

Hi! Please show me the config\jdbc file that represents your
DataSource. I will alter it ans send you instructions for
collecting some diagnostic logging.