Re: Advanced Result Mapping documentation error or misunderstanding of concept

2010-05-19 Thread Clinton Begin
Yep, just a typo. I'll take care of it in the docs. Cheers, Clinton On Wed, May 19, 2010 at 5:12 AM, alebu wrote: > Hi, at this moment I am reading documentation "Advanced Result Mapping" > section and one think I can't understand in the example with blogs (further > reading didn't clarified i

Advanced Result Mapping documentation error or misunderstanding of concept

2010-05-19 Thread alebu
Hi, at this moment I am reading documentation "Advanced Result Mapping" section and one think I can't understand in the example with blogs (further reading didn't clarified it either). SQL Query is described like: select B.id as *blog_id*, B.title as blog_title, ... Result set mapping for that

Re: Ibatis Mysql Sql error but sql runs fine

2010-04-12 Thread Nate Weiss
I am creating a table dynamically. CREATE TABLE #tableName# ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Hi-- Try $tableName$ rather than #tableName# See page 32 here for more: http://svn.apache.org/repos/asf/ibatis/java/ibatis-2/trunk/ibatis-2-docs/en/iBATIS-SqlMaps-2

Re: Ibatis Mysql Sql error but sql runs fine

2010-04-12 Thread Larry Meadors
from stackTrac--- > > org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad > SQL grammar []; nested exception is > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in Index.xml. > --- The error occurred while applying a parameter map. > --- Check the

Ibatis Mysql Sql error but sql runs fine

2010-04-12 Thread Corporate Tool
Types: [java.lang.String] (JakartaCommonsLoggingImpl.java:27) I get the following from stackTrac--- org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in Inde

RE: Eclipse error when running Ibator

2010-03-26 Thread Morearty, Brian
f Butler [mailto:jeffgbut...@gmail.com] Sent: Friday, March 26, 2010 12:49 PM To: user-java@ibatis.apache.org Subject: Re: Eclipse error when running Ibator Two questions - one obvious, one not so obvious :) 1. (Obvious) What's different in the failing environment? (Different Eclipse versi

Re: Eclipse error when running Ibator

2010-03-26 Thread Jeff Butler
ne have ideas for how to fix this? We are > using Ibator 1.2.2. > > > > Right-click on IbatorConfig.xml and choose “Generate iBATIS Artifacts.” > Progress bar goes part-way, then shows this error: > > > > Severity: Error > > Mess

Eclipse error when running Ibator

2010-03-25 Thread Morearty, Brian
shows this error: Severity: Error Message: Unexpected error while running Ibator. Exception Stack Trace: java.lang.ArrayIndexOutOfBoundsException: 247 at org.eclipse.jdt.internal.formatter.CodeFormatterVisitor.visit(CodeFormat terVisitor.java:3239)

Re: db2 -302 error

2010-03-23 Thread Mario Ds Briggs
PM Subject Re: db2 -302 error Please respond to user-j...@ibatis.

Re: db2 -302 error

2010-03-23 Thread Nathan Maves
To >> user-java@ibatis.apache.org >> 03/23/2010 11:04 cc >> AM >> Subject >>

Re: db2 -302 error

2010-03-22 Thread joson yu
user-java@ibatis.apache.org > 03/23/2010 11:04 cc > AM > Subject > Re: db2 -302 error >

Re: db2 -302 error

2010-03-22 Thread joson yu
it runs like it also constraint the parameter's. i don't know does i show the problem clear. 2010/3/23 Mario Ds Briggs > Hi Joson, > > I guess you figured the error out yourself i.e. length of the parameter > value is > than the column length (30). > > It works

Re: db2 -302 error

2010-03-22 Thread Mario Ds Briggs
va@ibatis.apache.org 03/23/2010 11:04 cc AM Subject

Re: db2 -302 error

2010-03-22 Thread joson yu
it runs like it also constraint the parameter's. i don't know does i show the problem clear. 2010/3/23 Mario Ds Briggs > Hi Joson, > > I guess you figured the error out yourself i.e. length of the parameter > value is > than the column length (30). > > It works

Re: db2 -302 error

