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. >> > >
