No, there's no support for that. If it's not supported by standard JDBC, it's not supported by iBATIS. However, you can probably write a custom type handler for it.
Cheers, Clinton On Mon, 14 Feb 2005 13:54:20 -0600, Brice Ruth <[EMAIL PROTECTED]> wrote: > Since this is not a standard JDBC type (that I know of), you'll > probably need to write a custom type handler. > > Others can correct me if I'm wrong ... but looking through the iBATIS > manual, I don't see any support for that. > > On Mon, 14 Feb 2005 14:29:23 -0500, William Harding > <[EMAIL PROTECTED]> wrote: > > It is in fact an array of Varchar. Postgres is an object orieanted db so > > it does allow for that. For example (in the code listed below) we want > > to store the candidates languages with them in that row. So a Varchar[] > > array is the best way to deal with it. Otherwise it means setting up a > > foreign keyd table and doing joins, etc..... > > > > > > Brice Ruth wrote: > > > > >So, in Postgres, its an array of Varchar?! That seems awfully odd, but > > >I'm not that familiar with Postgres. If this is not in fact the case, > > >and you're create a Varchar(10) (length of 10) - then that should be > > >mapped to a simple String object, not an Array of String (String[]). > > > > > >Brice > > > > > > > > >On Mon, 14 Feb 2005 12:34:27 -0500, William Harding > > ><[EMAIL PROTECTED]> wrote: > > > > > > > > >>*Note* - This is a second submission. I apologize if this is a repeat. I > > >>have been having so many problems with my ISP lately I don't know if > > >>this was ever sent through the first time. ** > > >> > > >>Greetings all, > > >> > > >>I have spent the last 2 days researching how to handle the Postgres data > > >>type: VARCHAR[] and how to map it to a String[] with little to no luck. > > >>I am fairly new to iBATIS and I could have easily missed something very > > >>simple. > > >> > > >>Here is what I have. > > >> > > >>My Current mapping is as follows: > > >> > > >><?xml version="1.0" encoding="UTF-8"?> > > >><!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" > > >>"http://www.ibatis.com/dtd/sql-map-2.dtd";> > > >> > > >><sqlMap namespace="CandidateInfo"> > > >><typeAlias alias="candidateinfo" type="candidateinput.CandidateInfo"/> > > >> > > >><insert id="insertCandidateInfo" parameterClass="candidateinfo"> > > >> INSERT INTO candidate_info ( > > >> c_candidate_id, > > >> c_f_name, c_m_initial, c_l_name, c_address_line_one, > > >>c_address_line_two, c_city, c_state, c_zipcode, > > >> c_country, c_email, c_areacode, c_primary_phone, > > >>c_cell_areacode, c_cellphone, c_biz_areacode, > > >> c_biz_phone, c_biz_phone_ext, c_lang_spoken, > > >>c_will_work_part_contract, c_resume_fliename, c_db_entry_date ) > > >> values ( > > >> (select MAX(c_candidate_id) from candidate_info) + 1, > > >> #FName#, #MI#, #LName#, #addyOne#, #addyTwo#, #city#, #state#, > > >>#zipcode#, > > >> #country#, #emailAddy#, #homeArea#, #homePhone#, #cellArea#, > > >>#cellPhone#, #workArea#, > > >> #workPhone#, #workExt#, #languagesSpoken#, #willWorkPartCont#, > > >>#resumeFilename#, current_date ) > > >></insert> > > >> > > >></sqlMap> > > >> > > >>The languagesSpoken parameter is a String[10] in the CandidateInfo > > >>object and is a VARCHAR[10] in the Postgresql database. I have tried > > >>various ways of setting the data type and nothing has worked. > > >> > > >>Each time I execute this mapping I get the following error: > > >> > > >>There was a sql Exception: > > >>com.ibatis.common.jdbc.exception.NestedSQLException: --- The error > > >>occurred in CandidateInfo.xml. --- The error occurred while applying a > > >>parameter map. --- Check the insertCandidateInfo-InlineParameterMap. --- > > >>Check the parameter mapping for the 'languagesSpoken' property. --- > > >>Cause: java.lang.NullPointerException Caused by: > > >>java.lang.NullPointerException > > >> > > >>I have done several tests ranging from not setting any of the array > > >>items to filling them all in order to make sure that they are not null. > > >>My only question is how to I go about handling this issue? I have tried > > >>using an <iterator> tag to build the array by hand. > > >> > > >>Is this a mapping issue or quite possibly a data issue? How do I even go > > >>about debugging this? > > >> > > >>Any help would be greatly appreciated. > > >> > > >>Thanks. > > >> > > >> > > >> > > >> > > > > > > > > > > > > > > > > > >
