URL datasource com MYSQL

System.out.println(“Hello Amigos”)
Estou com uma aplicaçãozinha utilizando Struts e Framework e estou com um pequeno problema na conexao data source, ele esta dando erro no minha URL: em meu SERVER.XML do tomcat esta assim:

&lt;/Context&gt;
      
	&lt;Host name="192.168.10.68" debug="0" appBase="webapps" unpackWARs="true" autoDeploy="true"&gt;
		&lt;DefaultContext&gt;
		&lt;Resource name="jdbc/StrutsDemoDS" auth="Container" type="javax.sql.DataSource" scope="Shareable"/&gt;
		&lt;ResourceParams name="jdbc/StrutsDemoDS"&gt;
&lt;parameter&gt;&lt;name&gt;factory&lt;/name&gt;&lt;value&gt;org.apache.commons.dbcp.BasicDataSourceFactory&lt;/value&gt;&lt;/parameter&gt;
&lt;parameter&gt;&lt;name&gt;driverClassName&lt;/name&gt;&lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt;&lt;/parameter&gt;
&lt;parameter&gt;&lt;name&gt;url&lt;/name&gt;&lt;value&gt;jdbc&#58;mysql&#58;//192.168.10.68/strutsdemo&lt;/value&gt;&lt;/parameter&gt;
&lt;parameter&gt;&lt;name&gt;username&lt;/name&gt;&lt;value&gt;root&lt;/value&gt;&lt;/parameter&gt;
&lt;parameter&gt;&lt;name&gt;password&lt;/name&gt;&lt;value&gt;solo23&lt;/value&gt;&lt;/parameter&gt;
&lt;parameter&gt;&lt;name&gt;maxActive&lt;/name&gt;&lt;value&gt;20&lt;/value&gt;&lt;/parameter&gt;
&lt;parameter&gt;&lt;name&gt;maxIdle&lt;/name&gt;&lt;value&gt;10&lt;/value&gt;&lt;/parameter&gt;
&lt;parameter&gt;&lt;name&gt;maxWait&lt;/name&gt;&lt;value&gt;100&lt;/value&gt;&lt;/parameter&gt;
		&lt;/ResourceParams&gt;	
	&lt;/DefaultContext&gt;
	&lt;/Host&gt;
	&lt;Host name="192.168.10.68" appBase="webapps"

e na minha classe esta assim:

public class AdminUsers &#123;
    
    protected static DataSource dataSource;
    protected static BasicDataSource ds;
    public AdminUsers&#40;&#41; throws Exception &#123;
        if &#40;dataSource == null&#41; &#123;
            try &#123;
                Connection conn = null;
                InitialContext ic = new InitialContext&#40;&#41;;
                dataSource = &#40;DataSource&#41; ic.lookup&#40;"java&#58;comp/env/jdbc/StrutsDemoDS"&#41;;
                if &#40;dataSource != null&#41; &#123;
                    conn = dataSource.getConnection&#40;&#41;;
                &#125;
                
            &#125; catch &#40;NamingException ex&#41; &#123;
                System.out.println&#40;ex.getMessage&#40;&#41;&#41;;
                throw ex;
            &#125;
        &#125;

acho que neste trecho “java:comp/env/jdbc/StrutsDemoDS” deve conter algum erro porque ele acusa que este url esta errado, e como ja disse estou utilizando data source, se alguem souber como arrumo isso eu agradeco.

Topicos relacionados