Search found 18 matches

Go to advanced search

by romanFleischer
Tue 21 Mar 2017 12:55
Forum: dotConnect for Oracle
Topic: Devart.Data.Oracle.DirectUtils Advanced Security EncryptionType or ChecksumType
Replies: 3
Views: 5153

Re: Devart.Data.Oracle.DirectUtils Advanced Security EncryptionType or ChecksumType

Hi,

the registry key FIPSAlgorithmPolicy is not enabled on our workstation. After enabling this key, we get another Exception (InvalidOperationException).

Our oracle database is running on a Red Hat Enterprise Linux 6.8 OS
Oracle Version: 12.1.0.2.0
Oracle Patches: 23177536;Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2016)
23144544;DATABASE BUNDLE PATCH: 12.1.0.2.160719 (23144544)
Architecture (OS/Database): x86_64

The error occurs on every simple select statement and on every table.
I will try to create a small project with our used components and will send it to you within the next days.

Thanks
Roman
by romanFleischer
Mon 13 Mar 2017 13:07
Forum: dotConnect for Oracle
Topic: Devart.Data.Oracle.DirectUtils Advanced Security EncryptionType or ChecksumType
Replies: 3
Views: 5153

Devart.Data.Oracle.DirectUtils Advanced Security EncryptionType or ChecksumType

Hi,

we have trouble to connect our ORACLE12C in direct mode, although we are using the newest version of dotConnect (9.2.220.0).
The settings on our database server are:
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256)
SQLNET.ENCRYPTION_SERVER = REQUIRED

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA256)
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED

