Re: passing connection to ibatis

On Tue, Sep 19, 2006 at 03:40:43PM +0300, Eugeny N Dzhurinsky wrote: Hello! I have a problem - my application creates temporary views for set of talbes and then I would like to execute some queries on this view using iBATIS. For postgresql the temporary view is alife unless the connection is

Re: passing connection to ibatis

Well, I have never imagined that anyone would want to. ;-) Larry On 9/20/06, Eugeny N Dzhurinsky [EMAIL PROTECTED] wrote: On Tue, Sep 19, 2006 at 03:40:43PM +0300, Eugeny N Dzhurinsky wrote: Hello! I have a problem - my application creates temporary views for set of talbes and then I

RE: Problem when executing multi result Sybase stored procedure

One thing I don't understand, looking at your SQL Map, why do you have the call to the sp in CDATA tags? I'm not using CDATA tags and the call to the sp works well for me.Also, remember that all SQL enclosed within procedure, insert, update and deleteelements, is treated as SQL, literally.

RE: passing connection to ibatis

This sounds like it could be solved by a connection lifecycle event handler that Clinton mentioned on Sept. 16th: http://www.mail-archive.com/user-java@ibatis.apache.org/msg06174.html Strangely, I've actually needed this functionality before. I created a bunch of temporary tables with Postgres

oracle and dbcp

I am having trouble configuring dbcp using oracle. Everything is fine using dataSource type=SIMPLE. When I change to use DBCP the oracle driver is unable to load. Does anyone have a solution? Robert

String or binary data would be truncated

I'm receiving the following error upon an insert to one of our tables. Is there any way to get iBatis to state exactly which field it is that is failing? I've tried investigating this by hand but due to the number of columns in this table and the time constraints we are under I'm looking

Re: String or binary data would be truncated

That message comes from SQL Server, and IIRC, SQL Server doesn't tell you the field either. :( Larry On 9/20/06, Matthew Hixson [EMAIL PROTECTED] wrote: I'm receiving the following error upon an insert to one of our tables. Is there any way to get iBatis to state exactly which field it is

RE: oracle and dbcp

Follows is my configuration info. Form Database.properties driver=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@curie.hire.com:1521:rec01 ... From sqlMapConfig.xml transactionManager type=JDBC dataSource type=SIMPLE property value=${driver} name=JDBC.Driver/ property

Re: oracle and dbcp

I hope you don't assume that you can just change SIMPLE to DBCP and have it work :) Please review page 13 of the current Developers guild for and example of each. Nathan On 9/20/06, Robert King [EMAIL PROTECTED] wrote: Follows is my configuration info. Form Database.properties

Postgresql serial type problem

I have a table in postgresql and in this table there is a column that's type is serial. (event_id is serial )I am adding data in this table like this;insert id=insertEvent parameterClass=Event insert into PUBLIC.event ( event_id, description ) values ( #event_id#, #description# )

RE: Postgresql serial type problem

I would guess that you should omit event_id. Instead setting it in your java code to the return valid of the insert() method. From: Okan Çetin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 5:08 PMTo: user-java@ibatis.apache.orgSubject: Postgresql serial type problem I

Re: Postgresql serial type problem

thanks for reply.Problem was solved. I changed the xml file like this:insert id=insertEvent parameterClass=Event insert into PUBLIC.event ( description ) values ( #event_id#, #description# ) /insertOn 9/21/06, Daniel Pitts [EMAIL PROTECTED] wrote: I would guess that you should omit

RE: oracle and dbcp

Nathan, thank you for the help. I did make that assumption;) My problem is performance. Does ibatis keep a pool of open connections? I recently moved to a new database that has a long connection time but short query times. I am experiencing severe performance problems and am a loss as how to

Re: oracle and dbcp

ibatis only asks the datasource for a connection. it is up to that datasource to pool or not to pool. Do you see your problems when using both the build in simple connection pool and the dbcp from apache? On 9/20/06, Robert King [EMAIL PROTECTED] wrote: Nathan, thank you for the help. I did

RE: Parameterised constructors

How do private setters work? Could I set the 'foo' property using the result map below? Is there anything I have to do to the jmv to allow it access to the private field? resultMap class="Foo" result property="foo" column="FOOBA" /resultMap public class Foo { private String foo;