Hi there,
I have 2 different Oracle DBs which i want to connect thru 2 different
poolman Datasources with castor.
For achiving this i have an poolman.xml file defining the two pools and
there names.
Futhermore I'm generating two jdo-conf files on the fly and pass it to JDO.
The problem now is that castor always uses the same poolman pool.
Castor does use the right jdo-conf for the database-name (tries to map on
wrong tables cause of the wrong mapping files read ...),
but it always uses the first pool in poolman.xml !
If I do tests with poolman standalone, I'am able to lookup and use different
pools in the poolman config.
How does castor lookup the datasource ? Do I have any configuration issues ?
Wrong params in the DataSource Config ?
Any ideas ? thanks for your help !
feel free to take a look at the config ...
poolman config:
<?xml version="1.0" encoding="UTF-8"?>
<poolman>
<management-mode>local</management-mode>
<datasource>
<dbname>test1</dbname>
<jndiName>test1</jndiName>
<driver>oracle.jdbc.driver.OracleDriver</driver>
<url>jdbc:oracle:thin:@....:1521:..</url>
<username>user1</username>
<password>pass1</password>
......
<cacheEnabled>true</cacheEnabled>
<cacheSize>100</cacheSize>
<cacheRefreshInterval>120</cacheRefreshInterval>
</datasource>
<datasource>
<dbname>test2</dbname>
<jndiName>test2</jndiName>
<driver>oracle.jdbc.driver.OracleDriver</driver>
<url>jdbc:oracle:thin:@....:1521:...</url>
<username>user2</username>
<password>user2</password>
.......
<cacheRefreshInterval>120</cacheRefreshInterval>
</datasource>
</poolman>
jdo-conf 1:
<?xml version="1.0" encoding="UTF-8"?>
<database name="test1" engine="oracle">
<data-source class-name="com.codestudio.sql.PoolManDataSource">
<params database-name="test1"/>
</data-source>
<mapping href="....file1.xml"/>
<mapping href="....file2.xml"/>
</database>
jdo-conf 2:
<?xml version="1.0" encoding="UTF-8"?>
<database name="test2" engine="oracle">
<data-source class-name="com.codestudio.sql.PoolManDataSource">
<params database-name="test2"/>
</data-source>
<mapping href="...file3.xml"/>
<mapping href="...file4.xml"/>
<mapping href="...file5.xml"/>
<mapping href="...file6.xml"/>
<mapping href="...file7.xml"/>
</database>
Any ideas ? thanks for your help !
DI(FH) Christian Cerny
IT-Consultant/XML
free com Internet Services GmbH
http://www.freecom.at
Brahmsplatz 7/4; A-1041Wien
tel +43(1)501 36 1452
fax +43(1)501 36 1210
mailto:[EMAIL PROTECTED]
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