But when we try to connect, we get the following error:
ORA-12656: Cryptographic checksum mismatch
[OracleException (0x80004005): ORA-12656: Cryptographic checksum mismatch]
Devart.Data.Oracle.as.c() +632
Devart.Data.Oracle.as.a() +85
Devart.Data.Oracle.as.a(Byte[] A_0, Int32 A_1, Int32 A_2) +322
Devart.Data.Oracle.as.h() +54
Devart.Data.Oracle.d3.a() +24
Devart.Data.Oracle.dr.a(cl A_0, p A_1) +581
Devart.Data.Oracle.OracleInternalConnection..ctor(cl connectionOptions, OracleInternalConnection proxyConnection) +542
Devart.Data.Oracle.ay.a(af A_0, Object A_1, DbConnectionBase A_2) +114
Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, af A_1, DbConnectionBase A_2) +324
Devart.Common.DbConnectionPool.a(DbConnectionBase A_0) +45
Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection) +1079
Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0) +207
Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection) +119
Devart.Common.DbConnectionBase.Open() +257
Devart.Data.Oracle.OracleConnection.Open() +947
Devart.Data.Oracle.Entity.aw.a(DbConnection A_0, OracleServerType& A_1, Nullable`1& A_2) +152
Devart.Data.Oracle.Entity.aw.b(DbConnection A_0) +53
Devart.Data.Oracle.Entity.OracleEntityProviderServices.GetDbProviderManifestToken(DbConnection connection) +36
System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) +87

[ProviderIncompatibleException: The provider did not return a ProviderManifestToken string.]
System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) +271
System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection) +33

Is there a possibility to configure the checksum to use, or is a default checksum used for connection?
How can we configure the used checksum and encryption type?

Thanks
Roman
by romanFleischer
Tue 05 Jun 2012 16:02
Forum: dotConnect for Oracle
Topic: string length for VARCHAR2(4000)
Replies: 15
Views: 20603

Re: string length for VARCHAR2(4000)

This is a helpfull information, but we still use the .NET 4.0 Framework (and the same version of Entity Framework). Nothing has changed since our update of the dotConnect. Is the new dotConnect version no longer compatible with older Entity Framework?
by romanFleischer
Mon 04 Jun 2012 08:33
Forum: dotConnect for Oracle
Topic: string length for VARCHAR2(4000)
Replies: 15
Views: 20603

Re: string length for VARCHAR2(4000)

Sounds good, but the reason for our problem can not be the Oracle database.
Why not? If we enter the following code into our entity mapping - everything works well without any change on the database.

Code: Select all

modelBuilder.Entity<Domain.Module>().Property(entity => entity.CertificateText).IsNotUnicode();

It is also posssible to enter 4000 characters by using a simple insert into, oder update SQL-Statement.

Newly we have also to check the "use unicode" checkbox inside our VisualStudio Database Explorer. This was also not necessary with our former used version 5.70. The databse has not been changed for the last 4 month.
by romanFleischer
Thu 31 May 2012 12:10
Forum: dotConnect for Oracle
Topic: string length for VARCHAR2(4000)
Replies: 15
Views: 20603

Re: string length for VARCHAR2(4000)

I get the result AL32UTF8
I wonder why it ist possible to insert 1999 character into a VARCHAR2(2000 CHAR) column but not possible to insert 2888 character into a VARCHAR2(4000 CHAR) colum?

Do the columns use different character sets dependent on the specified length, or does oracle handle VARCHARS in different ways?
by romanFleischer
Wed 30 May 2012 11:48
Forum: dotConnect for Oracle
Topic: string length for VARCHAR2(4000)
Replies: 15
Views: 20603

Re: string length for VARCHAR2(4000)

We found a workaround for our problem. If we insert folowing line into our entity mapping:

Code: Select all

...
modelBuilder.Entity<Domain.Module>().Property(entity => entity.CertificateText).IsNotUnicode();
we can insert 4000 charcters into the VARCHAR2(4000 CHAR) column.

But i hope this is not the only solution, because we have more than 2000 string columns in our solution and it will take some time to insert this line for every column. Also the mapping is generated automaticaly from an UML model and can not be modified every time.

This is the complete exception code of our solution and devart together. Mabe this will help analyze the problem.

Code: Select all

---> Devart.Data.Oracle.OracleException: ORA-01461: can bind a LONG value only for insert into a LONG column     bei Devart.Data.Oracle.t.d()     bei Devart.Data.Oracle.aq.h()     bei Devart.Data.Oracle.aq.c()     bei Devart.Data.Oracle.aa.a(Int32 A_0, bt A_1)     bei Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)     bei Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)     bei Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()     bei Devart.Data.Oracle.Entity.e.j()     bei System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)     bei System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)     --- Ende der internen Ausnahmestapelüberwachung ---     bei System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)     bei System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)     bei System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)     bei System.Data.Entity.DbContext.SaveChanges()     bei Sirius.EntityFramework.DbContextManager.SiriusPocoBaseDao`2.SaveAllObjectChanges()     bei ebis.Domain.Sibis.ModuleDao.Change(Module entity) in d:\Projekte-Zusatz\ebis2\Deployment\tfsCheckout\ebis.Domain.Sibis\target\ModuleDao.g.cs:Zeile 104.     bei ebis.PlanningAdministration.Core.TrainingCourseService.HandleSaveModule(ModuleVO 
...
by romanFleischer
Wed 30 May 2012 11:38
Forum: dotConnect for Oracle
Topic: string length for VARCHAR2(4000)
Replies: 15
Views: 20603

Re: string length for VARCHAR2(4000)

Sorry i typed a mismatch - installed is of course 6.80.325.0 as displayed in our configuration file.

Of course we can give you a small example how we test this stange effect. We use .NET Entity Framework 4.0 and Oracle 11g.

When inserting more than 2000 characters into a VARCHAR2 (4000 CHAR) db column, we get an Oracle Error.
Devart.Data.Oracle.OracleException: ORA-01461: can bind a LONG value only for insert into a LONG column
If we try to insert 2000 characters into a VARCHAR2 (2000 CHAR), it works! (We use the same table and the same enitity for our test)

Here is the definition of our table:

Code: Select all

CREATE TABLE MODUL (
  MODUL_ID NUMBER(5),
  ZERTIFIKATSTEXT VARCHAR2(4000 CHAR),
  TEXT VARCHAR2(2000 CHAR)
)
the entity class:

Code: Select all

public partial class Module
{
	//Id-Fields
	public int Id { get; set;}
	// Attributes
	public String CertificateText { get; set;}
	public String Text { get; set;}
}
the entity mapping:

Code: Select all

private void MapModule(ModelBuilder modelBuilder)
{
	// table-assignment
	modelBuilder.Entity<Domain.Module>().MapSingleType(entity => new
	{
		MODUL_ID = entity.Id
		,TEXT = entity.Text
		,ZERTIFIKATSTEXT = entity.CertificateText
	}).ToTable("MODUL");
	// Id
	modelBuilder.Entity<Domain.Module>().Property(entity => entity.Id).StoreGeneratedPattern = StoreGeneratedPattern.Identity;
	modelBuilder.Entity<Domain.Module>().HasKey(entity => entity.Id);
	// Properties
    modelBuilder.Entity<ebis.Domain.Sibis.Module>().Property(entity => entity.CertificateText).IsNotUnicode();
}
And then we only call the SaveChanges() method of the Entity.Context
by romanFleischer
Wed 23 May 2012 10:49
Forum: dotConnect for Oracle
Topic: string length for VARCHAR2(4000)
Replies: 15
Views: 20603

string length for VARCHAR2(4000)

Hello,

now after we installed the verson 6.80.335 of dotConnect, we can not insert strings with correct length in our database.

When we try to insert an string with 2888 chars into a column defined as VARCHAR2(4000) - we get an error. LONG value..

It is only possible to insert strings of length smaler than 2001 characters. We changed realy nothing in our environment. We updated only the dotConnect version from 5.70 to 6.80. With the old version of dotConnect we do not have any problem. We use the direct mode to connect.

Code: Select all

<add name="ApplDataModel" connectionString="User Id=xxxx;Password=yyyy;Server=test.anywhere.com;Port=1521;Direct=True;Sid=Appl;Persist Security Info=True" providerName="Devart.Data.Oracle" />

<add name="dotConnect for Oracle" invariant="Devart.Data.Oracle" description="Devart dotConnect for Oracle" type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle, Version=6.80.325.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx"/>
What do we have to change to make this version of dotConnect working?

Thanks Roman
by romanFleischer
Tue 15 May 2012 09:39
Forum: dotConnect for Oracle
Topic: DB-Connect impossible after changing Oracle Parameter
Replies: 2
Views: 1063

Re: DB-Connect impossible after changing Oracle Parameter

Thank You for the information. We installed the new version of dotConnect and now it works with the web.config. But again we can not connect to the Database with our databaseExplorer inside Visual Studio 2010. Is there also a new Version available?

Thanks
Roman
by romanFleischer
Fri 04 May 2012 09:25
Forum: dotConnect for Oracle
Topic: DB-Connect impossible after changing Oracle Parameter
Replies: 2
Views: 1063

DB-Connect impossible after changing Oracle Parameter

Hello,

our database provider has to set a special ORACLE parameter because of security issues.
The parameter is SQLNET.ALLOWED_LOGON_VERSION=11.
After seting this parameter it is no loger possible to connect to the database using our dotConnect (5.70.190.0). Do we need another version, or is this only a configuration problem?
We use this connection in our web.config

Code: Select all

<add name="ApplDataModel" connectionString="User Id=xxxx;Password=yyyy;Server=test.anywhere.com;Port=1521;Direct=True;Sid=Appl;Persist Security Info=True" providerName="Devart.Data.Oracle" />

<add name="dotConnect for Oracle" invariant="Devart.Data.Oracle" description="Devart dotConnect for Oracle" type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle, Version=5.70.190.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx"/>
Thanks
Roman
by romanFleischer
Wed 28 Mar 2012 08:18
Forum: dotConnect for Oracle
Topic: CLOB-Problem: ORA-01461: can bind a LONG value ..
Replies: 3
Views: 3307

Still does not work with version 6.80.325

Sorry it took some time to get the current version, because of our complex ordering process. But now I have installed the current version 6.80.325, and the error occurs again.

The :p2 parameter in dbMonitor is shown as NVarChar (not as CLOB).
Maybe our mapping is not right?

Our Mapping is in this way:

Code: Select all

modelBuilder.Entity().MapSingleType(entity => new
{
   AEND_DATUM = entity.LastChangeDate,
   AENDER_ID = entity.LastEditor.Id,
   LANGTEXT = entity.Text,
   LEITTEXT = entity.TeaserText,
   REVIEW = entity.Reviewer,
   EDITORIAL_ID = entity.Id
   BILD = entity.HasImage
   TITEL = entity.Title
   .....
 }
 ).ToTable("EDITORIAL");
The class for the news entity has String for the cLob databese field:

Code: Select all

public partial class News
{
	public int Id { get; set;}
	public DateTime ? LastChangeDate { get; set;}
	public virtual ebis.Domain.Sibis.User LastEditor { get; set;}
	public String Text { get; set;}
	public String TeaserText { get; set;}
	public String Reviewer { get;  set;}
	public int ? HasImage { get; set;}
	public String Title { get; set;}
	....
}
an the table is created in this way:

Code: Select all

CREATE TABLE EDITORIAL 
(
   AEND_DATUM DATE,
   AENDER_ID NUMBER(10),
   LANGTEXT CLOB,
   LEITTEXT VARCHAR2(400),
   REVIEW VARCHAR2(30),
   EDITORIAL_ID NUMBER(5),
   BILD NUMBER(1),
   TITEL VARCHAR2(60),
   CONSTRAINT SYS_C0022142 PRIMARY KEY (EDITORIAL_ID),
   CONSTRAINT SYS_C0022155 FOREIGN KEY (AENDER_ID)
     REFERENCES User(DB_USER_ID)
);
what is wrong in our solution?
thanks in advise
Roman
by romanFleischer
Tue 24 Jan 2012 10:54
Forum: dotConnect for Oracle
Topic: CLOB-Problem: ORA-01461: can bind a LONG value ..
Replies: 3
Views: 3307

CLOB-Problem: ORA-01461: can bind a LONG value ..

Hello,

we got big problems with devartDotConnect V 6.10.111.0 when we try to insert a huge amount of characters into a cLOB-Field.

The Update-Statement inside the dbMonitor is really simple.

Code: Select all

update SIBIS.RED_MITTE
   set AEND_DATUM = :p0, AENDER_ID = :p1, LANGTEXT = :p2, LEITTEXT = :p3, REVIEW = :p4
 where ((AENDER_ID = :p5) and (RED_MITTE_ID = :p6)
The parameter :p2 (LANGTEXT) contains more than 4096 german national characters.
When SaveAllObjects is called, we get the following error:
ORA-01461: can bind a LONG value only for insert into a LONG column

The same effect is caused when i try to update the row by devart database tools inside VisualStudio 2010.

But the table column is defined as Type CLOB. What goes wrong? Do we have to configure something?

Thanks in advice
Roman
by romanFleischer
Fri 17 Dec 2010 16:18
Forum: dotConnect for Oracle
Topic: Multiple versions of dotConnect in productive Environment
Replies: 3
Views: 1970

now another error is shown

We tried to make the described changes - now we get another error when we try to create an array of types included in Davart.Data.Oracle library.
System.ArrayTypeMismatchException

But the code is simple, and works with version 5.70.

Code: Select all

var paramProfession = professionId.CreateOracleParameter("profession", OracleDbType.Integer);
List parameters = new List { paramProfession};
These are the settings we use in web.config

Code: Select all
Any idea?
Thanks
Roman
by romanFleischer
Tue 14 Dec 2010 17:23
Forum: dotConnect for Oracle
Topic: Multiple versions of dotConnect in productive Environment
Replies: 3
Views: 1970

Multiple versions of dotConnect in productive Environment

Hello,

we serve several web applications on one windows server. The older applications were developed with .NET 3.5 and dotConnect version 5.40. No changes are necessary.

The new applications were developed under .NET 4.0 (with new entity framework) and therefore the dotConnect version 5.70

If we try to serve both - we get the following error

Code: Select all

Could not load file or assembly 'Devart.Data.Oracle, Version=5.35.79.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies
What goes wrong? All new dlls are in the bin directory of the web application. Is it possible to use both dotConnect versions, or do we have to install the new version?

Do the older applications work also with the new dotConnect version? This means are the versions downward compatible?

Thanks in advance
Roman
by romanFleischer
Wed 10 Nov 2010 12:53
Forum: dotConnect for Oracle
Topic: How to change type of sorting
Replies: 1
Views: 2014

How to change type of sorting

Hello,

we use dotConnect 5.70.120.00 with MS entity framework. Nearmost everything works well, but the sorting seems to be ASCII instead of national letters. So big letter words were shown prior to smal letter words.

This is wrong for our customer. We try to use NLS_SORT and ALTER SESSION. This works well when we connect direct to the database. But where can we set this value inside our sw-solution? How is it possible to change sorting?

Thanks
Roman

Go to advanced search