This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello: Using a two almost identical queries and one generates an 'ORA-01460 unimplemented or unreasonable conversion requested' Exception while the other works fine. The two queries are: // 1st query // 2nd query If I replace the 1st query with a copy of the 2nd, the problem goes away. Odd huh? Also, if I replace the 1st query with: _collection = uow.Collections.First(); // Works For now, I can continue to prototype but is there anything I'm doing wrong? The SQL generated by the logger runs fine in all cases and returns the appropriate collection. |
|
|
Some additional information, just noticed that if I change the 1st query to any collection that has zero entries it works. // i.e. However, if the collection actually contains collection entries ( a related table ) then I get the ORA-01460 error. |
|
|
Hi Matthew, Can you post a sample of the SQL which is being generated which is causing the error?
Thanks, Jeremy |
|
|
Hi, sorry for the delay, it's a long weekend here and had the SQL at the office. I had to rename the tables and some of the fields because there is some proprietary information in there but otherwise tables and columns are all the same type and size. If the error can't be reproduced then I'll try getting approval for the exact SQL we're using. As for the setup, the Collections, People, and Locations tables are all dervied classes of Object using your SingleClassInheritance feature. The discriminators as 1 for People, 2 for Locations, 3 for Collections. CollectionEntries does not derive from Objects. Since the FK relationship and inheritance results in two paths to CollectionEntries I called the relationship from Collections to CollectionsEntries, CollectionEntries and the relationship from Objects to CollectionEntries, ObjectEntries. Hopefully, that's not too confusing, otherwise tomorrow I can send a screenshot of my model. To summarize it appears that uow.Collections.Where( collection => collection.Name.Equal( "Something" ) ).Single() only throws the exception when the uderlying Collections actually has entries. |
|
|
Thanks for the additional info and the table definitions; What we do need however is to get a dump of the SQL text which LightSpeed is generating which is causing the error - you can get this by setting the Logger property on the UnitOfWork (e.g. attach a ConsoleLogger or TraceLogger and capture the output in an interactive debugging session) and then send this through. If the details are sensitive please feel free to email this through to me at jeremy @ the obvious domain name.
Jeremy |
|
|
Hi Jeremy: I'll e-mail you the SQL dump tomorrow. I had ran it a few times in SQLPlus and it was valid so wasn't sure if it was an Oracle issue or LightSpeed.
|
|