shibpid Table used by the Stored ID Data Connector in SQLSrvr
I can't create the shibpid table in SQL Server using the examples provided in the documentation.
CREATE TABLE shibpid
localEntity VARCHAR2(1024) NOT NULL ENABLE,
peerEntity VARCHAR2(1024) NOT NULL ENABLE,
principalName VARCHAR2(255) NOT NULL ENABLE,
localId VARCHAR2(255) NOT NULL ENABLE,
persistentId VARCHAR2(36) NOT NULL ENABLE,
SQL Server doesn't allow two timestamp datatype columns, I tried changing one to datetime but now I'm receiving this error in idp-process.log
ERROR [edu.internet2.middleware.shibboleth.common.attribute.resolver.provider.dataConnector.StoredIDDataConnector:205] - [TP-Processor3:] - Database error retrieving persistent identifier
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.
How should the shibpid table be structured in SQL Server so I can use it for the Stored Data Connector.
HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you.