Maybe you just have something configured incorrectly. Here is my Struts
config file, and the matching properties file, for a working 8i
configuration
#iBatis SQL Maps properties
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:GAK
username=user
password=pass
datasource=SIMPLE
<transactionManager type="JDBC" >
<dataSource type="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}"/>
</dataSource>
</transactionManager>
-----Original Message-----
From: KK [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 10:57 AM
To: ibatis-user-cs@incubator.apache.org
Subject: iBatis for Oracle 8i
Hello everyone,
I want to use iBatis in my application and started researching and
trying to develop a small application. But I have a problem using Oracle
8i as backend with JDBC, I could succesfully compile classes and set up
configmap and other required xml files after several attempts, but now
it fails with the following error,
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSourc
e.java:473)
at
com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSourc
e.java:200)
at
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.<init>(Jdbc
Transaction.java:26)
at
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransactionConfig.newTr
ansaction(JdbcTransactionConfig.java:32)
at
com.ibatis.sqlmap.engine.transaction.TransactionManager.begin(Transac
tionManager.java:35)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.startTransaction
(SqlMapExecutorDelegate.java:408)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.startTransaction(SqlM
apSessionImpl.java:113)
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.startTransaction(SqlMa
pClientImpl.java:87)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoStartTransac
tion(SqlMapExecutorDelegate.java:501)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(S
qlMapExecutorDelegate.java:308)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(S
qlMapExecutorDelegate.java:297)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMap
SessionImpl.java:69)
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapC
lientImpl.java:46)
at ActionTest.main(ActionTest.java:39)
I am using classes12.jar file for connecting to oracle, can someone help
me with this..
Thanks,
Kumar.
