Oracle netTiers support seems to be possible now.

I am begining and Oracle DB project and would love to test the NetTiers Oracle files.  Let me know what I can do to receive the modified files. 

If I don't get your files, I plan to rewrite enough of the netTiers templates to get them to work for Oracle.  I have done some similar stuff, but would much rather use some better tested methods.

Manongo

See http://community.codesmithtools.com/forums/storage/31/27566/nettiers_envio_oracle.patch.txt (posted earlier in this thread)

You need get SVN624 out so that you can apply it.

Let us know how you get on. 

hth

swin
 

 Hi Manongo. If you want, I can collaborate with you in testing, so the files I have posted work and can be added to the svn repository. Feel free to send me a mail.

 

Juanma. 

That would be great, I would appreciate all the help I can get.  I'll send you an email of where I am currently doing.

 Thank

Manongo

Hello, we are programming in Oracle more than 10 year, and last time we tried the neTTiers (v1.19) template so, we had to making some hacking to worrk on Oracle 9.2.

How is your work standing ? Could we help, to test this  ?

Please inform me, if we could help, to prepare a built-in Oracle support for netTiers. 

 

 

Hello swin!

Our company working with oracle database more than ten years, and we tried nettiers (v1.19 with some modification) in our last project.

So we will be proud if we, could help you, to test and finalize the Oracle support of netTiers.

Please inform me, how could we help.

Best regards

 

 

 

 

 

 

Hello, ElGreco

 I posted the necesary changes to make it work on Oracle. Currently, I tested it on Oracle XE, under the HR schema, makes almost a working site. I you like, we can work together to finish the Oracle support.

 

Best regards.

Hello,

I'am ready to start, actually we are working with 9.2 so we could test it on this version , but no problem, to install Oracle 10 too.

Please inform me, where can I found the templyete, and what to test.

best regards. 

You could reach me on my e-mail address too: gorog_istvan@hotmail.com 

 

 

Chingo_mucho - thank you for your efforts. I applied your patch (earlier in this thread) to revision 624 from SVN. I'm now using the latest Nettiers against the HR database (tables only) in a 10G Express edition of Oracle. I had the problem with the OracleNativeSchemaProvider where NUMBER is mapped to Int32, Single, Double or Decimal depending on the precision and scale of the NUMBER. I removed these conditionals and just returned System.Decimal which has worked well for me so far. Seems a bit of a blunt instrument though and Michael Toscano and Geoff McElhanon must have done it that way for good reason! I'm new to Oracle and I've yet to fully understand all the data type mapping issues to .NET so any advice on this would be welcome.

I am testing the use of a View next and I think there may be a problem with this...more later.

On a side note, for others coming here that had problems getting the OracleNativeSchemaProvider working - I had to compile it and reinstall Codesmith and Nettiers before it would appear in my drop down and/or crash Codesmith when it was selected in the data sources dialog. (Put the SchemaProvider.OracleNativeSchemaProvider.dll you compile into the SchemaProviders directory in the Codesmith install dir). Still not sure what was going on there.

rgds

 

Hi.

You are right with the provider. It's wrong because the Oracle Datatype number is a System.Decimal. I tried to find a reason to what Michael and Geof did, but I can't find any... If you look at the Oracle provider (made by Oracle, ODP.Net), they do the same as we do: a Number maps to a System.Decimal. There is another version of the provider, but needs to be recompiled... and the source code wasn't available (at least, last time I searched). But it's not obfuscated I think with reflector or cecil we could work on it. There is another reason: many things could be done via provider

What you are telling about the provider is true: a lot of weird things, I had almost the same problems... I don't know whats going on this...

About views... well, you are right, there are things to be done.

Regards.

The issue you describe seems to be a common theme that most people have come across - your best bet for anyone that experiences this problem is to check out the folder on WinXP - C:\Documents and Settings\[Username]\Application Data\CodeSmith\v3.2 - there is a file there named SchemaExplorer.config which stores the master data source information. It's been known to cause much grief and crashing CodeSmith when trying to select the data source. Give this file a check next time you have an issue, remove the ones that no longer exist or are invalid, this should stop CodeSmith from throwing the exception.

Hey, where are you guys with this? I'm at a point where I did 2 projects against SQL Server 2005 database (very successful), and now I've had a project assigned that is in Oracle. I'd like to help you get something out there to help those in Oracle land :)

The new ODP.NET seems to integrate nicely into VS , better than any of the previous versions, I even got to succesfully debug an oracle procedure through VS 2008 IDE.

 Anyway, please let me know where you are, and if I can help.

In the short term, I'm willing to use the generic OLE Provider before we get one more customized and optimized for Oracle. Has anyone had any success with that? Anyone have a recommended OLE Provider library to use against Oracle?

 Thanks, everyone!

Hello Guys ,

 Has anyone sorted out the Nettiers with oracle??? If so  can you guys let know how to do it.

 

Regards

Ganesh. 

 

Hi,

We implemented nettiers in one of our product and we are planning to implement it also on an Oracle DB. Just wanted to know how will I do this.

Thanks,

Jon 

Hello Jon,

Unfortunately there is no quick solution to using .NetTiers with Oracle. You can go here and download the Oracle Schema Provider and you will be able to use .NetTiers + CodeSmith to generate everything but the stored procedures. This should be receiving an update sometime soon, so keep your eyes open.

One would also need to rewrite all the stored procedures to use Oracle stored procedures. With each new release of .NetTiers, all the stored procedures would need to be revised.

Thanks

 -Blake Niemyjski