3 Replies Latest reply on Jan 20, 2004 8:31 AM by dvasaturo

    Sybase PersistenceManager

    stevemccoll Newbie

       

      "steve_mccoll" wrote:
      Hi,

      I'm trying to setup a JDBC persistance manager for my queues, and the database we will use is a Sybase database. Therefore, the statement (taken from hsqldb-jdbc-service.xml) ...

      INSERT_MESSAGE = INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION,MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)

      ...poses a problem - in Sybase I believe you need to create the row and retrieve a pointer to your blob, which you then update. You can't pass it in an insert statement unless the size of the blob is less than 1,200 bytes (this will not be the case) or pass a blob as a stored-proc parameter.

      Either way, this would require 2 statements for the insert of a message and looking at the code this doesn't look do-able.

      Does anyone know of a way to do this ?

      Many thanks,
      Steve

      ps - Just in case, running JBoss 3.2.2 on Win 2000, JDK 1.4.2