2010-03-22 Thread Mario Ds Briggs
Hi Joson, I guess you figured the error out yourself i.e. length of the parameter value is > than the column length (30). It works fine in db2 client since there you are not using a parameter marker but have value as a literal inside the SQL statement string. cheers Ma

Re: db2 -302 error

2010-03-22 Thread joson yu
ps:in the sql the parameter should passed in with String that is longger than 30. 2010/3/23 joson yu > there is an error happend in my situation.and want to know is there anyone > else meet this problem. > i use ibatis2. the database is used db2. > sql: select [columns] from

db2 -302 error

2010-03-22 Thread joson yu
there is an error happend in my situation.and want to know is there anyone else meet this problem. i use ibatis2. the database is used db2. sql: select [columns] from tables where column1 = ''. and the column1 is varchar type and it's length is 30. the sql is execute fine in

Re: Migrator and exit error code

2010-02-13 Thread Marco Speranza
ation tool, to automate >> and test our database scripts. The problem is that when one SQL error is >> encountered, migrator does not return the error code to the shell, and my CI >> tool does not report correctly the error. Yesterday night I've made a little >> patch

Re: Migrator and exit error code

2010-02-13 Thread Clinton Begin
Absolutely. On Sat, Feb 13, 2010 at 4:21 PM, Marco Speranza wrote: > Hi all, I'm using migrator into a Continuous integration tool, to automate > and test our database scripts. The problem is that when one SQL error is > encountered, migrator does not return the error code to the

Migrator and exit error code

2010-02-13 Thread Marco Speranza
Hi all, I'm using migrator into a Continuous integration tool, to automate and test our database scripts. The problem is that when one SQL error is encountered, migrator does not return the error code to the shell, and my CI tool does not report correctly the error. Yesterday night I'

Re: Lazy Loading cglib error

2010-02-12 Thread Clinton Begin
. but when I set lazy loading = true, the following error occurs > on every query: > > ### Error querying database. Cause: > net.sf.cglib.core.CodeGenerationException: > java.lang.reflect.InvocationTargetException -> null > ### The error may involve com.myapp.model.MyMapper.lo

Lazy Loading cglib error

2010-02-12 Thread Eugenia Mastantuono
Hi, I'm having problems enabling lazy loading. Using: Ibatis 3 beta 9, cglib 2.2, asm 3.2. (into a netbeans platform library module) Everything works great with lazy loading disabled, selects, inserts, updates, etc. but when I set lazy loading = true, the following error occurs on every

Re: Ibatis 3 Insert Error

