iBatis DAO

2005-05-04 Thread Folashade Adeyosoye
Is this a normal logger/system out output for iBatis DAO DEBUG[2005-May-04 22:47:24] - jdbc.SimpleDataSource(SimpleDataSource.java:506) - SimpleDataSource forcefully closed/removed all connections. May 4, 2005 10:47:35 PM org.apache.catalina.core.StandardHost getDeployer INFO: Create Host deplo

BLOB and CLOB FAQ page now restored.

2005-05-04 Thread Nathan Maves
Team, I have restored the FAQ on one way to use the built in BLOB and CLOB Custom Type Handlers (CTH). I have also added a section near the bottom on the to common problems. - 86 length on the result - 4000 limit on the result http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+

RE: BLOB type handler

2005-05-04 Thread Yee, Richard K, CTR,, DMDCWEST
Ming, Since BLOBs can contain binary data, some values cannot be represented in a Java String variable (ie. 0). -Richard -Original Message- From: Ming Xue [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 11:07 AM To: 'ibatis-user-java@incubator.apache.org' Subject: RE: BLOB type

Re: BLOB type handler

2005-05-04 Thread Brandon Goodin
You would have to convert the BLOB to a String in a custom type handler. On 5/4/05, Ming Xue <[EMAIL PROTECTED]> wrote: > I try to map BLOB to byte[] and it works, BUT the question is : > > How to map BLOB to String? and other possible java types? > > > -Original Message- > From: Brando

RE: BLOB type handler

2005-05-04 Thread Ming Xue
I try to map BLOB to byte[] and it works, BUT the question is : How to map BLOB to String? and other possible java types? -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 1:58 PM To: ibatis-user-java@incubator.apache.org Subject: Re: BLOB t

Re: BLOB type handler

2005-05-04 Thread Brandon Goodin
This link may help you. We used to have a FAQ on our wiki that dealt with it. But, recent transitions have removed it. http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg01800.html On 5/4/05, Ming Xue <[EMAIL PROTECTED]> wrote: > DB is oracle 9i, I already have the code to read/

RE: BLOB type handler

2005-05-04 Thread Ming Xue
DB is oracle 9i, I already have the code to read/write BLOB, the question is how to plug in these code into the Framework? In the app, BLOB is used in multiple places : JDBC type Java Type BLOBString BLOBXML BLOBJava Object How

Re: BLOB type handler

2005-05-04 Thread Brandon Goodin
Depends on what database you are using and how their driver supports it. Please provide more information. Brandon On 5/4/05, Ming Xue <[EMAIL PROTECTED]> wrote: > I am doing some testing on Custom Type Handler, in my project, BLOB is > mapped to a "String" type java bean property, it seems the

Re: Transactions/BatchStatements

2005-05-04 Thread Brice Ruth
If you're not using startBatch() - then iBATIS will have JDBC run each one individually ... the batching is something that's driver specific (but supported by JDBC), if I recall correctly. It just adds some efficiency. Each of your inserts runs at the time they are called (without batching), the co

BLOB type handler

2005-05-04 Thread Ming Xue
I am doing some testing on Custom Type Handler, in my project, BLOB is mapped to a "String" type java bean property, it seems the Framework can not set the value properly. Does the java bean property has to be byte[]? thanks

Re: Transactions/BatchStatements

2005-05-04 Thread Gregg D Bolinger
I am curious as to iBatis batching also. I have a question. From what you stated below, I am inferring that when you start a transaction, all inserts/updates/deletes are batched and then sent on commit? Here is my problem. I need to batch updates and inserts to multiple tables. So I am doing s

iBatis DAO Transaction Batch Default

2005-05-04 Thread Gregg D Bolinger
Why doesn't iBatis DAOManager transactions batch by default? Wouldn't it make more sense? It sure would solve a lot of problems for me.

Re: DAO and Batch in Single Transaction

2005-05-04 Thread Clinton Begin
Your approach sounds good.  I wouldn't try to overcomplicate this. Cheers, ClintonOn 5/2/05, Gregg D Bolinger <[EMAIL PROTECTED]> wrote: I am using iBatis SqlMap and iBatis DAO. I am trying to look intodoing batch inserts/updates/delete within a single transaction formultiple DAO's.  So should I

Re: Transactions/BatchStatements

2005-05-04 Thread Brice Ruth
Can you do batch w/ plain JDBC w/o a transaction?On 5/3/05, Simon Brunner <[EMAIL PROTECTED]> wrote: List,we just started a project from scratch and chose Spring/iBatis/Struts to build a mid-size J2EE web application. First I've to say that I'm veryimpressed on how fast you get productive by using