Introspect multiple tables at once
The group you are posting to is a
Usenet group . Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
From:
Ryan Conklin <ryancarolin... @gmail.com>
Date: Tue, 13 Nov 2012 10:57:14 -0800 (PST)
Local: Tues, Nov 13 2012 1:57 pm
Subject: Introspect multiple tables at once
Besides duplicating like the example below, is there a faster way to introspect multiple tables at once?
<table schema="" tableName="organization" domainObjectName=""> <property name="useActualColumnNames" value="true" /> <property name="ignoreQualifiersAtRuntime" value="true" /> <generatedKey column="name" sqlStatement="MySql" identity="true" type="post" /> <!--columnOverride column="DATE_FIELD" property="startDate" /> <ignoreColumn column="FRED" /> <columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" / --> </table> <table schema="" tableName="addresses" domainObjectName=""> <property name="useActualColumnNames" value="true" /> <property name="ignoreQualifiersAtRuntime" value="true" /> <generatedKey column="street" sqlStatement="MySql" identity="true" type="post" /> <!--columnOverride column="DATE_FIELD" property="startDate" /> <ignoreColumn column="FRED" /> <columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" / -->
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Ryan Conklin <ryancarolin... @gmail.com>
Date: Wed, 14 Nov 2012 14:17:46 -0800 (PST)
Local: Wed, Nov 14 2012 5:17 pm
Subject: Re: Introspect multiple tables at once
So FYI for anyone that is planning on doing a 1000+ tables, I encountered a heap dump "out of memory" error while running Mybatis Generator. I had to increase my total allowed memory for the project to Xmx512.
On Tuesday, November 13, 2012 1:57:14 PM UTC-5, Ryan Conklin wrote:
> Besides duplicating like the example below, is there a faster way to > introspect multiple tables at once?
> <table schema="" tableName="organization" > domainObjectName=""> > <property name="useActualColumnNames" value="true" > /> > <property name="ignoreQualifiersAtRuntime" > value="true" /> > <generatedKey column="name" sqlStatement="MySql" > identity="true" type="post" /> > <!--columnOverride column="DATE_FIELD" > property="startDate" /> > <ignoreColumn column="FRED" /> > <columnOverride column="LONG_VARCHAR_FIELD" > jdbcType="VARCHAR" / --> > </table> > <table schema="" tableName="addresses" domainObjectName=""> > <property name="useActualColumnNames" value="true" > /> > <property name="ignoreQualifiersAtRuntime" > value="true" /> > <generatedKey column="street" sqlStatement="MySql" > identity="true" type="post" /> > <!--columnOverride column="DATE_FIELD" > property="startDate" /> > <ignoreColumn column="FRED" /> > <columnOverride column="LONG_VARCHAR_FIELD" > jdbcType="VARCHAR" / -->
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Jeff Butler <jeffgbut... @gmail.com>
Date: Wed, 14 Nov 2012 17:42:45 -0500
Local: Wed, Nov 14 2012 5:42 pm
Subject: Re: Introspect multiple tables at once
Cool :)
As for your previous question, you can use SQL wildcards in the tableName,
so <table tableName="%"/> would generate for every table in the DB. This
won't work well for the tables with identity columns because the identity
column can't be easily specified for multiple tables - but it will work for
all the others.
Jeff Butler
On Wed, Nov 14, 2012 at 5:17 PM, Ryan Conklin <ryancarolin... @gmail.com>wrote:
> So FYI for anyone that is planning on doing a 1000+ tables, I encountered
> a heap dump "out of memory" error while running Mybatis Generator. I had to
> increase my total allowed memory for the project to Xmx512.
> On Tuesday, November 13, 2012 1:57:14 PM UTC-5, Ryan Conklin wrote:
>> Besides duplicating like the example below, is there a faster way to
>> introspect multiple tables at once?
>> <table schema="" tableName="organization"
>> domainObjectName="">
>> <property name="useActualColumnNames"
>> value="true" />
>> <property name="**ignoreQualifiersAtRuntime"
>> value="true" />
>> <generatedKey column="name" sqlStatement="MySql"
>> identity="true" type="post" />
>> <!--columnOverride column="DATE_FIELD"
>> property="startDate" />
>> <ignoreColumn column="FRED" />
>> <columnOverride column="LONG_VARCHAR_FIELD"
>> jdbcType="VARCHAR" / -->
>> </table>
>> <table schema="" tableName="addresses" domainObjectName="">
>> <property name="useActualColumnNames"
>> value="true" />
>> <property name="**ignoreQualifiersAtRuntime"
>> value="true" />
>> <generatedKey column="street"
>> sqlStatement="MySql" identity="true" type="post" />
>> <!--columnOverride column="DATE_FIELD"
>> property="startDate" />
>> <ignoreColumn column="FRED" />
>> <columnOverride column="LONG_VARCHAR_FIELD"
>> jdbcType="VARCHAR" / -->
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Javier Domingo <javier... @gmail.com>
Date: Wed, 14 Nov 2012 23:52:15 +0100
Local: Wed, Nov 14 2012 5:52 pm
Subject: Re: Introspect multiple tables at once
The solution is to use generic names for columns id instead of table_id etc
El 14/11/2012 23:17, "Ryan Conklin" <ryancarolin... @gmail.com> escribió:
> So FYI for anyone that is planning on doing a 1000+ tables, I encountered
> a heap dump "out of memory" error while running Mybatis Generator. I had to
> increase my total allowed memory for the project to Xmx512.
> On Tuesday, November 13, 2012 1:57:14 PM UTC-5, Ryan Conklin wrote:
>> Besides duplicating like the example below, is there a faster way to
>> introspect multiple tables at once?
>> <table schema="" tableName="organization"
>> domainObjectName="">
>> <property name="useActualColumnNames"
>> value="true" />
>> <property name="**ignoreQualifiersAtRuntime"
>> value="true" />
>> <generatedKey column="name" sqlStatement="MySql"
>> identity="true" type="post" />
>> <!--columnOverride column="DATE_FIELD"
>> property="startDate" />
>> <ignoreColumn column="FRED" />
>> <columnOverride column="LONG_VARCHAR_FIELD"
>> jdbcType="VARCHAR" / -->
>> </table>
>> <table schema="" tableName="addresses" domainObjectName="">
>> <property name="useActualColumnNames"
>> value="true" />
>> <property name="**ignoreQualifiersAtRuntime"
>> value="true" />
>> <generatedKey column="street"
>> sqlStatement="MySql" identity="true" type="post" />
>> <!--columnOverride column="DATE_FIELD"
>> property="startDate" />
>> <ignoreColumn column="FRED" />
>> <columnOverride column="LONG_VARCHAR_FIELD"
>> jdbcType="VARCHAR" / -->
You must
Sign in before you can post messages.
You do not have the permission required to post.