MySQL throws Exception when deploying Sonar

View: New views
2 Messages — Rating Filter:   Alert me  

MySQL throws Exception when deploying Sonar

by RealKillaz :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I'm trying to install sonar version 1.11 by deploying the sonar.war in tomcat (6.x).

I runned the war/build-war.sh after uncommenting the 3 lines of mysql

After this I copied the war in the webapps folder.

I 'm using the mysql-connector-java-5.0.4.jar in the lib folder of tomcat.

During deployment sonar throws some exception.
This is the StackTrace:

** BEGIN NESTED EXCEPTION **

java.lang.NullPointerException

STACKTRACE:

java.lang.NullPointerException
    at com.mysql.jdbc.Connection.
checkTransactionIsolationLevel
(Connection.java:2044)
    at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4094)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at org.sonar.core.database.JndiDatabaseConnector.getConnection(JndiDatabaseConnector.java:155)
    at org.sonar.api.database.AbstractDatabaseConnector.testConnection(AbstractDatabaseConnector.java:153)
    at org.sonar.api.database.AbstractDatabaseConnector.start(AbstractDatabaseConnector.java:91)
    at org.sonar.core.database.JndiDatabaseConnector.start(JndiDatabaseConnector.java:65)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)
    at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)
    at org.picocontainer.injectors.AbstractInjector.start(AbstractInjector.java:131)
    at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:171)
    at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:134)
    at org.picocontainer.behaviors.Stored.start(Stored.java:111)
    at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:916)
    at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:664)
    at org.sonar.core.Application.start(Application.java:58)
    at org.sonar.web.listeners.ApplicationListener.contextInitialized(ApplicationListener.java:53)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
    at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
    at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1217)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
    at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1337)
    at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
    at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
    at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
    at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **

Hope you can help me.

Regards,
Shurbann Martes

Re: MySQL throws Exception when deploying Sonar

by marodavid :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Shurban,

Can you provide more information? for example.

1- have you created the catalogues and users in mysql?

2- are you upgrading sonar from a previous version and maybe using the same database catalogue?

3- Did you previously have sonar deployed on tomcat and maybe you are keeping old files from your previous configuration?

I know those questions can be somehow stupid, but simple errors are sometimes the most difficult errors to find.

Regards,
David Barba

2009/10/21 S.D.C. Martes <shurbann@...>
Hi,

I'm trying to install sonar version 1.11 by deploying the sonar.war in tomcat (6.x).

I runned the war/build-war.sh after uncommenting the 3 lines of mysql

After this I copied the war in the webapps folder.

I 'm using the mysql-connector-java-5.0.4.jar in the lib folder of tomcat.

During deployment sonar throws some exception.
This is the StackTrace:

** BEGIN NESTED EXCEPTION **

java.lang.NullPointerException

STACKTRACE:

java.lang.NullPointerException
    at com.mysql.jdbc.Connection.
checkTransactionIsolationLevel
(Connection.java:2044)
    at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4094)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at org.sonar.core.database.JndiDatabaseConnector.getConnection(JndiDatabaseConnector.java:155)
    at org.sonar.api.database.AbstractDatabaseConnector.testConnection(AbstractDatabaseConnector.java:153)
    at org.sonar.api.database.AbstractDatabaseConnector.start(AbstractDatabaseConnector.java:91)
    at org.sonar.core.database.JndiDatabaseConnector.start(JndiDatabaseConnector.java:65)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)
    at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)
    at org.picocontainer.injectors.AbstractInjector.start(AbstractInjector.java:131)
    at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:171)
    at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:134)
    at org.picocontainer.behaviors.Stored.start(Stored.java:111)
    at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:916)
    at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:664)
    at org.sonar.core.Application.start(Application.java:58)
    at org.sonar.web.listeners.ApplicationListener.contextInitialized(ApplicationListener.java:53)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
    at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
    at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1217)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
    at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1337)
    at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
    at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
    at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
    at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **

Hope you can help me.

Regards,
Shurbann Martes