you would want to implement a custom ERXSQLHelper for MSSQL to provide
migration support for these types ...
ms
On Feb 19, 2009, at 4:36 PM, David Avendasora wrote:
Well, I guess this explains why I've never gotten Migrations to work
for me. I use nvarchar and ntext but couldn't get migrations to
generate those.
I never dug deep enough to figure this out. I knew it was a jdbcinfo
thing, just never tracked down where it was messed up.
Dave
On Feb 19, 2009, at 3: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
Dov Rosenberg
On 2/19/09 2:23 PM, "Chuck Hill" <[email protected]> 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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village
.
net
This email sent to [email protected]
_______________________________________________
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/webobjects%40avendasora.com
This email sent to [email protected]
_______________________________________________
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/mschrag%40mdimension.com
This email sent to [email protected]
_______________________________________________
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]
