Hi
Is there any place where it has updated information about calling stored
procedure from ibatis 3.0, i checked google and could not find any,
I was reading user guide and it says parameterMap is not used,
I tried the code below and seems it is working, but i would like to do this
using some
characters. What database are you using?
On Fri, Jul 24, 2009 at 12:22 PM, Ashish Kulkarni
ashish.kulkarn...@gmail.com wrote:
HiHas anyone noticed issue with inserting japanese characters in database
using ibatis, i am having some issues here, i have debugged my program and
found that the class
HiHas anyone noticed issue with inserting japanese characters in database
using ibatis, i am having some issues here, i have debugged my program and
found that the class which is passed to ibatis as input parameter has
correct japanese characters, but in database they are not,
Is there any special
HiI have to write a query like below
Select col1, col2 from table1 where col3='ABC' or col3='XYZ'
so i wrote a query like below, will this work, *what do i have to specify
for property, *i have specified it as list, will this work, any suggestions
select id=getMyInfi
Hi Any ideas on this mail, how to test if Pool.PingQuery is working as
expected
On Mon, May 4, 2009 at 10:03 AM, Ashish Kulkarni
ashish.kulkarn...@gmail.com wrote:
HiI have configured my data Source as below
transactionManager type=JDBC
dataSource type=SIMPLE
property name=JDBC.Driver
HiI have configured my data Source as below
transactionManager type=JDBC
dataSource type=SIMPLE
property name=JDBC.Driver value=com.ibm.as400.access.AS400JDBCDriver /
property name=JDBC.ConnectionURL
value=jdbc:as400:MYAS400/MYDB;naming=system;date format=iso;time
format=hms;prompt=false /
HiHow does the performance get affected if i add a ping query, or what is
the best way to do it
On Fri, Apr 24, 2009 at 1:10 PM, Chema demablo...@gmail.com wrote:
Logs show that he's using a SimpleDataSource , so I guess, the
connection pool is implemented by iBatis
I bet for a firewall
). Basically, you
are executing these queries every so often so that the systems around you
are reminded that these connections are active and shouldn't be closed.
On Mon, Apr 27, 2009 at 2:39 PM, Ashish Kulkarni
ashish.kulkarn...@gmail.com wrote:
HiHow does the performance get affected if i add
HiI am having some issue with connection dropping, i am using
ibatis ibatis-2.3.4.726.jar and creating connection to AS400 using JDBC,
but i am seeing these errors in log file, for some reason connection is
getting dropped, what may be the reason, the issue is this a high
availability system and
mario.bri...@in.ibm.comwrote:
What's SQL ERROR CODE in the exception. You want to look it up the DB2 on
AS400 docs
Ashish Kulkarni
ashish.kulkarni1
3...@gmail.com
. This would just let the database know not to kill the
connection in the first place.
Good luck.
On Fri, Apr 24, 2009 at 10:41 AM, Ashish Kulkarni
ashish.kulkarn...@gmail.com wrote:
HiThere is no SQL error code in log file, and this is all in intranet so
there is no firewall in between
HiI am having issue with ibatis, the error i am getting is
Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error
parsing XML. Cause: java.net.ProtocolException: Server redirected too many
times (20)
java.net.ProtocolException: Server redirected too many times (20)
How can i
HiI have a query as below where resultClass is same as parameterClass, for
some reason the response i get when i run this query is parameterClass, for
example if i input as
EnvNames envNames = new EnvNames();
envNames.setTYPE(APPROVALS);
envNames.setAS400NAME(PGMAPSD1);
Hican you please explain what do you there are no parameter markers
select id=getEnvNames
resultClass=com.pfizer.maps.base.data.file.EnvNames
parameterClass=com.pfizer.maps.base.data.file.EnvNames
SELECT TYPE, AS400NAME, ENVNAME, ENVDESC, DISABLED, INIPROG,
INIPGMLIB, USERID, PASS_WRD, MAPSLOGINR
HiIs there any standard way or best practice for of using Ibatis in web
application,
This is how i use it
In my InitServlet which is loaded when the application starts, i create
instance SqlMapClient and save it in ServletContext.
And in other servlets where i need to get data from database, i get
HiI am trying to create SqlMapClient using Properties object
I am getting following error, please see my code below
Exception in thread main java.lang.NullPointerException
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:782)
at
Hi
This is my code
// Create SQlMapClient
Properties prop = new Properties();
prop.setProperty(url, url.trim());
prop.setProperty(driver, driver);
prop.setProperty(username, userid);
prop.setProperty(password, password);
String resource = SQLMapConfigWeb.xml;
Reader reader =
Hi
I have a class like below with get and set method
public ColorClass
{
private String name, desc;
public void setName(String _name)
{
this.name = _name;
}
public String getName()
{
return name;
}
}
How can i define this ColorClass in parameterMap and use it in SQL statement
for varaible
Hi
How can i use java logging API to control logging of ibatis, for example if
i have log4j, i put all the logging information in log4j.xml and from there
i can control what logs i want from ibatis, for example i have added
following lines in log4j.xml
category name=com.ibatis
priority value=error
)
Cheers,
Chris
On 11/21/07 2:15 PM, Ashish Kulkarni [EMAIL PROTECTED]
wrote:
Hi
I am working on a swing application where the user enters his user id
and
password, then this user id and password is required to create
SqlMapClient,
this is what i am tried but did not work
in my
Hi
I am working on a swing application where the user enters his user id and
password, then this user id and password is required to create SqlMapClient,
this is what i am tried but did not work
in my sqlconfig.xml file i have
dataSource type=SIMPLE
property name=JDBC.Driver value=${driver} /
Hi
How do we set the log file location dyanamically in web application,
Currently i am using log4j.xml file with following definiation, this file is
under WEB-INF file
appender name=A2 class=org.apache.log4j.DailyRollingFileAppender
param name=File
value=C:\\Documents and Settings\\Kulkara\\My
Hi
Can you please let me know where do i look into for this information, any
hints please
Ashish
On 10/4/07, Larry Meadors [EMAIL PROTECTED] wrote:
http://logging.apache.org/
Larry
On 10/4/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
How do we set the log file location dyanamically
Hi
Sorry i send it to wrong forum, send the question to log4j forum
Ashish
On 10/4/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
Can you please let me know where do i look into for this information, any
hints please
Ashish
On 10/4/07, Larry Meadors [EMAIL PROTECTED] wrote:
http
configuration. What AppServer are you using?
-Richard
Ashish Kulkarni wrote:
Hi
I did modify this to look like below
transactionManager type=JDBC
dataSource type=JNDI
property name=DataSource value=AS400B/
/dataSource
/transactionManager
But i get following error
add a resource-env-ref to your webapp's web.xml to
link
to the global JNDI resource too, but I usually go with the ResourceLink in
the context files to avoid mucking with web.xml.
Cheers,
Chris
On 9/27/07 7:58 AM, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I am using tomcat application
.
Cheers,
Chris
On 9/27/07 9:32 AM, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
This is what i have done,
in my server.xml file i have added in host element
Context path=/approvals6302 docBase=c:\\approvals6302\\ debug=5
reloadable=true crossContext=true
Resource name=jdbc/AS400B type
Hi
I need some information about using ibatis in web application, i am using
sql maps for java. i have SqlMapConfig.xml and SqlMapConfig.properties file
under src folder,
SqlMapConfig.properties has database connection information,
Now the question is when i create the war file, i do not know
. Then your webapp just references the JNDI name
(something like java:/comp/env/jdbc/OrderDS) and you can change it as you
like outside the webapp.
Lookup JNDI DataSource in your weblogic docs to see more.
Cheers,
Chris
On 9/26/07 12:56 PM, Ashish Kulkarni [EMAIL PROTECTED]
wrote:
Hi
I
,
Ashish
On 9/26/07, Kenny Pearce [EMAIL PROTECTED] wrote:
What you are doing should work fine. However, depending on where you
initialize your ibatis client in your servlet code, you may have to
restart your web application after modifying the file.
Ashish Kulkarni wrote:
Hi
I need some
Hi
Is there any example of setting up ibatis to use JNDI as data source,
I have the following, how do i change it to use JNDI
properties resource=SqlMapConfigAS400.properties /
transactionManager type=JDBC
dataSource type=SIMPLE
property name=JDBC.Driver value=${driver} /
property
)
at com.pfizer.maps.data.GetSQLConfigForWeb.getSqlMapInstance(
GetSQLConfigForWeb.java:49)
at com.pfizer.maps.servlet.Log4JInitServlet.init(Log4JInitServlet.java:104)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java
:1105)
On 9/26/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
Is there any example of setting up ibatis
, Richard Yee [EMAIL PROTECTED] wrote:
Ashish,
Did you read the documentation? What have you tried so far?
-Richard
Ashish Kulkarni wrote:
Hi
I have a question about using Dynamic Mapped Statements and Iterate tag
I have a table with columns,
view
code
color
I have an sql statement
Hi
I have a sql statment like
select * from mytable where line in ('ABC', 'XYZ')
where this SQL
statement is going to extact all rows where line is ABC and XYZ,
but now the problem is i do not know if there are going to be only one line
or 2 or 10, so i thought i would define the sql as
select
, you may need to do some other
work. For example, WebSphere supplies it's own implementation of JCL that
must be configured from the administrative console.
Jeff Butler
On 8/24/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I am using ibatis 2.1.5 , and setting log file is only for 2.2
, Larry Meadors [EMAIL PROTECTED] wrote:
I'd look for a way to make the database do this - any solution on the
Java side will be inherently out-of-date.
Can you do this in a stored procedure?
Larry
On 6/10/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I have a situation where i have a table
Hi
I have a situation where i have a table of about 16,000. rows, which i need
to use for mathematical calculation.
i want to cache the data and this data should update as soon as the database
is updated.
Database is updated by external process, so Java program does not know if
there is update
Hi
I have a requirement where i have to constantly monitor a database for
changes, for example if thers is an row added, or row changed the java
program will process those records.
is there any good way of doing it, currently i am thinking of writing a
TimerTask which will sleep for 5-10 seconds
, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I have posted another thread with detail explaination
this is the thread
http://www.nabble.com/forum/ViewPost.jtp?post=9499524framed=y
if you can take a look and tell me if you have any solution for it
Ashish
On 3/18/07, j-lists [EMAIL
with
badly encoded text that give trouble.
Just a theory.
-J
On 3/12/07, Yuvraj Shinde [EMAIL PROTECTED] wrote:
You can use CDATA tag.
From: Ashish Kulkarni [mailto:[EMAIL PROTECTED]
Sent: Monday, March 12, 2007 5:47 AM
To: user-java
Hi
I am using ibatis to create XML file from database, i have the following
sqlMap
select id=getFooter4 resultClass=xml parameterClass=
java.math.BigDecimal xmlResultName=FOOTER4
SELECT P704SPEC, P704LINE, P704DETL, P704USER, P704DATE, P704TIME
FROM PU27041 WHERE P704SPEC =
, or lt; gt; etc...
It's just XML. ;-)
On 3/11/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I am using ibatis to run a SQL statement which returns a XML as output
as shown below,
select id=getItemSpeicalNotes resultClass=xml parameterClass=
java.math.BigDecimal xmlResultName
Hi
I have a application running on AS400 using ibatis, i am using Log4J for
logging, i am getting a lot of log in my spool file.
for preparedStatement created, resultset etc,
How do i suppress these logs from my Log4j.properties file which i use to
set logging in my application.
Ashish
Hi
Is there any source code for using properties when creating sql map client
Ashish
On 2/13/07, Larry Meadors [EMAIL PROTECTED] wrote:
Use a properties object when you create the sql map client.
Larry
On 2/13/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I have a web application where
Hi
I have a web application where i am using ibatis, i have a situation where i
want to select the database from where i want to get data.
In this application user will login and select he wants to use development
1, or development 2 or test 1 from a drop down
So if the user selects
Hi
I have a java program which uses ibatis to run SQL queries, this program
runs on AS400, and on of the AS400 boxes i am getting following error
Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error
parsing XML.
Caused by: java.net.UnknownHostException: ibatis.apache.org
The
be resolved in the iBATIS jar file. Are you using an older
version of iBATIS, or the current release?
Also, it could be the XML parser on the 400..if that is the case, you
could use a system DTD instead of the default.
Larry
On 2/6/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I have a java
using. This DOCTYPE is for versions after
2.1
-Richard
-Original Message-
*From:* Ashish Kulkarni [mailto:[EMAIL PROTECTED]
*Sent:* Tuesday, February 06, 2007 9:25 AM
*To:* user-java@ibatis.apache.org; [EMAIL PROTECTED]
*Subject:* Re: issue with unknown host exception
Hi
I tried
://ibatis.apache.org/dtd/sql-map-2.dtd;
Which version of iBATIS are you using. This DOCTYPE is for versions
after 2.1
-Richard
-Original Message-
*From:* Ashish Kulkarni [mailto: [EMAIL PROTECTED]
*Sent:* Tuesday, February 06, 2007 9:25 AM
*To:* user-java@ibatis.apache.org ; [EMAIL
On 12/18/06, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
How do i replace my existing code with
sqlMapClient.openSession(myConnection);
My excisting code is as below
client.setUserConnection(conn);
client.queryForList(getItemFormat,myname );
Regards
Ashish
Hi
We have a web application running in websphere, and for a while we are
seeing some hung threads in websphere,
do we did some java dump as insturcted by IBM and we are seeing some of the
following messages in the dump.
In our java program before calling SQL statemenet we do the following
Hi
I have attached the sqlmap and xml file with all the sql statements along
this mail.
On 12/18/06, Larry Meadors [EMAIL PROTECTED] wrote:
Can you post your configuration (database and sqlmap)?
Larry
On 12/18/06, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
We have a web application
://issues.apache.org/jira/browse/IBATIS-66
Make sure you're calling client.setUserConnection(null) after processing
each query.
Jeff Butler
On 12/18/06, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I have attached the sqlmap and xml file with all the sql statements
along this mail
Hi
Has anyone worked with SQLJ, suppose if i have 10 SQLJ
files, how do i use them from java.
How do i compile them?
and call them from java class?
Ashish
A$HI$H
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Hi
I am using ibatis for sql mapping in my web
application, i am also using log4j for logging,
I have a XML file which i load at startup where I
setup logging parameters and logging levels,
Can i use this XML file to setup ibatis logging
parameters?
Suppose i have to add following line
Hi
Recently i had asked question about designing java
classes for resultset,
So if i have desgined my java classes as per my
requirement, and using java.util.HashMap to get result
using ibatis, and then in my java program loading
values from HashMap in my java class,
am i not making the process
Hi
What is the best way to design java class for mapping,
for example suppose i have a SQL querry which join 2-3
tables and returns the data,
should i design java class to match this SQL querry,
or should i design java class to match tables, and
then create a Map in xml file and then populate
Hi
I have a table with 4 columns number, name, date,
time, it is not unique so can have multiple entries
for one name at different date and time.
I need to find out the first instance of name for that
number in this table, or get the name with minimum
date and time
i can do
select min(date),
= 123)
nathan
On Feb 24, 2006, at 9:25 AM, Nathan Maves wrote:
You almost had it :)
select min(date), min(time), name from mytable
where number = 123
group by name
Nathan
On Feb 24, 2006, at 8:58 AM, Ashish Kulkarni
wrote:
Hi
I have a table with 4 columns number
Hi
Is there any open source utility which i can use to
create DDL from an existing database, so i can use it
to run to create tables on other database.
This utility should be smart enough to create DDL
statements for tables with primary key, before tables
with foreign key.
That way when i run the
Hi
I have defined a query as
select id=selectLinesFromView
resultClass=java.lang.String
SELECT L083LINE FROM PL1083 WHERE L083CODE = #value#
ORDER BY L083SQNO
/select
and in my java code i do
List list = client.queryForList(selectLinesFromView,
ABC);
Suppose if i want a Vector as output, i just
Hi
I did configure Aator and ran to create sql mapping
for 1 table (PODATA),
it worked but then created on more java class called
(PodataExample) and also in
CXASHTEST_PODATA_SqlMap.xml (CXASHTEST is schema name)
there is a xml tags for
resultMap id=abatorgenerated_PodataResult
store the
SMC in application
scope based on the key (test1 or test2), and get it
from there.
Larry
On 12/22/05, Ashish Kulkarni
[EMAIL PROTECTED] wrote:
Hi
I have a situation, in which i have 2 database on
suppose DB2, first database is Test1, and second
is
Test2
Hello
If i have to use DAO and SQLMap to get data from my
database, but i want to supply the connection, is it
possible?
for example if i have to just SQLMap i do the
following
SqlMapClient client =
GetSQLConfig.getSqlMapInstance();
client.setUserConnection(conn);
How can i do it when using DAO
Butler
On 11/18/05, Ashish Kulkarni
[EMAIL PROTECTED] wrote:
Hello
Why do i get following error
Caused by:
org.xml.sax.SAXParseException: Element sqlMap
requires additional elements.
at java/lang/Throwable.init(Throwable.java:195)
at java/lang/Exception.init(Exception.java:41
Alan
What you are doing is singleton pattern, it makes sure
that there is only one instance of SqlMapClient
through out your application.
Ashish
--- Alan Chandler [EMAIL PROTECTED] wrote:
On Monday 24 Oct 2005 16:50, Ashish Kulkarni wrote:
Hello
What is the best way to get SqlMapClient
Hi
Suppose if i want to get any data using ibatis, this
is what i do
1, Create a javabean to store this data
public class MyBean
{
private String a;
//get and set methods
}
2, define in xml file SQL statement
select id=getCODataBean
resultClass=MyBean
Select name from nametable
/select
Now if
Hello
What is the best way to get SqlMapClient in a web
application
1 , Define a singleton pattern class, and create a
instance of SqlMapClient to use by all classes which
need to access data.
2, Define a AbstractClass and put method to get
SqlMapClient in constructor of this class, and then
each
...
Jeff Butler
On 10/24/05, Ashish Kulkarni
[EMAIL PROTECTED] wrote:
Jeff
Can you provide me a sample code of putting
SqlMapClient in servlet context with listener and
access it from class which requires to access it
Ashish
--- Jeff Butler [EMAIL PROTECTED] wrote:
I don't
of the DAO layer is to only execute queries
and return the data. You can externalize such
transformations into the RowHandler.
Rgds
Prashanth Sukumaran.
Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
this is a way i got around my problem
// definiation in xml file
parameterClass
%'
and type1 not like '%4%'
and type1 not like '%5%'
and type1 not like '%6%'
and type1 not like '%7%'
and type1 not like '%8%'
and type1 not like '%9%'
and type1 not like '%0%'
Crude, but effective...
Larry
On 7/13/05, Ashish Kulkarni
[EMAIL PROTECTED] wrote:
Hello
I
Hello
I am getting the following error
Check the DELETE FROM POCOMMENT WHERE SYSTEM=#system#
and USER=#user# and ENVNAME=#envname# and P204PORD =
#ponum# and P204ROUT=#routing# .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: [SQL0206] Column
#SYSTEM# not
, as far as I can see, just
passing in a Map of
Integer and String objects should work fine and you
don't really need to use
a parameter map.
- Original Message -
From: Ashish Kulkarni [EMAIL PROTECTED]
To: user-java@ibatis.apache.org
Sent: Tuesday, July 12, 2005 1:59 PM
Hi
I am not sure why i am getting the above error, is
there a way to debug it.
I am going to paste my xml file definiation here,
I am sure this SQL statement works
the error i am getting is as below
Caused by: com.ibatis.sqlmap.client.SqlMapException:
Unrecognized parameter mapping field: '
74 matches
Mail list logo