You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@archiva.apache.org by Glenn J Gonzales <gl...@simulalabs.com> on 2006/11/03 09:08:12 UTC
Re: Re: supported databases ?
Hi Arnaud, I tried this with MySQL 5.0.27 with Connector/J 5.04.
Worked without a hitch.
Cheers,
Glenn
From "Arnaud HERITIER" <ah...@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 <da...@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
Re: Re: supported databases ?
Posted by Arnaud HERITIER <ah...@gmail.com>.
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 <ah...@gmail.com> 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 < 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" <ah...@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 <da...@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
> >
>
>
Re: Re: supported databases ?
Posted by Arnaud HERITIER <ah...@gmail.com>.
Hi,
Thanks a lot.
I didn't yet try. I'll do it the next week.
Arnaud
On 11/3/06, Glenn J Gonzales <gl...@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" <ah...@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 <da...@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
>