- Original Message -
From: "DBS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 21, 2004 7:37 AM
Subject: Primary key error
> Hi list,
>
> MySQL newbie here and am using Navicat to learn how to manage a database
for
> a test OS sho
Hi list,
MySQL newbie here and am using Navicat to learn how to manage a database for
a test OS shopping cart. I got the below error message after importing a
table into the database. Can anyone tell me what I could do to correct the
problem? Would I need to add an additional column to the tabl
> user drop primary key;". Work fine. But "alter table user add primary key
> (userName)" didn't work. It print "ERROR 1062: Duplicate entry 'a' for key
> 1". What's wrong? Help me.
This means that you have more than one record with the same value under the
userName column...
try this
SELECT us
Mysql 2.23.45 win98.
I create a table "user".
FieldTypeNullKeyDefaultExtra
idchar(10)
userNamechar(20)
I type " alter table user add primary key (id);". It work fine. "alter table
user drop primary key;". Work fine. But "alter table user add primary key
(userName)" didn
(in case you're wondering, yes, i did get mysql working argh.)
info: WO5, Mac OS X 10.0.4, MySQL 3.23.32, mm.mysql JDBC adaptor 2.0.6.1
I get this error:
>java.lang.IllegalStateException: Adaptor
>com.webobjects.jdbcadaptor.JDBCAdaptor@b7ad3 failed to provide new primary
>keys for entity
Also, I'm seeing this in the logfile:
java.lang.NullPointerException
: Exception occurred while handling request:
com.webobjects.foundation.NSForwardException
[com.webobjects.jdbcadaptor.JDBCAdaptorException] null
Paul
>(in case you're wondering, yes, i did get mysql working argh.)
>
>
