Not logged in : Login

About: What Do I Do If My Applications Fail To Connect After I Upgraded My 1x3x Drivers To 4x5x? -- Answer     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : schema:Answer, within Data Space : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=https%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Ffaq%2Fuda%2F899d6d63a25b063873879a9a8e30e81f%23this

AttributesValues
name
  • What Do I Do If My Applications Fail To Connect After I Upgraded My 1x3x Drivers To 4x5x? -- Answer
category
  • ODBC
  • JDBC
  • UDA
text
  • OpenLink's 1.x and 3.x Multi-Tier drivers use different JDBC connection mechanisms. The older drivers route the request through a JDBC-specific agent that speaks to a database-specific agent. Here is the sequence of events needed to perform this task: 1. User creates a JDBC connection URL. For example: jdbc:openlink://localhost:5000/SVT=Ingres II/DATABASE=iidbdb/UID=ingres/PWD=ingres/JDBCAGENT=jodbc 2. The Broker associates all JDBC connection attempts with one of the JDBC Domains that appear in the [Domain] section of the Session Rules Book (oplrqb.ini). For example: [Domain Aliases] jodbc = jodbc judbc = judbc jdbc = jdbc 3. The Broker uses the Domain Alias to resolve the connection using one of the JDBC Mapping Rules from the [Mapping Rules] section of oplrqb.ini. For example: [Mapping Rules] jodbc:*:*:java:*:*:* = accept jodbc_client judbc:*:*:java:*:*:* = accept judbc_client jdbc:*:*:java:*:*:* = accept jdbc_client *:*:*:java:*:*:* = accept judbc_client 4. The Mapping Rules associate the connection attempt with a JDBC agent configuration section. For example: [jodbc_client] Program = jodbc_sv.exe CommandLine = ;+debug ReUse = never 5. The agent configuration section controls which JDBC agent is spawned to service the connection. In the above instance, jodbc_sv.exe is spawned. The JDBC agent spawns the database agent that corresponds to the SVT parameter of the JDBC connection URL. The following sections of the Rules Book shows how SVT=Ingres II causes the JDBC agent to spawn the oig2_sv database agent: Domain Aliases] Ingres II = oig2 [Mapping Rules] oig2:*:*:*:*:*:* = reject The Ingres II Database Agent is not configured [generic_oig2] Program = oig2_sv.exe Environment = INGRES_II OpsysLogin = Yes ReUse = never OpenLink's newest drivers omit the need for a distinct JDBC agent. JDBC-specific Domains, Mapping Rules, Agent Configuration Sections, and agents are omitted from the connection resolution. Instead, the Broker resolves the JDBC connection URL using only the SVT parameter. The database agent that is spawned is now able to handle both ODBC and JDBC connections Users may prevent most problems by removing JDBCAGENT= from their JDBC connection URLs. If problems persist, advanced users may resolve most problems by editing the Session Rules Book. New users are encouraged to contact OpenLink Product Support. Some 1.x and 3.x users create hybrid connections that pass an ODBC DSN in a Type 3 JDBC URL. For example: jdbc:openlink://localhost:5000/DSN=My Ingres Data Source/UID=ingres/PWD=ingres This connection format is no longer supported.
type
is acceptedAnswer of
Faceted Search & Find service v1.17_git110 as of Apr 06 2022


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3322 as of Apr 19 2022, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 20 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2022 OpenLink Software