• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Microsoft Plugin Weirdness
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Microsoft Plugin Weirdness


  • Subject: Re: Microsoft Plugin Weirdness
  • From: Mike Schrag <email@hidden>
  • Date: Thu, 19 Feb 2009 16:50:15 -0500

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@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

_______________________________________________ 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



_______________________________________________ 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


_______________________________________________
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


References: 
 >Re: Microsoft Plugin Weirdness (From: Dov Rosenberg <email@hidden>)
 >Re: Microsoft Plugin Weirdness (From: David Avendasora <email@hidden>)

  • Prev by Date: Re: OT: Drew Davidson
  • Next by Date: Re: OT: Drew Davidson
  • Previous by thread: Re: Microsoft Plugin Weirdness
  • Next by thread: Re: Microsoft Plugin Weirdness
  • Index(es):
    • Date
    • Thread