OK false alarm. It's all my fault. The error was somewhere else.
Sorry about the noise.
candide
----- Original Message -----
From: fractals <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 8:29 AM
Subject: Re: [JBoss-user] help needed: don't understand exception (jaws)
> OK, but this is a long bean:
>
> the ejb-jar entry:
>
> <entity>
> <description>Models a user</description>
> <ejb-name>UserBean</ejb-name>
> <home>be.fractals.gatekeeper.ejb.UserHome</home>
> <remote>be.fractals.gatekeeper.ejb.User</remote>
> <ejb-class>be.fractals.gatekeeper.ejb.UserBean</ejb-class>
> <persistence-type>Container</persistence-type>
> <prim-key-class>java.lang.Long</prim-key-class>
> <primkey-field>id</primkey-field>
> <reentrant>False</reentrant>
> <cmp-field><field-name>id</field-name></cmp-field>
> <cmp-field><field-name>sessionId</field-name></cmp-field>
> <cmp-field><field-name>state</field-name></cmp-field>
> <cmp-field><field-name>pseudo</field-name></cmp-field>
> <cmp-field><field-name>password</field-name></cmp-field>
> <cmp-field><field-name>userLevel</field-name></cmp-field>
> <cmp-field><field-name>firstname</field-name></cmp-field>
> <cmp-field><field-name>lastname</field-name></cmp-field>
> <cmp-field><field-name>birth</field-name></cmp-field>
> <cmp-field><field-name>registrationDate</field-name></cmp-field>
> <cmp-field><field-name>sex</field-name></cmp-field>
> <cmp-field><field-name>streetAddress1</field-name></cmp-field>
> <cmp-field><field-name>streetAddress2</field-name></cmp-field>
> <cmp-field><field-name>streetNumber</field-name></cmp-field>
> <cmp-field><field-name>zip</field-name></cmp-field>
> <cmp-field><field-name>city</field-name></cmp-field>
> <cmp-field><field-name>country</field-name></cmp-field>
> <cmp-field><field-name>phone1</field-name></cmp-field>
> <cmp-field><field-name>phone2</field-name></cmp-field>
> <cmp-field><field-name>fax</field-name></cmp-field>
> <cmp-field><field-name>email</field-name></cmp-field>
> <cmp-field><field-name>url</field-name></cmp-field>
> <cmp-field><field-name>secretQuestion</field-name></cmp-field>
> <cmp-field><field-name>secretAnswer</field-name></cmp-field>
> <cmp-field><field-name>screenSize</field-name></cmp-field>
> <cmp-field><field-name>fastCpu</field-name></cmp-field>
>
> <cmp-field><field-name>urbaniumAnnouncesWanted</field-name></cmp-field>
> <cmp-field><field-name>otherAnnouncesWanted</field-name></cmp-field>
>
>
<cmp-field><field-name>urbaniumMailAnnouncesWanted</field-name></cmp-field>
>
> <cmp-field><field-name>otherMailAnnouncesWanted</field-name></cmp-field>
>
>
<cmp-field><field-name>urbaniumPostAnnouncesWanted</field-name></cmp-field>
>
> <cmp-field><field-name>otherPostAnnouncesWanted</field-name></cmp-field>
> <env-entry>
> <env-entry-name>dbName</env-entry-name>
> <env-entry-type>java.lang.String</env-entry-type>
> <env-entry-value>jdbc/gatekeeperStore</env-entry-value>
> </env-entry>
> </entity>
>
> The jaws entry:
>
> <entity>
> <ejb-name>UserBean</ejb-name>
> <table-name>users</table-name>
> <create-table>true</create-table>
> <cmp-field>
> <field-name>sessionId</field-name>
> <column-name>session_id</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>CHAR(30)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>state</field-name>
> <column-name>state</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>id</field-name>
> <column-name>id</column-name>
> <jdbc-type>BIGINT</jdbc-type>
> <sql-type>int8</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>pseudo</field-name>
> <column-name>pseudo</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(15)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>password</field-name>
> <column-name>password</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(15)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>userLevel</field-name>
> <column-name>user_level</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>firstname</field-name>
> <column-name>firstname</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(40)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>lastname</field-name>
> <column-name>lastname</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(40)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>birth</field-name>
> <column-name>birth</column-name>
> <jdbc-type>DATE</jdbc-type>
> <sql-type>date</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>registrationDate</field-name>
> <column-name>registration_date</column-name>
> <jdbc-type>TIMESTAMP</jdbc-type>
> <sql-type>timestamp</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>sex</field-name>
> <column-name>sex</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(1)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>streetAddress1</field-name>
> <column-name>street_address_1</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(50)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>streetAddress2</field-name>
> <column-name>street_address_2</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(50)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>streetNumber</field-name>
> <column-name>street_number</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>zip</field-name>
> <column-name>zip</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>city</field-name>
> <column-name>city</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(40)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>country</field-name>
> <column-name>country</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(40)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>phone1</field-name>
> <column-name>phone_1</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(40)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>phone2</field-name>
> <column-name>phone_2</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(40)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>fax</field-name>
> <column-name>fax</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(30)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>email</field-name>
> <column-name>email</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(70)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>url</field-name>
> <column-name>url</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(70)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>secretQuestion</field-name>
> <column-name>secret_question</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(100)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>secretAnswer</field-name>
> <column-name>secret_answer</column-name>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>varchar(100)</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>screenSize</field-name>
> <column-name>screen_size</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>fastCpu</field-name>
> <column-name>fast_cpu</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>urbaniumAnnouncesWanted</field-name>
> <column-name>urbanium_Announces_Wanted</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>otherAnnouncesWanted</field-name>
> <column-name>other_Announces_Wanted</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>urbaniumMailAnnouncesWanted</field-name>
> <column-name>urbanium_Mail_Announces_Wanted</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>otherMailAnnouncesWanted</field-name>
> <column-name>other_Mail_Announces_Wanted</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>urbaniumPostAnnouncesWanted</field-name>
> <column-name>urbanium_Post_Announces_Wanted</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> <cmp-field>
> <field-name>otherPostAnnouncesWanted</field-name>
> <column-name>other_Post_Announces_Wanted</column-name>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>integer</sql-type>
> </cmp-field>
> </entity>
>
> The field declarations:
>
> public String sessionId;
> public int state;
>
> public Long id;
> public String pseudo;
> public String password;
> public int userLevel;
> public String firstname;
> public String lastname;
> public java.sql.Date birth;
> public java.sql.Timestamp registrationDate;
> public String sex;
> public String streetAddress1;
> public String streetAddress2;
> public String streetNumber;
> public int zip;
> public String city;
> public String country;
> public String phone1;
> public String phone2;
> public String fax;
> public String email;
> public String url;
> public String secretQuestion;
> public String secretAnswer;
> public int screenSize;
> public int fastCpu;
> public int urbaniumAnnouncesWanted;
> public int otherAnnouncesWanted;
> public int urbaniumMailAnnouncesWanted;
> public int otherMailAnnouncesWanted;
> public int urbaniumPostAnnouncesWanted;
> public int otherPostAnnouncesWanted;
>
> And finally, the fields' initialization code:
>
> public Long ejbCreate ()
> throws RemoteException, CreateException
> {
> this.pseudo = pseudo;
> try {
> this.id = new Long ( getMaxId ()+1 );
> } catch ( Exception e ) {
> throw new RemoteException ( "cannot get maximum user id." +
e );
> }
> this.pseudo = "";
> this.password = "";
> this.userLevel = -1;
> this.firstname = "";
> this.lastname = "";
> this.birth = new java.sql.Date ( 0 );
> this.registrationDate = new java.sql.Timestamp ( 0 );
> this.sex = "-";
> this.streetAddress1 = "";
> this.streetAddress2 = "";
> this.streetNumber = "";
> this.zip = -1;
> this.city = "";
> this.country = "";
> this.phone1 = "";
> this.phone2 = "";
> this.fax = "";
> this.email = "";
> this.url = "";
> this.secretQuestion = "";
> this.secretAnswer = "";
> this.screenSize = -1;
> this.fastCpu = -1;
> this.urbaniumAnnouncesWanted = -1;
> this.otherAnnouncesWanted = -1;
> this.urbaniumMailAnnouncesWanted = -1;
> this.otherMailAnnouncesWanted = -1;
> this.urbaniumPostAnnouncesWanted = -1;
> this.otherPostAnnouncesWanted = -1;
> return id;
> }
>
> All I think must be checked is where there's a Timestamp object. In this
> code, there's only the registrationDate field which holds a Timestamp
value,
> and it's correctly set in the jaws.xml code.
>
> What's even weirder is that I have another CMP Bean with a Timestamp field
> which doesn't complain when created...
>
> regards,
>
> candide
>
> > it would be helpful if you provided us with your code and your database
> > table structure.
> > somehow your code (CMP) calls setObject with java.sql.Timestamp object,
> when
> > something else is expected.
> >
> > Filip
> >
> > ~
> > Namaste - I bow to the divine in you
> > ~
> > Filip Hanik
> > Software Architect
> > [EMAIL PROTECTED]
> > www.filip.net
> >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]On Behalf Of fractals
> > > Sent: Wednesday, March 07, 2001 1:17 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [JBoss-user] help needed: don't understand exception
> > >
> > >
> > > I get the following exception on attempt to create an ejb:
> > >
> > > java.rmi.ServerException: Store failed; nested exception is:
> > > java.lang.ClassCastException: java.sql.Timestamp
> > > at org.postgresql.jdbc2.PreparedStatement.setObject
> > > (PreparedStatement.java:480)
> > >
> > > the jaws.xml is correctly set though,...
> > >
> > > Just in case someone already faced the same problem, or someone just
> knows
> > > all conditions under which the same exception occurs,...
> > >
> > > thanks in advance,
> > >
> > > Candide
> > >
> > >
> > > _______________________________________________
> > > JBoss-user mailing list
> > > [EMAIL PROTECTED]
> > > http://lists.sourceforge.net/lists/listinfo/jboss-user
> > >
> >
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
> >
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
