• 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: The conversion from binary to TIMESTAMP is unsupported.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: The conversion from binary to TIMESTAMP is unsupported.

  • Subject: Re: The conversion from binary to TIMESTAMP is unsupported.
  • From: Ronny Bubke <email@hidden>
  • Date: Thu, 26 Feb 2009 10:11:28 +0100
The database type is timestamp. if i used datetime it will work but timestamp can't be mapped to an java type. i suppose this is a problem of microsofts jdbc plugin and it can on be fixed by using an other all working plugin.

Ronny

On Wed, Feb 25, 2009 at 8:20 PM, Chuck Hill <email@hidden> wrote:

On Feb 25, 2009, at 2:16 AM, Ronny Bubke wrote:

Hello,

maybe somebody can help me with using MS SQL SERVER 2008 and datatype "timestamp".

I get following Exception when fetching Entity with an attribute of type "timestamp":

Error:
The conversion from binary to TIMESTAMP is unsupported.

What type is that column in the database?  I looks like it is defined as some binary type.


at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.DTV.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getTimestamp(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getTimestamp(Unknown Source) at com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:292) at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) at com.webobjects.jdbcadaptor.JDBCChannel.fetchRow(JDBCChannel.java:1462) at com.webobjects.eoaccess.EODatabaseChannel._fetchObject(EODatabaseChannel.java:321) at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3071) at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3204) at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:483) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4053) at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1114) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4428) at de.rheinmainclick.rmc.eo._Dictionary.fetchDictionaries(_Dictionary.java:585) at de.rheinmainclick.rmc.eo._Dictionary.fetchDictionary(_Dictionary.java:594) at de.rheinmainclick.rmc.eo._Dictionary.fetchDictionary(_Dictionary.java:590) at de.rheinmainclick.rmc.eo.Lookup.getMasterImageLookup(Lookup.java:34) at de.rheinmainclick.DirectAction.editActorAction(DirectAction.java:32) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.webobjects.appserver.WODirectAction.performActionNamed(WODirectAction.java:144) at er.extensions.appserver.ERXDirectAction.performActionNamed(ERXDirectAction.java:335) at com.webobjects.appserver._private.WOActionRequestHandler._handleRequest(WOActionRequestHandler.java:259) at com.webobjects.appserver._private.WOActionRequestHandler.handleRequest(WOActionRequestHandler.java:161) at er.extensions.appserver.ERXDirectActionRequestHandler.handleRequest(ERXDirectActionRequestHandler.java:123) at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1678) at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:1737) at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:1702) at de.rheinmainclick.Application.dispatchRequest(Application.java:28) at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144) at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226) at java.lang.Thread.run(Thread.java:637)

Reason:
The conversion from binary to TIMESTAMP is unsupported.

I tried all NSCalenderDate value types but nothing changes. Maybe the jdbc plugin is not usable for sql server 2008.

Hopefully somebody can help me.


I have only used SQL Server 2005.  For that I use this prototype as the timestamp definition:






Chuck


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










--
Ronny Bubke
Winterhuder Marktplatz 17
22299 Hamburg
Tel - +49 40 / 23549023
Mobil - +49 176 / 21198774
 _______________________________________________
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
  • Follow-Ups:
    • Re: The conversion from binary to TIMESTAMP is unsupported.
      • From: Chuck Hill <email@hidden>
References: 
 >The conversion from binary to TIMESTAMP is unsupported. (From: Ronny Bubke <email@hidden>)
 >Re: The conversion from binary to TIMESTAMP is unsupported. (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Hibernate
  • Next by Date: Re: Why do Dynamic Elements get values from enclosing component in takeValuesFromRequest?
  • Previous by thread: Re: The conversion from binary to TIMESTAMP is unsupported.
  • Next by thread: Re: The conversion from binary to TIMESTAMP is unsupported.
  • Index(es):
    • Date
    • Thread