ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: Ibator for postgresql
Date Wed, 04 Mar 2009 23:09:13 GMT
I think PostgreSQL may be case sensitive when doing catalog lookups.
Try your table configs like this:

    <table tableName="MAnggota" delimitIdentifiers="true">
      <property name="useActualColumnNames" value="true"/>
    </table>

Also note that you don't need a catalog, and you don't need to specify
the schema if the tables are in the public schema.

Jeff Butler


On Mon, Mar 2, 2009 at 9:52 PM, ahmad husain <husainahmad@gmail.com> wrote:
> Hi Jeff
> Thanks for your reply
> I'm using postgres user on the config file, i have changed a few
> configuration like shcema, catalog, but it still give me errors,
> and i send the detail the database in pdAdmin, and the error.
> Thanks
>
> On Tue, Mar 3, 2009 at 12:01 AM, Jeff Butler <jeffgbutler@gmail.com> wrote:
>>
>> I think there are two possibilities:
>>
>> 1. The table doesn't exist, or the userID in the config doesn't have
>> privileges to the table, or there is a misspelling in the table name,
>> or the table is in a different schema than you expect.
>>
>> 2. The table contains only LOB fields (A/Ibator does not support that
>> kind of table).
>>
>> BTW - the message you report does not match the config you sent (there
>> is no MUsers table in the config you sent).
>>
>> Jeff Butler
>>
>>
>> On Mon, Mar 2, 2009 at 5:38 AM, ahmad husain <husainahmad@gmail.com>
>> wrote:
>> > Thanks for your replay,
>> > I have change the connectionURL, but it still having the same error.
>> > Thanks
>> >
>> > On Fri, Feb 27, 2009 at 9:27 PM, vicky yes <afzaal11@hotmail.com> wrote:
>> >>
>> >> Hi Ahmad
>> >>
>> >> change ur connectionURL,
>> >>
>> >> try like this connectionURL="jdbc:postgresql:db_koperasi"
>> >>
>> >>
>> >>
>> >> ahmad husain wrote:
>> >> >
>> >> > Dear All expert
>> >> > Does anyone here knows about abatorConfig.xml with PostgreSQL?
>> >> >
>> >> > I have here one file, but still giving me warning message :
>> >> >
>> >> > Table MUsers does not exist, or contains only LOB fields
>> >> >
>> >> > Please help
>> >> >
>> >> > Thanks
>> >> >
>> >> > <?xml version="1.0" encoding="UTF-8"?>
>> >> > <!DOCTYPE abatorConfiguration PUBLIC "-//Apache Software
>> >> > Foundation//DTD
>> >> > Abator for iBATIS Configuration 1.0//EN"
>> >> >   "http://ibatis.apache.org/dtd/abator-config_1_0.dtd">
>> >> >
>> >> > <abatorConfiguration>
>> >> >   <abatorContext>
>> >> >     <!-- TODO: Add Database Connection Information -->
>> >> >     <jdbcConnection driverClass="org.postgresql.Driver"
>> >> >         connectionURL="jdbc:postgresql://localhost/db_koperasi"
>> >> >         userId="user_koperasi"
>> >> >         password="user_koperasi">
>> >> >       <classPathEntry location="postgresql-8.3-604.jdbc3.jar"
/>
>> >> >     </jdbcConnection>
>> >> >
>> >> >     <javaTypeResolver>
>> >> >       <property name="forceBigDecimals" value="false" />
>> >> >     </javaTypeResolver>
>> >> >
>> >> >     <javaModelGenerator targetPackage="com.koperasi.persistence"
>> >> >         targetProject="d:\tools\test\src">
>> >> >       <property name="enableSubPackages" value="true" />
>> >> >       <property name="trimStrings" value="true" />
>> >> >     </javaModelGenerator>
>> >> >
>> >> >     <sqlMapGenerator targetPackage="com.koperasi.persistence.xml"
>> >> >         targetProject="d:\tools\test\src">
>> >> >       <property name="enableSubPackages" value="true" />
>> >> >     </sqlMapGenerator>
>> >> >
>> >> >     <daoGenerator type="IBATIS" targetPackage="com.koperasi.dao"
>> >> >         targetProject="d:\tools\test\src">
>> >> >       <property name="enableSubPackages" value="true" />
>> >> >     </daoGenerator>
>> >> >
>> >> >     <table tableName="MAnggota" domainObjectName="MAnggota">
>> >> >        <property name="useActualColumnNames" value="false"/>
>> >> >     </table>
>> >> >
>> >> > <!--
>> >> >     <table tableName="MAnggota">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> >
>> >> >     <table tableName="MJenisKendaraan">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> >
>> >> >     <table tableName="MMerkKendaraan">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> >
>> >> >     <table tableName="MProgram">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> >
>> >> >     <table tableName="MTipeKendaraan">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> >
>> >> >     <table tableName="TCicilanDPKendaraan">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> >
>> >> >     <table tableName="TCicilanKendaraan">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> >
>> >> >     <table tableName="TKreditKendaraan">
>> >> >       <property name="useActualColumnNames" value="true"/>
>> >> >     </table>
>> >> > -->
>> >> >   </abatorContext>
>> >> > </abatorConfiguration>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >> http://www.nabble.com/Ibator-for-postgresql-tp22240734p22246917.html
>> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>> >>
>> >
>> >
>
>

Mime
View raw message