Re: Oracle PL/SQL with Schema Migrations

2010-01-20 Thread Michael Chambliss
Thanks, Clinton. That does work, with a few potential problems. In order for the DDL to execute properly with a full_line_delimiter set, you have to remove the semicolons at the end of single statement blocks (IE, create, insert, alter, etc). If the tool you used to generate the bootstrap DD

Re: Oracle PL/SQL with Schema Migrations

2010-01-20 Thread Clinton Begin
You can configure the line terminator in the environment properties. Try a full line delimiter like "GO" On Wed, Jan 20, 2010 at 12:29 PM, Michael Chambliss wrote: > Hello, > > I just wanted to follow up on a question that was asked back in October: > > http://www.mail-archive.com/user-java@ibat

Oracle PL/SQL with Schema Migrations

2010-01-20 Thread Michael Chambliss
Hello, I just wanted to follow up on a question that was asked back in October: http://www.mail-archive.com/user-java@ibatis.apache.org/msg14957.html In summary, PL/SQL terminates lines with a semicolon, which causes problems for the line delimiter logic in the migrations tool. Something lik

re: New Features of iBatis 3.0 Presentation

2010-01-20 Thread David Rosenstark
Not a presentation but a small writeup of integration with spring 3 http://groovyjavathoughts.blogspot.com/2009/09/test-driving-ibatis-3-and-spring3.html - Forwarded message -- From: "Hurley, Brian" To: "user-java@ibatis.apache.org" Date: Tue, 19 Jan 2010 16:13:40 -0600 Subject:

Re: Dropping down to JDBC.

2010-01-20 Thread Wesley Acheson
Okay thats great. When we do this and call SimpleDataSource.getStatus() after attempting this. Each time we attempt this. We get badConnectionCount incremented. Trying to find the source for this at the moment to see if this is just a counter or if its iterating through its connection object to s

Re: Dropping down to JDBC.

2010-01-20 Thread Larry Meadors
Just close the connection when you're done - that won't REALLY close it, it will just return it to the pool (just like any other connection pool). Larry On Wed, Jan 20, 2010 at 7:17 AM, Wesley Acheson wrote: > Yes thats what I suspected.  When the JDBC queries run do I close the > connection ob

Re: Dropping down to JDBC.

2010-01-20 Thread Wesley Acheson
Yes thats what I suspected. When the JDBC queries run do I close the connection object returned by this SimpleDataSource object? or is there some other way to return the connection back to the pool? Regards, Wesley Acheson On Wed, Jan 20, 2010 at 3:12 PM, Larry Meadors wrote: > sqlMapClient.ge

Re: Dropping down to JDBC.

2010-01-20 Thread Larry Meadors
sqlMapClient.getDataSource(); On Wed, Jan 20, 2010 at 7:05 AM, Wesley Acheson wrote: > Hi all, > > we have a need to drop down to a JDBC query at some point in our application. > > Is it possible to get a connection from the SimpleDataSource pool.  (I > see that this is a method on SimpleDataSour

Dropping down to JDBC.

2010-01-20 Thread Wesley Acheson
Hi all, we have a need to drop down to a JDBC query at some point in our application. Is it possible to get a connection from the SimpleDataSource pool. (I see that this is a method on SimpleDataSource). If so how does one return the connection to the SimpleDataSource object? Regards, Wesley

Re: The error occurred while applying a parameter map.

2010-01-20 Thread Clinton Begin
If you use a parameterMap in iBATIS 2, you have to use question mark (JDBC style) parameters, not named parameters. {call UPSERT_PM_PRECEDENCE(?,?,?,?,?)} Clinton On Wed, Jan 20, 2010 at 6:30 AM, nani2ratna wrote: > > Hi, > > I am trying to call stored procedure from spring-ibatis dao. > My co

The error occurred while applying a parameter map.

2010-01-20 Thread nani2ratna
Hi, I am trying to call stored procedure from spring-ibatis dao. My code is like this SqlMap.xml {call UPSERT_PM_PRECEDENCE(#skuid_var#,#pm_col_name

Re: update without set element

2010-01-20 Thread Larry Meadors
Do this in Java code. Doing it in xml is kinda silly. :) Larry On Wed, Jan 20, 2010 at 12:00 AM, masonka...@libero.it wrote: > Hi, > > I have a write a update statement with condition on every set element. > If > no condition are matched set part are empty, but where part is already created > a