Devart Forums

Hello,

Today I got the exception "String was not recognized as a valid TimeSpan" when trying to read an oracle column which is specified as

TIME_ELAPSED INTERVAL DAY(2) TO SECOND(6)


When debuging my code:

The following statement


shows in my watch-window that this is an object {System.Timespan}, and it holds the correct values (days, hours, seconds, etc...)
so this seems OK

But when i try the following code
then my watch-window shows the System.formatException ("String was not recognized as a valid TimeSpan.)


--> why does the .GetTimeSpan(...) method of the Devart.Data.Oracle.OracleDataReader object doesn't return a correct timestamp, but the simple indexer does ???

[/code]

thx
Fred

Hello,

I just posted my problem concerning an AccessViolationException I got when trying to do oracleCommand.Dispose().

http://www.devart.com/forums/viewtopic. ... 8859#78859

But then I saw the thread was in the topic "LinqConnect (LINQ to SQL support)", but in my case it's more related to "dotConnect for Oracle"


If possible, can someone have a look at my problem-description.


thx
Fred

StanislavK wrote:We are investigating the possible ways of resolving these issues. We will post here when any new information is available.

Hello all,


I do have some similar issues concerning AccessViolationException when trying to dispose an oracleCommand.

You can easily similate this kind of exception when you do the following

1) create connection
2) create command + execute
3) do not dispose the connection/command
4) unplug your pc from the network, wait some time, plug back in
5) try to execute same command again --> this will indeed result in error

6) catch the error, and try to do the clean-up --> meaning try to dispose the oracleCommand now (which is in debug-mode still some valid object)

--> the oracleCommand.Dispose() throws AccessViolationException, and most strange thing --> it is not catchable ????

I do understand that there could be strange things because of the network unplugged (but the code itself it just to handle this kind of network-loss, where we try to clean up everythind and recreate things)

--> if I just could catch the "AccessViolationException" in my case, everything should be ok.

Do i do something wrong in the code to try catching this exception.


Currently i do not have the exacte exception message, but it mentioned certainly some oracle client dll's.

my set-up was the next

*) oracle client 10.2
*) oci-mode (not direct mode)
*) oracle server 11
*) windows XP, vs.net 2010, .NET 4.0
*) Devart.Data.Oracle: v 6.60.258.0


thx
Fred

Hello Again,


Last days I have done some further testings.

- The tip of Set StoreGeneratedPattern attribute to "Identity" solved indeed my sequence-id problem.
But I still need an insert trigger (it's ok for this project)
And each datasource-refresh --> I have to this trick manually again (this 'bug' also mentioned in the info-link)

- When deploying my SL-app hosted on a Win2003 IIS webserver --> I got error's concerning the devart-dll's. Possible due to reference not copied and no correct licensing

Concerning the deployment --> what are the correct steps to be able to deploy the LS-app on my win 2003 webserver on IIS ?

- Where do i have to add the devart-references (the client, server, generated code projects....)
- Which references (and set copy-local == true), core, entity, linq, ...
- what about the licence.lixc file
...


Do you have idea when a more detailed example (walkthrough) for a real-world example could be provided ?

thx
Fred

Shalex wrote:We will investigate the possibility of creating Lightswitch sample.

Hi again,

It would be really great if some basic example is available.
I have done some more tests, but have some questions.


Currently, I created an before-insert trigger on my oracle DB-table, which fetches a new ID-value from the sequence.

When i now use the standard lightswitch "create new" screen, and pus the save button, my record is indeed created in DB and has the sequence value as ID.

But, now the problem :

After creating the record in LS --> de details windows is shown, but this is empty in my case.
Further investigation, shows that Lightswitch never "knows" the value of that ID --> so it can nog get the details back from DB to show them.

This can be verified in the ...._Inserted(... entity) method, which is executed after the entity is created in DB. There I see that my ID value is still 0 (and does nos have the value from the sequence fetched in the trigger)

Is there any workaround or way, to overcome this problem ? so that in some way I know what the value of my ID is when record is created.
As far i know, there is also no (easy) way to fetch first manually the sequence value, because executing simple SQL-statements is not possible....


thx
Fred

Shalex wrote:

goethals.f wrote:An error occurred while establishing a connection to SQL Server instance '.\SQLEXPRESS'.

Could you please try creating the new LightSwitch Application project that works only with Data Source which uses dotConnect for Oracle? Does the problem persist in this case as well? We cannot reproduce the issue at the moment.

Hello

Sorry for the late replay, but was really busy with some other projects.

I just tested some more, and it seems I can only get it working, when on my devel pc my SQLServerExpress-service is really started and running. Then no build problems occurs.

When I switch my local sqlserver express off, I get the build error again.
I also check the contents of my local DB, but there was nothing in it.

Also, a simple deploy to a IIS on win2003 server, did work.

so it seems maybe the developer "needs" a sqlserver express running for some reasons.


But now, I have some more questions related lightswitch - oracle - devart.

I created a new project, and included 1 DB-table with an ID-field as primary key.

When I first wanted to create a new record, I got the famous transaction-error (http://www.devart.com/forums/viewtopic. ... ightswitch) which i could solve by the explanation in that thread.

My table, currently has no trigger for creating ID-value based on sequence --> so inserting nex records via lightswitch does not really works (you have to specify ID by yourself)

I'm just wondering.
Is there any example from devart available, for a really simplistic LightSwitch application with following basic-every-day actions

*) 1-2 tables with relationship
*) ID-fields in table which would be auto-generated based on sequence --> but not really relying on insert-triggers if possible
*) how to implement the lightswitch roles/users/authentication model also with an oracle DB (which schema, connectionstring, ...)
*) simple deployment to an IIS server via the lightswitch deployment wizard

