Hi, I need to work with LLBLGen Pro in the described environment, which is not familiar for me:

Oracle 10g + Database Server Cluster

I guess LLBL supports Oracle 10g. Am I right?

Do you recommend any specific version? I have November 2005 version. If there's no issues with this one, I'd keep it.

I've been told that while working with a database server cluster I have to detect if a DB server is down and switch to the second one. Am I on the right track? If so, is there anyway that LLBL helps me make the switch, even modifying the generated or template code?

I guess I may need two connection string there and a replication of the database. Please, let me know you thoughts. I'm actually designing this part of the application.

My client wants to use 2 db server for more reliability and I have to take care of the software design stuff.

Thanks!

I guess LLBL supports Oracle 10g. Am I right?

Yes LLBLGen Pro supports Oracle 10g.

Do you recommend any specific version? I have November 2005 version. If there's no issues with this one, I'd keep it.

It's always better to use the latest available versions. We are constantly building new versions for enhancements and solving issues. I'd recommend using the latest available build of v.2.5, otherwise get that of v.2.0.

I've been told that while working with a database server cluster I have to detect if a DB server is down and switch to the second one. Am I on the right track? If so, is there anyway that LLBL helps me make the switch, even modifying the generated or template code?

According to what you have said. All you need is to set the connection string at runtime, and make a simple query to detect if the server is up and if not use the other connection string. For example using the adapter model: You may have a factory class that returns new instances of the DataAccessAdapter. Where in this class you may check in the database availability and if not available you may change the connection string in the returned DataAccessAdapter instance.

Thanks Walaa!