Re: Need a custom way for sqlMapConfig.xml to get JDBC properties

2006-11-24 Thread Hycel Taylor
Hey Julien! I tried out your suggestion. That's that ticket! It works beautifully. Thanks for the great advice!

Re: Need a custom way for sqlMapConfig.xml to get JDBC properties

2006-11-23 Thread Hycel Taylor
We don't use any containers. However, we do use Spring with ActiveMQ. Spring might be a possible solution. Thank you for your suggestions.

Re: Need a custom way for sqlMapConfig.xml to get JDBC properties

2006-11-23 Thread Hycel Taylor
Hey! This sounds like a pretty good idea. Another question however. We're using the DAO manager. Will this cause a problem? Will the DAO manager allow access to the sqlMap so that properties can be set before a connection to the database is made? Thank you for the suggestion.

Need a custom way for sqlMapConfig.xml to get JDBC properties

2006-11-22 Thread Hycel Taylor
ome more iBatis classes and the DTD to make this possible. I would appreciate any advice, suggestions or other possible solutions to resolve this issue. Thank you, Hycel Taylor Principal Architect 80108 Media

Re: Unavailable DTD

2006-09-19 Thread Hycel Taylor
Great! This is good information. Thank you so much for your continued research and efforts in this matter. Hycel

Re: Unavailable DTD

2006-09-19 Thread Hycel Taylor
We think you may be correct. Since this problem only occurred when the Apache web site went down, it was our first reaction in all the confusion. Initially, we also did not understand that IBatis validates from the jar at run time. It's not that we don't want to validate our IBatis sqlmaps. We

Re: Unavailable DTD

2006-09-19 Thread Hycel Taylor
Thank you for your response. Unfortunately, changing the DOCTYPE and using a file:// URL is not a good solution for us. It would create more problems than it would solve. May I make a few suggestions for you consideration? Have you considered defining an XSD instead of/or in addition to a DTD.

Re: Unavailable DTD

2006-09-18 Thread Hycel Taylor
We think we understand something better now. We are able to build now, because the apache web site is more stable. So, after we did the build, we disconnected from the internet and ran some unit tests. They worked, which proves that during runtime, IBatis is doing validation from the jar and not

Re: Unavailable DTD

2006-09-18 Thread Hycel Taylor
No container. We have a DaoManagerLoader a map of DaoManagers. public class DaoManagerLoader { public static Map map = new HashMap(); public static DaoManager getInstance(String daoXMLPath) { DaoManager daoManager = map.get(daoXMLPath); if (daoManager == null) { try { final

Unavailable DTD

2006-09-18 Thread Hycel Taylor
Hi, the Apache web site has been going up and down all day. We have discovered the our sqlmaps are validating the dtd from the web. Now it is no longer working. And we're suppose go into partner testing tomorrow. We are currently using version 2.1.7.597. The ibatis-sqlmap-2 jar has dtd's. H

Re: Build Time Checks

2006-01-14 Thread Hycel Taylor
Unit Tests. On 1/13/06, Gregg D Bolinger <[EMAIL PROTECTED]> wrote: > I am looking for a way that I can validate my mapping files against my > associated object files and even possibly the database. Basically, I want > to ensure that when the project it built, I run into as few runtime issues > a

Re: Doing Batch Processing with IBatis from DAO Manager

2005-09-07 Thread Hycel Taylor
Hi again Clinton,   I got some sleep, looked at my code again and I now stand corrected on a few issues.  The insertCampusCourse method, was working properly.  There is a simple rule that I forgot about batching and that it is, you cannot search for data that is currently being batched because none

Re: Doing Batch Processing with IBatis from DAO Manager

2005-09-06 Thread Hycel Taylor
o start more than one batch (and in fact it could be causing significant problems for you). The batch control DAO is just a convenient, reusable DAO that provides access to the batch API from the SQL Mapping framework, or your own custom JDBC batching code.Clinton On 8/13/05, Hycel Taylor <[EMAIL P

Re: Doing Batch Processing with IBatis from DAO Manager

2005-08-13 Thread Hycel Taylor
Got it! That will make code a lot cleaner too. Thanks for the advice.

Re: Doing Batch Processing with IBatis from DAO Manager

2005-08-13 Thread Hycel Taylor
Interesting. I'm not sure what, batchControlDao, is doing here. Currently, what I've just learned from others on this forum and what I'm currently doing is the following: daoManager.startTransaction(); schoolDao.startBatch(); majorDao.startBatch(); courseDao.startBatch(); ... // do work here.

Re: How do I do batch processing with IBatis DAO

2005-08-11 Thread Hycel Taylor
You are most welcome. Thank you for helping me to understand the proper use of iBatis Dao. :-)

Re: How do I do batch processing with IBatis DAO

2005-08-11 Thread Hycel Taylor
I forgot to put the daoManager.commit(), in my example. The business requirement: Actually, my code is a lot more complicated than the three dao's that I am using in my example. There are actually nine Dao's being used in this particular batch. I'm iterating over 500,000 records and I'm commit

Re: How do I do batch processing with IBatis DAO

2005-08-11 Thread Hycel Taylor
I want to make sure I'm understanding how to use iBatis batching correctly. I understand now that SqlMapDaoTemplate, contains the method, startBatch() and execute batch. My Dao will extend SqlMapBaseDao which extends SqlMapDaoTemplate. So, since my Dao's are sharing the same daoManager, if I sta

Re: How do I do batch processing with IBatis DAO

2005-08-11 Thread Hycel Taylor
Good Advice. Thanks.

Re: How do I do batch processing with IBatis DAO

2005-08-11 Thread Hycel Taylor
I see! This is what I needed to know. Thanks again!

Re: How do I do batch processing with IBatis DAO

2005-08-11 Thread Hycel Taylor
>From what I understand, looking at your source code, it appears that the batching is handled by, BaseSqlMapDao. As best I can tell, this is not a standard IBatis Class. It's package structure is the following: java.lang.Object com.ibatis.dao.client.template.DaoTemplate com.ibatis.dao.cl

How do I do batch processing with IBatis DAO

2005-08-11 Thread Hycel Taylor
Hi, I apologize, if this is the second time my email appears on the forum. I didn't see the first one show up after I posted it and this is my first time posting on this forum. Also, the first time I posted this email, there were '3D' characters all in my code example. I don't know how they got

Doing Batch Processing with IBatis from DAO Manager

2005-08-10 Thread Hycel Taylor
Hi, I'm converting my home grown custom DAO's over to IBatis sqlMaps and the IBatis DAO's. I'm finding IBatis a lot simpler to use than my own. However, I need to do a lot of batch processing and I need to do it from the DAO tier. With my custom DAO manager, I simply passed the same connection