Workbench DAtabase Connectivity

Avatar

Avatar

DevlAmol

Avatar

DevlAmol

DevlAmol

11-11-2011

How do we configure database server using the JDBCService in workbench?

What exactly is the relation between the DataSource Name in properties tab of JDBCService and the JDBCService presnt in components view?

I have added a JDBC activity in the Workbench LC 8.2,Now i need to connec it with my DB2 Database Server.So i am tring to edit the service configuration and add the DataSource name of my DAtabase(jdbc/JDQuoteDevl2DataSource).i have activated the JDBCService but in the properties tab I add the same DSN name and run a Select Query i  m getting the following exception:

               Exception: Context: DevlCell5/nodes/lsdewas80/servers/LIVECD, name: jdbc/JDQuoteDevl2DataSource: First component in name JDQuoteDevl2DataSource not found.. Cause: Context: DevlCell5/nodes/lsdewas80/servers/LIVECD, name: jdbc/JDQuoteDevl2DataSource: First component in name JDQuoteDevl2DataSource not found.

Please can You Help me Out..I am stuck with my work as i am not able to establish the connectivity and fetch the value.

Thanks in Advance

View Entire Topic

Avatar

Avatar

Steve_L_Walker

Avatar

Steve_L_Walker

Steve_L_Walker

11-11-2011

Is the DB2 database the same database being used for LC?

If not, you need to add an entry in a file *-ds.xml located under C:\Adobe\LiveCycle8.2\jboss\server\all\deploy. There should be at least two *-ds.xml files in the directory for the LC installation. The data source xml files add the JNDI names visible in Workbench.

I'd recommend creating a separate *-ds.xml for application data source so as not to mess with LC. You can copy-and-paste one of the datasources nodes and create a new file, such as my-db2-ds.xml for example, and add it to C:\Adobe\LiveCycle8.2\jboss\server\all\deploy.

This is a sample *-ds.xml file. Give it a unique jndi-name and configure connection-url, driver-class, user-name, password and any other relevent parameters. Please DO NOT cut-and-paste this datasources xml. I am not sure which version of LC it is from.

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

          <no-tx-datasource>

                    <jndi-name>DEMO_DS</jndi-name>

                    <connection-url>jdbc:mysql://localhost:3306/demo</connection-url>

                    <driver-class>com.mysql.jdbc.Driver</driver-class>

                    <user-name>root</user-name>

                    <password>password</password>

                    <min-pool-size>10</min-pool-size>

                    <max-pool-size>100</max-pool-size>

                    <blocking-timeout-millis>20000</blocking-timeout-millis>

                    <idle-timeout-minutes>10</idle-timeout-minutes>

                    <prepared-statement-cache-size>50</prepared-statement-cache-size>

                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

          </no-tx-datasource>

</datasources>

Steve