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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> > 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 <[email protected]> > >> 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 <[email protected]> > 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. > >> >> > >> > > >> > > > > > >
