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

Thx
Ronny
 _______________________________________________
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