[eclipselink-users] Exception inserting into Sybase AsE TEXT field

[cmathrusse <Christopher.Mathrusse@xxxxxxxxxx>]

EclipseLink version:  1.1.1
Sybase ASE 15. 
Table is defined as follows:

CREATE TABLE DOCSTORE (ID NUMERIC(19) IDENTITY NOT NULL, CONTENT TEXT NULL,
MOD_DATE DATETIME NOT NULL, CREATE_DATE DATETIME NOT NULL, VERSION INTEGER
NOT NULL, PRIMARY KEY (ID));

Entity is defined as follows:

public class DocStore implements Serializable {
  private static final long serialVersionUID = 5064345696140435452L;

  @Id @GeneratedValue( strategy = GenerationType.IDENTITY )
  @Column(
        name       = "ID",
        nullable   = false,
        updatable  = false
  )    
  private Long id;

  @Lob 
  @Column( name="CONTENT", nullable = true )
  private String content;

  @Column( name = "CREATE_DATE", nullable = false )
  @Temporal( javax.persistence.TemporalType.TIMESTAMP )
  private Calendar createDate;
  
  @Column( name = "MOD_DATE", nullable = false )
  @Temporal( javax.persistence.TemporalType.TIMESTAMP )
  private Calendar modDate;
  
  @Column( name = "VERSION", nullable = false )
  @Version
  private int version;
  
I am able to perform inserts successfully into this table consistently. The
data being inserted into the CONTENT field is always XML. I am having a
consistent problem inserting into this table, each night, when I attempt to
insert a document that is approx. 650 lines of formatted XML. I've tried the
insert using DB Visualizer, using the generated INSERT statement and it
succeeds, so I don't know why it is not working each night when EclipseLink
attempts the insert. 

The Exception message is as follows:
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Procedure
*ss1168273573_2036800886ss* expects parameter @p0, which was not supplied.

	at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
	at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
	at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
	at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:758)

I have no idea why a store proc is being invoked as my database has none. 
Any help is greatly appreciated.

Thanks....
-- 
View this message in context: http://www.nabble.com/Exception-inserting-into-Sybase-AsE-TEXT-field-tp23746802p23746802.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.