Devart Forums

Hello,

1) MySqlDependency will use only the first column if a table has several timestamps columns. In this case a hash will be calculated on the first timestamp column and this hash will be compared to the previous value.

2) I'm afraid, you need to load the whole table, as MySqlDependency doesn't track the updated data itself. It can just notify that the table has been changed.

Regards,
Alexey.

Hello again,

Please follow these steps to remove Core Lab policy files:
- open Windows Explorer;
- navigate to %windows%assembly folder
- find policy files that has Core Lab in its name, like
policy.3.55.CoreLab.Oracle
- press Delete button on this file (or right mouse click -> Uninstall)

Regards,
Alexey.

Hello Miguel,

I have received the code example. We are investigating the problem.
Could please check whether the issue is reproducible with the latest version of OraDirect .NET?
There were crucial changes and many fixes in 3.** and 4.** versions.

Yesterday we have purchase version 4.70 for framework 1 and apply this new version for the application that has memory leaks.

Is the bug fixed in the new version?

Can we have installed version 3.55 for .net2 and 4.70 for .net1.1 at the same time in the server?

Yes, you can. It is recommended to remove any OraDirect .NET policy files from GAC.
Example of CoreLab policy file name in GAC policy.3.55.CoreLab.Oracle

Regards,
Alexey.

Well, actually both approaches are fine.
If you will use connection pooling there won't be much overheads,
as the physical connections are not closed for some time span (10 to 40 seconds).
It's likely the main problem is in the unlocked method:
q.Execute(query)
If several threads execute this method simultaneously, you will definitely see the network error.

Hello,

Please specify the full version of OraDirect .NET you are using.
All results available after invoking GCHandle.Alloc(, GCHandleType.Pinned) are stored in one place inside a cursor or a reader.
CoreLab.Oracle.OracleLoader has its own place of storage.
These resources are freed as the reader is closed.
It's likely that the memory size is made excessively large by some unclosed OracleDataReaders.
Do you use cursors that are returned as a procedure or script parameter?
Probably we have a problem here. Could you please send me (alexeyman*crlab*com) a small sample project to demonstrate the problem?
The CoreLab.Oracle.OracleObjectBase.Finalize() method in OraDirect .NET 3.55.26 catches all exceptions and nothing should be left.

Regards,
Alexey.

Hello,

What CF do you use?
Please send me (alexeyman*crlab*com) a small test project to
reproduce the problem.
It is desirable to use 'test' schema objects, otherwise
include the
definition of your own database objects.
If it is impossible for you to create the test project, send
us a piece of
your code where the error occurs or describe steps to
reproduce the problem.

Regards,
Alexey.

Please send me (alexeyman*crlab*com) a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs or describe steps to reproduce the problem.
What is the version/edition of the product you use?

There is an alternative way, you can find an example in MySqlDependency class topic (help reference).
Additionaly, take a look at this post:
http://crlab.com/forums/viewtopic.php?p=34243#34243

1. Do you have to hold a MySqlConnection opened? In the code you posted the connection instance is never closed. Probably you can use a connection pooling?
2. You should lock any operation that uses the connection, i.e.
- query.Ping
- q.Execute(query)

What is the exact exception message you receive, “Net Packets Out Of Order” or "Lost connection to mysql server during query”?
Let me know on the results.

Hello,

Could you specify the version of CF you are using?
Is there any connection between “delete” and “select” blocks (is the error reproducible on other tables)?
Could you please provide a call stack?

Regards,
Alexey.

Hello,

If I'm correct you are using multithreading, right?
Do you use an independent connection for each thread?
could you please provide a small sample block of code?
Please inform me what version/edition of MyDirect .NET you are using.

P.S. the topic was moved from OraDirect .NET

Regards,
Alexey.

Hello,

Unfortunately, the uuid type is not supported yet.
We are actively working on developing PostgreSQL and Entity Framework interaction now.
As a temporary solution please use long type.

Regards,
Alexey.

The build is available for download now.
See the changes here:
http://crlab.com/forums/viewtopic.php?t=12286

Dear users,

New build of PostgreSQLDirect .NET version 3.70.27 is available for download now.

This version includes:

• Fixed bug with PostgreSQLDirect .NET Data Provider missing in the EDM wizard
• Fixed bug with inserting a row in DbDataTable when a filter is enabled

We're looking forward to your comments and suggestions.

Core Lab development team
http://www.crlab.com/pgsqlnet

Dear users,

New build of MyDirect .NET version 4.70.29 is available for download now.
This version includes:

• Fixed bug with MyDirect .NET Data Provider missing in the EDM wizard
• Fixed bug with inserting a row in DbDataTable when a filter is enabled

Core Lab development team
http://www.crlab.com/mysqlnet