i have the following sql table:
create table portalComponent (
id integer unsigned not null auto_increment,
name varchar(60),
type smallint unsigned not null default 1,
defaultFontName varchar(50) not null default 'Verdana',
defaultFontSize smallint unsigned not null default 12,
defaultFgColor char(7) not null default '#000000',
defaultBgColor char(7) not null default '#ffffff',
primary key(id)
);
in ejbCreate i want to put only 1 method setName(...).
for the rest of the columns it should put the values default.
in jbosscmp-jdbc.xml i have the following for this:
<cmp-field>
<field-name>fontName</field-name>
<column-name>defaultFontName</column-name>
<not-null/>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>varchar(50) not null default 'Verdana'</sql-type>
</cmp-field>
the error it gives me is:
12:31:55,254 ERROR [PortalComponent] Could not create entity
java.sql.SQLException: Column 'defaultFontName' cannot be null
thank you in advance
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3880908#3880908
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3880908
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
