You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@maven.apache.org by Zemian Deng <ke...@gmail.com> on 2008/01/07 19:57:16 UTC
archiva failed with mysql setup
Hi list,
I didn't see a separated list for archiva, so I post question here.
I am installing archiva with default derby worked fine. Now I am trying to
configure to use Mysql. When I run my Tomcat server, I get the following
error:
2008-01-07 13:18:12,481 [main] INFO
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva]
- Loading plexus context properties from: '/WEB-INF/plexus.properties'
2008-01-07 13:18:12,488 [main] INFO
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva]
- Could not load plexus context properties from:
'/WEB-INF/plexus.properties'
2008-01-07 13:18:13,365 [main] INFO org.codehaus.plexus.PlexusContainer -
Loading on start [role,roleHint]: [
org.apache.maven.archiva.web.startup.ArchivaStartup,default]
2008-01-07 13:18:15,031 [main] WARN
net.sf.ehcache.config.ConfigurationFactory - No configuration found.
Configuring ehcache from ehcache-failsafe.xml found in the classpath:
jar:file:/opt/apache-tomcat-5.5.17
/instances/buildman/webapps/archiva/WEB-INF/lib/ehcache-
1.3.0.jar!/ehcache-failsafe.xml
2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning:
java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use
'ENGINE=storage_engine' instead
2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown executing
CREATE TABLE `SECURITY_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
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column 'NAME'
used in key specification without a key length
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
I assume that I have to specific somewhere that I am using Mysql dialect?
Can't find where to configure this. Can someone help me here? Thanks.
-Zemian
Re: archiva failed with mysql setup
Posted by Zemian Deng <ke...@gmail.com>.
Mick, My exact error are gone now after I restart Tomcat again. It's weird.
But anyways, to your replied, I think the following works actually:
1.) default mysql jdbc url is to 3306. The exception did not complain
connection problem, but an SQLException when creating table.
2.) the two databases are assuming user table are in different
location(which is a good feature). But if I wanted them all in the same db,
it should create wihtou problem as it has different table names than the
rest of the application. So pointing two db settings back into one db should
works.
Thanks for quick response.
-Zemian
On Jan 7, 2008 3:17 PM, Mick Knutson <mi...@gmail.com> wrote:
> You did not specify the port :3306 in your jdbc URL And you need 2 DB's. 1
> for archiva, and 1 for users.
>
>
> On Jan 7, 2008 11:34 AM, Zemian Deng <ke...@gmail.com> wrote:
>
> > @Mick
> > I am using Mysql version 4.1.21-standard
> >
> > Here are archiva.xml
> > <Context path="/archiva"
> > docBase="${catalina.base}/wars/apache-archiva-1.0.war">
> > <Resource name="jdbc/users" auth="Container" type="
> > javax.sql.DataSource
> > "
> > username="archiva"
> > password="archiva"
> > driverClassName="com.mysql.jdbc.Driver"
> > url="jdbc:mysql://localhost/archiva" />
> >
> > <Resource name="jdbc/archiva" auth="Container" type="
> > javax.sql.DataSource"
> > username="archiva"
> > password="archiva"
> > driverClassName="com.mysql.jdbc.Driver"
> > url="jdbc:mysql://localhost/archiva" />
> > <Resource name="mail/Session" auth="Container"
> > type="javax.mail.Session"
> > mail.smtp.host="popmail01.corporate.connextions.net"/>
> > </Context>
> >
> >
> >
> > @Wayne
> > Thanks! I will post there from now on after this question :)
> >
> > -Zemian
> >
> > On Jan 7, 2008 2:05 PM, Wayne Fay <wa...@gmail.com> wrote:
> >
> > > As Wendy says... ;-)
> > >
> > > Archiva has separate mailing lists... please come join us there if you
> > > have questions: http://maven.apache.org/archiva/mail-lists.html
> > >
> > > Wayne
> > >
> > > On 1/7/08, Mick Knutson <mi...@gmail.com> wrote:
> > > > What MySql Version?
> > > >
> > > > Can you post your archiva.xml?
> > > >
> > > >
> > > > On Jan 7, 2008 10:57 AM, Zemian Deng <ke...@gmail.com>
> wrote:
> > > >
> > > > > Hi list,
> > > > > I didn't see a separated list for archiva, so I post question
> here.
> > > > >
> > > > > I am installing archiva with default derby worked fine. Now I am
> > > trying to
> > > > > configure to use Mysql. When I run my Tomcat server, I get the
> > > following
> > > > > error:
> > > > >
> > > > > 2008-01-07 13:18:12,481 [main] INFO
> > > > > org.apache.catalina.core.ContainerBase
> > > .[Catalina].[localhost].[/archiva]
> > > > > - Loading plexus context properties from:
> > '/WEB-INF/plexus.properties'
> > > > > 2008-01-07 13:18:12,488 [main] INFO
> > > > > org.apache.catalina.core.ContainerBase
> > > .[Catalina].[localhost].[/archiva]
> > > > > - Could not load plexus context properties from:
> > > > > '/WEB-INF/plexus.properties'
> > > > > 2008-01-07 13:18:13,365 [main] INFO
> > > org.codehaus.plexus.PlexusContainer -
> > > > > Loading on start [role,roleHint]: [
> > > > > org.apache.maven.archiva.web.startup.ArchivaStartup,default]
> > > > > 2008-01-07 13:18:15,031 [main] WARN
> > > > > net.sf.ehcache.config.ConfigurationFactory - No configuration
> > found.
> > > > > Configuring ehcache from ehcache-failsafe.xml found in the
> > classpath:
> > > > > jar:file:/opt/apache-tomcat-5.5.17
> > > > > /instances/buildman/webapps/archiva/WEB-INF/lib/ehcache-
> > > > > 1.3.0.jar!/ehcache-failsafe.xml
> > > > > 2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning:
> > > > > java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use
> > > > > 'ENGINE=storage_engine' instead
> > > > > 2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown
> > > executing
> > > > > CREATE TABLE `SECURITY_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
> > > > > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT
> > column
> > > > > 'NAME'
> > > > > used in key specification without a key length
> > > > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java
> :936)
> > > > >
> > > > > I assume that I have to specific somewhere that I am using Mysql
> > > dialect?
> > > > > Can't find where to configure this. Can someone help me here?
> > Thanks.
> > > > >
> > > > > -Zemian
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Thanks,
> > > > Mick Knutson
> > > >
> > > > http://www.baselogic.com
> > > > http://www.blincmagazine.com
> > > > http://www.djmick.com
> > > > http://www.myspace.com/mickknutson
> > > > http://www.myspace.com/BLiNCMagazine
> > > > http://tahoe.baselogic.com
> > > > ---
> > > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
> > > For additional commands, e-mail: users-help@maven.apache.org
> > >
> > >
> >
>
>
>
> --
> Thanks,
> Mick Knutson
>
> http://www.baselogic.com
> http://www.blincmagazine.com
> http://www.djmick.com
> http://www.myspace.com/mickknutson
> http://www.myspace.com/BLiNCMagazine
> http://tahoe.baselogic.com
> ---
>
Re: archiva failed with mysql setup
Posted by Mick Knutson <mi...@gmail.com>.
You did not specify the port :3306 in your jdbc URL And you need 2 DB's. 1
for archiva, and 1 for users.
On Jan 7, 2008 11:34 AM, Zemian Deng <ke...@gmail.com> wrote:
> @Mick
> I am using Mysql version 4.1.21-standard
>
> Here are archiva.xml
> <Context path="/archiva"
> docBase="${catalina.base}/wars/apache-archiva-1.0.war">
> <Resource name="jdbc/users" auth="Container" type="
> javax.sql.DataSource
> "
> username="archiva"
> password="archiva"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost/archiva" />
>
> <Resource name="jdbc/archiva" auth="Container" type="
> javax.sql.DataSource"
> username="archiva"
> password="archiva"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost/archiva" />
> <Resource name="mail/Session" auth="Container"
> type="javax.mail.Session"
> mail.smtp.host="popmail01.corporate.connextions.net"/>
> </Context>
>
>
>
> @Wayne
> Thanks! I will post there from now on after this question :)
>
> -Zemian
>
> On Jan 7, 2008 2:05 PM, Wayne Fay <wa...@gmail.com> wrote:
>
> > As Wendy says... ;-)
> >
> > Archiva has separate mailing lists... please come join us there if you
> > have questions: http://maven.apache.org/archiva/mail-lists.html
> >
> > Wayne
> >
> > On 1/7/08, Mick Knutson <mi...@gmail.com> wrote:
> > > What MySql Version?
> > >
> > > Can you post your archiva.xml?
> > >
> > >
> > > On Jan 7, 2008 10:57 AM, Zemian Deng <ke...@gmail.com> wrote:
> > >
> > > > Hi list,
> > > > I didn't see a separated list for archiva, so I post question here.
> > > >
> > > > I am installing archiva with default derby worked fine. Now I am
> > trying to
> > > > configure to use Mysql. When I run my Tomcat server, I get the
> > following
> > > > error:
> > > >
> > > > 2008-01-07 13:18:12,481 [main] INFO
> > > > org.apache.catalina.core.ContainerBase
> > .[Catalina].[localhost].[/archiva]
> > > > - Loading plexus context properties from:
> '/WEB-INF/plexus.properties'
> > > > 2008-01-07 13:18:12,488 [main] INFO
> > > > org.apache.catalina.core.ContainerBase
> > .[Catalina].[localhost].[/archiva]
> > > > - Could not load plexus context properties from:
> > > > '/WEB-INF/plexus.properties'
> > > > 2008-01-07 13:18:13,365 [main] INFO
> > org.codehaus.plexus.PlexusContainer -
> > > > Loading on start [role,roleHint]: [
> > > > org.apache.maven.archiva.web.startup.ArchivaStartup,default]
> > > > 2008-01-07 13:18:15,031 [main] WARN
> > > > net.sf.ehcache.config.ConfigurationFactory - No configuration
> found.
> > > > Configuring ehcache from ehcache-failsafe.xml found in the
> classpath:
> > > > jar:file:/opt/apache-tomcat-5.5.17
> > > > /instances/buildman/webapps/archiva/WEB-INF/lib/ehcache-
> > > > 1.3.0.jar!/ehcache-failsafe.xml
> > > > 2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning:
> > > > java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use
> > > > 'ENGINE=storage_engine' instead
> > > > 2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown
> > executing
> > > > CREATE TABLE `SECURITY_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
> > > > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT
> column
> > > > 'NAME'
> > > > used in key specification without a key length
> > > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> > > >
> > > > I assume that I have to specific somewhere that I am using Mysql
> > dialect?
> > > > Can't find where to configure this. Can someone help me here?
> Thanks.
> > > >
> > > > -Zemian
> > > >
> > >
> > >
> > >
> > > --
> > > Thanks,
> > > Mick Knutson
> > >
> > > http://www.baselogic.com
> > > http://www.blincmagazine.com
> > > http://www.djmick.com
> > > http://www.myspace.com/mickknutson
> > > http://www.myspace.com/BLiNCMagazine
> > > http://tahoe.baselogic.com
> > > ---
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
> > For additional commands, e-mail: users-help@maven.apache.org
> >
> >
>
--
Thanks,
Mick Knutson
http://www.baselogic.com
http://www.blincmagazine.com
http://www.djmick.com
http://www.myspace.com/mickknutson
http://www.myspace.com/BLiNCMagazine
http://tahoe.baselogic.com
---
Re: archiva failed with mysql setup
Posted by Zemian Deng <ke...@gmail.com>.
@Mick
I am using Mysql version 4.1.21-standard
Here are archiva.xml
<Context path="/archiva"
docBase="${catalina.base}/wars/apache-archiva-1.0.war">
<Resource name="jdbc/users" auth="Container" type="javax.sql.DataSource
"
username="archiva"
password="archiva"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/archiva" />
<Resource name="jdbc/archiva" auth="Container" type="
javax.sql.DataSource"
username="archiva"
password="archiva"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/archiva" />
<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"
mail.smtp.host="popmail01.corporate.connextions.net"/>
</Context>
@Wayne
Thanks! I will post there from now on after this question :)
-Zemian
On Jan 7, 2008 2:05 PM, Wayne Fay <wa...@gmail.com> wrote:
> As Wendy says... ;-)
>
> Archiva has separate mailing lists... please come join us there if you
> have questions: http://maven.apache.org/archiva/mail-lists.html
>
> Wayne
>
> On 1/7/08, Mick Knutson <mi...@gmail.com> wrote:
> > What MySql Version?
> >
> > Can you post your archiva.xml?
> >
> >
> > On Jan 7, 2008 10:57 AM, Zemian Deng <ke...@gmail.com> wrote:
> >
> > > Hi list,
> > > I didn't see a separated list for archiva, so I post question here.
> > >
> > > I am installing archiva with default derby worked fine. Now I am
> trying to
> > > configure to use Mysql. When I run my Tomcat server, I get the
> following
> > > error:
> > >
> > > 2008-01-07 13:18:12,481 [main] INFO
> > > org.apache.catalina.core.ContainerBase
> .[Catalina].[localhost].[/archiva]
> > > - Loading plexus context properties from: '/WEB-INF/plexus.properties'
> > > 2008-01-07 13:18:12,488 [main] INFO
> > > org.apache.catalina.core.ContainerBase
> .[Catalina].[localhost].[/archiva]
> > > - Could not load plexus context properties from:
> > > '/WEB-INF/plexus.properties'
> > > 2008-01-07 13:18:13,365 [main] INFO
> org.codehaus.plexus.PlexusContainer -
> > > Loading on start [role,roleHint]: [
> > > org.apache.maven.archiva.web.startup.ArchivaStartup,default]
> > > 2008-01-07 13:18:15,031 [main] WARN
> > > net.sf.ehcache.config.ConfigurationFactory - No configuration found.
> > > Configuring ehcache from ehcache-failsafe.xml found in the classpath:
> > > jar:file:/opt/apache-tomcat-5.5.17
> > > /instances/buildman/webapps/archiva/WEB-INF/lib/ehcache-
> > > 1.3.0.jar!/ehcache-failsafe.xml
> > > 2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning:
> > > java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use
> > > 'ENGINE=storage_engine' instead
> > > 2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown
> executing
> > > CREATE TABLE `SECURITY_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
> > > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column
> > > 'NAME'
> > > used in key specification without a key length
> > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> > >
> > > I assume that I have to specific somewhere that I am using Mysql
> dialect?
> > > Can't find where to configure this. Can someone help me here? Thanks.
> > >
> > > -Zemian
> > >
> >
> >
> >
> > --
> > Thanks,
> > Mick Knutson
> >
> > http://www.baselogic.com
> > http://www.blincmagazine.com
> > http://www.djmick.com
> > http://www.myspace.com/mickknutson
> > http://www.myspace.com/BLiNCMagazine
> > http://tahoe.baselogic.com
> > ---
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
> For additional commands, e-mail: users-help@maven.apache.org
>
>
Re: archiva failed with mysql setup
Posted by Wayne Fay <wa...@gmail.com>.
As Wendy says... ;-)
Archiva has separate mailing lists... please come join us there if you
have questions: http://maven.apache.org/archiva/mail-lists.html
Wayne
On 1/7/08, Mick Knutson <mi...@gmail.com> wrote:
> What MySql Version?
>
> Can you post your archiva.xml?
>
>
> On Jan 7, 2008 10:57 AM, Zemian Deng <ke...@gmail.com> wrote:
>
> > Hi list,
> > I didn't see a separated list for archiva, so I post question here.
> >
> > I am installing archiva with default derby worked fine. Now I am trying to
> > configure to use Mysql. When I run my Tomcat server, I get the following
> > error:
> >
> > 2008-01-07 13:18:12,481 [main] INFO
> > org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva]
> > - Loading plexus context properties from: '/WEB-INF/plexus.properties'
> > 2008-01-07 13:18:12,488 [main] INFO
> > org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva]
> > - Could not load plexus context properties from:
> > '/WEB-INF/plexus.properties'
> > 2008-01-07 13:18:13,365 [main] INFO org.codehaus.plexus.PlexusContainer -
> > Loading on start [role,roleHint]: [
> > org.apache.maven.archiva.web.startup.ArchivaStartup,default]
> > 2008-01-07 13:18:15,031 [main] WARN
> > net.sf.ehcache.config.ConfigurationFactory - No configuration found.
> > Configuring ehcache from ehcache-failsafe.xml found in the classpath:
> > jar:file:/opt/apache-tomcat-5.5.17
> > /instances/buildman/webapps/archiva/WEB-INF/lib/ehcache-
> > 1.3.0.jar!/ehcache-failsafe.xml
> > 2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning:
> > java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use
> > 'ENGINE=storage_engine' instead
> > 2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown executing
> > CREATE TABLE `SECURITY_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
> > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column
> > 'NAME'
> > used in key specification without a key length
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> >
> > I assume that I have to specific somewhere that I am using Mysql dialect?
> > Can't find where to configure this. Can someone help me here? Thanks.
> >
> > -Zemian
> >
>
>
>
> --
> Thanks,
> Mick Knutson
>
> http://www.baselogic.com
> http://www.blincmagazine.com
> http://www.djmick.com
> http://www.myspace.com/mickknutson
> http://www.myspace.com/BLiNCMagazine
> http://tahoe.baselogic.com
> ---
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org
Re: archiva failed with mysql setup
Posted by Mick Knutson <mi...@gmail.com>.
What MySql Version?
Can you post your archiva.xml?
On Jan 7, 2008 10:57 AM, Zemian Deng <ke...@gmail.com> wrote:
> Hi list,
> I didn't see a separated list for archiva, so I post question here.
>
> I am installing archiva with default derby worked fine. Now I am trying to
> configure to use Mysql. When I run my Tomcat server, I get the following
> error:
>
> 2008-01-07 13:18:12,481 [main] INFO
> org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva]
> - Loading plexus context properties from: '/WEB-INF/plexus.properties'
> 2008-01-07 13:18:12,488 [main] INFO
> org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva]
> - Could not load plexus context properties from:
> '/WEB-INF/plexus.properties'
> 2008-01-07 13:18:13,365 [main] INFO org.codehaus.plexus.PlexusContainer -
> Loading on start [role,roleHint]: [
> org.apache.maven.archiva.web.startup.ArchivaStartup,default]
> 2008-01-07 13:18:15,031 [main] WARN
> net.sf.ehcache.config.ConfigurationFactory - No configuration found.
> Configuring ehcache from ehcache-failsafe.xml found in the classpath:
> jar:file:/opt/apache-tomcat-5.5.17
> /instances/buildman/webapps/archiva/WEB-INF/lib/ehcache-
> 1.3.0.jar!/ehcache-failsafe.xml
> 2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning:
> java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use
> 'ENGINE=storage_engine' instead
> 2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown executing
> CREATE TABLE `SECURITY_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
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column
> 'NAME'
> used in key specification without a key length
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
>
> I assume that I have to specific somewhere that I am using Mysql dialect?
> Can't find where to configure this. Can someone help me here? Thanks.
>
> -Zemian
>
--
Thanks,
Mick Knutson
http://www.baselogic.com
http://www.blincmagazine.com
http://www.djmick.com
http://www.myspace.com/mickknutson
http://www.myspace.com/BLiNCMagazine
http://tahoe.baselogic.com
---