Re: Configuring 2nd and on DBs

Gene:

I think you'll need to put the mapping file in keel-map.properties,
that's the filename that startup looks for to build the mappings used.
I'm not sure it will see it in a different name...

Mike


On Tue, 2005-02-08 at 00:15, Gene wrote:
> i also added a jdbc-map.properties to my app's conf/server directory, 
> containing:
> 
> <snip>
> jdbc.oscn-dbpool.driver=//jdbc[@id='oscn-dbpool']/driver
> jdbc.oscn-dbpool.dburl=//jdbc[@id='oscn-dbpool']/dburl
> jdbc.oscn-dbpool.user=//jdbc[@id='oscn-dbpool']/user
> jdbc.oscn-dbpool.password=//jdbc[@id='oscn-dbpool']/password
> jdbc.oscn-dbpool.keep-alive-disable=//jdbc[@id='oscn-dbpool']/pool-controller/keep-alive|disable
> 
> svc.persist.dbtype.INNODBmysql=//INNODBmysql[@id='keel-dbtype-INNODBmysql']|id
> </snip>
> 
> 
> but i think this just allows me to override with keel.properties in my 
> project.
> 
> hth
> gene
> 
> Gene wrote:
> > i THINK i fixed my same situation by editing the keel-map.properties.
> > 
> > i altered the xpath to only change the dbtype for keel-dbtype, 
> > otherwise, it seemed to change each instance of the dbtype
> > 
> > svc.persist.dbtype.INNODBmysql=//INNODBmysql[@id='keel-dbtype-INNODBmysql']|id 
> > 
> > (I've added an INNODBmysql type, which simply supports transactions)
> > 
> > I think if that attribute check on each dbtype, it would clear this 
> > problem up.  With the addition of the check on the id value, i think my 
> > db access started working again.  Let me know if that doesn't do it, 
> > because i have the same problem, but have it working.
> > 
> > gene
> > 
> > Shash Chatterjee wrote:
> > 
> >> Mike,
> >>
> >> The app's been running fine for a while, but I dusted off the dev. 
> >> copy this weekend for the first time since Nov. and ran into this 
> >> problem:
> >>
> >> org.keel.services.persist.PersistenceException: Role 
> >> 'org.keel.services.persist.DatabaseType' does not have an 
> >> implementation with id/hint 'ba-dbtype'. It's available 
> >> implementations are keel-dbtype-informix, keel-dbtype-oracle, 
> >> keel-dbtype, keel-dbtype-mysql, keel-dbtype-postgresql, 
> >> keel-dbtype-sqlserver. 
> >> (Key='org.keel.services.persist.DatabaseType/ba-dbtype').
> >>
> >> Here's my config in system.xconf, after the merge:
> >>
> >>     <default-persistent security="default" logger="ba-persist" 
> >> activation="request" name="ba" id="ba">
> >>       <dbpool>ba-dbpool</dbpool>
> >>       <dbtype>ba-dbtype</dbtype>
> >>       <snip...../>
> >>
> >>     </default-persistent>
> >>     <jdbc id="ba-dbpool">
> >>       <pool-controller timeout="-1" min="1" blocking="true" 
> >> connection-class="org.apache.avalon.excalibur.datasource.JdbcConnection" 
> >> trim-interval="60000" maxStrict="true" max="10" auto-commit="true">
> >>         <keep-alive disable="true"/>
> >>       </pool-controller>
> >>       <driver>org.hsqldb.jdbcDriver</driver>
> >>       <dburl>jdbc:hsqldb:./db/ba-hsqldb</dburl>
> >>       <user>sa</user>
> >>       <password/>
> >>     </jdbc>
> >>     <hsqldb id="ba-dbtype">
> >>       <type to="bit" suffix="" prefix="" from="boolean"/>
> >>     </hsqldb>
> >>
> >> What do I need to change?
> >>
> >> In this deployment, I have two hsqldb DBs.  In other apps, I have 
> >> hsqldb for the keel-specific tables, and Oracle for the custom 
> >> apps/services. I am sure I'll have to make similar adjustments there too.
> >>
> >> Thanks,
> >> Shash
> >> http://keelframework.org/documentation.shtml
> >> Keelgroup mailing list
> >> [email protected]
> >> http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
> >>
> > http://keelframework.org/documentation.shtml
> > Keelgroup mailing list
> > [email protected]
> > http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
> > 
> http://keelframework.org/documentation.shtml
> Keelgroup mailing list
> [email protected]
> http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com

http://keelframework.org/documentation.shtml
Keelgroup mailing list
[email protected]
http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com