Vic, i tried connecting to PostGres DB. It is fine. It is only with the Oracle that i am getting nulls. May be i should change the Oracle Driver and try tonight.
Every reply encourages to try one step further... Thank you very much Santhi -----Original Message----- From: Vic Cekvenich [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 4:57 PM To: [EMAIL PROTECTED] Subject: Re: [MVC-Programmers] IBatis returns null I use ibatis from java console applications a lot (for batch, etc.). Here is my snipet that works: static { try { Reader reader = Resources.getResourceAsReader("properties/sql-map-config.xml"); _sqlMap = XmlSqlMapBuilder.buildSqlMap(reader); _sqlMap.setCurrentDataSourceName("ids"); log.debug("we have a connection pool!"); } I am not sure where you might be stuck, can you put a few debugs in? .V Peyathevar, Santhi {PBG} wrote: >Vic, > >1.i do not need a web app. Only, simple java app. >2.I tried both Dbcp and SimpleDataSourceFactory. >both give null. Connecting to oracle database. >I know it is connecting to the database, >because it complains if i leave syntax errors. > >************************************ >This is the sample that i am trying to run - from IBatis Web site: >************************************ >SqlMapConfigExample.xml > > <datasource name="basic" default = "true" > >factory-class="com.ibatis.db.sqlmap.datasource.SimpleDataSourceFactory"> > <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> > > <sql-map resource="examples/sqlmap/maps/Account.xml" /> > >************************************ > >Account.xml > > <result-map name="indexed-account-result2" >class="examples.domain.Account"> > <property name="id" column="ACC_ID" columnIndex="1"/> > <property name="firstName" column="ACC_FIRST_NAME" columnIndex="2"/> > <property name="lastName" column="ACC_LAST_NAME" columnIndex="3"/> > </result-map> > > <mapped-statement name="getAccount" cache-model="account-cache" >result-map="indexed-account-result2"> > select > ACC_ID, > ACC_FIRST_NAME, > ACC_LAST_NAME > from ACCOUNT > where ACC_ID = #value# > </mapped-statement> > >************************************* >SqlMapConfigExample.java (Don't i have to use the datasource name "basic" >anywhere ? > >static >{ > > Reader reader = >Resources.getResourceAsReader("examples/sqlmap/maps/SqlMapConfigExample.xml " >); > sqlMap = XmlSqlMapBuilder.buildSqlMap(reader); >} > >*********************************** >QueryForListExample.java > > SqlMap sqlMap = SqlMapConfigExample.getSqlMap(); > > try > { > sqlMap.startTransaction(); > Account account = (Account) >sqlMap.executeQueryForObject("getAccount", new Integer(1)); > sqlMap.commitTransaction(); > } >************************************ >Sorry about the long email >Santhi >************************************ > >-----Original Message----- >From: Vic Cekvenich [mailto:[EMAIL PROTECTED] >Sent: Thursday, October 16, 2003 3:49 PM >To: [EMAIL PROTECTED] >Subject: Re: [MVC-Programmers] IBatis returns null > > >It's best to use JNDI container DataSource pools, howerver: ><datasource name="ids" > >factory-class="com.ibatis.db.sqlmap.datasource.SimpleDataSourceFactory" >default="true"> ><property name="JDBC.Driver" value="org.postgresql.Driver"/> ><property name="JDBC.ConnectionURL" >value="jdbc:postgresql://localhost:5432/bp?autoReconnect=true"/> ><property name="JDBC.Username" value="bpuser"/> ><property name="JDBC.Password" value="changeme"/> ></datasource> > >aboove is a sample iBatis pool. >I think that was your question. From there, it is just standard iBatis. > >.V > >Peyathevar, Santhi {PBG} wrote: > > > >>All: >> >>1.I am trying to use IBatis for running some SQL >> >> >> >>from simple java code. > > >>2.using DbcpDataSourceFactory >> >>3.It connects to the database but the result is null >> >>Can anybody help? >> >>Santhi >> >>_______________________________________________ >>MVC-Programmers mailing list >>[EMAIL PROTECTED] >>http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers >> >> >> >> >> >> > >_______________________________________________ >MVC-Programmers mailing list >[EMAIL PROTECTED] >http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers >_______________________________________________ >MVC-Programmers mailing list >[EMAIL PROTECTED] >http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers > > > > _______________________________________________ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers _______________________________________________ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
