Re: Re: supported databases ?
Hi, Thanks a lot. I didn't yet try. I'll do it the next week. Arnaud On 11/3/06, Glenn J Gonzales [EMAIL PROTECTED] wrote: Hi Arnaud, I tried this with MySQL 5.0.27 with Connector/J 5.04. Worked without a hitch. Cheers, Glenn FromArnaud HERITIER [EMAIL PROTECTED] Subject Re: supported databases ? DateThu, 12 Oct 2006 19:59:03 GMT There's certainly (I hope) another setting somewhere in archiva to tell it which database we want to use and how the SQL must be generated. I'll try to have a look at it if no developer reply. Arnaud On 10/12/06, Mohni, Daniel [EMAIL PROTECTED] wrote: Hi Arnaud What databases are supported ? Only Derby or I can try to connect archiva to another one like mySQL ? I tryed with mySQL using this ressource definition: Resource name=jdbc/users auth=Container type=javax.sql.DataSource username=archiva password=archiva driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost/archiva?autoReconnect=true / with a local mysql instance with catalog archiva and user archiva/archiva when accesing localhost:8080/archiva I get an exception, the logs will show this: 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,421 [http-8080-Processor24] ERROR VelocityComponent - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. 2006-10-12 10:02:55,281 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:55,812 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:56,515 [http-8080-Processor24] ERROR RDBMS - Error thrown executing CREATE TABLE `OPERATIONS` ( `NAME` VARCHAR(256) BINARY NOT NULL, `DESCRIPTION` VARCHAR(256) BINARY NULL, `PERMANENT` BIT NOT NULL, `RESOURCE_REQUIRED` BIT NOT NULL, PRIMARY KEY (`NAME`) ) TYPE=INNODB : BLOB/TEXT column 'NAME' used in key specification without a key length java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification without a key length at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) at com.mysql.jdbc.Connection.execSQL(Connection.java:2998) at com.mysql.jdbc.Connection.execSQL(Connection.java:2927) at com.mysql.jdbc.Statement.execute(Statement.java:535) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute (DelegatingStatem ent.java:261) at
Re: supported databases ?
With datasources usage, we want to support a maximum of databases. For all exception found with a database, you need to create an issue and we'll look at it. We probably need to add more informations in the jpox descriptor used for the database generation. Emmanuel Mohni, Daniel a écrit : Hi Arnaud What databases are supported ? Only Derby or I can try to connect archiva to another one like mySQL ? I tryed with mySQL using this ressource definition: Resource name=jdbc/users auth=Container type=javax.sql.DataSource username=archiva password=archiva driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost/archiva?autoReconnect=true / with a local mysql instance with catalog archiva and user archiva/archiva when accesing localhost:8080/archiva I get an exception, the logs will show this: 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,421 [http-8080-Processor24] ERROR VelocityComponent - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. 2006-10-12 10:02:55,281 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:55,812 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:56,515 [http-8080-Processor24] ERROR RDBMS - Error thrown executing CREATE TABLE `OPERATIONS` ( `NAME` VARCHAR(256) BINARY NOT NULL, `DESCRIPTION` VARCHAR(256) BINARY NULL, `PERMANENT` BIT NOT NULL, `RESOURCE_REQUIRED` BIT NOT NULL, PRIMARY KEY (`NAME`) ) TYPE=INNODB : BLOB/TEXT column 'NAME' used in key specification without a key length java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification without a key length at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) at com.mysql.jdbc.Connection.execSQL(Connection.java:2998) at com.mysql.jdbc.Connection.execSQL(Connection.java:2927) at com.mysql.jdbc.Statement.execute(Statement.java:535) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatem ent.java:261) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTab le.java:561) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(Abstrac tTable.java:516) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:244) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:287) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R DBMSManager.java:3006) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.j ava:2397) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603) at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617) at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016) at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134) at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager .java:2216) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll Objects(JdoTool.java:199) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll Objects(JdoTool.java:182) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.trigge rInit(JdoTool.java:131) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getPer sistenceManager(JdoTool.java:118) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getObj ectById(JdoTool.java:236) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.object ExistsById(JdoTool.java:283) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoRbacManager .roleExists(JdoRbacManager.java:124) at org.codehaus.plexus.rbac.profile.AbstractDynamicRoleProfile.getRole(Abst ractDynamicRoleProfile.java:164) at org.codehaus.plexus.rbac.profile.DefaultRoleProfileManager.getDynamicRol e(DefaultRoleProfileManager.java:87) at org.apache.maven.archiva.web.check.RoleExistanceEnvironmentCheck.validat eEnvironment(RoleExistanceEnvironmentCheck.java:74) at
RE: supported databases ?
Hi Arnaud What databases are supported ? Only Derby or I can try to connect archiva to another one like mySQL ? I tryed with mySQL using this ressource definition: Resource name=jdbc/users auth=Container type=javax.sql.DataSource username=archiva password=archiva driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost/archiva?autoReconnect=true / with a local mysql instance with catalog archiva and user archiva/archiva when accesing localhost:8080/archiva I get an exception, the logs will show this: 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,421 [http-8080-Processor24] ERROR VelocityComponent - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. 2006-10-12 10:02:55,281 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:55,812 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:56,515 [http-8080-Processor24] ERROR RDBMS - Error thrown executing CREATE TABLE `OPERATIONS` ( `NAME` VARCHAR(256) BINARY NOT NULL, `DESCRIPTION` VARCHAR(256) BINARY NULL, `PERMANENT` BIT NOT NULL, `RESOURCE_REQUIRED` BIT NOT NULL, PRIMARY KEY (`NAME`) ) TYPE=INNODB : BLOB/TEXT column 'NAME' used in key specification without a key length java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification without a key length at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) at com.mysql.jdbc.Connection.execSQL(Connection.java:2998) at com.mysql.jdbc.Connection.execSQL(Connection.java:2927) at com.mysql.jdbc.Statement.execute(Statement.java:535) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatem ent.java:261) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTab le.java:561) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(Abstrac tTable.java:516) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:244) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:287) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R DBMSManager.java:3006) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.j ava:2397) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603) at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617) at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016) at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134) at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager .java:2216) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll Objects(JdoTool.java:199) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll Objects(JdoTool.java:182) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.trigge rInit(JdoTool.java:131) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getPer sistenceManager(JdoTool.java:118) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getObj ectById(JdoTool.java:236) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.object ExistsById(JdoTool.java:283) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoRbacManager .roleExists(JdoRbacManager.java:124) at org.codehaus.plexus.rbac.profile.AbstractDynamicRoleProfile.getRole(Abst ractDynamicRoleProfile.java:164) at org.codehaus.plexus.rbac.profile.DefaultRoleProfileManager.getDynamicRol e(DefaultRoleProfileManager.java:87) at org.apache.maven.archiva.web.check.RoleExistanceEnvironmentCheck.validat eEnvironment(RoleExistanceEnvironmentCheck.java:74) at org.codehaus.plexus.security.ui.web.interceptor.EnvironmentCheckIntercep tor.init(EnvironmentCheckInterceptor.java:78) at org.codehaus.plexus.xwork.PlexusObjectFactory.buildInterceptor(PlexusObj ectFactory.java:101) at com.opensymphony.xwork.config.providers.InterceptorBuilder.constructInte rceptorReference(InterceptorBuilder.java:48)
Re: supported databases ?
There's certainly (I hope) another setting somewhere in archiva to tell it which database we want to use and how the SQL must be generated. I'll try to have a look at it if no developer reply. Arnaud On 10/12/06, Mohni, Daniel [EMAIL PROTECTED] wrote: Hi Arnaud What databases are supported ? Only Derby or I can try to connect archiva to another one like mySQL ? I tryed with mySQL using this ressource definition: Resource name=jdbc/users auth=Container type=javax.sql.DataSource username=archiva password=archiva driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost/archiva?autoReconnect=true / with a local mysql instance with catalog archiva and user archiva/archiva when accesing localhost:8080/archiva I get an exception, the logs will show this: 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,078 [http-8080-Processor24] INFO Interceptor:pssSecureActionInterceptor - org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor initialized! 2006-10-12 10:02:52,421 [http-8080-Processor24] ERROR VelocityComponent - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. 2006-10-12 10:02:55,281 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:55,812 [http-8080-Processor24] WARN General - SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 2006-10-12 10:02:56,515 [http-8080-Processor24] ERROR RDBMS - Error thrown executing CREATE TABLE `OPERATIONS` ( `NAME` VARCHAR(256) BINARY NOT NULL, `DESCRIPTION` VARCHAR(256) BINARY NULL, `PERMANENT` BIT NOT NULL, `RESOURCE_REQUIRED` BIT NOT NULL, PRIMARY KEY (`NAME`) ) TYPE=INNODB : BLOB/TEXT column 'NAME' used in key specification without a key length java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification without a key length at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) at com.mysql.jdbc.Connection.execSQL(Connection.java:2998) at com.mysql.jdbc.Connection.execSQL(Connection.java:2927) at com.mysql.jdbc.Statement.execute(Statement.java:535) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatem ent.java:261) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTab le.java:561) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(Abstrac tTable.java:516) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:244) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:287) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R DBMSManager.java:3006) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.j ava:2397) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603) at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617) at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016) at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134) at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager .java:2216) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll Objects(JdoTool.java:199) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll Objects(JdoTool.java:182) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.trigge rInit(JdoTool.java:131) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getPer sistenceManager(JdoTool.java:118) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getObj ectById(JdoTool.java:236) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.object ExistsById(JdoTool.java:283) at org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoRbacManager .roleExists(JdoRbacManager.java:124) at org.codehaus.plexus.rbac.profile.AbstractDynamicRoleProfile.getRole(Abst ractDynamicRoleProfile.java:164) at org.codehaus.plexus.rbac.profile.DefaultRoleProfileManager.getDynamicRol e(DefaultRoleProfileManager.java:87) at org.apache.maven.archiva.web.check.RoleExistanceEnvironmentCheck.validat eEnvironment(RoleExistanceEnvironmentCheck.java:74) at org.codehaus.plexus.security.ui.web.interceptor.EnvironmentCheckIntercep