archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arnaud HERITIER" <aherit...@gmail.com>
Subject Re: Re: supported databases ?
Date Fri, 03 Nov 2006 22:19:09 GMT
Hi,

  Thanks a lot.
  I didn't yet try. I'll do it the next week.

Arnaud

On 11/3/06, Glenn J Gonzales <glenn.gonzales@simulalabs.com> 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" <aherit...@gmail.com>
> 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 <daniel.mohni@ch.unisys.com> 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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message