I think if you provide us with an basic example or really good blog-post or ... it would help a lot of users which want to use/test lightswitch in combination with oracle.


Or if there is already enough info somewhere else --> maybe just combining this info together to make it a lot easier for developer to start with lightswitch and have any feeling if we can really use devart, oracle and lightswitch together.


Greetings and keep up the good work to at least make the new technologies possible, but a little more detailed examples can do magic sometimes.


Fred





[/list]

Hello,


I tested it again with a non dba-user which has only acces to some tables. and indeed, after some time I can select the tables and complete the wizard.


But when I just try to run the project itself, I get an error related to a SQLEXpress not found. Does the lightSwitch still needs some sql server ?

When I look in the file C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v1.0\Microsoft.LightSwitch.targets at line 157. I see the following info.
Is there still something that's missing or that I have done wrong.

My first test was to just create a basic default LightSwitch app, with 1-2 tables to see what it could do...


PS: in the generated app.config, there was some connectionstring, but I have tested with and without these. But still the same error.

Is there any Lightswitch Devart example available somewhere ?


Greetings,

Fred

Shalex wrote:Notify us about the results. If the issue persists, please send us the DDL script to reproduce the issue.

Hello, today i have tested the LightSwitch again, but it give still the same error.

I tested it with

- VS.NET 2010 premium SP1 and Lightswitch 2011
- dotConnect for Oracle version is 6.50.228.0
- Database Oracle 11.2.0.2
- Tried with: oracle client 8, 10, 11


I have tested with a seperate DB-owner, and seperate tablespace with has only one table in it. (seee below)

I have the feeling it takes also a long time to retrieve the Db-objects (I only have 1 in my schema), and get to the error.


*) Does the Lightswitch fetches all the DB-objects (all schema's) first before you can select ?
*) What happens if 1 of your tables is a table without primary key, etc... --> does your full DB needs to be 100% OK, to use Lightswitch onle for some tables ?


Fred




CREATE TABLE TESTING_FG_ADMIN.TEST1 (
COL1 NUMBER(38),
CONSTRAINT PK_TEST1 PRIMARY KEY (COL1))
TABLESPACE TESTING_FG
LOGGING;

Shalex wrote:We have reproduced the error. We will investigate the issue and notify you about the results as soon as possible.

Yesterday, I just tried the LightSwitch with devart and oracle, and had the Exact same error-message.... (but in english)

I tested it with

- VS.NET 2010 premium SP1 and Lightswitch 2011
- dotConnect for Oracle version is 6.30.196.0
- Database Oracle 11.2.0.2

