When I'm trying to set
<transactionManager type="JDBC" commitRequired="true">
<property name="DataSource" value="SIMPLE" />
<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" />
</transactionManager>
I got these errors..
com.ibatis.sqlmap.client.SqlMapException: There was an error while building
the SqlMap instance.
--- The error occurred in the SQL Map Configuration file.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error.
Cause: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
Caused by: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error.
Cause: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlS
qlMapClientBuilder.java:198)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientB
uilder.java:61)
at com.*.quiz.dao.MyAppSqlConfig.<clinit>(MyAppSqlConfig.java:24)
at com.*.quiz.engine.TestSP2.main(TestSP2.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error.
Cause: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1165)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlS
qlMapClientBuilder.java:190)
... 8 more
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder$SimpleErrorHandl
er.error(XmlSqlMapClientBuilder.java:1313)
at org.apache.crimson.parser.Parser2.error(Parser2.java:3359)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1595)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1963)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1691)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
at
org.apache.crimson.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:1
85)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1162)
... 9 more
Caused by:
com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause:
org.xml.sax.SAXException: Error: URI=null Line=9: Attribute "commitRequired"
is not declared for element "transactionManager".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1165)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlS
qlMapClientBuilder.java:190)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientB
uilder.java:61)
at com.*.quiz.dao.MyAppSqlConfig.<clinit>(MyAppSqlConfig.java:24)
at com.*.quiz.engine.TestSP2.main(TestSP2.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder$SimpleErrorHandl
er.error(XmlSqlMapClientBuilder.java:1313)
at org.apache.crimson.parser.Parser2.error(Parser2.java:3359)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1595)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1963)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1691)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
at
org.apache.crimson.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:1
85)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1162)
... 9 more
Caused by:
org.xml.sax.SAXException: Error: URI=null Line=9: Attribute "commitRequired"
is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder$SimpleErrorHandl
er.error(XmlSqlMapClientBuilder.java:1313)
at org.apache.crimson.parser.Parser2.error(Parser2.java:3359)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1595)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1963)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1691)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
at
org.apache.crimson.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:1
85)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1162)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlS
qlMapClientBuilder.java:190)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientB
uilder.java:61)
at com.*.quiz.dao.MyAppSqlConfig.<clinit>(MyAppSqlConfig.java:24)
at com.*.quiz.engine.TestSP2.main(TestSP2.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by:
com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause:
org.xml.sax.SAXException: Error: URI=null Line=9: Attribute "commitRequired"
is not declared for element "transactionManager".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1165)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlS
qlMapClientBuilder.java:190)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientB
uilder.java:61)
at com.*.quiz.dao.MyAppSqlConfig.<clinit>(MyAppSqlConfig.java:24)
at com.*.quiz.engine.TestSP2.main(TestSP2.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder$SimpleErrorHandl
er.error(XmlSqlMapClientBuilder.java:1313)
at org.apache.crimson.parser.Parser2.error(Parser2.java:3359)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1595)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1963)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1691)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
at
org.apache.crimson.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:1
85)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1162)
... 9 more
Caused by:
org.xml.sax.SAXException: Error: URI=null Line=9: Attribute "commitRequired"
is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder$SimpleErrorHandl
er.error(XmlSqlMapClientBuilder.java:1313)
at org.apache.crimson.parser.Parser2.error(Parser2.java:3359)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1595)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1963)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1691)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
at
org.apache.crimson.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:1
85)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1162)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlS
qlMapClientBuilder.java:190)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientB
uilder.java:61)
at com.*.quiz.dao.MyAppSqlConfig.<clinit>(MyAppSqlConfig.java:24)
at com.*.quiz.engine.TestSP2.main(TestSP2.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by:
org.xml.sax.SAXException: Error: URI=null Line=9: Attribute "commitRequired"
is not declared for element "transactionManager".
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder$SimpleErrorHandl
er.error(XmlSqlMapClientBuilder.java:1313)
at org.apache.crimson.parser.Parser2.error(Parser2.java:3359)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1595)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1963)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1691)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
at
org.apache.crimson.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:1
85)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.getDoc(XmlSqlMap
ClientBuilder.java:1162)
at
com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap(XmlS
qlMapClientBuilder.java:190)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientB
uilder.java:61)
at com.*.quiz.dao.MyAppSqlConfig.<clinit>(MyAppSqlConfig.java:24)
at com.*.quiz.engine.TestSP2.main(TestSP2.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
java.lang.ExceptionInInitializerError
at com.*.quiz.engine.TestSP2.main(TestSP2.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.lang.RuntimeException: Error initializing MyAppSqlConfig
class. Cause: com.ibatis.sqlmap.client.SqlMapException: There was an error
while building the SqlMap instance.
--- The error occurred in the SQL Map Configuration file.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error.
Cause: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
Caused by: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error.
Cause: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
Caused by: org.xml.sax.SAXException: Error: URI=null Line=9: Attribute
"commitRequired" is not declared for element "transactionManager".
at com.*.quiz.dao.MyAppSqlConfig.<clinit>(MyAppSqlConfig.java:29)
... 6 more
Exception in thread "main"
-----Original Message-----
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 21:43
To: [email protected]
Subject: Re: Calling PL/PGSQL doesn't work?
Set <transactionManager ... commitRequired="true">
This will force even queries to be committed.
Larry
