JDBCRealm using iBATIS?
Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher
Re: JDBCRealm using iBATIS?
i don't see why you would need to use ibatis for that. If you wanted to you could write a Realm implementation that took advantage of ibatis... but, why? Brandon On Thu, 17 Mar 2005 15:37:03 +, Tim Christopher [EMAIL PROTECTED] wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher
Getting the generate primary key
Hi, I want to get the automatically generated key from a newly inserted row (my oracle database handles the generation of the key via a trigger). I followed the docs but it does not appear to be working. SqlMap: insert id=writeOrder parameterClass=Order INSERT INTO ORDERS(order_price) values(#orderPrice#) /insert Code: Long id = (Long)client.insert(new SqlMapId(writeOrder),order); The returned value is always null. but I want the primary key id. am I doing anything wrong here (using ibatis 2.0.9.496) I'm sure when i tried this on an earlier version if iBatis it was working. Thanks, Steve.
RE: Getting the generate primary key
you need to add the selectKey resultClass=int keyProperty=id select LAST_INSERT_ID() /selectKey above is for mysql just change to olacle specific code. etc steve -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Thu 3/17/2005 3:52 PM To: 'ibatis-user-java@incubator.apache.org' Subject: Getting the generate primary key Hi, I want to get the automatically generated key from a newly inserted row (my oracle database handles the generation of the key via a trigger). I followed the docs but it does not appear to be working. SqlMap: insert id=writeOrder parameterClass=Order INSERT INTO ORDERS(order_price) values(#orderPrice#) /insert Code: Long id = (Long)client.insert(new SqlMapId(writeOrder),order); The returned value is always null. but I want the primary key id. am I doing anything wrong here (using ibatis 2.0.9.496) I'm sure when i tried this on an earlier version if iBatis it was working. Thanks, Steve. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.winmail.dat
RE: Getting the generate primary key
Hi, Thanks James. Anyone know how I can the last generated key from oracle then?? I don't know of any such function. Cheers Steve. -Original Message- From: James, Steven [mailto:[EMAIL PROTECTED] Sent: 17 March 2005 17:03 To: ibatis-user-java@incubator.apache.org Subject: RE: Getting the generate primary key you need to add the selectKey resultClass=int keyProperty=id select LAST_INSERT_ID() /selectKey above is for mysql just change to olacle specific code. etc steve -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Thu 3/17/2005 3:52 PM To: 'ibatis-user-java@incubator.apache.org' Subject: Getting the generate primary key Hi, I want to get the automatically generated key from a newly inserted row (my oracle database handles the generation of the key via a trigger). I followed the docs but it does not appear to be working. SqlMap: insert id=writeOrder parameterClass=Order INSERT INTO ORDERS(order_price) values(#orderPrice#) /insert Code: Long id = (Long)client.insert(new SqlMapId(writeOrder),order); The returned value is always null. but I want the primary key id. am I doing anything wrong here (using ibatis 2.0.9.496) I'm sure when i tried this on an earlier version if iBatis it was working. Thanks, Steve. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
RE: Getting the generate primary key
In Oracle, is that going to be difficult if you're using a trigger to create the ID? Using a select from sequence insure that you have the same ID as the insert statement is going to receive. Using @@identiy and select Last_insert_id() guarantee (I think) that the value returned was the one used by your insert statement. However, in Oracle, you'll have to select the max(id) after the insert and there is no guarantee that you're getting the same id, right? -Original Message- From: James, Steven [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:03 AM To: ibatis-user-java@incubator.apache.org Subject: RE: Getting the generate primary key you need to add the selectKey resultClass=int keyProperty=id select LAST_INSERT_ID() /selectKey above is for mysql just change to olacle specific code. etc steve -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Thu 3/17/2005 3:52 PM To: 'ibatis-user-java@incubator.apache.org' Subject: Getting the generate primary key Hi, I want to get the automatically generated key from a newly inserted row (my oracle database handles the generation of the key via a trigger). I followed the docs but it does not appear to be working. SqlMap: insert id=writeOrder parameterClass=Order INSERT INTO ORDERS(order_price) values(#orderPrice#) /insert Code: Long id = (Long)client.insert(new SqlMapId(writeOrder),order); The returned value is always null. but I want the primary key id. am I doing anything wrong here (using ibatis 2.0.9.496) I'm sure when i tried this on an earlier version if iBatis it was working. Thanks, Steve.
RE: Getting the generate primary key
Yes, that's right. Not a good idea to use max(id) in oracle at all. -Original Message- From: Akins, Greg [mailto:[EMAIL PROTECTED] Sent: 17 March 2005 17:08 To: ibatis-user-java@incubator.apache.org Subject: RE: Getting the generate primary key In Oracle, is that going to be difficult if you're using a trigger to create the ID? Using a select from sequence insure that you have the same ID as the insert statement is going to receive. Using @@identiy and select Last_insert_id() guarantee (I think) that the value returned was the one used by your insert statement. However, in Oracle, you'll have to select the max(id) after the insert and there is no guarantee that you're getting the same id, right? -Original Message- From: James, Steven [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:03 AM To: ibatis-user-java@incubator.apache.org Subject: RE: Getting the generate primary key you need to add the selectKey resultClass=int keyProperty=id select LAST_INSERT_ID() /selectKey above is for mysql just change to olacle specific code. etc steve -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Thu 3/17/2005 3:52 PM To: 'ibatis-user-java@incubator.apache.org' Subject: Getting the generate primary key Hi, I want to get the automatically generated key from a newly inserted row (my oracle database handles the generation of the key via a trigger). I followed the docs but it does not appear to be working. SqlMap: insert id=writeOrder parameterClass=Order INSERT INTO ORDERS(order_price) values(#orderPrice#) /insert Code: Long id = (Long)client.insert(new SqlMapId(writeOrder),order); The returned value is always null. but I want the primary key id. am I doing anything wrong here (using ibatis 2.0.9.496) I'm sure when i tried this on an earlier version if iBatis it was working. Thanks, Steve.
RE: Getting the generate primary key
We have always used the table-driven approach for generating keys (i.e. a database table that provides the next id). I am currently comtemplating moving to identity columns in MS SQL Server and let the database handle the id generation. Any pros and cons (apart from the usual portability concerns) with this approach? Is performance, with SQL Server, acceptable when inserting thousands of rows in this fashion? -Original Message- From: Akins, Greg [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 10:08 AM To: ibatis-user-java@incubator.apache.org Subject: RE: Getting the generate primary key In Oracle, is that going to be difficult if you're using a trigger to create the ID? Using a select from sequence insure that you have the same ID as the insert statement is going to receive. Using @@identiy and select Last_insert_id() guarantee (I think) that the value returned was the one used by your insert statement. However, in Oracle, you'll have to select the max(id) after the insert and there is no guarantee that you're getting the same id, right? -Original Message- From: James, Steven [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:03 AM To: ibatis-user-java@incubator.apache.org Subject: RE: Getting the generate primary key you need to add the selectKey resultClass=int keyProperty=id select LAST_INSERT_ID() /selectKey above is for mysql just change to olacle specific code. etc steve -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Thu 3/17/2005 3:52 PM To: 'ibatis-user-java@incubator.apache.org' Subject: Getting the generate primary key Hi, I want to get the automatically generated key from a newly inserted row (my oracle database handles the generation of the key via a trigger). I followed the docs but it does not appear to be working. SqlMap: insert id=writeOrder parameterClass=Order INSERT INTO ORDERS(order_price) values(#orderPrice#) /insert Code: Long id = (Long)client.insert(new SqlMapId(writeOrder),order); The returned value is always null. but I want the primary key id. am I doing anything wrong here (using ibatis 2.0.9.496) I'm sure when i tried this on an earlier version if iBatis it was working. Thanks, Steve.
Re: JDBCRealm using iBATIS?
Brandon: - ability to potentially switch db connection parameters in onlyone ibatis database.properties file(don't repeat yourself) - ability to changeyour user auth data model in one ibatis XML file instead of potentially multiple web.xml files - wouldn't thisprovide good "inversion of control" / "dependency injection": if the realm implementation itself were configurable, you'd presumably tweak that realm implementation in one place (if, for example, you wanted to temporarily read in user information from an XMLfileduring db maintenance.) Your ibatis realm implementation may be a singleton used by more than one app--and you could get away with configuring thatin only one spot if that's what floats your boat... It seems worthwhile to me--in fact I had already considered doing something like this... But I wasn't using Tomcat at the time. My only reservation is that I would be more likely to develop and use something like this if itwere made to beportable across Java app servers. Agree? Disagree? -Brett Brandon Goodin [EMAIL PROTECTED] wrote: i don't see why you would need to use ibatis for that. If you wantedto you could write a Realm implementation that took advantage ofibatis... but, why?BrandonOn Thu, 17 Mar 2005 15:37:03 +, Tim Christopher<[EMAIL PROTECTED]>wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher
Does Ibatis support Unit of Work like Hibernate
Title: Does Ibatis support Unit of Work like Hibernate Hi, I just want to know if Ibatis supports unit of work instead of requerying the database each time.
Re: Does Ibatis support Unit of Work like Hibernate
iBATIS is not an ORM. So there are a great many differences between it and Hibernate. iBATIS never calls any statements implicitly, nor does it support object identity. So there's no need to track changes on objects. Cheers, Clinton On Thu, 17 Mar 2005 11:48:18 -0500, Jason Hall [EMAIL PROTECTED] wrote: Hi, I just want to know if Ibatis supports unit of work instead of requerying the database each time.
Re: JDBCRealm using iBATIS?
FWIW, I recently switched from using container-managed security (i.e. JDBCRealm in Tomcat) to using Acegi Security and it's working great so far. Not only is it portable between app servers, but it allows you to easily plugin in your own authentication provider. Matt On Mar 17, 2005, at 8:24 AM, Brett Gorres wrote: Brandon: - ability to potentially switch db connection parameters in only one ibatis database.properties file (don't repeat yourself) - ability to change your user auth data model in one ibatis XML file instead of potentially multiple web.xml files - wouldn't this provide good inversion of control / dependency injection: if the realm implementation itself were configurable, you'd presumably tweak that realm implementation in one place (if, for example, you wanted to temporarily read in user information from an XML file during db maintenance.) Your ibatis realm implementation may be a singleton used by more than one app--and you could get away with configuring that in only one spot if that's what floats your boat... It seems worthwhile to me--in fact I had already considered doing something like this... But I wasn't using Tomcat at the time. My only reservation is that I would be more likely to develop and use something like this if it were made to be portable across Java app servers. Agree? Disagree? -Brett Brandon Goodin [EMAIL PROTECTED] wrote: i don't see why you would need to use ibatis for that. If you wanted to you could write a Realm implementation that took advantage of ibatis... but, why? Brandon On Thu, 17 Mar 2005 15:37:03 +, Tim Christopher wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher
Re: JDBCRealm using iBATIS?
Is Acegi Security tied to Spring's WebMVC? On Thu, 17 Mar 2005 09:03:15 -0800, Matt Raible [EMAIL PROTECTED] wrote: FWIW, I recently switched from using container-managed security (i.e. JDBCRealm in Tomcat) to using Acegi Security and it's working great so far. Not only is it portable between app servers, but it allows you to easily plugin in your own authentication provider. Matt On Mar 17, 2005, at 8:24 AM, Brett Gorres wrote: Brandon: - ability to potentially switch db connection parameters in only one ibatis database.properties file (don't repeat yourself) - ability to change your user auth data model in one ibatis XML file instead of potentially multiple web.xml files - wouldn't this provide good inversion of control / dependency injection: if the realm implementation itself were configurable, you'd presumably tweak that realm implementation in one place (if, for example, you wanted to temporarily read in user information from an XML file during db maintenance.) Your ibatis realm implementation may be a singleton used by more than one app--and you could get away with configuring that in only one spot if that's what floats your boat... It seems worthwhile to me--in fact I had already considered doing something like this... But I wasn't using Tomcat at the time. My only reservation is that I would be more likely to develop and use something like this if it were made to be portable across Java app servers. Agree? Disagree? -Brett Brandon Goodin [EMAIL PROTECTED] wrote: i don't see why you would need to use ibatis for that. If you wanted to you could write a Realm implementation that took advantage of ibatis... but, why? Brandon On Thu, 17 Mar 2005 15:37:03 +, Tim Christopher wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher
Re: JDBCRealm using iBATIS?
No, you can use with or without. You are tied to using Spring IoC though. Acegi'ss rather good IMHO, if a little daunting to set up first time. :-) Kris Is Acegi Security tied to Spring's WebMVC? On Thu, 17 Mar 2005 09:03:15 -0800, Matt Raible [EMAIL PROTECTED] wrote: FWIW, I recently switched from using container-managed security (i.e. JDBCRealm in Tomcat) to using Acegi Security and it's working great so far. Not only is it portable between app servers, but it allows you to easily plugin in your own authentication provider. Matt On Mar 17, 2005, at 8:24 AM, Brett Gorres wrote: Brandon: - ability to potentially switch db connection parameters in only one ibatis database.properties file (don't repeat yourself) - ability to change your user auth data model in one ibatis XML file instead of potentially multiple web.xml files - wouldn't this provide good inversion of control / dependency injection: if the realm implementation itself were configurable, you'd presumably tweak that realm implementation in one place (if, for example, you wanted to temporarily read in user information from an XML file during db maintenance.) Your ibatis realm implementation may be a singleton used by more than one app--and you could get away with configuring that in only one spot if that's what floats your boat... It seems worthwhile to me--in fact I had already considered doing something like this... But I wasn't using Tomcat at the time. My only reservation is that I would be more likely to develop and use something like this if it were made to be portable across Java app servers. Agree? Disagree? -Brett Brandon Goodin [EMAIL PROTECTED] wrote: i don't see why you would need to use ibatis for that. If you wanted to you could write a Realm implementation that took advantage of ibatis... but, why? Brandon On Thu, 17 Mar 2005 15:37:03 +, Tim Christopher wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher -- Kris Jenkins Email: [EMAIL PROTECTED] Blog: http://cafe.jenkster.com/ Wiki: http://wiki.jenkster.com/
Re: Advice sought: Designing cached User Session objects
Hi Clinton, (Thanks for commenting - really appreciated.) Is your suggestion that we'd rather interface with OSCache directly (and separately) instead of relying on the integrated iBatis approach? Can you briefly explain how that would afford us better performance instead? (To be honest, I'd feel more comfortable :) to stick with the existing integrated architecture of iBatis' caching!) Also, we had prototyped a hack in a 1.3.x release of iBatis where we modified iBatis code to mutate the cached object directly (I recall asking whether a public API could be made available ...). That hack seemed to work, but the project never really got off the ground and so we couldn't test it in controlled environment. Would that approach not be advisable to take with the latest version of iBatis? Thanks once again for your assistance, Kind regards, Abdullah Clinton Begin wrote: I would suggest you don't use the iBATIS cache and instead write your own. It's been proven to me numerous times that an application (i.e. business domain) level cache cannot be beaten in terms of performance. This is especially true considering your complex requirements. Alternatively, you could try taking one of the open source caches (OSCache, EHCache) or even a commercial one (Tangosol Coherence) and modify it or extend it to your needs. Cheers, Clinton
MS SQL Server 2000 connection reset problem
Title: Message I'm using Ibatis 2 with a web app and I get the following error after connecting to the data source and then letting it sit for 2 minutes and then retrying my web applicaiton. ERROR:2005-03-17 10:35:57,379 - Failed to queryForList - id [getUsers], parameterObject [null]. Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error Here's my sql map config: transactionManager type="JDBC" dataSource type="DBCP" property name="JDBC.Driver" value="${driver}"/ property name="JDBC.ConnectionURL" value="${url}"/ property name="JDBC.Username" value="${username}"/ property name="JDBC.Password" value="${password}"/ property name="JDBC.DefaultAutoCommit" value="true"/ property name="Pool.MaximumActiveConnections" value="20"/ property name="Pool.MaximumIdleConnections" value="5"/ property name="Pool.MaximumWait" value="12"/ property name="Pool.TimeToWait" value="500"/ property name="Pool.PingQuery" value="select 1 from BBEXTRACT.USERS"/ property name="Pool.PingEnabled" value="true"/ property name="Pool.PingConnectionsOlderThan" value="1"/ property name="Pool.PingConnectionsNotUsedFor" value="1"/ /dataSource /transactionManager Thanks, Brent Ryan Don't miss the 2005 Blackboard Users Conference April 12-14 in Baltimore, MD! Visit http://www.blackboard.com/about/events/BbUC05/index.htm for more information. This e-mail is intended only for the personal and confidential use of the recipient(s) named above. It may include Blackboard confidential and proprietary information, and is not for redistribution.
Re:
Yes, I found the problem and pointed to the right DTD but still get the error saying There is no statement named insertRow in this SqlMap Wen can we get this sort of an error? I know maybe it's a silly mistake on my end, but am really lost on it.. Hope to get some help. Thanks --- Clinton Begin [EMAIL PROTECTED] wrote: now it looks like your DTD is missing or incorrect (make sure you're using the right DTD for the right kind of file). Clinton On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Well, I did solve this problem by copying all the DTDs from the web. I am able to get the instance of DAO through the DAOManager. But what is weird is, that in my file which contains the queries, if I have something like: mapped-statement name=insertRow INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /mapped-statement However, this throws an error: I am in InsertDAO and error is:There is no statement named insertRow in this SqlMap. Whereas if I have the query as insert id=insertRow parameter=Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /insert I get an error : Error in DAOConfig:com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. --- Clinton Begin [EMAIL PROTECTED] wrote: It looks like your XML parser is trying to validate the DTD using the server (www.ibatis.com/dtd). There may be firewall issues in your environment that prevent this from working. iBATIS is configured to validate from the JAR file, but some parsers (I wish I knew which ones) don't seem to support EntityResolvers. So the solution for you might be to download the DTDs with your browser (or just grab them from the JAR), and then use a file:///usr/local/ibatis/dtd path or something like that. Cheers, Clinton On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I was able to fix that. But now I am getting this error: Error in DAOConfig:Error while configuring DaoManager. Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by:
Re:
Yes, I found the problem and pointed to the right DTD but still get the error saying There is no statement named insertRow in this SqlMap Wen can we get this sort of an error? I know maybe it's a silly mistake on my end, but am really lost on it.. Hope to get some help. Thanks --- Clinton Begin [EMAIL PROTECTED] wrote: now it looks like your DTD is missing or incorrect (make sure you're using the right DTD for the right kind of file). Clinton On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Well, I did solve this problem by copying all the DTDs from the web. I am able to get the instance of DAO through the DAOManager. But what is weird is, that in my file which contains the queries, if I have something like: mapped-statement name=insertRow INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /mapped-statement However, this throws an error: I am in InsertDAO and error is:There is no statement named insertRow in this SqlMap. Whereas if I have the query as insert id=insertRow parameter=Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /insert I get an error : Error in DAOConfig:com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. --- Clinton Begin [EMAIL PROTECTED] wrote: It looks like your XML parser is trying to validate the DTD using the server (www.ibatis.com/dtd). There may be firewall issues in your environment that prevent this from working. iBATIS is configured to validate from the JAR file, but some parsers (I wish I knew which ones) don't seem to support EntityResolvers. So the solution for you might be to download the DTDs with your browser (or just grab them from the JAR), and then use a file:///usr/local/ibatis/dtd path or something like that. Cheers, Clinton On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I was able to fix that. But now I am getting this error: Error in DAOConfig:Error while configuring DaoManager. Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by:
Re:
Yes, I found the problem and pointed to the right DTD but still get the error saying There is no statement named insertRow in this SqlMap I know maybe it's a silly mistake on my end, but am really lost on it.. Hope to get some help. Thanks --- Clinton Begin [EMAIL PROTECTED] wrote: now it looks like your DTD is missing or incorrect (make sure you're using the right DTD for the right kind of file). Clinton On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Well, I did solve this problem by copying all the DTDs from the web. I am able to get the instance of DAO through the DAOManager. But what is weird is, that in my file which contains the queries, if I have something like: mapped-statement name=insertRow INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /mapped-statement However, this throws an error: I am in InsertDAO and error is:There is no statement named insertRow in this SqlMap. Whereas if I have the query as insert id=insertRow parameter=Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /insert I get an error : Error in DAOConfig:com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. --- Clinton Begin [EMAIL PROTECTED] wrote: It looks like your XML parser is trying to validate the DTD using the server (www.ibatis.com/dtd). There may be firewall issues in your environment that prevent this from working. iBATIS is configured to validate from the JAR file, but some parsers (I wish I knew which ones) don't seem to support EntityResolvers. So the solution for you might be to download the DTDs with your browser (or just grab them from the JAR), and then use a file:///usr/local/ibatis/dtd path or something like that. Cheers, Clinton On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I was able to fix that. But now I am getting this error: Error in DAOConfig:Error while configuring DaoManager. Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
Re:
Yes, I found the problem and pointed to the right DTD but still get the error saying There is no statement named insertRow in this SqlMap I know maybe it's a silly mistake on my end, but am really lost on it.. Hope to get some help. Thanks --- Clinton Begin [EMAIL PROTECTED] wrote: now it looks like your DTD is missing or incorrect (make sure you're using the right DTD for the right kind of file). Clinton On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Well, I did solve this problem by copying all the DTDs from the web. I am able to get the instance of DAO through the DAOManager. But what is weird is, that in my file which contains the queries, if I have something like: mapped-statement name=insertRow INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /mapped-statement However, this throws an error: I am in InsertDAO and error is:There is no statement named insertRow in this SqlMap. Whereas if I have the query as insert id=insertRow parameter=Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /insert I get an error : Error in DAOConfig:com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. --- Clinton Begin [EMAIL PROTECTED] wrote: It looks like your XML parser is trying to validate the DTD using the server (www.ibatis.com/dtd). There may be firewall issues in your environment that prevent this from working. iBATIS is configured to validate from the JAR file, but some parsers (I wish I knew which ones) don't seem to support EntityResolvers. So the solution for you might be to download the DTDs with your browser (or just grab them from the JAR), and then use a file:///usr/local/ibatis/dtd path or something like that. Cheers, Clinton On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I was able to fix that. But now I am getting this error: Error in DAOConfig:Error while configuring DaoManager. Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
Re:
Yes, I found the problem and pointed to the right DTD but still get the error saying There is no statement named insertRow in this SqlMap I know maybe it's a silly mistake on my end, but am really lost on it.. Hope to get some help. Thanks --- Clinton Begin [EMAIL PROTECTED] wrote: now it looks like your DTD is missing or incorrect (make sure you're using the right DTD for the right kind of file). Clinton On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Well, I did solve this problem by copying all the DTDs from the web. I am able to get the instance of DAO through the DAOManager. But what is weird is, that in my file which contains the queries, if I have something like: mapped-statement name=insertRow INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /mapped-statement However, this throws an error: I am in InsertDAO and error is:There is no statement named insertRow in this SqlMap. Whereas if I have the query as insert id=insertRow parameter=Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /insert I get an error : Error in DAOConfig:com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. --- Clinton Begin [EMAIL PROTECTED] wrote: It looks like your XML parser is trying to validate the DTD using the server (www.ibatis.com/dtd). There may be firewall issues in your environment that prevent this from working. iBATIS is configured to validate from the JAR file, but some parsers (I wish I knew which ones) don't seem to support EntityResolvers. So the solution for you might be to download the DTDs with your browser (or just grab them from the JAR), and then use a file:///usr/local/ibatis/dtd path or something like that. Cheers, Clinton On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I was able to fix that. But now I am getting this error: Error in DAOConfig:Error while configuring DaoManager. Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
Sorry
Sorry for flooding everyone's mailbox with 6 mails, got a page not found error on submitting the email and so did it so many times without realizing that it actually did get posted. --- Swati Singhal [EMAIL PROTECTED] wrote: Yes, I found the problem and pointed to the right DTD but still get the error saying There is no statement named insertRow in this SqlMap Wen can we get this sort of an error? I know maybe it's a silly mistake on my end, but am really lost on it.. Hope to get some help. Thanks --- Clinton Begin [EMAIL PROTECTED] wrote: now it looks like your DTD is missing or incorrect (make sure you're using the right DTD for the right kind of file). Clinton On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Well, I did solve this problem by copying all the DTDs from the web. I am able to get the instance of DAO through the DAOManager. But what is weird is, that in my file which contains the queries, if I have something like: mapped-statement name=insertRow INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /mapped-statement However, this throws an error: I am in InsertDAO and error is:There is no statement named insertRow in this SqlMap. Whereas if I have the query as insert id=insertRow parameter=Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /insert I get an error : Error in DAOConfig:com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. --- Clinton Begin [EMAIL PROTECTED] wrote: It looks like your XML parser is trying to validate the DTD using the server (www.ibatis.com/dtd). There may be firewall issues in your environment that prevent this from working. iBATIS is configured to validate from the JAR file, but some parsers (I wish I knew which ones) don't seem to support EntityResolvers. So the solution for you might be to download the DTDs with your browser (or just grab them from the JAR), and then use a file:///usr/local/ibatis/dtd path or something like that. Cheers, Clinton On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I was able to fix that. But now I am getting this error: Error in DAOConfig:Error while configuring DaoManager. Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: === message truncated === __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best
Sorry
Sorry for flooding everyone's mailbox with 6 mails, got a page not found error on submitting the email and so did it so many times without realizing that it actually did get posted. --- Swati Singhal [EMAIL PROTECTED] wrote: Yes, I found the problem and pointed to the right DTD but still get the error saying There is no statement named insertRow in this SqlMap Wen can we get this sort of an error? I know maybe it's a silly mistake on my end, but am really lost on it.. Hope to get some help. Thanks --- Clinton Begin [EMAIL PROTECTED] wrote: now it looks like your DTD is missing or incorrect (make sure you're using the right DTD for the right kind of file). Clinton On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Well, I did solve this problem by copying all the DTDs from the web. I am able to get the instance of DAO through the DAOManager. But what is weird is, that in my file which contains the queries, if I have something like: mapped-statement name=insertRow INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /mapped-statement However, this throws an error: I am in InsertDAO and error is:There is no statement named insertRow in this SqlMap. Whereas if I have the query as insert id=insertRow parameter=Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#sProcessedInd#, #createdDate#, #processedDate#, #sRow#) /insert I get an error : Error in DAOConfig:com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type insert must be declared. Caused by: org.xml.sax.SAXParseException: Element type insert must be declared. --- Clinton Begin [EMAIL PROTECTED] wrote: It looks like your XML parser is trying to validate the DTD using the server (www.ibatis.com/dtd). There may be firewall issues in your environment that prevent this from working. iBATIS is configured to validate from the JAR file, but some parsers (I wish I knew which ones) don't seem to support EntityResolvers. So the solution for you might be to download the DTDs with your browser (or just grab them from the JAR), and then use a file:///usr/local/ibatis/dtd path or something like that. Cheers, Clinton On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I was able to fix that. But now I am getting this error: Error in DAOConfig:Error while configuring DaoManager. Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ConnectException: Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: === message truncated === __ Do you Yahoo!? Make Yahoo! your home page
Re: MS SQL Server 2000 connection reset problem
Some guesses: * If you are using transactions, make sure you are commiting/rolling back the transactions. * Perhaps connection pool is not working and the number of server connection hits maximum: check sql server connection property, set Maximum Allowable Connection to zero (0) = no maximum. * Do sp_who on the server to see number of concurrent connections * Do netstat -n to see live TCP/IP connection on the client (many connections for a single user is telltale sign of leaky connection objects) HTH, Abdullah Brent Ryan wrote: Message I'm using Ibatis 2 with a web app and I get the following error after connecting to the data source and then letting it sit for 2 minutes and then retrying my web applicaiton. ERROR:2005-03-17 10:35:57,379 - Failed to queryForList - id [getUsers], parameterObject [null]. Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error Here's my sql map config: transactionManager type=JDBC dataSource type=DBCP property name=JDBC.Driver value=${driver}/ property name=JDBC.ConnectionURL value=${url}/ property name=JDBC.Username value=${username}/ property name=JDBC.Password value=${password}/ property name=JDBC.DefaultAutoCommit value=true/ property name=Pool.MaximumActiveConnections value=20/ property name=Pool.MaximumIdleConnections value=5/ property name=Pool.MaximumWait value=12/ property name=Pool.TimeToWait value=500/ property name=Pool.PingQuery value=select 1 from BBEXTRACT.USERS/ property name=Pool.PingEnabled value=true/ property name=Pool.PingConnectionsOlderThan value=1/ property name=Pool.PingConnectionsNotUsedFor value=1/ /dataSource /transactionManager Thanks, !-- A.psl { TEXT-DECORATION: none; COLOR: #4e81c4; FONT-FAMILY: Verdana,Arial,fixed } A:hover { TEXT-DECORATION: underline } A.psl:hover { COLOR: #99 } .noro { FONT-SIZE: 8pt; COLOR: #4e81c4; FONT-FAMILY: Verdana,Arial,fixed } .logotext { TEXT-DECORATION:none; FONT-SIZE: 10pt; FONT-FAMILY: Verdana,Arial,fixed } A.brand { COLOR: #77; FONT-SIZE: 7pt; FONT-FAMILY: Verdana,Arial,fixed; TEXT-DECORATION: none } -- Brent Ryan *Don't miss the 2005 Blackboard Users Conference April 12-14 in Baltimore, MD! Visit **http://www.blackboard.com/about/events/BbUC05/index.htm** for more information.* This e-mail is intended only for the personal and confidential use of the recipient(s) named above. It may include Blackboard confidential and proprietary information, and is not for redistribution.
Re: DTD not resolving
Please send all support requests to the user list. The DTDs are there and iBATIS.com is responding. http://www.ibatis.com/dtd/sql-map-config-2.dtd http://www.ibatis.com/dtd/sql-map-2.dtd You might be behind a firewall or http proxy that WSAD can't access the site through. The DTDs are normally resolved from the JAR file, but depending on your XML parser (during runtime) and/or your IDE (during development), your environment may not allow for this. Your option is to use a file:// based URL to the DTD. Clinton On Thu, 17 Mar 2005 13:12:41 -0500, Darren Shopbell [EMAIL PROTECTED] wrote: Clinton - im using this doctype in my map however i am getting : unable to connect to host: www.ibatis.com error thoughts? Im using WSAD 5.1 JRE 1.3.13 !DOCTYPE sqlMapConfig PUBLIC -//iBATIS.com//DTD SQL Map Config 2.0//EN http://www.ibatis.com/dtd/sql-map-config-2.dtd; Darren Shopbell - D 123/B503, RTP, NC IBM TEST - http://test.ibm.com voice mail: (919) 254-6796, IBM tie line: 444-6796 Internet: [EMAIL PROTECTED]
Ibatis vs Jaxor
Title: Ibatis vs Jaxor Hi, I was just reading up on Jaxor, similar to ibatis using a xml mapping technique and traditional SQL queries. But it provides more, like unit of work, identity, etc. It seems intrieging. What's significantly better in ibatis than Jaxor? Thanks:) Jason Hall
Re: MS SQL Server 2000 connection reset problem
Brent Ryan wrote: For some reason the datasource isn't running the ping command to check the connections. They seem to be timing out. Is there a setting in SQL Server that causes connections to timeout? What version of SQL Server are you using?
Re: MS SQL Server 2000 connection reset problem
Brent Ryan wrote: * The commiting/rolling back is handled by the datasource automatically. * The max allowable connection is set to 0 * netstat -n on client and server show 3 connections established. If I set this property to 0 then it works, but then this means there is nothing in the pool. Right? property name=Pool.MaximumIdleConnections value=0/ Also, can you post the SQL statement?
Re: DTD not resolving
This does look like WSAD's error message related to proxy access. Make sure you've set the proxy in WSAD's preference pages (WindowPreferencesInternet) Jeff Butler [EMAIL PROTECTED] 3/17/2005 12:16:42 PM Please send all support requests to the user list. The DTDs are there and iBATIS.com is responding. http://www.ibatis.com/dtd/sql-map-config-2.dtd http://www.ibatis.com/dtd/sql-map-2.dtd You might be behind a firewall or http proxy that WSAD can't access the site through. The DTDs are normally resolved from the JAR file, but depending on your XML parser (during runtime) and/or your IDE (during development), your environment may not allow for this. Your option is to use a file:// based URL to the DTD. Clinton On Thu, 17 Mar 2005 13:12:41 -0500, Darren Shopbell [EMAIL PROTECTED] wrote: Clinton - im using this doctype in my map however i am getting : unable to connect to host: www.ibatis.com error thoughts? Im using WSAD 5.1 JRE 1.3.13 !DOCTYPE sqlMapConfig PUBLIC -//iBATIS.com//DTD SQL Map Config 2.0//EN http://www.ibatis.com/dtd/sql-map-config-2.dtd; Darren Shopbell - D 123/B503, RTP, NC IBM TEST - http://test.ibm.com voice mail: (919) 254-6796, IBM tie line: 444-6796 Internet: [EMAIL PROTECTED]
Re: Ibatis vs Jaxor
I don't know that I'd ever try to say any framework is significantly better than another. Each one will fit a particular need better. Jaxor is an ORM. iBATIS is not. If you want to compare Jaxor to something, you're likely to have more success comparing it to Hibernate. Cheers, Clinton On Thu, 17 Mar 2005 13:19:22 -0500, Jason Hall [EMAIL PROTECTED] wrote: Hi, I was just reading up on Jaxor, similar to ibatis using a xml mapping technique and traditional SQL queries. But it provides more, like unit of work, identity, etc. It seems intrieging. What's significantly better in ibatis than Jaxor? Thanks:) Jason Hall
Re: Ibatis vs Jaxor
It's actually a code generator, much like Torque. So perhaps even comparing it to Hibernate would not be appropriate. Clinton On Thu, 17 Mar 2005 11:32:07 -0700, Brandon Goodin [EMAIL PROTECTED] wrote: Jaxor still funcitons with the mindset of mapping table - objects and querying the mappings. IBatis maps SQL to objects not Tables to Objects. Also, i am very suspect of their sql support. I'm not certain it is true SQL. It looks as though it may use SQL constructs yet it is not the actual sql that reaches your database. I may be wrong. Also, jaxor does not abstract it's sql from the java class. It only abstracts the mapping to entity objects from the java class. That's just a quick overview of what i saw. I'd be interested to hear what others have to say. Brandon On Thu, 17 Mar 2005 13:19:22 -0500, Jason Hall [EMAIL PROTECTED] wrote: Hi, I was just reading up on Jaxor, similar to ibatis using a xml mapping technique and traditional SQL queries. But it provides more, like unit of work, identity, etc. It seems intrieging. What's significantly better in ibatis than Jaxor? Thanks:) Jason Hall
Re: MS SQL Server 2000 connection reset problem
Hi Brent, I think your best bet would be to talk to the folks at the JDBC forum on the Microsoft newsgroups. I've had a terrible week with SQL Server too. :) Sorry I couldn't be of further help, Abdullah Brent Ryan wrote: I'm running SQL Server 2000 8.00.760. The connection reset problem happens for any sql statement, but the ones that I'm testing are: select id=getUsers resultMap=userResult select * from BBEXTRACT.USERS /select select id=getRoles resultMap=roleResult select * from BBEXTRACT.ROLES /select I never had this problem when connection to a Oracle DB. This only happens when connecting to MS SQL Server. Brent Ryan -Original Message- From: Abdullah Kauchali [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:22 AM To: ibatis-user-java@incubator.apache.org Subject: Re: MS SQL Server 2000 connection reset problem Brent Ryan wrote: * The commiting/rolling back is handled by the datasource automatically. * The max allowable connection is set to 0 * netstat -n on client and server show 3 connections established. If I set this property to 0 then it works, but then this means there is nothing in the pool. Right? property name=Pool.MaximumIdleConnections value=0/ Also, can you post the SQL statement? Don't miss the 2005 Blackboard Users Conference April 12-14 in Baltimore, MD! Visit http://www.blackboard.com/about/events/BbUC05/index.htm for more information. This e-mail is intended only for the personal and confidential use of the recipient(s) named above. It may include Blackboard confidential and proprietary information, and is not for redistribution.
Re: JDBCRealm using iBATIS?
Thanks for the tips guys. I've read Matt's blog in the past and tried out appfuse--I think it was based on his recommendation that I bought a certain Wiley o.s. Java book. So must try Acegi now. Bummer about 1st time setup. I am capable but it's a pet peeve. For similar reasons I have migrated all my important work to OS X. I don't like gratuitous busy work and/or config files, or vendor lock-in!! My experience w/ IoC frameworks for production use has been limited to picocontainer. Haven't fully grasped how I would leverage Spring as opposed to the way I do things without it, but perhaps in time... Does anyone know enough to recommend the (new?) apress Spring book? As I recall, there may be a section on Spring in the aforementioned Wiley book, but I haven't taken time to work through it. Maybe it's just me, but the less crazy configuration I have to do to get my HelloCrazyWorld applications going, the more likely I will get comfortable with said framework(s). So much more so if someone like Matt or Clinton puts together war/ear files or decent documentation as they have done. I have always appreciated that... -Brett --- Matt Raible [EMAIL PROTECTED] wrote: On Mar 17, 2005, at 9:40 AM, Kris Jenkins wrote: No, you can use with or without. You are tied to using Spring IoC though. Acegi'ss rather good IMHO, if a little daunting to set up first time. :-) I definitely agree about the setup. I put together a howto for AppFuse, and was able to migrate almost everything from CMA to Acegi w/o changing any code. http://raibledesigns.com/wiki/Wiki.jsp?page=AppFuseAuthentication I hope to add a short how to for going back to CMA in the next few weeks. Matt Kris Is Acegi Security tied to Spring's WebMVC? On Thu, 17 Mar 2005 09:03:15 -0800, Matt Raible [EMAIL PROTECTED] wrote: FWIW, I recently switched from using container-managed security (i.e. JDBCRealm in Tomcat) to using Acegi Security and it's working great so far. Not only is it portable between app servers, but it allows you to easily plugin in your own authentication provider. Matt On Mar 17, 2005, at 8:24 AM, Brett Gorres wrote: Brandon: - ability to potentially switch db connection parameters in only one ibatis database.properties file (don't repeat yourself) - ability to change your user auth data model in one ibatis XML file instead of potentially multiple web.xml files - wouldn't this provide good inversion of control / dependency injection: if the realm implementation itself were configurable, you'd presumably tweak that realm implementation in one place (if, for example, you wanted to temporarily read in user information from an XML file during db maintenance.) Your ibatis realm implementation may be a singleton used by more than one app--and you could get away with configuring that in only one spot if that's what floats your boat... It seems worthwhile to me--in fact I had already considered doing something like this... But I wasn't using Tomcat at the time. My only reservation is that I would be more likely to develop and use something like this if it were made to be portable across Java app servers. Agree? Disagree? -Brett Brandon Goodin [EMAIL PROTECTED] wrote: i don't see why you would need to use ibatis for that. If you wanted to you could write a Realm implementation that took advantage of ibatis... but, why? Brandon On Thu, 17 Mar 2005 15:37:03 +, Tim Christopher wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher -- Kris Jenkins Email: [EMAIL PROTECTED] Blog: http://cafe.jenkster.com/ Wiki: http://wiki.jenkster.com/
Re: JDBCRealm using iBATIS?
On Mar 17, 2005, at 10:47 AM, Brett Gorres wrote: Does anyone know enough to recommend the (new?) apress Spring book? As I recall, there may be a section on Spring in the aforementioned Wiley book, but I haven't taken time to work through it. Sorry, you gave me quite an opportunity to plug Spring Live (www.springlive.com). It has lots of code samples, is updated monthly and will have a new chapter published on Acegi at the end of this month. Of course, it shows how to use iBATIS with Spring too. ;-) Matt
RE: JDBCRealm using iBATIS?
Hi Matt, I am reading your webframeworks presentation and I liked your cons for struts - mailing list volume is overwhelming. Some of us like that. Thanks for the presentation. -Original Message- From: Matt Raible [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:26 AM To: ibatis-user-java@incubator.apache.org Subject: Re: JDBCRealm using iBATIS? On Mar 17, 2005, at 10:47 AM, Brett Gorres wrote: Does anyone know enough to recommend the (new?) apress Spring book? As I recall, there may be a section on Spring in the aforementioned Wiley book, but I haven't taken time to work through it. Sorry, you gave me quite an opportunity to plug Spring Live (www.springlive.com). It has lots of code samples, is updated monthly and will have a new chapter published on Acegi at the end of this month. Of course, it shows how to use iBATIS with Spring too. ;-) Matt
Re: JDBCRealm using iBATIS?
The new apress book 'Pro Spring' is excellent. It also has good coverage of iBATIS. I have'nt had a chance to look at Matt's book, but if his blogs are any indication, it should be an good one too. - Original Message - From: Brett Gorres [EMAIL PROTECTED] To: ibatis-user-java@incubator.apache.org Subject: Re: JDBCRealm using iBATIS? Date: Thu, 17 Mar 2005 10:47:28 -0800 (PST) Thanks for the tips guys. I've read Matt's blog in the past and tried out appfuse--I think it was based on his recommendation that I bought a certain Wiley o.s. Java book. So must try Acegi now. Bummer about 1st time setup. I am capable but it's a pet peeve. For similar reasons I have migrated all my important work to OS X. I don't like gratuitous busy work and/or config files, or vendor lock-in!! My experience w/ IoC frameworks for production use has been limited to picocontainer. Haven't fully grasped how I would leverage Spring as opposed to the way I do things without it, but perhaps in time... Does anyone know enough to recommend the (new?) apress Spring book? As I recall, there may be a section on Spring in the aforementioned Wiley book, but I haven't taken time to work through it. Maybe it's just me, but the less crazy configuration I have to do to get my HelloCrazyWorld applications going, the more likely I will get comfortable with said framework(s). So much more so if someone like Matt or Clinton puts together war/ear files or decent documentation as they have done. I have always appreciated that... -Brett --- Matt Raible [EMAIL PROTECTED] wrote: On Mar 17, 2005, at 9:40 AM, Kris Jenkins wrote: No, you can use with or without. You are tied to using Spring IoC though. Acegi'ss rather good IMHO, if a little daunting to set up first time. :-) I definitely agree about the setup. I put together a howto for AppFuse, and was able to migrate almost everything from CMA to Acegi w/o changing any code. http://raibledesigns.com/wiki/Wiki.jsp?page=AppFuseAuthentication I hope to add a short how to for going back to CMA in the next few weeks. Matt Kris Is Acegi Security tied to Spring's WebMVC? On Thu, 17 Mar 2005 09:03:15 -0800, Matt Raible [EMAIL PROTECTED] wrote: FWIW, I recently switched from using container-managed security (i.e. JDBCRealm in Tomcat) to using Acegi Security and it's working great so far. Not only is it portable between app servers, but it allows you to easily plugin in your own authentication provider. Matt On Mar 17, 2005, at 8:24 AM, Brett Gorres wrote: Brandon: - ability to potentially switch db connection parameters in only one ibatis database.properties file (don't repeat yourself) - ability to change your user auth data model in one ibatis XML file instead of potentially multiple web.xml files - wouldn't this provide good inversion of control / dependency injection: if the realm implementation itself were configurable, you'd presumably tweak that realm implementation in one place (if, for example, you wanted to temporarily read in user information from an XML file during db maintenance.) Your ibatis realm implementation may be a singleton used by more than one app--and you could get away with configuring that in only one spot if that's what floats your boat... It seems worthwhile to me--in fact I had already considered doing something like this... But I wasn't using Tomcat at the time. My only reservation is that I would be more likely to develop and use something like this if it were made to be portable across Java app servers. Agree? Disagree? -Brett Brandon Goodin [EMAIL PROTECTED] wrote: i don't see why you would need to use ibatis for that. If you wanted to you could write a Realm implementation that took advantage of ibatis... but, why? Brandon On Thu, 17 Mar 2005 15:37:03 +, Tim Christopher wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher -- Kris Jenkins Email: [EMAIL PROTECTED] Blog: http://cafe.jenkster.com/ Wiki: http://wiki.jenkster.com/ Antony Joseph http://www.logicden.com https://workeffort.dev.java.net -- ___ NEW! Lycos Dating Search. The only place to search multiple dating sites at once. http://datingsearch.lycos.com
Groundbreaking favicon.ico Theory, Re: Ibatis vs Jaxor
Can you judge a book by its cover? Maybe a favicon.ico tells you all you need to know about Ibatis vs Jaxor... (see attached PNG or references below.) My preliminary findings: - the iBATIS icon is larger - the iBATIS icon is more flexible (it can be used in both largeand small contexts)- the Jaxor icon is leaner(and looks to be more aerodynamic) but I'm not sure if it is also meaner. (I'm not gonna mess with thatiBATIS icon! Ouch!) - they are both pretty cool looking. - at that 16 x 16 resolution, Jaxor requires a closer look. (both of you icons: what the heck are you, anyway?) Youmay bethinking, "Not very scientific." Someone pls feel free to examine the ico files more closely... I think I'm on to something. (What software was used to create each of them? I am over budget now.) Here is my favicon.ico theory in its simplest form: "You can tell a lot about someone by the favicon.ico file in their root directory." There I said it. Probably could have sold this concept to Jakob Nielson, but I choose to open source it. Anyone want to co-author that favicon book with me? : ) -Brett References: http://jaxor.sourceforge.net/favicon.ico http://www.ibatis.com/favicon.ico Clinton Begin [EMAIL PROTECTED] wrote: It's actually a code generator, much like Torque. So perhaps evencomparing it to Hibernate would not be appropriate.ClintonOn Thu, 17 Mar 2005 11:32:07 -0700, Brandon Goodin<[EMAIL PROTECTED]>wrote: Jaxor still funcitons with the mindset of mapping table - objects and querying the mappings. IBatis maps SQL to objects not Tables to Objects. Also, i am very suspect of their sql support. I'm not certain it is true SQL. It looks as though it may use SQL constructs yet it is not the actual sql that reaches your database. I may be wrong. Also, jaxor does not abstract it's sql from the java class. It only abstracts the mapping to entity objects from the java class. That's just a quick overview of what i saw. I'd be interested to hear what others have to say. Brandon On Thu, 17 Mar 2005 13:19:22 -0500, Jason Hall <[EMAIL PROTECTED]>wrote:Hi, I was just reading up on Jaxor, similar to ibatis using a xml mapping technique and traditional SQL queries. But it provides more, like "unit of work", identity, etc. It seems intrieging. What's significantly better in ibatis than Jaxor?Thanks:) Jason Hallinline: ibatis-vs-jaxor-icons.png
Re: Groundbreaking favicon.ico Theory, Re: Ibatis vs Jaxor
Good catch jaaron, but that may go even further to prove my theory! i.e., why didn't Jaxor make their own icon? On the other hand, leveraging the fine work of drupal may show excellent judgement. At any rate, I'm learning about some neat projects here today! Sorry if I wasted anyone's time! Regards, -Brett or maybe it means that Jaxor is using Drupal? http://www.drupal.org/ jaaron
M:N Question
I have a quick question and just need to know if I can use any ofM :N solutions , I have a object (Parent) with different collection properties. I would like to load them all in one query but if one of them is empty or there is no record that relates to parent for one of the child properties I still want to load the rest. Here is an example, Product { List items, List vendors; List similarProducts; } Now here when I load a product i would want to load all these three properties independent of each other hopefully all in one query. Is it possible to that. Amad begin:vcard fn:Amad Fida n:Fida;Amad email;internet:[EMAIL PROTECTED] x-mozilla-html:TRUE version:2.1 end:vcard
Re: JDBCRealm using iBATIS?
Just a thought, use JNDI ... you setup your DataSource once, use it in your Realm and in iBATIS. That's what we do ... BR On Thu, 17 Mar 2005 15:37:03 +, Tim Christopher [EMAIL PROTECTED] wrote: Hi, Can anyone let me know if it is possible to use iBATIS for implementing JDBCRealm, or do I have to access the database directly? I've looked on Google and in the Developer Notes for iBATIS and have found nothing on this topic. Any help would be much appreciated. Tim Christopher
How does iBATIS read the SqlMap files?
Hi, I have an Actionclass from where I instantiate my Service class which in turn gets me a DAO instance and calls a class where I say: daoManager.startTransaction(); insert(insertRow, row); daoManager.endTransaction(); Now, I have defined all my XML files containing the queries in sql-map-config.xml file like: sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/Shop.xml/ sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/order.xml/ What I want to know is, how does iBATIS know which of the 2 XML files it should look INTO for finding a statement named insertRow ?? I have only one such XML file and have a statement by the name insertRow but am getting that there is no statement by the name insertRow in this SqlMap Any solutions? Thanks __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs
Re: How does iBATIS read the SqlMap files?
are you using namespaces? if yes then you need to make it... insert(Order.insertRow, row); if your namespace is Order Brandon On Thu, 17 Mar 2005 22:44:26 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I have an Actionclass from where I instantiate my Service class which in turn gets me a DAO instance and calls a class where I say: daoManager.startTransaction(); insert(insertRow, row); daoManager.endTransaction(); Now, I have defined all my XML files containing the queries in sql-map-config.xml file like: sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/Shop.xml/ sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/order.xml/ What I want to know is, how does iBATIS know which of the 2 XML files it should look INTO for finding a statement named insertRow ?? I have only one such XML file and have a statement by the name insertRow but am getting that there is no statement by the name insertRow in this SqlMap Any solutions? Thanks __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs
Re: How does iBATIS read the SqlMap files?
post your sqlmap On Thu, 17 Mar 2005 23:09:42 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Yes, in my Order.xml I have: sql-map namespace=Order typeAlias alias=Row type=com.ibatis.dataaccess.beans.Row/ insert id=insertRow parameterClass=com.ibatis.dataaccess.beans.Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#processind#, #createddate#, #processeddate#, #orderxml#) /insert /sql-map I am still getting the error when I call: daoManager.startTransaction(); insert(Order.insertRow, xmlrow); daoManager.endTransaction(); any idea?? Thanks Swati --- Brandon Goodin [EMAIL PROTECTED] wrote: are you using namespaces? if yes then you need to make it... insert(Order.insertRow, row); if your namespace is Order Brandon On Thu, 17 Mar 2005 22:44:26 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I have an Actionclass from where I instantiate my Service class which in turn gets me a DAO instance and calls a class where I say: daoManager.startTransaction(); insert(insertRow, row); daoManager.endTransaction(); Now, I have defined all my XML files containing the queries in sql-map-config.xml file like: sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/Shop.xml/ sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/order.xml/ What I want to know is, how does iBATIS know which of the 2 XML files it should look INTO for finding a statement named insertRow ?? I have only one such XML file and have a statement by the name insertRow but am getting that there is no statement by the name insertRow in this SqlMap Any solutions? Thanks __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: How does iBATIS read the SqlMap files?
urrr sorry...post your sql-map-config.xml file please. Brandon On Fri, 18 Mar 2005 00:56:20 -0700, Brandon Goodin [EMAIL PROTECTED] wrote: post your sqlmap On Thu, 17 Mar 2005 23:09:42 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hello, Yes, in my Order.xml I have: sql-map namespace=Order typeAlias alias=Row type=com.ibatis.dataaccess.beans.Row/ insert id=insertRow parameterClass=com.ibatis.dataaccess.beans.Row INSERT INTO ORDER (processed_ind, insr_dt, processed_dt, order_det) VALUES (#processind#, #createddate#, #processeddate#, #orderxml#) /insert /sql-map I am still getting the error when I call: daoManager.startTransaction(); insert(Order.insertRow, xmlrow); daoManager.endTransaction(); any idea?? Thanks Swati --- Brandon Goodin [EMAIL PROTECTED] wrote: are you using namespaces? if yes then you need to make it... insert(Order.insertRow, row); if your namespace is Order Brandon On Thu, 17 Mar 2005 22:44:26 -0800 (PST), Swati Singhal [EMAIL PROTECTED] wrote: Hi, I have an Actionclass from where I instantiate my Service class which in turn gets me a DAO instance and calls a class where I say: daoManager.startTransaction(); insert(insertRow, row); daoManager.endTransaction(); Now, I have defined all my XML files containing the queries in sql-map-config.xml file like: sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/Shop.xml/ sqlMap resource=com/myibatis/dataaccess/persistence/sqlmapdao/sql/order.xml/ What I want to know is, how does iBATIS know which of the 2 XML files it should look INTO for finding a statement named insertRow ?? I have only one such XML file and have a statement by the name insertRow but am getting that there is no statement by the name insertRow in this SqlMap Any solutions? Thanks __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com