0005024: EC2 CONFIG DEPLOY: Problems using MySQL @Inject DataSource with config-deploy

(0005737)
rickHigh
04-06-12 15:07

MySQL should load because of
ls /var/www/resin-data/app-0/config/resin-inf/blog-db/lib
is under cloud:/resin-inf

cloud:/resin-inf = /var/www/resin-data/app-0/config/resin-inf/

I think...

  <class-loader>
    <tree-loader path="${resin.root}/ext-lib"/>
    <tree-loader path="${resin.root}/resin-inf"/>
    <tree-loader path="cloud:/resin-inf"/>
  </class-loader>

(0005738)
rickHigh
04-06-12 15:12

I tried to move it based on

$ resinctl config-ls
app-inf/blog-db/blog-database-conf.xml
app-inf/blog-db/lib/mysql-connector-java-5.1.19-bin.jar

It seems like this is not working either....

   
    <class-loader>
      <tree-loader path="${resin.root}/${cluster.id}-inf"/>
      <tree-loader path="cloud:/{cluster.id}-inf"/>
    </class-loader>

    
    <resin:import fileset="${__DIR__}/${cluster.id}-inf/**/*.xml"/>
    <resin:import fileset="cloud:/${cluster.id}-inf/**/*.xml"
                  recover="true"/>

(0005739)
rickHigh
04-06-12 18:46

I got it to deploy with including the jar in the war (WEB-INF/lib) and creating a resin-web.xml file with the configured driver.

This works....

<web-app xmlns="http://caucho.com/ns/resin"> [^]

<database jndi-name="jdbc/blogdb">
        <driver type="com.mysql.jdbc.Driver">
                 <url>jdbc:mysql://localhost:3306/blogdb</url> [^]
                 <user>bloguser</user>
                 <password>roofoo</password>
         </driver>
</database>

</web-app>

With this:

@WebServlet("/blog")
public class BlogServlet extends HttpServlet {

    @Inject
    @Named("jdbc/blogdb")
    private DataSource database;

Now I am going to retrace my steps and see if I can get it to work with config-deploy

(0005929)
ferg
06-21-12 15:59

See 0005004

Issue History
Date Modified	Username	Field	Change
04-06-12 15:02	rickHigh	New Issue
04-06-12 15:07	rickHigh	Note Added: 0005737
04-06-12 15:12	rickHigh	Note Added: 0005738
04-06-12 18:46	rickHigh	Note Added: 0005739
06-21-12 15:59	ferg	Note Added: 0005929
06-21-12 15:59	ferg	Assigned To	=> ferg
06-21-12 15:59	ferg	Status	new => closed
06-21-12 15:59	ferg	Resolution	open => fixed
06-21-12 15:59	ferg	Fixed in Version	=> 4.0.29

Notes
(0005737) rickHigh 04-06-12 15:07	MySQL should load because of ls /var/www/resin-data/app-0/config/resin-inf/blog-db/lib is under cloud:/resin-inf cloud:/resin-inf = /var/www/resin-data/app-0/config/resin-inf/ I think... <class-loader> <tree-loader path="${resin.root}/ext-lib"/> <tree-loader path="${resin.root}/resin-inf"/> <tree-loader path="cloud:/resin-inf"/> </class-loader>

(0005738) rickHigh 04-06-12 15:12	I tried to move it based on $ resinctl config-ls app-inf/blog-db/blog-database-conf.xml app-inf/blog-db/lib/mysql-connector-java-5.1.19-bin.jar It seems like this is not working either.... <!-- shared jars and drivers for the app-tier --> <class-loader> <tree-loader path="${resin.root}/${cluster.id}-inf"/> <tree-loader path="cloud:/{cluster.id}-inf"/> </class-loader> <!-- include resources config files in resources/ --> <resin:import fileset="${__DIR__}/${cluster.id}-inf/*/.xml"/> <resin:import fileset="cloud:/${cluster.id}-inf/*/.xml" recover="true"/>

(0005739) rickHigh 04-06-12 18:46	I got it to deploy with including the jar in the war (WEB-INF/lib) and creating a resin-web.xml file with the configured driver. This works.... <web-app xmlns="http://caucho.com/ns/resin"> [^] <database jndi-name="jdbc/blogdb"> <driver type="com.mysql.jdbc.Driver"> <url>jdbc:mysql://localhost:3306/blogdb</url> [^] <user>bloguser</user> <password>roofoo</password> </driver> </database> </web-app> With this: @WebServlet("/blog") public class BlogServlet extends HttpServlet { @Inject @Named("jdbc/blogdb") private DataSource database; Now I am going to retrace my steps and see if I can get it to work with config-deploy

(0005929) ferg 06-21-12 15:59	See 0005004

Relationships