Re: [xmlblaster] Microsoft SQL Server

[Michele Laghi <laghi at swissinfo.org>]

Hi Peter,
it seems that there is a problem in defining String as Text for the 
nodeId. Try to configure as follows:

jdbcDriver.mapping[MySQL]=string=varchar(128),longint=bigint,int=int,boolean=char(1),blob=blob

that is change 'text' to 'varchar(128)'. It seems that text is handled 
as blob by mySql.

Saluti
Michele


Peter Bennett wrote:
> Greetings Michele
>
> This is the first one I have run into...
> Will keep working on it over the weekend and see what I can make go...
>
> org.xmlBlaster.engine.msgstore.cache.PersistenceCachePlugin-msgUnitStore:xmlBlaster_192_168_44_1_3412/__sys__UserList] 
> could not initialize the persistent queue. Is the JDBC Driver jar file 
> in the CLASSPATH ? Is the DB up and running ?XmlBlasterException 
> errorCode=[resource.db.unknown] serverSideException=true 
> node=[xmlBlaster_192_168_44_1_3412] 
> location=[JdbcManagerCommonTable.tablesCheckAndSetup] message=[An 
> unknown error with the backend database using JDBC occurred : 
> java.sql.SQLException: General error,  message from server: "BLOB column 
> 'nodeId' used in key specification without a key length"]
>
> Regards


--
Michele Laghi
mailto:laghi at swissinfo.org
tel. +46 8 7492952 / mob. +46 70 4103964
http://www.geocities.com/laghi2000
http://www.xmlBlaster.org