headers
Josh Stone | 1 Apr 2010 20:50
Picon

Preferred tool for database modeling and generating SQL / DDL

This question isn't directly related to iBATIS, but is relevant for iBATIS and iBATOR users. Are there any recommended or preferred tools (eclipse plugins?) for database modeling and generating SQL or DDL? I ask since iBATOR relies on a database structure already existing and all of the modeling and generation tools I can find are JPA related (such as Dali), which doesn't help me with iBATIS.

Thanks,
Josh

Permalink | Reply | 6 comments |
headers
François Schiettecatte | 1 Apr 2010 21:07
Picon
Gravatar

Re: Preferred tool for database modeling and generating SQL / DDL

Josh

On the Mac I used an application called SQLEditor which I have found to be pretty good:

	http://www.malcolmhardie.com/sqleditor/

Cheers

François

On Apr 1, 2010, at 2:50 PM, Josh Stone wrote:

> This question isn't directly related to iBATIS, but is relevant for iBATIS and iBATOR users. Are there any
recommended or preferred tools (eclipse plugins?) for database modeling and generating SQL or DDL? I ask
since iBATOR relies on a database structure already existing and all of the modeling and generation tools
I can find are JPA related (such as Dali), which doesn't help me with iBATIS.
> 
> Thanks,
> Josh
Permalink | Reply | 5 comments |
headers
Larry Meadors | 1 Apr 2010 21:12
Picon
Gravatar

Re: Preferred tool for database modeling and generating SQL / DDL

I use Aqua Data Studio, it's a java app.

François: SQL Editor looks pretty nice, I may have to try it. :)

Larry

2010/4/1 François Schiettecatte <fschiettecatte <at> gmail.com>:
> Josh
>
> On the Mac I used an application called SQLEditor which I have found to be pretty good:
>
>        http://www.malcolmhardie.com/sqleditor/
>
>
> Cheers
>
> François
>
>
> On Apr 1, 2010, at 2:50 PM, Josh Stone wrote:
>
>> This question isn't directly related to iBATIS, but is relevant for iBATIS and iBATOR users. Are there
any recommended or preferred tools (eclipse plugins?) for database modeling and generating SQL or DDL? I
ask since iBATOR relies on a database structure already existing and all of the modeling and generation
tools I can find are JPA related (such as Dali), which doesn't help me with iBATIS.
>>
>> Thanks,
>> Josh
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>
Permalink | Reply | 4 comments |
headers
Josh Stone | 1 Apr 2010 21:55
Picon

Re: Preferred tool for database modeling and generating SQL / DDL

To answer my own question (for anyone else who might be interested) I just came across a promising looking Eclipse plugin: ER Master.

http://ermaster.sourceforge.net/

Thanks as well for the responses François and Larry.

On Thu, Apr 1, 2010 at 12:12 PM, Larry Meadors <larry.meadors <at> gmail.com> wrote:
I use Aqua Data Studio, it's a java app.

François: SQL Editor looks pretty nice, I may have to try it. :)

Larry


2010/4/1 François Schiettecatte <fschiettecatte <at> gmail.com>:
> Josh
>
> On the Mac I used an application called SQLEditor which I have found to be pretty good:
>
>        http://www.malcolmhardie.com/sqleditor/
>
>
> Cheers
>
> François
>
>
> On Apr 1, 2010, at 2:50 PM, Josh Stone wrote:
>
>> This question isn't directly related to iBATIS, but is relevant for iBATIS and iBATOR users. Are there any recommended or preferred tools (eclipse plugins?) for database modeling and generating SQL or DDL? I ask since iBATOR relies on a database structure already existing and all of the modeling and generation tools I can find are JPA related (such as Dali), which doesn't help me with iBATIS.
>>
>> Thanks,
>> Josh
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: user-java-help <at> ibatis.apache.org


Permalink | Reply | 1 comment |
headers
Ed Stafford | 1 Apr 2010 21:58
Picon

Re: Preferred tool for database modeling and generating SQL / DDL

