I’m using IS 6.1 JDBC adapter 6.0.3. When trying to enable a notification to a SQL Server table with user-defined datatypes, I get the following error message:
[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification utils:OASySEventsNotifications.
[ADA.1.316] Cannot execute the SQL statement “CREATE TABLE WMBbafeg2d (time GMTtime, type nameType(15) NULL, host nameType(15) NULL, dbName nameType(15) NULL, ptName nameType(15) NULL, rtuName nameType(15) NULL, message msgType(131), sevInt tinyint NULL, wm_rowid numeric(9) identity, wm_sendTime numeric(14))”. "
(HY000/2716) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Column or parameter #2: Cannot specify a column width on data type nameType."
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Column or parameter #2: Cannot specify a column width on data type nameType.
The nameType user-defined data type is based on varchar. The funny thing is that when we create a notification using a dummy table with varchar instead of the user-defined data types, we have no problems. Anybody have suggestions?