On Feb 19, 2009, at 10:54 AM, Saad Laassel wrote:

We are getting the following messages shortly after our App starts up when using MSSQL:

77736 [TestScheduler_Worker-14] WARN NSLog - *** JDBCAdaptor : no type info found for nvarchar 77736 [TestScheduler_Worker-14] WARN NSLog - *** JDBCAdaptor : no type info found for nchar

We traced it down to com.webobjects.jdbcadaptor.MicrosoftPlugIn that ships with WO, more specifically the jdbcInfo method which removes the type info for those types. Does anybody why?

The *identity ones are removed as they are not compatible with EOF. I am not sure about the others, perhaps not compatible with EOF or the Java types?


Chuck


        public NSDictionary jdbcInfo() {
boolean isLogging = NSLog.debugLoggingAllowedForLevelAndGroups(2, 0L);
                NSMutableDictionary jdbcInfo = super.jdbcInfo().mutableClone();
NSMutableDictionary typeInfo = ((NSDictionary) jdbcInfo.objectForKey("typeInfo")).mutableClone();
                typeInfo.removeObjectForKey("bigint identity");
                typeInfo.removeObjectForKey("decimal() identity");
                typeInfo.removeObjectForKey("int identity");
                typeInfo.removeObjectForKey("numeric() identity");
                typeInfo.removeObjectForKey("nchar");
                typeInfo.removeObjectForKey("ntext");
                typeInfo.removeObjectForKey("nvarchar");
                typeInfo.removeObjectForKey("smallint identity");
                typeInfo.removeObjectForKey("tinyint identity");
                typeInfo.removeObjectForKey("sql_variant");
JDBCPlugIn._takeValueForKeyPath(typeInfo, "0", "money", "createParams"); JDBCPlugIn._takeValueForKeyPath(typeInfo, "0", "sysname", "createParams");
                jdbcInfo.setObjectForKey(typeInfo, "typeInfo");
                if (isLogging)
NSLog.debug.appendln((new StringBuilder("fetched MS SQL Server (")).append(databaseProductName()).append(") JDBC Info = ").append(jdbcInfo).toString());
                return jdbcInfo;
        }

Thanks,

Saad

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net

This email sent to [email protected]

--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects






_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to