You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Sven Haiges <sv...@flavor.de> on 2001/12/13 00:01:19 UTC

DataSources Problem: 2 DataSources won't work!

Hi,

we are currently working with Struts and a single database (mysql). Now, we 
wanted to use a second database pooling for a oracle database.

We updated our struts-config to contain a second data-source tag.

<data-sources>
    <data-source>
      <set-property property="key" value="mysql"/>
      <set-property property="autoCommit" value="true"/>
      <set-property property="description" value="MySQL Data Source 
Configuration"/>
      <set-property property="maxCount" value="4"/>
      <set-property property="minCount" value="2"/>
      <set-property property="password" value="mysql"/>
      <set-property property="url" 
value="jdbc:mysql://localhost:3306/dbjava"/>
      <set-property property="user" value="root"/>
    </data-source>
      
    <data-source
      autoCommit="true"
      description="Oracle Data Source Configuration"
      driverClass="oracle.jdbc.driver.OracleDriver"
      maxCount="4"
      minCount="2"
      password="xxx"
      url="jdbc:oracle:thin:@141.28.xxx.xxx:1521:FHF"
      user="Schippmann"
      key="oracle"
      />
  </data-sources-->
    
  </data-sources>

We tested the connection to the oracle db with a thin Driver, it worked 
perfectly. 

"Cannot find ActionMappings or FormBeans Declarations" is the error we get, I 
know that it has absolutely nothing to do with datasources, but this is the 
error we get if we add the second datasource!

We also tried to use the set-property tag inside the data-sources, but the 
same error occured.

We really appreciate any kind of help we can get,

thanx,
Sven Haiges




-- 

Sven Haiges
mailto:sven@flavor.de

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: DataSources Problem: 2 DataSources won't work!

Posted by Rob Parker <rp...@bstonetech.com>.
I usually get that problem when there is a problem with the actual xml in
struts-config (eg, I left out a closing tag, etc).

Is this exactly like your struts-config xml looks? If so, you have a problem
at the end
 - there are 2 closing </data-sources> tags - one is actually
"<data-sources-->"

If that doesn't work, check the rest of the file for mistakes. Hope that
helps,

Rob

-----Original Message-----
From: Sven Haiges [mailto:sven@flavor.de]
Sent: Wednesday, December 12, 2001 5:01 PM
To: struts-user@jakarta.apache.org
Subject: DataSources Problem: 2 DataSources won't work!


Hi,

we are currently working with Struts and a single database (mysql). Now, we
wanted to use a second database pooling for a oracle database.

We updated our struts-config to contain a second data-source tag.

<data-sources>
    <data-source>
      <set-property property="key" value="mysql"/>
      <set-property property="autoCommit" value="true"/>
      <set-property property="description" value="MySQL Data Source
Configuration"/>
      <set-property property="maxCount" value="4"/>
      <set-property property="minCount" value="2"/>
      <set-property property="password" value="mysql"/>
      <set-property property="url"
value="jdbc:mysql://localhost:3306/dbjava"/>
      <set-property property="user" value="root"/>
    </data-source>

    <data-source
      autoCommit="true"
      description="Oracle Data Source Configuration"
      driverClass="oracle.jdbc.driver.OracleDriver"
      maxCount="4"
      minCount="2"
      password="xxx"
      url="jdbc:oracle:thin:@141.28.xxx.xxx:1521:FHF"
      user="Schippmann"
      key="oracle"
      />
  </data-sources-->

  </data-sources>

We tested the connection to the oracle db with a thin Driver, it worked
perfectly.

"Cannot find ActionMappings or FormBeans Declarations" is the error we get,
I
know that it has absolutely nothing to do with datasources, but this is the
error we get if we add the second datasource!

We also tried to use the set-property tag inside the data-sources, but the
same error occured.

We really appreciate any kind of help we can get,

thanx,
Sven Haiges




--

Sven Haiges
mailto:sven@flavor.de

--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>