AnsweredAssumed Answered

Invalid ID returned in JDBC query

Question asked by joe.ruth on Feb 5, 2015
Latest reply on Feb 6, 2015 by joe.ruth

Hi,

 

I am querying JDBC, with multiple queries joining on IDs (GUID).  The class coming back in Java is UUID, and often does not match the GUID displayed doing the same query in OLEDB.  E.g., I have a query for EventFrameTemplates.

 

Results from OLEDB (query: SELECT ID, Name FROM [Production].[EventFrame].[EventFrameTemplate])


 

dfa8cf6a-5b13-451d-b572-f31f8fd1def2Procedure
ead41c27-e6ca-4087-b3f9-6353d0703b2aUnitProcedure
edcbd122-4246-4ae1-9b90-8a02038a3fe5Operation
0f9b117b-a4fd-4722-a134-2e3c0e58ed0ePhase
856f9986-422f-42e8-b86c-cdc6c1356470PhaseState
bec56cc4-d8fb-4e12-a709-e2506348641ePhaseStep

 

Results from JDBC with catalog set to "Production" (query: select ID, Name from EventFrameTemplate)

 

dfa8cf6a-5b13-451d-b572-f31f8fd1def2Procedure
ffffffff-e6ca-4087-b3f9-6353d0703b2aUnitProcedure
edcbd122-4246-4ae1-9b90-8a02038a3fe5Operation
ffffffff-a4fd-4722-a134-2e3c0e58ed0ePhase
856f9986-422f-42e8-b86c-cdc6c1356470PhaseState
ffffffff-d8fb-4e12-a709-e2506348641ePhaseStep

 

Rows 2, 4, and 6 all start with "ffffffff" which is incorrect.  If I do a JDBC of "select ID from EventFrameTemplate where ID = 'ead41c27-e6ca-4087-b3f9-6353d0703b2a'", it returns the "ffffff..." value.

 

Thanks for any help!

Outcomes