From: Boris T. <BTa...@re...> - 2002-09-04 21:53:48
|
Thanks David, It as a driver issue. Boris From: David Ward <dav...@do...> Organization: Distributed Object Technologies, Inc. To: jbo...@li... Subject: Re: [JBoss-user] RE: CMP2 java.lang.Short mapping for Oracle 9i Reply-To: jbo...@li... Just curious if you've tried the 9.2.0.1.0 driver, "ojdbc14.jar" Oracle has stopped calling it classes12.zip/jar. Not sure if the latest would work better for you or not... David -- Boris Tamarkin wrote: > So java.lang.Short can't be mapped with CMP2 for Oracle? > It is strange. > I tried to replace jdbc-type with INTEGER, but it doesn't work as well. > I don't wont to change existing code: replace java.lang.Short type with > Integer, because it is already works with > mySQL and MSSQL databases fine. We just need to add support to Oracle. > BTW, I have the Oracle 9i version of classes12.jar in lib directory > > Anyone knows how to resolve this issue with supporting java.lang.Short > in CMP2? > I have tried to search in forum archives without success. > Dan, may be You can help? > Thanks, > Boris > > From: "Saroj Kumar" <kum...@wi...> > To: <jbo...@li...> > Subject: RE: [JBoss-user] CMP2 java.lang.Short mapping for Oracle 9i > Date: Wed, 4 Sep 2002 10:42:02 +0530 > Organization: wipro > Reply-To: jbo...@li... > > Try INTEGER. > -----Original Message----- > From: jbo...@li... > [mailto:jbo...@li...] On Behalf Of Boris > Tamarkin > Sent: Wednesday, September 04, 2002 3:44 AM > To: 'jbo...@li...' > Subject: [JBoss-user] CMP2 java.lang.Short mapping for Oracle 9i > > > > What correct mapping for "java.lang.Short" should be for Oracle 9i in > standardjbosscmp-jdbc.xml file? > I have tried > <java-type>java.lang.Short</java-type> > <jdbc-type>NUMERIC</jdbc-type> > <sql-type>NUMBER(5)</sql-type> > also > <java-type>java.lang.Short</java-type> > <jdbc-type>SMALLINT</jdbc-type> > <sql-type>SMALLINT</sql-type> > also > <java-type>java.lang.Short</java-type> > <jdbc-type>NUMERIC</jdbc-type> > <sql-type>SMALLINT</sql-type> > also > <java-type>java.lang.Short</java-type> > <jdbc-type>SMALLINT</jdbc-type> > <sql-type>NUMBER(5)</sql-type> > and no success. > I got java.lang.ClassCastException in ejbCreate(..., java.lang.Short > arg, ....). > > It happens when using CMP2 on JBoss3.0.0-tomcat4.0.3. > Also I tried both SMALLINT and Number(5) types for column in table in > Oracle 9i database that corresponds to Short type. > > with all combinations above. > Will appreciate help. > Thanks, > Boris |