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