Ingres DataSource Configuration

From: nasser (nasser_at_unify.com.br)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 12:46:37 -0600

Hi

I obtain to carry through the connection with ingres using ca.edbc.jdbc.EdbcDriver , normally, using this xml file:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>DSIngres</jndi-name>
                   <connection-url>jdbc:edbc://localhost:portName/DBaseName;UID=userName;PWD=password</connection-url>
    <driver-class>ca.edbc.jdbc.EdbcDriver</driver-class>
    <user-name>x</user-name>
    <password>y</password>
  </local-tx-datasource>
</datasources>

____________________________________________________________

How I could make this same connection using following class ca.edbc.jdbcx.EdbcCPDataSource ?

I tried to use this xml file:

<?xml version="1.0" encoding="UTF-8"?>
<!-- *********************************************** -->
<!-- Ingres CP local-tx-datasource CP example -->
<!-- Author: Hamilton 2004-02-04 22:30 -->
<!-- Revised Hamilton xxxx-xx-xx xx:xx -->
<!-- *********************************************** -->

<xa-datasource>
    <jndi-name>CPDataSource</jndi-name>
    <track-connection-by-tx>true</track-connection-by-tx>

<xa-datasource-class>ca.edbc.jdbcx.EdbcCPDataSource</xa-datasource-class>
<xa-datasource-property-name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property-name="PortName">PortName</xa-datasource-property>
<xa-datasource-property-name="DatabaseName">DBaseName</xa-datasource-property>
<xa-datasource-property-name="SelectMethod">cursor</xa-datasource-property>
<xa-datasource-property-name="SendStringParametersAsUnicode">true</xa-datasource-property>
<user-name>x</user-name>
<password>y</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>50</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
</xa-datasource>

But the following error occurred:

Unable to get connection to data source "CPDataSource"
java.lang.ClassCastException: ca.edbc.jdbcx.EdbcCPDataSource

Any aid I am thankful.
Nasser Auada

Relevant Pages

  • RE: Build comment web pages for "value" and "example"
    ... I generated xml file when I build my application. ... I use my own laptop and connection in Graz Technical University. ... and I can download anything except the visual studio.net. ... >> public class MyClass ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DataAdapter Not Updating
    ... That is the key purpose of the XML file but if some of the data updates and ... where it will cause referential integrity problems. ... >> You could open the connection in a try block before clearing the ... could you use the xml file your referred to in the first post as ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Change connection string
    ... You could as well hold this in a seperate file. ... an xml file. ... but then on occasion the connection to the table holding the ... >>> sam ...
    (microsoft.public.access.modulesdaovba)
  • Re: SSIS Package Configuration
    ... You have to choose a connection that is in your connection manager. ... connection is in your XML file, ... "Francisco A. Gonzalez" wrote: ...
    (microsoft.public.sqlserver.dts)
  • RE: Crystal Report - connection string
    ... > In my project i'm having an xml file which is having connection ... > string(for sql server).I included some reports in that project .How should i ...
    (microsoft.public.dotnet.languages.vb)