I would also appreciate it if you could notify me when you have any results about this issue...

Thx
Fred

Hello,

I'm already using the dotconnect for oracle provider, and currently I'm evaluating the schema-compare tool for oracle.

I have a question about it. Does it also support the comparison of the roles/grants/users in the DB's, schema's.

Because we use quite some defined roles and grants on db-objects/tables/packages, which becomes sometimes hard to manage when moving from one DB to another.

Currently in the object-filter I see nothing which reflects to the users/roles/grants. --> is this feature already supported in the tool or maybe in the future.

PS: I did a small test (added some extra user, changed some roles...) but nothing came up in the comparison tool !!!

Shalex wrote:

goethals.f wrote:Hi,
I did also find some more info on the forum
http://www.devart.com/forums/viewtopic. ... cle+client
It seems also a problem concerning multiple homes and multiple connections in the same application.... And in combination with the oracle 11 client...
The advice from devart was not to use multiple/different homes in the same application.
Is this advice still valid, because I did not have any issues combining oracle 8 client and oracle 10 client.

Yes, this piece of advice is valid. We strongly recommend not to use multiple homes in the same application. In addition to the thread you have mentioned, here is one more: http://www.devart.com/forums/viewtopic.php?t=16648. It is possible that oci.dll from the client, that is loaded last, doesn't use its own libraries, but uses the ones from the client, that is loaded first instead.

Hmm, bad news to hear...


I first did my testproject again with the oracle8 and oracle 10 client --> and there I did'n received any error, independant of the sequence of opening the connections.

After that, I did some further testing with my testproject, and combined it now with my working oracle 10 client (so 3 clients now: 8 / 10 /11)

Now I have 6 possible sequences of opening my 3 connections, and only when I first open (use) my oracle 11 client, I can open also an 10-client and 8-client connection.

All other cases where I first open a oracle8 or orcacle10 connection, all fail when I try the oracle 11 client.


PS: it seems I have mixed up my first post where I mention that this error only happens when first the oracle 11 is used. It should be the other way around


It seems indeed that something is changed in the oracle 11 client dll's, regarding the oracle 10 client dll's


so we have to keep using the oracle 10 and oracle 8 combined, and move on to the oracle 11 client if we get rid off our old oracle 734 DB.



But nevertheless, thx for pointing out that this is indeed some sort of unsupported way of using mutiple homes in the same app....

Hi,


I did also find some more info on the forum

http://www.devart.com/forums/viewtopic. ... cle+client

It seems also a problem concerning multiple homes and multiple connections in the same application.... And in combination with the oracle 11 client...


The advice from devart was not to use multiple/different homes in the same application.

Is this advice still valid, because I did not have any issues combining oracle 8 client and oracle 10 client.

but now combining oracle 8 and oracle 11 gives errors.....


Not using multiple homes would leave us stuck to the oracle 8 client because of our old oracle 734 DB.
And in that way we can not benefit of any enhancements of the oracle 10/11 client.


So if anyone from devart can give some feedback, it could maybe clear up the sky a little bit


Fred

Hello,


I have just logged a specific support-request with title "OCI.DLL Error: Using oracle 11 client + Oracle 8 client" (+ uploaded full test project) about OCICALL.DLL when using Oracle 8 client + Oracle 11 client in 1 application.

I will post in short some info about the error. Maybe some other forum people can give also some feedback.


We have an oracle 734 DB and Oracle 10.2 DB.
On the clients we have oracle 8 client installed as the default home, and oracle 10 client installed.

Our applications uses dotconnect 6.10.96.0 and uses 2 connections objects, one for oracle 734 using oracle8 client, and one for oracle 10 using oracle 10 client.

So far so good. This is working perfect (already for some years)


Currently we have setup a new Oracle 11.2 DB which would replace the full oracle 10.2 DB. The old oracle 734 is still needed.

So my plan was to have on the clients the oracle 8 client (for access to oracle734) and the new oracle 11.2 client for connecting to oracle 11.2
So no oracle 10 client anymore on the client.


