I have a datasource defined in the server.xml, looks like this:

    <Resource
      name="DefaultDS2"
      type="javax.sql.DataSource"
      driverClassName="org.postgresql.Driver"
      password="dzbw"
      maxIdle="2"
      maxWait="5000"
      username="postgres"
      url="jdbc:postgresql://localhost/DynaVis"
      maxActive="4"/> 

The entry in the project.properties:

dataSource=java:/DefaultDS2

I removed all the other datasource Properties (but, as for my understanding,
this should not matter)

The applicationContext-datasource.xml as generated now:

<beans>

    <!-- ========================= DATASOURCE DEFINITION
========================= -->
    
    <!-- Local DataSource that works in any environment -->
    <bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    </bean>

    <!-- ====================== End of DATASOURCE DEFINITION
====================== -->

</beans>
Shouldn't my Datasource be mentioned there?!

The result is, that no Connection can be established because of:
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:532)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at
org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFro
mDriverManager(DriverManagerDataSo

The driver is in place and works proberly.






> -----Ursprüngliche Nachricht-----
> Von: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] Im Auftrag 
> von gehel
> Gesendet: Mittwoch, 22. Juni 2005 11:59
> An: [EMAIL PROTECTED]
> Betreff: [Andromda-user] [Newbie corner] [Setting a DB Schema]
> 
> 
> 
> You should declare a datasource within Tomcat (in the 
> server.xml file). See 
> http://galaxy.andromda.org/forum/viewtopic.php?t=274 and 
> http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasourc
e-examples-howto.html



Than just configure your project.properties to have dataSource=<your tomcat
datasource>. This should do the trick.
_________________________________________________________
Reply to the post :
http://galaxy.andromda.org/forum/viewtopic.php?p=1637#1637
Posting to http://forum.andromda.org/ is preferred over posting to the
mailing list!


-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Andromda-user mailing list
Andromda-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/andromda-user


-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
_______________________________________________
Andromda-user mailing list
Andromda-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/andromda-user

Reply via email to