[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [xmlblaster] XmlBlaster and Firebird - last problem

Hi Chris,
great that you managed this !


chris lau wrote: 
Okay, I got my java applet working and getting the msgs passed from the
xmlBlaster server.

However, when I look at the status messages from the xmlBlaster window, I get these
errors:

[16-Jun-2005 10:00:32 AM ERROR XmlBlaster.SubjectEntryShuffler MsgQueueUpdateEnt
ry-subject:/node/xmlBlaster_192_168_219_205_3412/client/specialist104/NORM/11189
41231826000001/specialist104] incr=-1 to 'subject:/node/xmlBlaster_192_168_219_2
05_3412/client/specialist104' raised an exception: errorCode=resource.db.unknown
 message=#1.0.2 An unknown error with the backend database using JDBC occurred -

http://www.xmlblaster.org/xmlBlaster/doc/requirements/admin.errorcodes.listing 

.html#resource.db.unknown : org.firebirdsql.jdbc.FBSQLException: GDS Exception.
335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 74
blob

You should set 'blobVarName' to whatever is not a reserved word and 'blob' to the name which is used for blobs in Firebird. Once you get this right you should not get the mentioned error message.

The error message is coming from xmlBlaster and includes the error returned from Firebird
database. Firebird is complaining about an unknown column (blob). In my properties file, I
specified that the blobvarname as something else (because blob is a reserved word in Firebird).
In any event, I don't know which java code is generating this sql statement as I would like to
know what the statement actually is.

The weird thing is that, when I look at the XB_ENTRIES table, all of the TOPIC_XML, UPDATE_REF,
and MSG_XML entries that were related to this session (specialist104) are gone... and I have
confirmed that the msgs were passed successfully.


It could be that you get the correct content because it is retreived from the cache.

You can actually check the code. Basically all jdbc stuff related to the queues is in the package org.xmlBlaster.util.queue.jdbc and the class is

JdbcManagerCommonTable.java

Regards
Michele



	

Can anyone help?

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com