1. EJB: Mapping a DB column field to another field type stackoverflow.comI have a DB table with a column with fieldtype INT, i want to map it to an EJB (Java Object), and use an Enum instead of int for that column/field. ... |
2. Get Column Type coderanch.comHi: I'm having problems geting the columnType DATE, this is the code I used for my program, rsmd is ResulSetMetaDeta switch( rsmd.getColumnType( i ) ) { case Types.INTEGER: currentVector.addElement( local + String.valueOf(rs.getInt(i))); break; case Types.DECIMAL: currentVector.addElement( local + String.valueOf(rs.getInt(i))); break; case Types.FLOAT: currentVector.addElement( local + two.format(rs.getFloat(i))); break; case Types.DOUBLE: currentVector.addElement( local + two.format(rs.getDouble(i))); break; case Types.NUMERIC: currentVector.addElement( local + two.format(rs.getDouble(i))); break; ... |
3. Invalid column type coderanch.comI see some picky people here. I just want to confirm this with you guys. Anyway you are helping me. The type in Oracle is NUMBER(8). I used rs.getLong(j+1). It works for other similar result set, but it fails this one. This is the code: package com.ubsw.fusion.data; import java.util.List; import java.util.HashSet; import java.util.HashMap; import java.util.Map; import java.util.Set; import java.util.Iterator; import java.sql.Connection; ... |
4. column type to save byte array coderanch.com |
5. Retrive column of type 'image' coderanch.com |
6. Store char[] as column type coderanch.com |
7. getting column type info from db coderanch.com |
8. Wrong no or type of argument in line 1, column 7 coderanch.comHi All, I have used 9 parameter in procedure , below is signature. MNC.mplsuk_create_bulk_vc_pvc(in_request_type in varchar2, in_acvp_ckt_name in varchar2, in_port_type in varchar2, in_port_no in varchar2, in_chk_all_param in number, in_create_bulk_vcpvc in t_create_bulk_vcpvc, out_result_vc_pvc out t_result_vc_pvc, out_status_code out number, out_status_message out varchar2) as String query = "{call mplsuk_create_bulk_vc_pvc(?,?,?,?,?,?,?,?,?)}"; cstmt = this.getConnection().prepareCall(query); ArrayDescriptorDAO adDAO = new ArrayDescriptorDAOImpl(this .getConnection()); ARRAY saveArrayBulkVcPVC = adDAO.getArrayDescriptor("DBSEC.T_CREATE_BULK_VCPVC", listTo2DArrayBulkVcPvcDetails(bulkVcPvcDetailsList)); System.out.println("saveBulkVcPvcDetails ... |