http://argouml.tigris.org/ is pretty nice and has plugins for db and sql generation.

Cheers,
-Ed

On 1 April 2010 20:55, Josh Stone <pacesysjosh <at> gmail.com> wrote:
To answer my own question (for anyone else who might be interested) I just came across a promising looking Eclipse plugin: ER Master.

http://ermaster.sourceforge.net/

Thanks as well for the responses François and Larry.


On Thu, Apr 1, 2010 at 12:12 PM, Larry Meadors <larry.meadors <at> gmail.com> wrote:
I use Aqua Data Studio, it's a java app.

François: SQL Editor looks pretty nice, I may have to try it. :)

Larry


2010/4/1 François Schiettecatte <fschiettecatte <at> gmail.com>:
> Josh
>
> On the Mac I used an application called SQLEditor which I have found to be pretty good:
>
>        http://www.malcolmhardie.com/sqleditor/
>
>
> Cheers
>
> François
>
>
> On Apr 1, 2010, at 2:50 PM, Josh Stone wrote:
>
>> This question isn't directly related to iBATIS, but is relevant for iBATIS and iBATOR users. Are there any recommended or preferred tools (eclipse plugins?) for database modeling and generating SQL or DDL? I ask since iBATOR relies on a database structure already existing and all of the modeling and generation tools I can find are JPA related (such as Dali), which doesn't help me with iBATIS.
>>
>> Thanks,
>> Josh
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: user-java-help <at> ibatis.apache.org



Permalink | Reply | 0 comments |
headers
Clinton Begin | 1 Apr 2010 23:27
Picon

Re: Preferred tool for database modeling and generating SQL / DDL

+1 for Aqua!

On Thu, Apr 1, 2010 at 1:12 PM, Larry Meadors <larry.meadors <at> gmail.com> wrote:
I use Aqua Data Studio, it's a java app.

François: SQL Editor looks pretty nice, I may have to try it. :)

Larry


2010/4/1 François Schiettecatte <fschiettecatte <at> gmail.com>:
> Josh
>
> On the Mac I used an application called SQLEditor which I have found to be pretty good:
>
>        http://www.malcolmhardie.com/sqleditor/
>
>
> Cheers
>
> François
>
>
> On Apr 1, 2010, at 2:50 PM, Josh Stone wrote:
>
>> This question isn't directly related to iBATIS, but is relevant for iBATIS and iBATOR users. Are there any recommended or preferred tools (eclipse plugins?) for database modeling and generating SQL or DDL? I ask since iBATOR relies on a database structure already existing and all of the modeling and generation tools I can find are JPA related (such as Dali), which doesn't help me with iBATIS.
>>
>> Thanks,
>> Josh
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: user-java-help <at> ibatis.apache.org


Permalink | Reply | 1 comment |
headers
傅玉宝 | 2 Apr 2010 03:06
Picon

Re: Preferred tool for database modeling and generating SQL / DDL

http://ibatis.apache.org/ibator.html
Permalink | Reply | 0 comments |
headers
Viv Kapadekar | 2 Apr 2010 03:08
Favicon

iBatis 3 and Spring integration

Hi 

Does anyone have an example of iBatis 3 integration with Spring 3.0. With iBatis 2.X the spring conflig file was like this:

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="dataSource" ref="dbcpDataSource"/>
<property name="configLocation" value="classpath:sqlmap-config.xml"/>
</bean>

-Viv

Permalink | Reply | 5 comments |
headers
Derek Scherger | 2 Apr 2010 05:33

ClassInfo.CLASS_INFO_MAP

I ran into an "interesting" issue with sqlmaps today.


I've been trying to get a webapp into a state where it can be reloaded repeatedly without eventually failing but this turns out to be almost impossible (see http://www.szegedi.org/articles/memleak.html for an entertaining write up). The JDK has various places that can hold references to classes loaded by a webapp classloader, which prevents the webapp classloader from being garbage collected (see http://www.docjar.com/docs/api/sun/net/www/http/HttpClient.html and http://www.docjar.com/html/api/sun/net/www/http/KeepAliveCache.java.html for examples). Eventually the (Sun) JVM runs out of PermGen space, throws an OutOfMemoryError and all is lost.

Tomcat 5.5 tries to clean up various things in the clearReferences method of its WebappClassLoader, like deregistering jdbc drivers, clearing various IntrospectionUtils caches, releasing the commons logging LogFactory, etc. but there are so many different things that hold references it is fighting a losing battle.

In trying to rearrange various jars in the app I'm working with to avoid holding references from outside the webapp classloader to classes inside the webapp classloader I noticed that sqlmaps has similar issues. The ClassInfo CLASS_INFO_MAP holds onto a static map keyed by class. If the sqlmap jars are loaded from outside the webapp classloader (in Tomcat's common or shared libs) this map can hold references to classes loaded by the webapp classloader. These references keep the webapp classloader live in the eye of the garbage collector and it will never be reclaimed. This keeps all the classes loaded by the webapp classloader live and eats up PermGen space fairly quickly.

Here's another good link that notes problems with sqlmaps as well http://www.java-community.de/archives/140-Memory-leaks-et-alii.html

There are so many other places that do similar things that fixing sqlmaps probably won't help the situation much, but it sure can't hurt. It would be nice if sqlmaps could be changed to use weak references to the cached reflection information so that it isn't the reason a webapp classloader can't be reclaimed by the garbage collector.

Cheers,
Derek

Permalink | Reply | 3 comments |
headers
Clinton Begin | 2 Apr 2010 06:55
Picon

Re: ClassInfo.CLASS_INFO_MAP

This is a known issue.  I agree that it would be nice to do something with it. Ideas are welcome.   The only one I have at the moment is to make ClassInfo an instance and inject it into the SQL mapper configuration.  I've done similar things to eliminate static classes in the framework. 


You can call ClassInfo.setCacheEnabled(false); to stop it from caching classes.

Clinton

On Thu, Apr 1, 2010 at 9:33 PM, Derek Scherger <derek <at> echologic.com> wrote:
I ran into an "interesting" issue with sqlmaps today.

I've been trying to get a webapp into a state where it can be reloaded repeatedly without eventually failing but this turns out to be almost impossible (see http://www.szegedi.org/articles/memleak.html for an entertaining write up). The JDK has various places that can hold references to classes loaded by a webapp classloader, which prevents the webapp classloader from being garbage collected (see http://www.docjar.com/docs/api/sun/net/www/http/HttpClient.html and http://www.docjar.com/html/api/sun/net/www/http/KeepAliveCache.java.html for examples). Eventually the (Sun) JVM runs out of PermGen space, throws an OutOfMemoryError and all is lost.

Tomcat 5.5 tries to clean up various things in the clearReferences method of its WebappClassLoader, like deregistering jdbc drivers, clearing various IntrospectionUtils caches, releasing the commons logging LogFactory, etc. but there are so many different things that hold references it is fighting a losing battle.

In trying to rearrange various jars in the app I'm working with to avoid holding references from outside the webapp classloader to classes inside the webapp classloader I noticed that sqlmaps has similar issues. The ClassInfo CLASS_INFO_MAP holds onto a static map keyed by class. If the sqlmap jars are loaded from outside the webapp classloader (in Tomcat's common or shared libs) this map can hold references to classes loaded by the webapp classloader. These references keep the webapp classloader live in the eye of the garbage collector and it will never be reclaimed. This keeps all the classes loaded by the webapp classloader live and eats up PermGen space fairly quickly.

Here's another good link that notes problems with sqlmaps as well http://www.java-community.de/archives/140-Memory-leaks-et-alii.html

There are so many other places that do similar things that fixing sqlmaps probably won't help the situation much, but it sure can't hurt. It would be nice if sqlmaps could be changed to use weak references to the cached reflection information so that it isn't the reason a webapp classloader can't be reclaimed by the garbage collector.

Cheers,
Derek


Permalink | Reply | 2 comments |

Gmane