I succeeded to use it with mysql 5.x But I wasn't able to install it with mysql 4.x.
Arnaud On 11/3/06, Arnaud HERITIER <[EMAIL PROTECTED]> wrote:
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 > > From "Arnaud HERITIER" <[EMAIL PROTECTED]> > Subject Re: supported databases ? > Date Thu, 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 >
