topic Re: Error with Mysql 5.0 in Alfresco Archive

Error with Mysql 5.0

ejml — Tue, 20 Feb 2007 10:05:58 GMT

Hello folksSometime I get the next error:09:45:17,193 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] ExcepciÃ³n enviando evento inicializado de contexto a instancia de escuchador de clase org.springframework.web.context.ContextLoaderListenerorg.alfresco.error.Alfre

Re: Error with Mysql 5.0

derek — Wed, 21 Feb 2007 11:03:49 GMT

Hi,

The JDBC Driver metadata queries are running into trouble.

Have you granted the alfresco user the correct privileges for the database?
Try connecting to the database as alfresco using the mysql command line client and creating a table. Try executing a describe statement against your new table.
If that works, then check the permissions on the mysql directories and ensure that the mysql server or service has the correct permissions to operate on the tables.
Check that you have the correct JDBC driver.

If you are still having issues, put SQL logging into the JDBC driver URL and see which statements are failing and try to reproduce it directly.

Regards

Re: Error with Mysql 5.0

ejml — Wed, 21 Feb 2007 18:01:52 GMT

This work fine:
Try connecting to the database as alfresco using the mysql command line client and creating a table. Try executing a describe statement against your new table.

You say:

heck the permissions on the mysql directories and ensure that the mysql server or service has the correct permissions to operate on the tables.

What permission must have the mysql directory?

Thanks

Re: Error with Mysql 5.0

derek — Thu, 22 Feb 2007 13:38:27 GMT

Did you execute the table creation as the alfresco user?
What version of the JDBC driver are you using?
Have you managed to run Alfresco against HSQL or another database?

Regards

Re: Error with Mysql 5.0

ejml — Thu, 22 Feb 2007 14:38:50 GMT

Did you execute the table creation as the alfresco user?
yes, it works fine.

What version of the JDBC driver are you using?

Where can i see this?

Have you managed to run Alfresco against HSQL or another database?

Mysql 5.0

Re: Error with Mysql 5.0

ejml — Thu, 22 Feb 2007 14:42:18 GMT

in the repository.properties:
db.driver = org.gjt.mm.mysql.Driver

Re: Error with Mysql 5.0

derek — Thu, 22 Feb 2007 15:01:30 GMT

What exact version of MySQL are you using:

mysql –version‍

If you are using a standard Alfresco install, then the JDBC driver is in tomcat/common/lib. You should be using mysql-connector-java-5.0.3-bin.jar.

Try the latest MySQL with the 5.0.3 driver. We use 5.0.x (5.0.20 for me) during development and for our benchmarks. We've not seen anything like this in Windows or Linux.

Are you running a 32bit or 64bit machine?
Perhaps you might want to check with MySQL to see if they have any known issues or incompatibilities with your particular setup, especially since the error doesn't always occur.

Re: Error with Mysql 5.0

ejml — Thu, 22 Feb 2007 15:50:45 GMT

Hi Derek

This is my mysql version:

Ver 14.12 Distrib 5.0.27, for Win32 (ia32)

Yes I use standard Alfresco install and it's mysql-connector-java-5.0.3-bin.jar

It's running on a 32 bit machine.

Re: Error with Mysql 5.0

derek — Thu, 22 Feb 2007 16:28:08 GMT

Hi,

See the bugs on the MySQL site raised against ConnectorJ 5.0.x. Try upgrading your driver to 5.0.4 as well as the last nightly build. If the problem persists, raise a bug on our JIRA, detailing the versions of everything so that we can reproduce it exactly.

Regards

Re: Error with Mysql 5.0

ejml — Mon, 26 Feb 2007 10:36:15 GMT

ok, thanks.

Re: Error with Mysql 5.0

ejml — Wed, 28 Feb 2007 09:35:10 GMT

Hi Derek, I have the same problem again.

I Have done the next steps:

1) I have stopped Alfresco.
2) I have updated the sql driver to 5.0.4
3) I have deleted the Alfresco Database
4) I have deleted the Alf_data
5) I have created the database with the script.
6) I have started with the index.recovery.mode = FULL.

All it works fine since it crashed again with the same error.

I Use:
- Microsoft Windows 2003 server
- Alfresco 1.4
- Mysql 5.0

Thanks

Re: Error with Mysql 5.0

derek — Wed, 28 Feb 2007 09:53:49 GMT

put SQL logging into the JDBC driver URL and see which statements are failing and try to reproduce it directly.

http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html

Step 5: Let the server do that for you.
Step 6: Only do this if you lose your indexes w.r.t. the database. It's meaningless against a clean system.

Have you granted the alfresco user ALL privileges to the database as per the README?

Regards

Re: Error with Mysql 5.0

ejml — Wed, 28 Feb 2007 10:21:15 GMT

these are the privileges of the alfresco's user:

mysql> show grants;
+——————————————————————————-
———————————-+
| Grants for alfresco@localhost
|
+——————————————————————————-
———————————-+
| GRANT USAGE ON *.* TO 'alfresco'@'localhost' IDENTIFIED BY PASSWORD '*F9F45731
0EF9364D42AABE6D8C24A21712C000B5' |
| GRANT ALL PRIVILEGES ON `alfresco`.* TO 'alfresco'@'localhost' WITH GRANT OPTI
ON |
+——————————————————————————-
———————————-+
2 rows in set (0.00 sec)

Re: Error with Mysql 5.0

ejml — Wed, 28 Feb 2007 14:56:12 GMT

Sorry, but I think that this error not is the same that the top of post, really?


15:39:27,265 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:613)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.hibernate.exception.GenericJDBCException: could not get table metadata: JBPM_ACTION
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:100)
   at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:838)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:335)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:598)
   … 32 more
Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_240_0.MYI' (Errcode: 17)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)
   at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2056)
   at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:76)
   at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:1930)
   at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:185)
   at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:33)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:85)
   … 35 more
15:39:27,280 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] ExcepciÃ³n enviando evento inicializado de contexto a instancia de escuchador de clase org.springframework.web.context.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:613)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.hibernate.exception.GenericJDBCException: could not get table metadata: JBPM_ACTION
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:100)
   at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:838)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:335)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:598)
   … 32 more
Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_240_0.MYI' (Errcode: 17)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)
   at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2056)
   at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:76)
   at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:1930)
   at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:185)
   at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:33)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:85)
   … 35 more
15:39:27,280 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] ExcepciÃ³n enviando evento inicializado de contexto a instancia de escuchador de clase org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:613)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.hibernate.exception.GenericJDBCException: could not get table metadata: JBPM_ACTION
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:100)
   at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:838)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:335)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:598)
   … 32 more
Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_240_0.MYI' (Errcode: 17)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)
   at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2056)
   at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:76)
   at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:1930)
   at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:185)
   at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:33)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:85)
   … 35 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Error with Mysql 5.0

derek — Wed, 28 Feb 2007 16:24:50 GMT

Hi,

So, get the SQL logging and reproduce the situation using the mysql command line client. Then head over to the MySQL forums and find out how to get your database to execute the statements without the failure.

Regards

Re: Error with Mysql 5.0

ejml — Wed, 28 Feb 2007 17:37:17 GMT

How put I the SQL Logging?. Where is the properties in repository.properties to indicate the logging file, etc.

Thanks

Re: Error with Mysql 5.0

ejml — Thu, 01 Mar 2007 08:20:24 GMT

sorry, sorry, sorry. All problems were the antivirus. I have uninstalled and it works fine now. I go to find the temp's folder of mysql and I will exclude of scanner.

Thanks Derek and sorry to bother you.

Re: Error with Mysql 5.0

miguel_gil_mart — Tue, 17 Apr 2007 08:37:56 GMT

Hi.

What exact version of MySQL are you using:
mysql –version‍
If you are using a standard Alfresco install, then the JDBC driver is in tomcat/common/lib. You should be using mysql-connector-java-5.0.3-bin.jar.

Does Alfresco use mysql-client? I thought that Alfresco was pure Java, so only uses mysql-connector-java.