JasperIntelligence with JBoss

[MohanRao]

Hi,

 

I have installed JBoss-4.0.5.GA on my Windows XP machine. I was trying to deploy jasperserver on JBoss, but not able to do it. I have copied jasperserver to JBOSS_HOME/default/deploy/. I have created the mysql-ds.xml file. I just copied the contents of the context.xml of the apache-tomcat.

 

Can anyone please give me a detailed information on what I have to do in order to run the JasperIntelligence on JBoss successfully. Kindly help with the syntax also.

 

Thanks in advance,

Mohan.

[Grazy Mos]

There is a sample of the syntax of the mysql-ds.xml file at jbosdir/docs/examples/jca/mysql-ds.xml

 

Here is mine:

<datasources> <local-tx-datasource> <jndi-name>MysqlDSA</jndi-name> <connection-url>jdbc:mysql://127.0.0.1:3306/jasperserver</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password>root</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <!-- should only be used on drivers after 3.22.1 with "ping" support <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name> --> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>

 

Make sure you put your mysql driver jar in the serverdefaultlib

 

Then follow the install guide and create a jboss-web.xml

 

here is a example of my jboss-web.xml:

<jboss-web> <resource-ref> <description>JasperServer Metadata</description> <res-ref-name>jdbc/jasperserver</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <jndi-name>java:/MysqlDSA</jndi-name> </resource-ref> </jboss-web>

 

also dont forget to rename the jasperserver directory to jasperserver.war else jboss wont deploy it

 

Niels,

Post edited by: Grazy Mos, at: 2006/11/21 07:40

[MohanRao]

Hi,

 

Thanks a lot, but it is not working. I had made the necessary changes. Let me show what I did:

 

This was my jboss-web.xml:

<jboss-web>

<resource-ref>

<description>JasperServer Metadata</description>

<res-ref-name>jdbc/jasperserver</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

<jndi-name>java:jasperserver</jndi-name>

</resource-ref>

 

<resource-ref>

<description>SugarCRM example database</description>

<res-ref-name>jdbc/sugarcrm</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

<jndi-name>java:foodmart</jndi-name>

</resource-ref>

 

<resource-ref>

<description>Foodmart database</description>

<res-ref-name>jdbc/foodmart</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

<jndi-name>java:sugarcrm</jndi-name>

</resource-ref>

</jboss-web>

 

I have the web.xml of jasperserver. I have not changed it.

 

This is my mysql-ds.xml:

 

<datasources>

<local-tx-datasource>

<jndi-name>MysqlDSA</jndi-name>

<connection-url>jdbc:mysql://localhost:3306/jasperserver</connection-url>

<driver-class>com.mysql.jdbc.Driver</driver-class>

<user-name>root</user-name>

<password>dbadmin</password>

<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>

<!-- should only be used on drivers after 3.22.1 with "ping" support

<valid-connection-checker-class-name> org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class- name>

-->

<!-- sql to call when connection is created

<new-connection-sql>some arbitrary sql</new-connection-sql>

-->

<!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers

<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>

-->

 

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<metadata>

<type-mapping>mySQL</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>

 

Can you please spare some time to look at what I had done?

 

I had renamed the jasperser to jasperserver.war.

 

Also if I have to do any additional things, please let me know.

 

Thanks a lot for the help,

Mohan.

 

 

Grazy Mos wrote:

There is a sample of the syntax of the mysql-ds.xml file at jbosdir/docs/examples/jca/mysql-ds.xml Here is mine: <datasources> <local-tx-datasource> <jndi-name>MysqlDSA</jndi-name> <connection-url>jdbc:mysql://127.0.0.1:3306/jasperserver</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password>root</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <!-- should only be used on drivers after 3.22.1 with "ping" support <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name> --> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>   Make sure you put your mysql driver jar in the serverdefaultlib   Then follow the install guide and create a jboss-web.xml   here is a example of my jboss-web.xml: <jboss-web> <resource-ref> <description>JasperServer Metadata</description> <res-ref-name>jdbc/jasperserver</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <jndi-name>java:/MysqlDSA</jndi-name> </resource-ref> </jboss-web>   also dont forget to rename the jasperserver directory to jasperserver.war else jboss wont deploy it   Niels,<br><br>Post edited by: Grazy Mos, at: 2006/11/21 07:40

[swood]

We use JBoss every day.

 

When you say it doesn't work, you have to give more details. Stack traces, behavior etc.

 

 

Sherman

JasperSoft

[MohanRao]

Hi, In fact, it was my silly mistake, which I realized just after posting my question :-) In the mysql-ds.xml, in one place, I had not given the correct datasource name. When I realized this and changed it, it was working fine. Thanks for the help.

 

Cheers,

Mohan

 

swood wrote:

We use JBoss every day. When you say it doesn't work, you have to give more details. Stack traces, behavior etc. Sherman JasperSoft