ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roberto R <roberto.r...@gmail.com>
Subject Re: c# ibatis Help!
Date Wed, 15 Feb 2006 14:24:20 GMT
If logging in works through SQL Plus, your tnsnames is ok.  Your connection
string looks ok too.

Have you tried Ron's suggestion of creating a simple console app to try to
connect?

Roberto


On 2/15/06, Henry Lu <zhlu@umich.edu> wrote:
>
> Do you/someone have an example of code and tnsnames.ora and sqlnet.ora
> configures for connecting to oracle database?
>
> I have mine as followings but they didn't work.
>
> string connectStr = "User Id=scott;Password=tiger;Data Source=ORCL";
>
> ORCL =
>   (DESCRIPTION =
>     (ADDRESS_LIST =
>       (ADDRESS = (PROTOCOL = TCP)(HOST = my_leptop)(PORT = 1521))
>     )
>     (CONNECT_DATA =
>       (SERVICE_NAME = orcl)
>     )
>   )
>
> I tried sqlplus with ORCL, it works fine. Do I need to set sqlnet.ora?
> How?
>
> -Henry
>
> Ron Grabowski wrote:
>
> >Could you post more of the exception?
> >
> >Have you verified that the Oracle.DataAccess.dll assembly works
> >correctly? Try creating a simple console app using just ADO.Net and the
> >Oracle.DataAccessd.dll assembly and see if you can execute a simple
> >"SELECT COUNT(*) FROM tblUsers" statement.
> >
> >--- zhlu@umich.edu wrote:
> >
> >
> >
> >>Could someone help to run this HelloWorld program? I go the following
> >>errors:
> >>
> >>An unhandled exception of type
> >>'IBatisNet.DataMapper.Exceptions.DataMapperException'
> >>occurred in ibatisnet.datamapper.dll
> >>
> >>Additional information: Unable to open connection to "Oracle, oracle
> >>provider V10.1.0.301".
> >>
> >>sqlmap.config file is following:
> >>
> >><?xml version="1.0" encoding="utf-8"?>
> >><sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper"
> >>xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
> >>      <providers embedded="Resources.Providers.config, HelloWorld" />
> >>      <database>
> >>              <provider name="oracle10.1"/>
> >>              <dataSource
> name="HelloWorld"              connectionString="Data
> >>Source=lu10g;User Id=scott;Password=tiger"/>
> >>      </database>
> >>      <sqlMaps>
> >>              <sqlMap embedded="Resources.OleDb.Person.xml, HelloWorld"
> />
> >>      </sqlMaps>
> >></sqlMapConfig>
> >>
> >>
> >>I am using Oracle.DataAccess.dll for provider downloaded from oracle
> >>site this morning.
> >>
> >>
> >>Here is my provider file:
> >>
> >><?xml version="1.0" encoding="utf-8"?>
> >><providers xmlns="http://ibatis.apache.org/providers"
> >>xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> >><clear/>
> >><provider name="OleDb1.1"     description="OleDb, provider V1.0.5000.0
> >>in
> >>framework .NET V1.1"  enabled="true"
> >>      assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
> >>PublicKeyToken=b77a5c561934e089"
> >>connectionClass="System.Data.OleDb.OleDbConnection"
> >>      commandClass="System.Data.OleDb.OleDbCommand"
> >>      parameterClass="System.Data.OleDb.OleDbParameter"
> >>      parameterDbTypeClass="System.Data.OleDb.OleDbType"
> >>      parameterDbTypeProperty="OleDbType"
> >>      dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"
> >>      commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"
> >>      usePositionalParameters="true"  useParameterPrefixInSql="false"
> >>      useParameterPrefixInParameter="false"   parameterPrefix=""/>
> >><provider     name="oracle10.1"       description="Oracle, oracle
> provider
> >>V10.1.0.301"
> >>      enabled="true"  assemblyName="Oracle.DataAccess, Version=
> 10.1.0.301,
> >>
> >>Culture=neutral, PublicKeyToken=89b483f429c47342"
> >>connectionClass="Oracle.DataAccess.Client.OracleConnection"
> >>      commandClass="Oracle.DataAccess.Client.OracleCommand"
> >>      parameterClass="Oracle.DataAccess.Client.OracleParameter"
> >>      parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"
> >>      parameterDbTypeProperty="OracleDbType"
> >>      dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"
> >>      commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder
> "
> >>      usePositionalParameters="true"  useParameterPrefixInSql="true"
> >>      useParameterPrefixInParameter="true"    parameterPrefix=":"
> >>      useDeriveParameters="false"/>
> >></providers>
> >>
> >>-Henry
> >>
> >>Quoting Ron Grabowski <rongrabowski@yahoo.com>:
> >>
> >>
> >>
> >>>Here's a console application that calls the QueryForList method on
> >>>
> >>>
> >>a
> >>
> >>
> >>>SqlMapper object and prints out Count property of the returned
> >>>PersonCollection object:
> >>>
> >>>http://www.ronosaurus.com/IBatisNet/HelloWorld.zip
> >>>
> >>>The path the the Person.mdb file is hard-coded to C:\Person.mdb in
> >>>
> >>>
> >>the
> >>
> >>
> >>>SqlMap.config file. The program uses the Log4Net logging adapter
> >>>
> >>>
> >>and
> >>
> >>
> >>>records the sql queries sent to the database to a file called
> >>>HelloWorld.log.
> >>>
> >>>If you have any questions, try doing this tutorial:
> >>>
> >>>http://tinyurl.com/78use
> >>>
> >>>
> >>>
> >
> http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Quick+Start+Guide
> >
> >
> >>>--- Henry Lu <zhlu@umich.edu> wrote:
> >>>
> >>>
> >>>
> >>>>Is there one who can send me a complete console example of c#
> >>>>
> >>>>
> >>ibatis
> >>
> >>
> >>>>net
> >>>>project? I got so many errors one after another. I am not sure I
> >>>>got/downloaded  the right version for everything.
> >>>>
> >>>>-Henry
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >
> >
> >
> >
> >
>

Mime
View raw message