Hi,
What interclient version are you using, which dialect db?
Can you find the generated sql and send it? (there's a debug switch
somewhere in jaws, I don't remember if you have to set it and recompile or
if there's some way of configuring it on.
david jencks
On 2001.05.23 09:16:23 -0400 Belli Andrea wrote:
> This is the error:
>
> [mail.News] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception
> is:
> java.sql.SQLException: Unable to create PreparedStatement!;
> nested
> exception is:
> java.rmi.ServerException: Load failed; nested exception is:
> java.sql.SQLException: Unable to create PreparedStatement!
>
> and the type mapping is the same in standardjaws.xml:
> <type-mapping>
> <name>InterBase</name>
> <mapping>
> <java-type>java.lang.Boolean</java-type>
> <jdbc-type>BIT</jdbc-type>
> <sql-type>SMALLINT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Byte</java-type>
> <jdbc-type>TINYINT</jdbc-type>
> <sql-type>SMALLINT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Short</java-type>
> <jdbc-type>SMALLINT</jdbc-type>
> <sql-type>SMALLINT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Integer</java-type>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>INTEGER</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Long</java-type>
> <jdbc-type>BIGINT</jdbc-type>
> <sql-type>NUMERIC(18,0)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Float</java-type>
> <jdbc-type>REAL</jdbc-type>
> <sql-type>FLOAT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Double</java-type>
> <jdbc-type>DOUBLE</jdbc-type>
> <sql-type>DOUBLE PRECISION</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Character</java-type>
> <jdbc-type>CHAR</jdbc-type>
> <sql-type>CHAR</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.String</java-type>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR(255)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.Date</java-type>
> <jdbc-type>DATE</jdbc-type>
> <sql-type>DATE</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.Time</java-type>
> <jdbc-type>TIME</jdbc-type>
> <sql-type>TIME</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.Timestamp</java-type>
> <jdbc-type>TIMESTAMP</jdbc-type>
> <sql-type>TIMESTAMP</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Object</java-type>
> <jdbc-type>JAVA_OBJECT</jdbc-type>
> <sql-type>VARCHAR(2000)</sql-type>
> </mapping>
> </type-mapping>
>
> I used a field DATE_BEGIN of type java.sql.Date in the entity bean,
> mapping
> the column DATE_BEGIN in the db created with the statement: DATE_BEGIN
> DATE
> NOT NULL,
>
> it's a maze and I've got lost!
> Andrea
> -----Messaggio originale-----
> Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Inviato: Wednesday, May 23, 2001 1:28 PM
> A: [EMAIL PROTECTED]
> Oggetto: RE: [JBoss-user] Interbase 6 problem
>
>
> What kind of exception did you get on server side?
> Can you include mapping here?
>
> And, for sure, storing date in String should not be the problem, as long
> as
> JAWS is able to parse it. Also, I would suggest to use VARCHAR sql type
> instead of CHAR (JAWS may have problems to parse the empty spaces).
>
> > -----Original Message-----
> > From: Belli Andrea [mailto:[EMAIL PROTECTED]]
> > Sent: Mittwoch, 23. Mai 2001 11:56
> > To: Jboss-User (E-mail)
> > Subject: [JBoss-user] Interbase 6 problem
> >
> >
> > I have a problem with data type date: in type mappings found in
> > standardjaws.xml the type mapping for DATE is java.sql.Date,
> > so I use it in
> > the field of the entity bean.
> > The problem is that I receive an error about the composition of
> > PreparedStatement; I tried to change the Date type with a
> > String and It
> > seems to function.
> > What is the problem? Andrea
> >
> > _______________________________________________
> > 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
