I never used it, but maybe Hibernate Shards is the solution to your problem:
http://www.hibernate.org/414.html Bye, Peter 2009/3/24 sudhakargupta <sudhakargupta_s...@hotmail.com> > > Thanks for your reply if you got the solution on this type of multiple > database connections in one application please help me. > > Sudhakar > > > mraible wrote: > > > > I'm not a good person so ask as I haven't recently had to connect to > > multiple databases in a single application. Hopefully others on this list > > have had this experience and can help you. > > > > Matt > > > > On Mon, Mar 23, 2009 at 11:28 PM, sudhakargupta < > > sudhakargupta_s...@hotmail.com> wrote: > > > >> > >> Thanks for your reply. i'm connecting to multiple database with out the > >> appfuse structure (connect to the database while calling the > daoHibernate > >> methods with normal connection). > >> can you please suggest me it is the good structure to connect to > >> database > >> through this one or not. > >> > >> Sudhakar > >> > >> > >> mraible wrote: > >> > > >> > AppFuse doesn't do anything special outside of Spring and Hibernate > (or > >> > whatever persistence framework you choose). If you can do it with > >> Spring > >> > and > >> > Hibernate, you can probably do it in AppFuse. I don't believe we > >> prevent > >> > any > >> > special behavior from happening. > >> > > >> > Matt > >> > > >> > On Mon, Mar 23, 2009 at 11:04 PM, sudhakargupta < > >> > sudhakargupta_s...@hotmail.com> wrote: > >> > > >> >> > >> >> Thanks for your reply but i am unable to get the solution. is there > >> any > >> >> possibilities to maintain multiple databases for one application > >> through > >> >> appfuse. > >> >> > >> >> please help to resolve this problem. > >> >> > >> >> Sudhakar > >> >> > >> >> > >> >> > >> >> mraible wrote: > >> >> > > >> >> > I would suggest searching the mailing list archives at > >> >> > http://appfuse.markmail.org. I believe there's some solutions for > >> >> > connecting > >> >> > to multiple databases in there. > >> >> > > >> >> > Matt > >> >> > > >> >> > On Mon, Mar 23, 2009 at 6:59 AM, sudhakargupta < > >> >> > sudhakargupta_s...@hotmail.com> wrote: > >> >> > > >> >> >> > >> >> >> Hi Matt, > >> >> >> > >> >> >> I'm presently working with the appfuse1.9.4, and postgresql > >> >> database. > >> >> >> In > >> >> >> my application i need to develop a reports like charts. For this > >> >> reports > >> >> >> i > >> >> >> need to use different databases like (test1,test2,test3) in > >> postgresql > >> >> in > >> >> >> the same host with the different user name and passwords. > >> >> >> > >> >> >> why i need to use like this is if any problems are occurred in > >> >> reports > >> >> >> then it doesn't want to disturb the application (reports are > >> updated > >> >> >> continuously) > >> >> >> > >> >> >> presently i'm specifying host name,database name, user > >> name,password > >> >> in > >> >> >> the build.properties. > >> >> >> > >> >> >> 1) Is it possible to maintain multiple database connection > >> details > >> >> in > >> >> >> build.properties file ? > >> >> >> 2) If possible how to change the database while call the reports > >> >> >> classes > >> >> >> ? > >> >> >> 3) How to develop this application to maintain multiple > databases > >> >> with > >> >> >> reusability, when changes occurred in database names or user name, > >> >> >> password > >> >> >> changes ? > >> >> >> > >> >> >> Can you please suggest me how to solve this problem. > >> >> >> > >> >> >> Sudhakar. > >> >> >> -- > >> >> >> View this message in context: > >> >> >> > >> >> > >> > http://www.nabble.com/Multiple-database-connection-in-One-host-tp22659650s2369p22659650.html > >> >> >> Sent from the AppFuse - User mailing list archive at Nabble.com. > >> >> >> > >> >> >> > >> >> >> > >> --------------------------------------------------------------------- > >> >> >> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net > >> >> >> For additional commands, e-mail: users-h...@appfuse.dev.java.net > >> >> >> > >> >> >> > >> >> > > >> >> > > >> >> > >> >> > >> >> ----- > >> >> --- > >> >> Sudhakar > >> >> -- > >> >> View this message in context: > >> >> > >> > http://www.nabble.com/Multiple-database-connections-in-One-host-for-one-application-tp22659650s2369p22674356.html > >> >> Sent from the AppFuse - User mailing list archive at Nabble.com. > >> >> > >> >> > >> >> --------------------------------------------------------------------- > >> >> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net > >> >> For additional commands, e-mail: users-h...@appfuse.dev.java.net > >> >> > >> >> > >> > > >> > > >> > >> > >> ----- > >> --- > >> Sudhakar > >> -- > >> View this message in context: > >> > http://www.nabble.com/Multiple-database-connections-in-One-host-for-one-application-tp22659650s2369p22674534.html > >> Sent from the AppFuse - User mailing list archive at Nabble.com. > >> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net > >> For additional commands, e-mail: users-h...@appfuse.dev.java.net > >> > >> > > > > > > > ----- > --- > Sudhakar > -- > View this message in context: > http://www.nabble.com/Multiple-database-connections-in-One-host-for-one-application-tp22659650s2369p22674619.html > Sent from the AppFuse - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net > For additional commands, e-mail: users-h...@appfuse.dev.java.net > >
