Re: Microsoft Plugin Weirdness
Re: Microsoft Plugin Weirdness
- Subject: Re: Microsoft Plugin Weirdness
- From: Chuck Hill <email@hidden>
- Date: Thu, 19 Feb 2009 19:28:03 -0800
On Feb 19, 2009, at 12:31 PM, Dov Rosenberg wrote:
The ones we are most concerned with is the nchar (String), ntext
(String/clob), nvarchar (string). These are all localized strings
UTF strings you mean? I don't know why those are excluded. It might
be some historical restriction that never got removed.
Chuck
On 2/19/09 2:23 PM, "Chuck Hill" <email@hidden> wrote:
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@hidden)
Help/Unsubscribe/Update your Subscription:
.
net
This email sent to email@hidden
--
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden