topic Error while configuring MySql with Alfresco. in Alfresco Archive

Error while configuring MySql with Alfresco.

dynamolalit — Tue, 05 May 2009 08:58:54 GMT

Hi,I have installed Alfresco2.0+Jboss4.0 on my machine.When i try to configure MySql database with it using this linkhttp://wiki.alfresco.com/wiki/Setting_up_the_MySQL_database_for_AlfrescoBut i am getting this error.14:08:55,758 ERROR [JDBCExceptionReporter] Unexpected token: LAST_INSERT_ID in stat

Re: Error while configuring MySql with Alfresco.

kalpesh_patel — Tue, 05 May 2009 11:50:05 GMT

From the log, it looks like alfresco is still using HSQLDB. Can you provide your database configuration here?

nested exception is java.sql.SQLException: Unexpected token: LAST_INSERT_ID in statement [select last_insert_id()]
java.sql.SQLException: Unexpected token: LAST_INSERT_ID in statement [select last_insert_id()]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

Re: Error while configuring MySql with Alfresco.

dynamolalit — Wed, 06 May 2009 07:52:54 GMT

Hi Kalpesh,

As per web doc, here are these two files after changed for MYSql configuration::
1.custom-repository.properties

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#
dir.root=D:/alfresco-enterprise-jboss-2.0.0Preview/alf_data

#
# Sample database connection properties
#
#db.username=alfresco
#db.password=alfresco
#db.pool.initial=10
#db.pool.max=100

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed. After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# HSQL connection
#
#db.driver=org.hsqldb.jdbcDriver
#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

#
# Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbcracle:thin:@localhost:1521:alfresco

#
# Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)
#
#db.driver=com.sybase.jdbc2.jdbc.SybDriver
#db.url=jdbc:sybase:Tds:localhost:2638/alfresco

#
# SQLServer connection (requires jdts-1.2.jar or equivalent - http://jtds.sourceforge.net/)
#
#db.driver=net.sourceforge.jtds.jdbc.Driver
#db.url=jdbc:jtds:sqlserver://localhost/alfresco

#
# SQLServer connection using Microsoft JDDB driver
#
#db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
#db.url=jdbc:sqlserver://localhost;DatabaseName=alfresco

2.custom-hibernate-dialect.properties

# Sample Hibernate configuration to disnable Hibernate schema updates
# Values are "validate" or "update" (default)
#hibernate.hbm2ddl.auto=validate

#
# Sample Hibernate configuration for changing Database dialect
# For a full list: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects
#

#
# HSQL dialect
#
#hibernate.dialect=org.hibernate.dialect.HSQLDialect

#
# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

#
# Oracle dialect
#
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

#
# Sybase dialect
#
#hibernate.dialect=org.hibernate.dialect.SybaseAnywhereDialect

#
# SQLServer dialect
#
#hibernate.dialect=org.hibernate.dialect.SQLServerDialect

Thanks & Regards,
lalit

Re: Error while configuring MySql with Alfresco.

mrogers — Wed, 06 May 2009 08:28:54 GMT

Was your first post that you are using Alfresco2.0 correct?

Re: Error while configuring MySql with Alfresco.

dynamolalit — Wed, 06 May 2009 08:41:32 GMT

Hi,

I am using "alfresco-enterprise-jboss-2.0.0Preview" which i downloaded from Alfresco Partner Site.

Thanks You,
Regards,
Lalit.

Re: Error while configuring MySql with Alfresco.

dynamolalit — Thu, 07 May 2009 10:57:54 GMT

is anybody out there to help me out?

Re: Error while configuring MySql with Alfresco.

norgan — Fri, 08 May 2009 09:49:43 GMT

If you dont want to test jboss specific functions but want to know, if and ow Alfresco can solve your requirements, take the alfresco bundle for Alfresco Labs Stable v3 on the alfresco download pages