2010-01-31 Thread Clinton Begin
> > Currently, I have the return type from insertKey as “Key”. Presumbably, > this would be a key object containing the newly created key object and key > id. > > > > - Chip > > > -- > > *From:* Clinton Begin [mailto:clinton.be...@gma

RE: Ibatis 3 Insert Error

2010-01-31 Thread Chip Owen
ubject: Re: Ibatis 3 Insert Error What's the return type of the mapper method? Clinton On Sun, Jan 31, 2010 at 3:03 PM, ChippyJoey wrote: Hi - I am new to Ibatis and I have run into an issue regarding inserts into a table. I am getting the following error when I attempt to insert da

Re: Ibatis 3 Insert Error

2010-01-31 Thread Clinton Begin
What's the return type of the mapper method? Clinton On Sun, Jan 31, 2010 at 3:03 PM, ChippyJoey wrote: > > Hi – > > I am new to Ibatis and I have run into an issue regarding inserts into a > table. I am getting the following error when I attempt to insert data into &g

Ibatis 3 Insert Error

2010-01-31 Thread ChippyJoey
Hi – I am new to Ibatis and I have run into an issue regarding inserts into a table. I am getting the following error when I attempt to insert data into a table: DEBUG [main] - Checked out connection 14247087 from pool. DEBUG [main] - ooo Connection Opened DEBUG [main] - ==> Executing: ins

Re: ibator build from source 1.2.1 running error

2010-01-27 Thread Jeff Butler
ding with is Maven2 and the build is OK as I got the jar > file generated. > However, I got some error when I was trying to run it from the command line. > > The error is as follows > java.net.MalformedURLException >  at java.net.URL.(URL.java:601) >  at java.net.URL.

ibator build from source 1.2.1 running error

2010-01-27 Thread kevin zhao
Hi there, I'm trying to build ibator from source that I downloaded form this address http://people.apache.org/builds/ibatis/ibator/ibator-1.2.1-681.zip. The tool I'm building with is Maven2 and the build is OK as I got the jar file generated. However, I got some error when I was trying

Re: The error occurred while applying a parameter map.

2010-01-20 Thread Clinton Begin
ap.put("skuid_var", prodmDatPm.getSkuid()); > hashMap.put("pm_col_name", pmColumnName); > hashMap.put("prec_master_col_name", precedenceColName); > hashMap.put("new_source", 20); > hashMap.put("col_value", col_va

The error occurred while applying a parameter map.

2010-01-20 Thread nani2ratna
_name", precedenceColName); hashMap.put("new_source", 20); hashMap.put("col_value", col_value); getSqlMapClientTemplate().update("UPSERT_PM_PRECEDENCE", hashMap); Error Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The er

Re: com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance

2009-12-21 Thread nath1
meindert-3, Thanks for the reply. Am also using MySql drivers but not mentioned in the jar files listing.. nath1 wrote: > > Hi > Am very new to iBATIS. Am facing com.ibatis.sqlmap.client.SqlMapException: > There was an error while building the SqlMap instance Exception. >

RE: com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance

2009-12-21 Thread meindert
ption: There was an error while building the SqlMap instance Hi Am very new to iBATIS. Am facing com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance Exception. below is the SQLMapConfig.xml file: http://ibatis.apache.org/dtd/sql-map-config-

com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance

2009-12-21 Thread nath1
Hi Am very new to iBATIS. Am facing com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance Exception. below is the SQLMapConfig.xml file: http://ibatis.apache.org/dtd/sql-map-config-2.dtd

Re: Re: Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.

2009-11-25 Thread Larry Meadors
Hm, it seems to have cut off the useful parts - the swing and awt stuff doesn't help at all. :( What driver are you using? Larry On Tue, Nov 24, 2009 at 11:57 PM, masonka...@libero.it wrote: > Here my stack trace: > > org.apache.ibatis.exceptions.IbatisException: > ### Error

R: Re: Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.

2009-11-24 Thread masonka...@libero.it
Here my stack trace: org.apache.ibatis.exceptions.IbatisException: ### Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.### The error may exist in org/acl/dbmapping/User.xml### The error may involve org.acl.base.user.insert### The error

Re: Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.

2009-11-24 Thread Clinton Begin
Stack trace? On Tue, Nov 24, 2009 at 4:11 PM, masonka...@libero.it wrote: > Hi, > > I have a problem when I try to insert into table e new line. > Ibatis > (version 3, beta 5) report the error message: > > Error updating database. > Cause: org.apache.ibatis.executor.Exe

Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.

2009-11-24 Thread masonka...@libero.it
Hi, I have a problem when I try to insert into table e new line. Ibatis (version 3, beta 5) report the error message: Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed. the insert clause used is: insert into user (usr,pwd,role,dsc,sts

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread meindert
; -Original Message- From: Ron H [mailto:be.spec...@gmail.com] Sent: 18 November 2009 01:24 PM To: user-java@ibatis.apache.org Subject: RE: Error calling Connection.setAutoCommit: thanks do you use it instead of: meindert-3 wrote: > > Not sure what the differe

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread Ron H
; in DUAL, shouldn't you use 'select top 1 * from DUAL' > > -Original Message- > From: Ron H [mailto:be.spec...@gmail.com] > Sent: 18 November 2009 11:48 AM > To: user-java@ibatis.apache.org > Subject: Error calling Connection.setAutoCommit: > > >

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread meindert
-- From: Ron H [mailto:be.spec...@gmail.com] Sent: 18 November 2009 11:48 AM To: user-java@ibatis.apache.org Subject: Error calling Connection.setAutoCommit: hi randomly, i get the following exception: 18/11/2009 03:18:49 ERROR Connection:19 - Error calling Connection.setAutoCommit: com.mysq

Error calling Connection.setAutoCommit:

2009-11-18 Thread Ron H
hi randomly, i get the following exception: 18/11/2009 03:18:49 ERROR Connection:19 - Error calling Connection.setAutoCommit: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE

Re: connection problem using ibatis2.3+postgresql8.3+glassfish2 ( An I/O error occured while sending to the backend.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException)

2009-09-10 Thread Larry Meadors
Probably a stale connection. Google for "org.postgresql.util.PSQLException: An I/O error occured while sending to the backend" Larry On Thu, Sep 10, 2009 at 8:01 PM, Donmis wrote: > > HELP HELP!!! > :,( > -- > View this message in context: > http://www.nabble.

Re: connection problem using ibatis2.3+postgresql8.3+glassfish2 ( An I/O error occured while sending to the backend.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException)

2009-09-10 Thread Donmis
HELP HELP!!! :,( -- View this message in context: http://www.nabble.com/connection-problem-using-ibatis2.3%2Bpostgresql8.3%2Bglassfish2-%28-An-I-O-error-occured-while-sending-to-the-backend.--nested-exception-is-com.ibatis.common.jdbc.exception.NestedSQLException%29-tp25394317p25394320.html

connection problem using ibatis2.3+postgresql8.3+glassfish2 ( An I/O error occured while sending to the backend.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException)

2009-09-10 Thread Donmis
, always hit the below problem: com.sph.newslink.service.UserManager - org.springframework.dao.DataAccessResourceFailureException: SqlMapClient operation; SQL []; --- The error occurred in com/sph/newslink/dao/ibatis/sqlmap/TOP_SQLMAP.xml. --- The error occurred while applying a parameter map

Re: Ibatis conversion error on DB2

2009-09-04 Thread Mario Ds Briggs
Based on the proof you have provided (the traces, the SQLSTATES of the error & spring DAO exception - DataIntegrityViolationException) there is nothing further you need to look at execpt values being inserted/updated. SQL0406N A numeric value in the UPDATE or INSERT statement is not wi

Re: Ibatis conversion error on DB2

2009-09-04 Thread adi203793
Subject > Please respond to Re: Ibatis conversion error on DB2 > user-j...@ibatis.

Re: Ibatis conversion error on DB2

2009-09-04 Thread Mario Ds Briggs
Subject Please respond to Re: Ibatis conversion error on DB2 user-j...@ibatis. apache.org

Re: Ibatis conversion error on DB2

2009-09-04 Thread adi203793
Hi Mario, Thanks for the reply. The OS name i5/AS400. One more thing value which I have inserted is perfectly fine. As I mentioned sometimes it failed but most of the times it worked. Please help me out Mario Briggs wrote: > > Nothing to do with ibatis. Look up the error definiti

Re: Ibatis conversion error on DB2

2009-09-04 Thread Mario Ds Briggs
Nothing to do with ibatis. Look up the error definitions of SQLStates SQL302 & SQL406 and you will understand why it occurs arbitarily :-) The value that is trying to be inserted in out-of-range for the column in the db. M

Ibatis conversion error on DB2

2009-09-03 Thread adi203793
I have been using Ibatis through Spring to acccessing data from DB2 to java. I have been run this query so many times sometimes it works and sometimes not. means I m not able to replicate it.while updating the record I got the error like this: UPDATE STHEDRL1 SET STHRIN=? WHERE STHINT=? AND

Re: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Clinton Begin
sage- > From: Clinton Begin [mailto:clinton.be...@gmail.com] > Sent: Friday, August 14, 2009 2:10 PM > To: user-java@ibatis.apache.org > Subject: Re: iBatis 3.x.x - documentation error ? > > Thanks!  The easiest way to create a test is to check out the iBATIS source > fro

RE: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Poitras Christian
atis 3.x.x - documentation error ? Thanks! The easiest way to create a test is to check out the iBATIS source from SVN: http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-3/ Create a descriptive subdirectory of the 'submitted' test directory: ibatis-3-core/src/test/ja

RE: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Poitras Christian
Done. https://issues.apache.org/jira/browse/IBATIS-625 Christian -Original Message- From: Poitras Christian [mailto:christian.poit...@ircm.qc.ca] Sent: Friday, August 14, 2009 1:39 PM To: 'user-java@ibatis.apache.org' Subject: RE: iBatis 3.x.x - documentation error ? I will f

Re: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Clinton Begin
t; From: Clinton Begin [mailto:clinton.be...@gmail.com] > Sent: Friday, August 14, 2009 12:34 PM > To: user-java@ibatis.apache.org > Subject: Re: iBatis 3.x.x - documentation error ? > > Can one of you file a Jira ticket with a description and a failing unit test > attached if possible?

RE: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Poitras Christian
I will file a JIRA. I will also try to make a unit test for it. Christian -Original Message- From: Clinton Begin [mailto:clinton.be...@gmail.com] Sent: Friday, August 14, 2009 12:34 PM To: user-java@ibatis.apache.org Subject: Re: iBatis 3.x.x - documentation error ? Can one of you file

Re: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Clinton Begin
Date: Fri, 14 Aug 2009 09:11:03 -0400 > Subject: RE: iBatis 3.x.x - documentation error ? > > When I tried iBATIS 3, I've done like you naming my interface and my xml > with the same name. Don't do that, iBATIS will throw an exception like > yours. > > You should name you

RE: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Erdem Budak
Works fine now. Thank you. From: christian.poit...@ircm.qc.ca To: user-java@ibatis.apache.org Date: Fri, 14 Aug 2009 09:11:03 -0400 Subject: RE: iBatis 3.x.x - documentation error ? When I tried iBATIS 3, I've done like you naming my interface and my xml with the same name. Don

RE: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Poitras Christian
interface. I beleive this is a bug. Christian From: Erdem Budak [mailto:erdembu...@hotmail.com] Sent: Friday, August 14, 2009 6:01 AM To: user-java@ibatis.apache.org Subject: RE: iBatis 3.x.x - documentation error ? And what do think about the mapping class. Is

RE: iBatis 3.x.x - documentation error ?

2009-08-14 Thread Erdem Budak
And what do think about the mapping class. Is something wrong with my code ? Date: Thu, 13 Aug 2009 21:34:47 -0600 Subject: Re: iBatis 3.x.x - documentation error ? From: clinton.be...@gmail.com To: user-java@ibatis.apache.org corrected. On Thu, Aug 13, 2009 at 9:22 AM, Clinton Begin wrote

Re: iBatis 3.x.x - documentation error ?

2009-08-13 Thread Clinton Begin
mapper class and >> could not manage to do it. What i tried to do is. >> >> -a UserMapper interface which defines a selectUser function. >> >> public interface UserMapper { >> >> public User selectUser(int id); >> >> } >> >

Re: iBatis 3.x.x - documentation error ?

2009-08-13 Thread Clinton Begin
c interface UserMapper { > > public User selectUser(int id); > > } > > -a UserMapper.xml > > > > SELECT * FROM users WHERE id = #{id} > > > > -in my configuration.xml > > > > > > having the error > > Exception

iBatis 3.x.x - documentation error ?

2009-08-13 Thread Erdem Budak
d to do is. -a UserMapper interface which defines a selectUser function. public interface UserMapper { public User selectUser(int id); } -a UserMapper.xml SELECT * FROM users WHERE id = #{id} -in my configuration.xml having the error Exception in thread &q

Re: how to do error handling?

2009-07-31 Thread Nail Uenlue
you catch  a SQLException from the DB? Does the >> developer >> that catches this exception really know what to do with it? Can he >> recover from such a >> situation at runtime? He cant in 99% of the casesso dont even >> bother catching those >> exception at

Re: how to do error handling?

2009-07-30 Thread Bhaarat Sharma
from such a > situation at runtime? He cant in 99% of the casesso dont even > bother catching those > exception at DAO level and let them get all the way up to your so > called Exception Barrier, > which you can configure at web layer (like the error-page directive in > the web.xm

Re: how to do error handling?

2009-07-30 Thread Nail Uenlue
...so dont even bother catching those exception at DAO level and let them get all the way up to your so called Exception Barrier, which you can configure at web layer (like the error-page directive in the web.xml) and show a generic message like "A technical problem occured"... Most of the pp

Re: how to do error handling?

2009-07-30 Thread Bhaarat Sharma
s, > > I have a few questions on how to handle errors that are thrown when > iBatis > > calls the Stored Procedures. > > Assuming i have the following code: > > results_list = getSqlMapClientTemplate().queryForList("spfile.getReport", > > parmMap); > &g

Re: how to do error handling?

2009-07-30 Thread Larry Meadors
e: > results_list = getSqlMapClientTemplate().queryForList("spfile.getReport", > parmMap); > If i have the above code then when error occurs, we see it on the screen and > it looks very ugly. Also, if the error occurs in above line then code after > this line is not executed.

how to do error handling?

2009-07-30 Thread Bhaarat Sharma
Hi guys, I have a few questions on how to handle errors that are thrown when iBatis calls the Stored Procedures. Assuming i have the following code: results_list = getSqlMapClientTemplate().queryForList("spfile.getReport", parmMap); If i have the above code then when error occurs, we

Re: DB Error

2009-07-21 Thread Glenn Barnard
, May 28, 2009 12:05 PM > *To:* user-java@ibatis.apache.org > *Subject:* RE: DB Error > > I noticed this problem with straight SQL too (insert / update) … > > > > If I open connection with autocommit(false), and then try to commit / > rollback; I get the same error >

RE: DB Error

2009-07-21 Thread Shannon, Bryan
Hope this helps! From: Ejaz X Mohammed [mailto:ejaz.moham...@jpmorgan.com] Sent: Thursday, May 28, 2009 12:05 PM To: user-java@ibatis.apache.org Subject: RE: DB Error I noticed this problem with straight SQL too (insert / update) ... If I open connection with a

Ibatis select Query failing throwing Error getting Connection from Transaction

2009-07-16 Thread BiswaMishra
: com.tgt.ecl.exception.TgtDataAccessException: com.ibatis.common.jdbc.exception.NestedSQLException: Error getting Connection from Transaction. Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: JtaTransaction could not start transaction. Cause: at

RE: error fetching BLOB and CLOB data

2009-07-16 Thread Mario Ds Briggs
Subject Please respond to RE: error fetching BLOB and CLOB user-j...@ibatis. data apache.org

Re: error fetching BLOB and CLOB data

2009-07-14 Thread Jeff Butler
> jdbc 2.0. > > We eliminated the driver as an issue, as I mentioned in my question, by > using the same datasource with straight SQL. We were able to successfully > fetch BLOB and CLOB with straight SQL instead of iBATIS. > > Any other suggestions would be appreciated. > >

RE: error fetching BLOB and CLOB data

2009-07-14 Thread Pat Thatte
ATIS. Any other suggestions would be appreciated. > Subject: Re: error fetching BLOB and CLOB data > > Pat, > > looks like you are using a very old version of the DB2 JDBC driver (atleast > in the iBatis use-case u have detailed below) > a - which is not a type 4 JDBC dri

Re: error fetching BLOB and CLOB data

2009-07-13 Thread Mario Ds Briggs
Subject Please respond to error fetching BLOB and CLOB data user-j...@ibatis. apache.org

error fetching BLOB and CLOB data

2009-07-13 Thread Pat Thatte
We have BLOBs and CLOBs in a DB2 v8 database. We use a jdbcType of 'BLOB' or 'CLOB' respectively in our SQL Map file and are getting an error 'CLI0123E SQL data type out of range. SQLSTATE=HY004'. There was an older post about checking the driver type, but

Local transaction error (not failure) listing 7.3 Begin book

2009-07-06 Thread David Brown
Hello iBatis group, an attempt to implement the equivalent Local Transaction as outlined in the listing 7.3 of the Begin book returns an error condition: java.lang.NullPointerException at com.sexingtechnologies.st.dao.TestAnimalmasterDAO.testDAOInsert(TestAnimalmasterDAO.java:101

Re: com.ibatis.dao.client.DaoException: Error while configuring DaoManager

2009-07-03 Thread David Brown
- From: "Kai Grabfelder" To: user-java@ibatis.apache.org Sent: Friday, June 26, 2009 6:46:04 PM GMT -06:00 US/Canada Central Subject: Re: com.ibatis.dao.client.DaoException: Error while configuring DaoManager sounds like an older version of iBATIS. Which version are you using? Have you

Re: com.ibatis.dao.client.DaoException: Error while configuring DaoManager

2009-06-26 Thread Kai Grabfelder
tis folks, I finished reading the Begin book and I have the > JPetStore exmaple imported into Eclipse running OK. I decided to have a hand > at iBatis testcase on a live DB but this is all that I can get: > > > > com.ibatis.dao.client.DaoException: Error while configuring

com.ibatis.dao.client.DaoException: Error while configuring DaoManager

2009-06-26 Thread David Brown
Hello iBatis folks, I finished reading the Begin book and I have the JPetStore exmaple imported into Eclipse running OK. I decided to have a hand at iBatis testcase on a live DB but this is all that I can get: com.ibatis.dao.client.DaoException: Error while configuring DaoManager. Cause

Re: Error while trying to call stored proc from ibatis

2009-06-18 Thread Jeff Butler
sample.setId( "111" ); > > sample.setName ( "name1" ); > > sample.setResult("" ); > > (String)getSqlMapClientTemplate().queryForObject( "sampleProc", > sample ); > > * * > > *Am getting th

Error while trying to call stored proc from ibatis

2009-06-18 Thread aravind . s
SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in SqlMap.xml. --- The error occurred while applying a parameter map. --- Check the parameterId. --- Check the statement (update procedure failed).

Re: SVN Trunk build error ?

2009-06-16 Thread DelGurth
Perhaps that is because you build for java 6 and not java 5? http://java.sun.com/javase/6/docs/api/java/sql/ResultSet.html#updateNClob(int,%20java.sql.NClob) Also see (probably among others): http://www.mail-archive.com/d...@ibatis.apache.org/msg03146.html DelGurth On Tue, Jun 16, 2009 at 10:0

SVN Trunk build error ?

2009-06-16 Thread Linard Moll
Building the trunk source doesn't work out for me. The java compiler returns 2 errors: SVN Url: http://svn.apache.org/repos/asf/ibatis/trunk Ant: src.compile: [javac] D:\SVN\iBatis\java\ibatis-2\ibatis-2-core\src\com\ibatis\common\jdbc\SimpleD ataSource.java:52: com.ibatis.common.jdbc.SimpleD

Re: Unexpected error while running Ibator NPE

2009-06-12 Thread andig
asses. > > See this thread: > http://mail-archives.apache.org/mod_mbox/ibatis-user-java/200901.mbox/%3c35dbee350901190659t668c375as2a1cbba564cf7...@mail.gmail.com%3e > > Hope this helps. > > Dan Turkenkopf > > On Fri, Jun 12, 2009 at 7:35 AM, andig wrote: > &g

Re: Unexpected error while running Ibator NPE

2009-06-12 Thread Dan Turkenkopf
-user-java/200901.mbox/%3c35dbee350901190659t668c375as2a1cbba564cf7...@mail.gmail.com%3e Hope this helps. Dan Turkenkopf On Fri, Jun 12, 2009 at 7:35 AM, andig wrote: > > I'm trying to run Ibator on Eclipse seeing this error: > > > !ENTRY org.apache.ibatis.ibator.eclipse.

Unexpected error while running Ibator NPE

2009-06-12 Thread andig
I'm trying to run Ibator on Eclipse seeing this error: !ENTRY org.apache.ibatis.ibator.eclipse.ui 4 4 2009-06-12 13:30:57.656 !MESSAGE Unexpected error while running Ibator. !STACK 0 java.lang.NullPointerException

RE: DB Error

2009-05-28 Thread Ejaz X Mohammed
I noticed this problem with straight SQL too (insert / update) ... If I open connection with autocommit(false), and then try to commit / rollback; I get the same error Ejaz From: Glenn Barnard [mailto:barnardgl...@gmail.com] Sent: Thursday, May 28, 2009 10:54 AM To: user-java

Re: DB Error

2009-05-28 Thread Glenn Barnard
wrote: > I get same error with Sybase 12.5, but when I call a stored proc which > has begin tran / end tran > > > > when I execute same stored proc directly via jdbc, I don't get "SET > CHAINED …" error > > > > Should be something with driver …jconn2

RE: DB Error

2009-05-28 Thread Ejaz X Mohammed
I get same error with Sybase 12.5, but when I call a stored proc which has begin tran / end tran when I execute same stored proc directly via jdbc, I don't get "SET CHAINED ..." error Should be something with driver ...jconn2.jar Ejaz From: Glenn Barnard [mailto:barnard

DB Error

2009-05-28 Thread Glenn Barnard
: Unable to set AutoCommit property.SET CHAINED command not allowed within multi-statement transaction. Then as the connections become useless, the following messages start coming out. This message I would expect after the pool is exhausted. Error in allocating a connection. Cause: In-use

Re: resultset access error

2009-05-28 Thread Bhaarat Sharma
my stack trace is: org.springframework.jdbc.InvalidResultSetAccessException: SqlMapClient operation; invalid ResultSet access for SQL []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in securityexam.xml. --- The error occurred while executing

Re: resultset access error

2009-05-27 Thread Sundar Sankar
harma wrote: > I am getting the following error: SqlMapClient operation; invalid ResultSet > access for SQL []; nested exceptionCaused by: java.sql.SQLException: > Invalid column index > org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:518) > > All the resul

resultset access error

2009-05-27 Thread Bhaarat Sharma
I am getting the following error: SqlMapClient operation; invalid ResultSet access for SQL []; nested exceptionCaused by: java.sql.SQLException: Invalid column index org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:518) All the resultmappings and parameter mappings are fine

RE: error handling in iBatis?

2009-05-11 Thread Winarto
want. Cheers, Winarto From: Bhaarat Sharma [mailto:bhaara...@gmail.com] Sent: Monday, 11 May 2009 23:27 To: user-java@ibatis.apache.org Subject: error handling in iBatis? we have been using iBatis for a while now. However, we do not perform any error handling while executing the sql maps.

Re: error handling in iBatis?

2009-05-11 Thread Sundar Sankar
have written Unit test for the same and tested out the erroneous cases to make sure of what I was getting! Let us know if it didnt work -Sundar On Mon, May 11, 2009 at 8:26 AM, Bhaarat Sharma wrote: > we have been using iBatis for a while now. > However, we do not perform any error handling

Re: error handling in iBatis?

2009-05-11 Thread Nathan Maves
Sharma wrote: > we have been using iBatis for a while now. > However, we do not perform any error handling while executing the sql maps. > Back when we used java code to connect, we used try and catch blocks. > Where the catch block would log an error message. > > s

error handling in iBatis?

2009-05-11 Thread Bhaarat Sharma
we have been using iBatis for a while now. However, we do not perform any error handling while executing the sql maps. Back when we used java code to connect, we used try and catch blocks. Where the catch block would log an error message. something like this: try

Re: newbie trouble grokking error message

2009-04-30 Thread Sean Mitchell
urns out that it was indeed a mapping issue, but not in the reported file. The error log said the problem was in the source mapping file, but in fact it was in the target mapping file. Case sensitivity issue and user error :) Sean

Re: newbie trouble grokking error message

2009-04-29 Thread Sean Mitchell
On Wed, Apr 29, 2009 at 9:46 AM, Nathan Maves wrote: > This really does look like a mapping issue.  Please include the source code > of the bean and the map that you are using. As I'm new to this company and they are a bit uptight about some things, I'm not sure that I can do that just yet. Wil

  1   2   3   4   5   6   >