Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Heiko W.R. <pi...@us...> - 2004-01-12 15:42:42
|
User: pilhuhn
Date: 04/01/12 07:42:41
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
db2 complains about a bad parameter map when not casting the arguments.
When using blobs, db2 choked on jdbc-type JAVA_OBJECT.
Revision Changes Path
1.70 +15 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.69
retrieving revision 1.70
diff -u -r1.69 -r1.70
--- standardjbosscmp-jdbc.xml 31 Dec 2003 15:42:39 -0000 1.69
+++ standardjbosscmp-jdbc.xml 12 Jan 2004 15:42:41 -0000 1.70
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.69 2003/12/31 15:42:39 ejort Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.70 2004/01/12 15:42:41 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -578,6 +578,12 @@
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
</function-mapping>
+
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>locate(CAST(?1 as VARCHAR(254)),
+ CAST(?2 as VaRCHAR(254)),?3)</function-sql>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -642,11 +648,19 @@
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
+ <!-- this one gives errors with DB2 V8.1
+ and at least the NET driver
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB(2000)</sql-type>
</mapping>
+ -->
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BLOB(2000)</sql-type>
+ </mapping>
</type-mapping>
<type-mapping>
|
