Nhibernate 3.2 doesnt work related the Parameter names
Nhibernate 3.2 doesnt work related the Parameter names
Nhibernate 3.2 was just released and I was using it and found it doesnt work with the devart oracle driver anymore and I found it was related to the ParameterName field in the parameter. in a sqlstatement you will have paramters defined with a ":" , ie :P0 and if you create a new devart oracle parameter and pass in the name as ":P0" , then if you read it back it returns "p0" so it strips off the ":" . Unfortuantly this can cause some problem with nhibernate because it needs to look up parameters in the parameters collection by name and its looking for ":P0" because thats what it gave you when it created it but you are returning "P0" so it never finds the parameter and you end up with and error saying "not all paremters defined".
I wasnt sure who to blame for this but since the sqlserver pametername returns its prefix, ie "@p0" shouldnt you return the oracle prefix too ":p0" ? Also, have you noticed any problems with your driver and nhibernate 3.2?
let me know anyhow.
thanks
scott
I wasnt sure who to blame for this but since the sqlserver pametername returns its prefix, ie "@p0" shouldnt you return the oracle prefix too ":p0" ? Also, have you noticed any problems with your driver and nhibernate 3.2?
let me know anyhow.
thanks
scott
A similar issue was discussed at http://www.devart.com/forums/viewtopic.php?t=21508. Please try OracleUtils.OracleClientCompatible = true; in the OCI mode (via Oracle client). We are investigating the issue with OracleUtils.OracleClientCompatible = true; in the Direct mode.
We can reproduce the ORA-01036 error only in the Direct mode. We will notify you when this issue is fixed.
As a workaround, please use the OCI mode ("Direct=false;"). If you are getting this error in the OCI mode, try to localize the issue by monitoring the SQL statement that is send to server.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html
As a workaround, please use the OCI mode ("Direct=false;"). If you are getting this error in the OCI mode, try to localize the issue by monitoring the SQL statement that is send to server.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html
You are right ... still one day left
I'm working on CoreLab 4.75 and this controls have the same problem with Nh 3.2 - it's obvious. But I have one more problem (version 4.70 hadn't this problem) i call oracle pl-sql functions returning varchar and the results are always "some two strnge signs". Guys do you know this problem?
I have a question: do I need to buy another license to use newest dotConnect controls (released after 1 of september ) ?
Greeting
P.
I'm working on CoreLab 4.75 and this controls have the same problem with Nh 3.2 - it's obvious. But I have one more problem (version 4.70 hadn't this problem) i call oracle pl-sql functions returning varchar and the results are always "some two strnge signs". Guys do you know this problem?
I have a question: do I need to buy another license to use newest dotConnect controls (released after 1 of september ) ?
Greeting
P.
The bug with parameter names when OracleUtils.OracleClientCompatible=true in Direct mode is fixed. We will post here when the next build of dotConnect for Oracle is available for download. We plan to release it next week.
Please try the latest (6.30.202) version of dotConnect for Oracle (trial version). If the problem persists with this version as well, please send us a small test project with the corresponding DDL/DML script to reproduce the issue in our environment.JomKippur wrote:I'm working on CoreLab 4.75 and this controls have the same problem with Nh 3.2 - it's obvious. But I have one more problem (version 4.70 hadn't this problem) i call oracle pl-sql functions returning varchar and the results are always "some two strnge signs". Guys do you know this problem?
Seems like you have to renew your subcription (http://www.devart.com/dotconnect/oracle ... scriptions) to get access to the latest builds. Please contact our Sales department (sales at devart*com) to check the status of your subscription.JomKippur wrote:I have a question: do I need to buy another license to use newest dotConnect controls (released after 1 of september Smile ) ?
New version of dotConnect for Oracle 6.50 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21942 .
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21942 .
After this patch I don't have a problem in Nh3.2 but I have this problem (ORA-01036 illegal variable name/number)
using simple Ado query with parameters:
insert into TestData(a, b) values(:a, :b)
when I set: OracleUtils.OracleClientCompatible = false;
simple Ado query is ok but Nh 3.2 is wrong ...
Why I have to use this setting: OracleUtils.OracleClientCompatible =true;?
thanks
JK
using simple Ado query with parameters:
insert into TestData(a, b) values(:a, :b)
when I set: OracleUtils.OracleClientCompatible = false;
simple Ado query is ok but Nh 3.2 is wrong ...
Why I have to use this setting: OracleUtils.OracleClientCompatible =true;?
thanks
JK
JomKippur, we have answered you at http://www.devart.com/forums/viewtopic.php?t=22037.