Re: [Abator] The required stored procedure

[Jeff Butler]

Hi Minjae,

 

Sorry for your trouble.

 

The message "Table not found in statement [SELECT * FROM SYSTEM_COLUMNS]" is not generated by Abator.  Abator does not do a 'select *' anywhere.

 

This is an error coming from hsqldb related to the database setup - it means that the system tables are not setup in your hsqldb instance.  See this page for more information (especially the section entitled 'HSQLDB-Specific Information'):

 

http://hsqldb.org/doc/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.html

 

Jeff Butler

 

 

 

On 12/23/05, Minjae Kim <[EMAIL PROTECTED]> wrote:

I tried with hsqldb, but still have a problem.

 

<abatorConfig.xml>

...

<jdbcConnection driverClass="org.hsqldb.jdbcDriver"
        connectionURL="jdbc:hsqldb:hsql://localhost/xdb"
        userId="sa"
        password="">
        <classPathEntry location="/hsqldb/lib/hsqldb.jar" />
</jdbcConnection>

....

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

</abatorConfig.xml>

 

 

I created mydb using the following script.

 

cd \hsqldb\data
java org.hsqldb.Server -database.0 mydb -dbname.0 xdb

 

When I tested queries MJ01TB for  using SQLExplorer(Eclipse plugin), there was no problem.

 

select * from MJ01TB

 

But I got the following message when I did  "Generate iBatis Artifacts" menu

 

Generation Failed

Reason:

 Table not found in statement [SELECT * FROM SYSTEM_COLUMNS]

 

I am eager to see the generated artifacts using Abator, but that is not easy to me.

Please help me. Can you provide me a simplied hsqldb abatorConfig.xml sample?

 

Best,

Minjae