-
1. Re: Strange Problems with Timestamp
scoy Aug 14, 2003 5:58 PM (in response to wellington.pinheiro)What JDBC/SQL mappings are you using?
Steve Coy -
2. Re: Strange Problems with Timestamp
wellington.pinheiro Aug 15, 2003 10:52 AM (in response to wellington.pinheiro)The datasource-mapping is set to Oracle8.
For the field we defined as Timestamp we use the default values for the field we use as Password (that is a byte[]) we force the values on jbosscmp-jdbc:
<jdbc-type>LONGVARBINARY</jdbc-type>
<sql-type>LONG RAW</sql-type>
We are using jboss 3.0.3 -
3. Re: Strange Problems with Timestamp
scoy Aug 18, 2003 6:30 AM (in response to wellington.pinheiro)You are using a very old version of JBoss 3.0.
In fact, 3.0.4 had significant fixes to the handling of binary data.
Also, there are now Oracle 9i datasource mappings with proper support for the TimeStamp datatype (which does not exist in Oracle 8).
Using JBoss 3.0.4 or later, VABINARY/RAW should work fine for your password field.
Steve Coy -
4. Re: Strange Problems with Timestamp
wellington.pinheiro Aug 18, 2003 12:50 PM (in response to wellington.pinheiro)Hi, now I'm using JBoss 3.2.2RC2 and I changed the mapping for Oracle9i.
If I don't change the type of the column on the database from DATE to TIMESTAMP the problem remains...if I change it works with no problem.
I tried to force the configuration on the jbosscmp-jdbc to:
<cmp-field>
<field-name>dtUltAlterSenha</field-name>
<column-name>DT_ULT_ALTER_SENHA</column-name>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</cmp-field>
but jboss throws an exception when it tries to persist the data!!
I still don't know what's happening here!! But it's really strange! -
5. Re: Strange Problems with Timestamp
scoy Aug 19, 2003 7:46 AM (in response to wellington.pinheiro)What's the exception?
Please show the full stack trace.
Is it possible that you created the table with an SQL type of TIMESTAMP initially?
Steve Coy -
6. Re: Strange Problems with Timestamp
wellington.pinheiro Aug 25, 2003 11:14 AM (in response to wellington.pinheiro)We don't have any field as TIMESTAMP. We always used DATE.
I tried to make a change, I redefined the field as VARCHAR2 and in my Entity bean I put a method that converts the byte array to a two digits hexadecimal.
It's strange but the problem is still there! I think that it can be a situation where my entity bean (or my session bean maybe) throws some kind of exception that I catch in any part of the code but doesn't show the stack trace !
I will provide you the stack trace asap!!
Thanks for your help!! -
7. Re: Strange Problems with Timestamp
wellington.pinheiro Aug 25, 2003 11:32 AM (in response to wellington.pinheiro)I attached the piece of log messages of my server.log where you can find the stack trace.