Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Heiko W.R. <pi...@us...> - 2004-01-12 15:37:32
|
User: pilhuhn
Date: 04/01/12 07:37:31
Modified: src/etc/conf/default Tag: Branch_3_2
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
No revision
No revision
1.39.2.38 +15 -2 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.39.2.37
retrieving revision 1.39.2.38
diff -u -r1.39.2.37 -r1.39.2.38
--- standardjbosscmp-jdbc.xml 31 Dec 2003 15:41:26 -0000 1.39.2.37
+++ standardjbosscmp-jdbc.xml 12 Jan 2004 15:37:30 -0000 1.39.2.38
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.37 2003/12/31 15:41:26 ejort Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.38 2004/01/12 15:37:30 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -579,6 +579,11 @@
<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>
@@ -643,13 +648,21 @@
<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>
<name>Oracle9i</name>
<!--
|
