Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-1881

[SqlTablesInit] Driver not found for MySql

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 4.0M7
    • None
    • None
    • None

      1. Create a MySQL datasource
      2. From the datasources_sql.xml file, retrieve its id and modify the datasource id of the feature core/runtime.core.sql.users.and.groups.init to automatically create users and groups tables in the newly created mysql datasource
      3. Relaunch your server, getting the following error: 
        Category:	org.ametys.core.script.SqlTablesInit
Message:		Error during SQL tables initialization for data source id: 'SQL-ip70wlps'.
Location:	org.apache.cocoon.util.log.SLF4JLoggerAdapter.error(SLF4JLoggerAdapter.java:46)
Thrown:
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/ametys_cmsweb_40
	at java.sql.DriverManager.getConnection(DriverManager.java:689)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:77)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:868)
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)
	at org.ametys.core.script.SqlTablesInit.init(SqlTablesInit.java:150)
	at org.ametys.runtime.servlet.RuntimeServlet._initPlugins(RuntimeServlet.java:368)
	at org.ametys.runtime.servlet.RuntimeServlet._initAmetys(RuntimeServlet.java:306)
	at org.ametys.runtime.servlet.RuntimeServlet.init(RuntimeServlet.java:207)

            raphael Raphaël Franchet
            sprieul Simon Prieul (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: