Ok There is also one thing I overlooked
in your web.xml
add the following entry to expose the resource to your application:
JDBC Connection
jdbc/DataSourceTest
javax.sql.DataSource
Container
Mike Fagan wrote:
This is a JNDI lookup error please verify you are passing the same
name
This is a JNDI lookup error please verify you are passing the same name
as appears in the JNDI column for this data source on your JDBC Data
Sources admin page. It should be that simple
[EMAIL PROTECTED] wrote:
It won’t work; i get in my stacktrace the following message.
Would someone please
Try,
or whatever the JNDI name is for DataSourceTest in the JDBC Data Sources
Admin Screen.
Regards,
MF
Davy Pulinckx wrote:
Hi,
Cane anyone explain me how you configured *weblogic* and *sqlmapconfig*.
I use weblogic, I have a datasource and a connectionpool b
Is it possible that your procedure fails if called simultaneously? My guess is
an error occured in the proc and failed to return a value.
I would verify in sqlplus your pl/sql is reentrant.
Regards,
Mike Fagan
- Original Message -
From: Hendry [mailto:[EMAIL PROTECTED]
Sent: 5/18/2006
Clinton,
I am comfortable with the implementation and will provide any help you
need (testing etc.)
Regards,
Mike Fagan
Clinton Begin wrote:
If you're all comfortable with the solution as it is in the Wiki, I
may be able to implement it.
I have a list of things after TSSJS that I
e since I
use it everywhere. I have requested to have it added in the past but did
not get any feedback from committers on how to make this happen.
Regards,
Mike Fagan
r from the postgres JDBC driver.
Regards,
Mike Fagan
March, Andres wrote:
I have been
looking for a way to do this
for postgres. Is this feature only available for the Oracle RefCursor
type or
can it be used with other databases?
From: Mike
Fagan [mailto:[EMAIL
Ted,
This is standard callable statement JDBC syntax for a
procedure/function. The "?" are assigned the parameter from the
parameterMap in the order declared. Your sample might also work but I
have never tried it :-[ .
Regards,
Mike Fagan
Ted Schrader wrote:
Hi Mike,
I&
Hi,
What is the process to get additional features into the IBATIS baseline?
In particular the oracle ref cursor solution that I have outlined in
http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
Regards,
Mike Fagan
Here is a sample that will take the refcursor and map it automatically
to your resultMap - No TypeHandler required.
{ ? = call myRefCursorFunction(? ) }
Regards,
Mike Fagan
bob robertson wrote:
Just read http://opensource2
Yusuf,
The SQL package is bundled with the testsrc.zp in the attachments.
Regards,
Mike Fagan
Yusuf wrote:
Hello, I was wondering about the support for ref cursors in ibatis, and
i stumbled upon this in the ibatis wiki page
(http://opensource2.atlassian.com/confluence/oss/display/IBATIS
I am unaware of any planned native support of PL/SQL tables.
Your best bet for handling PL/SQL tables or object types is to create a
implement a custom TypeHandlerCallback.
Regards,
Mike Fagan
Juan Cañadas wrote:
It works fine!!!
Thanks!!! :-)
Another question... Oracle PL/SQL tables
Juan,
Sorry I missed the change for namespaces. If you download the source
from the wiki it should work fine for you.
(I even tested with your sample code)
Regards,
Mike Fagan
Juan Cañadas wrote:
ok, thanks...
i have been replaced older ibatis jars now, i get this error
Juan,
The source code has been updated to fix this error. You can download
patch code at:
http://opensource2.atlassian.com/confluence/oss/pages/viewpageattachments.action?pageId=561
Regards,
Mike Fagan
Juan Cañadas wrote:
Hi
I'm trying to get a list of values from an oracle s
Juan,
I have seen this behavior once when the cursor did not return any rows.
There must be a check I am missing, I will try to replicate the problem
to get you a solution.
Regards,
Mike Fagan
Juan Cañadas wrote:
Hi
I'm trying to get a list of values from an oracle stored proc
t the parameter OPEN_CURSORS. I bet this is set to
a number less than 1000. If your DBA is not willing to update this
value, then you will have to adjust your batch inserts not to exceed
this value.
Regards,
Mike Fagan
Kevin,
since your "id" parameter is in/out I would pass in an inital value,
also I think your JDBC type for that parameter wants to be "NUMERIC"
not "NUMBER"
Regards,
Mike Fagan
Broderick, Kevin wrote:
Hi,
Apologies, errors
in previous mail.
ments.
http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
is another option.
Regards,
Mike Fagan
.
Regards,
Mike Fagan
Rao, Satish wrote:
Message
Hi Mike
We are using Oracle 9i and I am using
ojdbc14.jar. But my classpath also has classes12.jar. I removed
classes12.jar, but that did not make any difference.
What Oracle version and driver are you using?
Also I am using
k it is
looping thru thousands of records again?
Thanks,
Satish
-Original Message-
From: Mike Fagan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 18, 2005 4:40 PM
To: user-java@ibatis.apache.org
Subject: Re: Performance issue with CustomTypeHand
Satish,
I am also using oracle ref cursors and do not see the delay you are
experiencing.
Has something possibly changed in your database and the delay you see
is really in the pl/sql?
Regards,
Mike Fagan
Rao, Satish wrote:
Message
Is anyone facing a similar issue. Please
When returning a oracle XMLType to ibatis use the getClobVal()/getStringVal()
function and it work fine.
That is why your extractValue works because it returns varchar2.
so try
SELECT extract(value(x),'/employee').getClobVal() xml
FROM employees
Mike Fagan
Uma S Mudu
22 matches
Mail list logo
