Re: [appfuse-user] Multiple DataSources

2008-10-25 Thread Michael Horwitz
Profiles are added pretty much as they are needed, so the answer is probably that no one has yet submitted a DB2 profile for AppFuse. Including it should be simple. In terms of the groupId/artifactId for the DB2 JDBC driver, this is probably up to you. DB2's driver is more than likely proprietary

Re: [appfuse-user] Multiple DataSources

2008-10-20 Thread jackalista
from looking at the top level pom.xml, it looks like it's the DB2 JDBC driver that I want the groupId and artifactId for, but I don't see anything in there like a DB2 profile. Anybody know where the relevant info for the DB2 JDBC driver is? Also, why no DB2 profile in the pom? There's stuff for

Re: [appfuse-user] Multiple DataSources

2008-10-20 Thread jackalista
Hey Nathan (or anyone else that knows), Sorry to ask possibly very obvious questions but I'm new to maven too. Do I add the jar using the groupId and artifactId of my appfuse project or do I need to get the relevant info for the jar I want to add? I want to add a DB2 JDBC driver to my app, so

Re: [appfuse-user] Multiple DataSources

2007-04-21 Thread Matt Raible
On 4/20/07, Jason Brice <[EMAIL PROTECTED]> wrote: With Spring you can use any pooled (poolable?) datasource... for example c3p0's ComboPooledDataSource or Apache's DBCP BasicDataSource. Proxool is also an option. By the way, I have had a terrible day or two struggling with Spring + Hibernate +

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Sanjiv Jivan
please note the typo getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { StatelessSession statelessSession = session.getSessionFactory().openStatelessSession(); S

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Sanjiv Jivan
On 4/20/07, Jason Brice <[EMAIL PROTECTED]> wrote: >> However if would still like to use Hibernate for your read-only DB2 data, make sure you're using Hibernate's StatelessSession API or else you'll just be paying a huge CPU and memory overhead using Hiberanate. Hi Sanjiv, Is there a way to us

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Nathan Anderson
Turns out adding a Jar isn't that hard at all [which may be why no one bothered replying to that part of the question ;)] http://maven.apache.org/general.html#importing-jars I ran that on jt400.jar, and added a new dependency in my pom.xml and *poof* the jar is in my webapp next time I ra

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Jason Brice
With Spring you can use any pooled (poolable?) datasource... for example c3p0's ComboPooledDataSource or Apache's DBCP BasicDataSource. Proxool is also an option. By the way, I have had a terrible day or two struggling with Spring + Hibernate + Apache's DBCP + WebSphere closing the socket in the

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Jason Brice
However if would still like to use Hibernate for your read-only DB2 data, make sure you're using Hibernate's StatelessSession API or else you'll just be paying a huge CPU and memory overhead using Hiberanate. Hi Sanjiv, Is there a way to use the StatelessSession API and still have Spring managi

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Nathan Anderson
I probably just need to read more, but in case you know off the top of your head... ;) I hope that spring is using some sort of connection pooling? And is there a way that you know of to configure a cache? The DB2 database connection will be going over the Internet, so I want to minimize it

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Sanjiv Jivan
If you're not planning on using Hibernate for fetching data from the second datasource, then you dont need to define a second SessionFactory bean. Just define a second DataSource bean and inject it into your DAO's. You can then use the Spring JDBC helper classes by utilizing the DB2 DataSource tha

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Nathan Anderson
Hi Sanjiv, I wasn't sure what I would use to fetch the data from the DB2 database. Hibernate crossed my mind, but then it seemed like it would not be worth the difficulty of just getting the object to map correctly. I haven't used iBATIS before, so I was starting to look at what JDBC templat

Re: [appfuse-user] Multiple DataSources

2007-04-20 Thread Sanjiv Jivan
You just need to define a second SessionFactory bean and inject it in the DAO's that you need access to it. You'll have to manage this second session opening and closing manually since the OpenSessionInViewFilter manages just the the bean names "sessionFactory". You could setup a second OSIV filte

[appfuse-user] Multiple DataSources

2007-04-20 Thread Nathan Anderson
[ You thought I was kidding about the 60 seconds, huh? ;) ] So I need to have 2 data sources in my application. The AppFuse core and my CRUD classes are being persisted to a MySQL database. I also need fetch Read-Only objects from a DB2 database. Being new to maven I'm a little stumped on h