Application Server Solutions for Microsoft IIS and ASP.NET
       solutions   products   partners   company   support   downloads         store
BlueDragon Self-Help: FAQ
Back to Search >  Back to Search Results

Faq ID 131
Product JTurbo
Category ResultSet
Question I am trying to use JTurbo JDBC Driver to select a column whose SQL Data Type is uniqueidentifier but the value I get when I call getString() on the ResultSet is not correct. What is wrong?
Answer Let's say that your uniqueidentifier as shown in MS SQL Server Enterprise Manager is:
{78BEF5D8-1FB0-4223-89BF-C153BD7122FC}

If your java code is instead getting something like:
D8F5BE78B01F234289BFC153BD7122FC

Then the problem is that you need to set the sql70 option flag to true in your JDBC URL

If your java code is instead getting something like: 78bef5d8-1fb0-4223-89bf-c153bd7122fc
(i.e. missing the leading and trailing curly braces, and all lower case)
Then this was a bug in JTurbo and it was fixed in JTurbo 3.0b2



   
company media information terms of use privacy policy contact us