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 + Apache's DBCP + WebSphere closing the socket in the middle
of transactions. Switched to c3p0 and all was sunshine and light
again.
In the midst of troubleshooting I came across Matt's blog entry here:
http://www.jroller.com/page/raible?entry=spring_makes_appfuse_more_portable
Matt, in that post you indicated that you chose to go with c3p0 over
DBCP ... but in my version of AppFuse (1.9.4 / webwork) it appears
DBCP is being used. Just curious, did you change for any specific
reason? In researching this error I saw that the Hibernate folks don't
have much nice to say about DBCP , and I of course had my own problems
(only on WebSphere - Tomcat works fine).
When we first switched from a JNDI DataSource to a Spring-managed one,
we did use c3p0. However, there were a lot of issues reported from
users and it didn't work on some containers. Therefore, we switched to
DBCP and haven't had any issues reported since.
http://issues.appfuse.org/browse/APF-241 (January '06)
Of course, c3p0 could have improved a lot in the last year.
Matt
Thanks,
Jason
On 4/20/07, Nathan Anderson <[EMAIL PROTECTED]> wrote:
> 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 as
> much as I can.
>
> Thanks,
> Nathan
>
> Sanjiv Jivan wrote:
> > 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 that you injected in your DAO's. All of
> > the Spring JDBC helper classes like MappingSqlQuery and JdbcTemplate
> > can be constructed using a DataSource object.
> >
> >
> > On 4/20/07, *Nathan Anderson* <[EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>> wrote:
> >
> > 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 templates
> > Spring has [http://www.springframework.org/docs/reference/jdbc.html ].
> > This is a very simple app other than the fact that there are 2 data
> > sources. Given the limited time to spend on it and the fact it
> > won't be
> > used a lot [maybe 10 users max], I'm going for simple ;)
> >
> > Thanks for the tip and the warning,
> > Nathan
> >
> > Sanjiv Jivan wrote:
> > > 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 filter but it
> > might be
> > > overkill depending on how frequently you need to fetch data from
> > your
> > > DB2 database.
> > >
> > > I would personally use Ibatis for fetching read-only data since it
> > > takes a lot of work to get Hibernate to perform efficiently as a
> > data
> > > mapper alone when you dont need its ORM capabilities. (Getting
> > > Hibernate to perform efficiently when working with large amounts of
> > > read only data is a battle I've almost given up on). 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.
> > >
> > > On 4/20/07, *Nathan Anderson* < [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> > > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote:
> > >
> > > [ 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 how to add the JDBC jars for
> > DB2. But even
> > > after I figure that out I'm not sure how to configure a second
> > > dataSource. I'm guessing I create a new "dataSource" bean,
> > but I
> > > don't
> > > see how to tell Hibernate or some other mechanism to connect
> > to it.
> > >
> > > Thanks,
> > > Nathan
> > >
> > >
> > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> > > <mailto:[EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>>
> > > For additional commands, e-mail:
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> > > <mailto:[EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>>
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
http://raibledesigns.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