But when I now test an application which has both a connection towards oracle 734 and oracle 11.2 --> I encounter ocicall.dll errors ("Procedure not found" errors (freely translated from the dutch error message)

But the strangest part is, that this error ONLY happens when I first create the oracle 11 connection followed by the oracle 734 connection.

When I first create oracle 734 connection followed by oracle 11 connection --> there is no error ???

Each connection has a specific connectionstring, pointing to the correcte oracle home. But it seems that when I first open the oracle 11 connection, and then the oracle 734 some DLL's errors happens.

Why is this specific sequence gives only in one scenario an error ?


*** Edited ***
I have just tested it also on a Windows server 2008 R2 , and got the following error

The procedure entry point orasql10.sqlxss could not be located in the dynamic link library orasql8.dll.


Maybe this gives us some more info which procedure calls are failing, and trying to execute towards oracle 734 DB....

*** End Edited ***

*** Edited 2 ***

I have the same error messages when I'm using OraDeveloper tools from VS.NET 2010.

When I use the database explorer and first open an oracle 11 connection, and then try an oracle 734 connection. It throws the OCI errors

But restarting vs.NET 2010 and first oracle 734 connection with oracle8 client followed by the oracle 11 connection, does work

This was all working fine with the oracle 10 client, and now not anymore with installing oracle 11

*** End Edited ***


In our apps it is not always so easy to force that specific sequence of opening connections. (like service apps, websites, ...)


So, hopefully you can reproduce this very specific situation !


Thx,
Fred


PS: As a backup plan we could stick to the oracle 10 client, but then I will have some other issues maybe on Windows 7 32/64 bit /Windows 2008 R2 64 bit....
On those new OS's I would like to use the oracle 11 client --> so we only have 2 clients in our infrastructure (oracle 8 and oracle 11 client, and not 3 client versions....)

Hello,

I have some questions about the integration of the new "Sharepoint Foundation 2010" (the free version) and the BDC-functions (Business Data Connectivity), combined with access to our oracle DB.

As far as I know, the BDC makes accessing oracle info possible from within sharepoint.

Therefore, some special XML-config-file needs to be imported in the system (See: http://msdn.microsoft.com/en-us/library/ff464424.aspx , How to: Connect to an Oracle Database Using Business Connectivity Services )


Some settings in that xml-file concerns the connection (in the example there is only "Oracle" provided as DatabaseAccessProvider . What this really mean, I don't know.

And I'm just wondering if you know if we can specify devart as the connection-provider, and eventually what extra settings we need to specify (tns-names, ....)

I would like to achive something like (http://www.lightningtools.com/bcs/bcs-meta-man.aspx ) --> that software seems to make the bridge between sharepoint and oracle (but relies on ODP.NET)

In the end, I'm just researching if the combination of sharepoint foundation 2010, BDC and oracle could give me a quick solution to have some UI that I can use for simlple CRUD operations on my oracle table (single table)

If a direct solution is not really possible, I think BDC and some WCF-service (which connects to oracle using dotconnect) may be the second possibility.

So maybe some people are already some stages further then me, and can give some feedback.


thanks a lot

Fred

Shalex wrote:Concerning the issue with dotConnect for Oracle.
We have reproduced the described behaviour with your code. We will investigate it and notify you about the results as soon as possible.

Concerning the issue with OraDeveloper Tools for Visual Studio.
I have forwarded your request to the OraDeveloper Tools support team. Could you please specify the version of your Oracle Server, and tell us if the problem persists on your collegue's machine after updating to OraDeveloper Tools for Visual Studio v 2.60.176?

My current system (the "problematic" one), is windowsXP, VS.NET 2010 prof, and DeveloperTools 2.60.176

I have tested on a second pc: Windows 7, VS.NET 2010, DeveloperTools 2.60.176 and there I don't see the extra null-column...


But some more good news: I remember that I have changed some settings once in VS.NET, and I have found the setting which causes this strange behaviour.

If you enable in VS.NET --> tools --> options --> Devart Developer tools --> Data Editor: And enable the first checkbox "Show data view for every SQL document", Then you gave the extra null-columns.

Default it is not checked and that way it was working on my second pc and the collegues, If I enable the option on my windows 7 pc --> I have the extra columns.

The option itself is usefull for me, because each SQL-stament has his own data-result grid instead of one shared data-result grid.