Oracle netTiers support seems to be possible now.

Yep, I concur, same issue here. You can create an OracleProvider project by copying the SqlNetTiersProvider files, then to take a stored procedure building shortcut, you can download the free tool from Oracle: SQL Developer.

http://www.oracle.com/technology/products/database/sql_developer/index.html

Warning, it's written in Java, so it's kind of kludgy and slow. Also it doesn't like Vista too much, so it wants to switch compatibility, but it still works

There is a function off the menu: Migration -> Translation Scratch Editor.

If you have the database schema loaded in MSSQL Server, you can grab each procedure that was created by nettiers and translate them there.

This may be a hassle if you aren't an MSSQL person, but if you are, it works quite well and you don't have to learn much about PL-SQL to get up and running

Hi Blake,

Thanks for the reply. I would be trying it out. By the way do you happen to know if there are future plans to support other database engine also? Or there are already on going development to support them. Or may be I'm not looking at the right place. Hehehe. Anyway, your reply will be very much appreciated.

Thank you very much,

Jon 

Hi,

I already downloaded the dll but I'm lost on where to place it and what to do next.  I hope you could provide me with a link regarding some instructions.

Thanks,

Jon 

Hello Jon,

CodeSmith already has support for Oracle, but .NetTiers at this time doesn’t “support” Oracle as there is still quite a bit of work left to get Oracle working. Hence there are people out there writing stored procedure patches etc... I’m really hoping that the .NetTiers team jumps on board and starts supporting oracle as well. Because there are a few individuals like yourself who want to use Oracle with .NetTiers.

Hopefully a person from the .NetTiers team will respond to this post with a definite answer as to their future plans for Oracle Support .

Thanks

-Blake Niemyjski

There is so much work involved in getting this working that I admit I gave up - fortunately the project I'm on isn't Oracle centric. You could get something working with Codesmith far easier than trying to shoehorn Nettiers for it. 

What put a stop to my work on this was the CTP release of the Entity Framework. There's no support for Oracle yet but there is a full release due soon and a number of companies have been working on supporting Oracle for over 6 months (according to a press release from Microsoft, Datadirect and IBM are a couple of them). I would imagine that support for Oracle in EF will come along a lot quicker than waiting for Nettiers. Maybe the Nettiers team can prove me wrong.

Otherwise, good luck with this. I liked Nettiers a lot and would love to have been able to use it.

Regards

N 

Hi Blake,

Hi,

What do you think about this post:

http://community.codesmithtools.com/forums/p/7848/30538.aspx#30538

Any possibilities.  It seems that there are only a few Oracle users.  Is there a tutorial on how to go about making the changes to the download to get a partial result without errors using Oracle..  The new native provider talks about changes; However I could not understand where these changes should be made.  I appreciate any help in making that part a little bit more clear.

Hello,

I’ve responded to that post that you have mentioned above. I haven’t come across any tutorials on how to modify NetTiers to work successfully with Oracle. Lately, I have been trying to get the time to play with Oracle and CodeSmith.  

I know that one must rewrite all the stored procedure code in the NetTiers template, as that is the chunk of NetTiers that doesn’t work.  I haven’t looked into or heard much about the new native provider and its changes, so I can’t help you there. If you could provide me a link to this, it would be greatly appreciated.

I’ve been reading some of the previous threads on Oracle and there have been a few people who worked on previous versions of NetTiers to get the oracle stored procedures functional. Hopefully someone can get a hold of them and see if they would be willing to upkeep a branch if one is created.

Thanks

-Blake Niemyjski

Hi Vinny,

You sad you converted the store procedure for MS SQL to Oracle. I’m very much intressed to hear if your solution did work and how you did it?

Thanks!

Hello,

I wanted to update this post and let everyone know that I'm slowly but surely working on including full Oracle support for .netTiers. I don't have a timeline of when this will be done, other than I'm working on it and want it done asap .

Thanks

-Blake Niemyjski 

So far, this has been an uphill battle. I used the software I mentioned above. It's written by Oracle, unfortunately, it generated PL/SQL code transations that were not valid. I have made the necessary validation changes, but much of this was done manually.

I have pointed Nettiers to my Oracle DB, it generated all code , including the GenericProvider. I had to remove from SQLLite references. Everything compiles, I even get to the Admin Web site. Then came the runtime errors. It is still hung up on missing the xml file containing the procedures. I have all the procdures in the Oracle DB, hopefully another couple of days and I will have a working version. Then I will need to backtrace my steps to figure out how to get an Oracle version into a nettiers template. The code translation is still going to be the greatest challenge. I will keep you posted.