Yeah, the approach used by the samples is designed so they are easier to run on any app server. Sounds like you know the right practice, but for others who might be reading this for production use, I recommend using a data source using a connection pool which requires app server specific configuration. That also keeps the connection info out of your code.
Jeff ________________________________ From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of greenfishinwater Sent: Wednesday, February 13, 2008 3:55 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] Re: LCDS - Express, how to change database connection Thanks Jeff, I thought it would be easy. I think I will write my own product screen from scratch to see how it all works. My initial idea was to gradually modify the sample to get it working with Oracle, and make other changes. Seems like these samples are not a good 'standard practice' Thanks Andrew --- In flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> , "Jeff Vroom" <[EMAIL PROTECTED]> wrote: > > Some of the samples hardcode the database connection info in a class > called ConnectionHelper.java. Check in WEB-INF/src/... > > > > Look at the sample you are running, find the destination names. Find > these in your config... you probably found connection info for the > SQLAssembler destinations which are entirely coded without Java but if > you are using a Java based sample you'll have to change the Java code > itself. > > > > Jeff > > > > ________________________________ > > From: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> [mailto:flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> ] On > Behalf Of greenfishinwater > Sent: Tuesday, February 12, 2008 10:45 AM > To: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> > Subject: [flexcoders] LCDS - Express, how to change database connection > > > > I have just installed LCDS Express version with included JRun, and I > have been looking at the test drive samples. > > These samples use the associated hsqldb as the database. I want to > write some test code that uses an Oracle database. Where do I change > the database connection data. I found a database entry in > > data-management-config.xml in > > c:\lcds\jrun4\servers\default\samples\WEB-INF\flex > > I changed this to use Oracle, but the sample still uses hsqldb > > Where do I setup different database connections? > > Thanks Andrew >