Bugs item #983945, was opened at 2004-07-02 11:57
Message generated for change (Comment added) made by loubyansky
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=983945&group_id=22866
Category: JBossCMP
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: radl (radl01)
Assigned to: Alexey Loubyansky (loubyansky)
Summary: CMP and Sybase JConnect (Short field)
Initial Comment:
I had a problem with Short CMP fields with JConnect
JDBC driver for ASE/ASA. JConnect does not support
setObject() method with Short Object type.
I had to change a source code
(org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil) in
setParameter method a litle bit: I added one more case
Code:
case Types.SMALLINT: // due to setObject
problem with JConnect
if (value instanceof Short) {
ps.setShort(index,
((Short)value).shortValue());
} else {
ps.setObject(index, value, jdbcType);
}
break;
Jan
----------------------------------------------------------------------
>Comment By: Alexey Loubyansky (loubyansky)
Date: 2004-07-02 13:31
Message:
Logged In: YES
user_id=543482
Yes, try something other than SMALLINT.
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
<sql-type>SMALLINT</sql-type>
</mapping>
Putting in vendor-specific hacks is a bad habit and should
be avoided if possible. If there already are hacks for
JConnect then think about its quality.
I don't mind having vendor specific extensions specifically
in setting parameters and reading results to workaround
their bugs but I have other priorities. If someone wants to
help we can discuss it.
----------------------------------------------------------------------
Comment By: radl (radl01)
Date: 2004-07-02 13:11
Message:
Logged In: YES
user_id=1075502
I do not understand. How can I use defferent mappings when
my CMP fields are Short ? You mean to set Integer mapping to
my Short CMP fields ?
Is it a problem to change JDBCUtil class ? I see that you
have already change this class due to JConnect bugs.
Jan
----------------------------------------------------------------------
Comment By: Alexey Loubyansky (loubyansky)
Date: 2004-07-02 12:38
Message:
Logged In: YES
user_id=543482
Actually, if you can't set Short parameter using this method
then it's a bug in JConnect as it does not implement the
JDBC spec. Try different sql/jdbc mappings.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=983945&group_id=22866
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
