ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ahmad husain <husainah...@gmail.com>
Subject Re: Ibator for postgresql
Date Thu, 05 Mar 2009 04:04:10 GMT
Hi Jeff,
It works, now, my ibator was generated my tables.

thanks a lot
Ahmad Husain


On Thu, Mar 5, 2009 at 6:09 AM, Jeff Butler <jeffgbutler@gmail.com> wrote:

> 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