Re: Configuring 2nd and on DBs

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