Installing on JBOSS and MySQL 4.1.x Â

[ktrinad]

By: Rouxxx - rouxxx

Installing on JBOSS and MySQL 4.1.x Â

2006-04-11 08:25

Hello,Â

Â

And congratulations for your job!Â

Â

First, I have succeeded in installing Jasperserver with the bundled mysql and tomcat and in using my own reports.Â

Â

Then I tried to deploy it on JBOSS (4.0.2) and MySQL 4.1.x. While running Jboss, I have got this error (last part of the logs)Â

Â

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---Â

ObjectName: jboss.web.deployment:war=jasperserver.war,id=-1894287205Â

State: FAILEDÂ

Reason: org.jboss.deployment.DeploymentException: Error during deploy; - nesteÂ

d throwable: (javax.naming.NamingException: resource-ref: jdbc/jserver has no vaÂ

lid JNDI binding. Check the jboss-web/resource-ref.)Â

Â

How can I deploy it on JBOSS successfully?Â

Â

Is MySQL 4.1.x enough, or I will need to deploy it on 5 ?Â

Â

Thank you for your answers, if you need more information, just tell me.Â

Â

RouxxxÂ

Â

 

 

 

 

 

By: Sherman Wood - sgwood

RE: Installing on JBOSS and MySQL 4.1.x Â

2006-04-11 08:33

Â

You need to set up the required data source in JBoss. Have you done that for JBoss before?Â

Â

There is nothing in particular stopping you from using MySQL 4.X for the metadata repository, though transactional rollback will not work due to MySQL 4.X limitations.Â

Â

You can run reports against any DBMS that supports JDBC, as per normal JasperReports. Â

Â

Â

ShermanÂ

JasperSoft

 

 

 

By: Rouxxx - rouxxx

RE: Installing on JBOSS and MySQL 4.1.x Â

2006-04-11 08:51

You are right, I have never done this before. Can you help a little in doing it?Â

Â

About transactions and MySQL 4.1.x, it is already possible to use them. By default, tables are created in MyISAM mode but with InnoDB, it works fine.

 

 

 

By: Sherman Wood - sgwood

RE: Installing on JBOSS and MySQL 4.1.x Â

2006-04-11 13:19

Â

For setting up the data source in JBoss, check out:Â

Â

http://docs.jboss.org/jbossas/getting_started/v4/html/db.html#d0e1933Â

Â

http://www.jboss.com/index.html?module=bb&op=viewtopic&t=80943Â

Â

Cheers,Â

Â

Â

Sherman

 

 

 

By: Rouxxx - rouxxx

RE: Installing on JBOSS and MySQL 4.1.x Â

2006-04-12 04:04

I will work on it when I will have time.Â

Â

If it seems useful, I will post the whole process.Â

Â

If someone succeed in it before me, please let me know :pÂ

Â

Rouxxx