[mule-jira] Created: (MULE-5351) JDBC driver found but is not loaded

JDBC driver found but is not loaded
-----------------------------------

                 Key: MULE-5351
                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
             Project: Mule
          Issue Type: Bug
          Components: Core: Deployment / Federation
    Affects Versions: 3.1.0
            Reporter: Daniel Zapata


I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39043#comment-39043 ]

Mike Schilling commented on MULE-5351:
--------------------------------------

This needs to be documented.

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment / Federation
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Daniel Zapata
>            Priority: Major
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39044#comment-39044 ]

Andrew Perepelytsya commented on MULE-5351:
-------------------------------------------

There might be things we can do to fix/workaround this, resorting to lib/user should be avoided. Danny, could you please attach a full app and ddl?

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment / Federation
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Daniel Zapata
>            Priority: Major
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39057#comment-39057 ]

Daniel Zapata commented on MULE-5351:
-------------------------------------

You can use the jdbc example which ships with EE to reproduce.

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment / Federation
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Daniel Zapata
>            Priority: Major
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=40365#comment-40365 ]

Erik Seilnacht commented on MULE-5351:
--------------------------------------

Here is a simple mule config I have been using to test the secure data gateway.

<mule xmlns="http://www.mulesoft.org/schema/mule/core"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:spring="http://www.springframework.org/schema/beans"
    xmlns:jdbc="http://www.mulesoft.org/schema/mule/ee/jdbc"
   
    xsi:schemaLocation="
       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
       http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/3.1/mule.xsd
       http://www.mulesoft.org/schema/mule/ee/jdbc http://www.mulesoft.org/schema/mule/ee/jdbc/3.1/mule-jdbc-ee.xsd">
       
    <spring:bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <spring:property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <spring:property name="url" value="jdbc:mysql://localhost:10000/ion_test"/>
        <spring:property name="username" value="eriks"/>
        <spring:property name="password" value=""/>
    </spring:bean>
   
    <jdbc:connector name="jdbcConnector" dataSource-ref="dataSource">
        <jdbc:query key="ionTestInsert"
            value="insert into ion_test_table values
            (#[header:inbound:value])"/>
    </jdbc:connector>

    <flow name="logtest">
       <inbound-endpoint address="<a href="http://localhost:$">http://localhost:${http.port}/jdbctest"/>
       <jdbc:outbound-endpoint queryKey="ionTestInsert"/>
   </flow>
   
</mule>

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

     [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrew Perepelytsya closed MULE-5351.
-------------------------------------

       Resolution: Won't Fix or Usage Issue
    Fix Version/s: 3.1.3
     Affects Docs:   (was: [Yes])

User error. Tested with Mule 3.2.x & 3.1.x, both CE & EE.

Read big fat warnings for the DriverManagerDataSource about its applicability: http://static.springsource.org/spring/docs/3.0.x/api/org/springframework/jdbc/datasource/DriverManagerDataSource.html

Replacing it with a 'proper' class like this works:

http://static.springsource.org/spring/docs/3.0.x/api/org/springframework/jdbc/datasource/SimpleDriverDataSource.html


P.S.: neither of the above are actually connection pools and must not be used in the documentation

P.P.S.: I'll try with enhydra pool which Roko reported had the issue too, just to double-check.

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>             Fix For: 3.1.3
>
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=40374#comment-40374 ]

Andrew Perepelytsya commented on MULE-5351:
-------------------------------------------

Tried with xapool (enhydra) - everything works as expected.

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>             Fix For: 3.1.3
>
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

     [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Roko Kruze reopened MULE-5351:
------------------------------


I'm seeing this issue again when I use an inbound file poller. Previously this worked just fine when I didn't have a polling inbound endpoint.

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>             Fix For: 3.1.3
>
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=40538#comment-40538 ]

Roko Kruze commented on MULE-5351:
----------------------------------

My config looks like the following:


<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesoft.org/schema/mule/core"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:spring="http://www.springframework.org/schema/beans"
      xmlns:file="http://www.mulesoft.org/schema/mule/file"
      xmlns:vm="http://www.mulesoft.org/schema/mule/vm"
      xmlns:mule-xml="http://www.mulesoft.org/schema/mule/xml"
      xmlns:datapack="http://www.mulesoft.org/schema/mule/datapack"
      xmlns:quartz="http://www.mulesoft.org/schema/mule/quartz"
      xmlns:pm="http://www.mulesoft.org/schema/mule/peoplematter"
      xmlns:jdbc="http://www.mulesoft.org/schema/mule/jdbc"
      xmlns:http="http://www.mulesoft.org/schema/mule/http"
      xmlns:script="http://www.mulesoft.org/schema/mule/scripting"
      xmlns:mule-ss="http://www.mulesoft.org/schema/mule/spring-security"
      xmlns:ss="http://www.springframework.org/schema/security"
      xmlns:json="http://www.mulesoft.org/schema/mule/json"
      xsi:schemaLocation="
        http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/3.1/mule.xsd
        http://www.mulesoft.org/schema/mule/file http://www.mulesoft.org/schema/mule/file/3.1/mule-file.xsd
        http://www.mulesoft.org/schema/mule/vm http://www.mulesoft.org/schema/mule/vm/3.1/mule-vm.xsd
        http://www.mulesoft.org/schema/mule/xml http://www.mulesoft.org/schema/mule/xml/3.1/mule-xml.xsd
        http://www.mulesoft.org/schema/mule/datapack http://www.mulesoft.org/schema/mule/datapack/3.1/mule-datapack.xsd
        http://www.mulesoft.org/schema/mule/quartz http://www.mulesoft.org/schema/mule/quartz/3.1/mule-quartz.xsd
        http://www.mulesoft.org/schema/mule/peoplematter http://www.mulesoft.org/schema/mule/peoplematter/3.1/mule-peoplematter.xsd
        http://www.mulesoft.org/schema/mule/jdbc http://www.mulesoft.org/schema/mule/jdbc/3.1/mule-jdbc.xsd
        http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/3.1/mule-http.xsd
        http://www.mulesoft.org/schema/mule/scripting http://www.mulesoft.org/schema/mule/scripting/3.1/mule-scripting.xsd
        http://www.mulesoft.org/schema/mule/spring-security http://www.mulesoft.org/schema/mule/spring-security/3.1/mule-spring-security.xsd
        http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd
        http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/3.1/mule-json.xsd">

    <description>
        People Matter Testing
    </description>

    <mule-ss:security-manager>
        <mule-ss:delegate-security-provider name="memory-provider" delegate-ref="authenticationManager"/>
    </mule-ss:security-manager>

    <spring:beans>
        <ss:authentication-manager alias="authenticationManager">
            <ss:authentication-provider>
                <ss:user-service id="userService">
                   <!-- user info -->
                </ss:user-service>
            </ss:authentication-provider>
        </ss:authentication-manager>
    </spring:beans>

    <mule-xml:namespace-manager>
        <mule-xml:namespace prefix="hrxml" uri="http://www.hr-xml.org/3"/>
        <mule-xml:namespace prefix="oagis" uri="http://www.openapplications.org/oagis/9"/>
        <mule-xml:namespace prefix="pm" uri="http://www.peoplematter.com/release/1"/>
    </mule-xml:namespace-manager>

    <spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
        <spring:property name="driverName" value="com.mysql.jdbc.Driver"/>
        <spring:property name="url" value="...."/>
        <spring:property name="user" value="...."/>
        <spring:property name="password" value="...."/>
    </spring:bean>

    <jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
        <jdbc:query key="lookupJobTitleQuery"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JobTitle = #[xpath://hrxml:MasterPosition/hrxml:PositionTitle]"/>
        <jdbc:query key="lookupEmergencyContactQuery"
                    value="select * from EMERGENCYCONTACTLOOKUP WHERE PMDESCRIPTION = #[xpath://pm:EmergencyContactUserArea/pm:Relationship]"/>
        <jdbc:query key="lookupEthnicityMapping"
                    value="select * from ethnicityMapping WHERE PEOPLEMATTER = #[xpath://hrxml:EthnicityCode]"/>
        <jdbc:query key="selectJobTitle"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE"/>
        <jdbc:query key="selectJobTitleFromName"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLE = #[json:jobtitle]"/>
        <jdbc:query key="selectJobTitleFromID"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLEID = #[json:jobtitleid]"/>
        <jdbc:query key="createJobTitle"
                    value="INSERT INTO JOBTITLELOOKUPTABLE (JOBTITLE) VALUES(#[json:jobtitle]);"/>
        <jdbc:query key="updateJobTitles"
                    value="UPDATE JOBTITLELOOKUPTABLE SET orglvl1 = #[json:orglvl1], jobtitle = #[json:jobtitle],
                    isautopaid = #[json:isautopaid], eecscheduledworkhrs = #[json:eecscheduledworkhrs],
                    eecsalaryorhourly = #[json:eecsalaryorhourly], eecpaygroup = #[json:eecpaygroup],
                    eecjobcode = #[json:eecjobcode], eecfulltimeorparttime = #[json:eecfulltimeorparttime],
                    eecearngroupcode = #[json:eecearngroupcode], eecdebgroupcode = #[json:eecdebgroupcode],
                    accuraloption = #[json:accuraloption] WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="deleteJobTitle"
                    value="DELETE FROM JOBTITLELOOKUPTABLE WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="insertEmployee"
                    value="INSERT INTO previousEmployees_stage VALUES(#[map-payload:employeeID], #[map-payload:SSN],
                    #[map-payload:FirstName], #[map-payload:LastName], #[map-payload:DOB])"/>
        <jdbc:query key="deleteEmployeeTable_stage"
                    value="DELETE FROM previousEmployees_stage"/>
        <jdbc:query key="moveEmployeesFromStage"
                    value="DELETE FROM previousEmployees; INSERT INTO previousEmployee SELECT * FROM previousEmployees_stag"/>
    </jdbc:connector>

    <file:connector name="append" outputAppend="true"/>
    <file:connector name="normal"/>

    <quartz:connector name="quartzJobStore">
        <quartz:factory-property key="org.quartz.jobStore.class" value="org.quartz.impl.jdbcjobstore.JobStoreTX"/>
        <quartz:factory-property key="org.quartz.jobStore.driverDelegateClass"
                                 value="org.quartz.impl.jdbcjobstore.StdJDBCDelegate"/>
        <quartz:factory-property key="org.quartz.jobStore.dataSource" value="myDS"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.connectionProvider.class"
                                 value="org.mule.transport.quartz.config.MuleFriendlyConnectionProvider"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.driver" value="com.mysql.jdbc.Driver"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.URL"
                                 value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.user" value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.password" value="...."/>
        <quartz:factory-property key="org.quartz.scheduler.threadsInheritContextClassLoaderOfInitializer" value="true"/>
    </quartz:connector>

    <script:transformer name="genderMappingTransformer">
        <script:script engine="groovy">
            if (payload == "Male")
            {
                return "M";
            }
            else if (payload == "Female")
            {
                return "F";
            }
        </script:script>
    </script:transformer>

    <object-to-string-transformer name="objectToString"/>

    <flow name="ReadInEmployees">
        <file:inbound-endpoint path="/temp/ftpfiles" pollingFrequency="1000" connector-ref="normal"/>

        <jdbc:outbound-endpoint queryKey="deleteEmployeeTable_stage" exchange-pattern="request-response"/>

        <vm:outbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <jdbc:outbound-endpoint queryKey="moveEmployeesFromStage" exchange-pattern="request-response"/>

    </flow>

    <flow name="ReadInEmployees.split">
        <vm:inbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <splitter evaluator="string" expression="\n"/>

        <datapack:delimited-to-map-transformer delimiter=",">
            <datapack:column column-name="employeeID"/>
            <datapack:column column-name="SSN"/>
            <datapack:column column-name="FirstName"/>
            <datapack:column column-name="MiddleName"/>
            <datapack:column column-name="LastName"/>
            <datapack:column column-name="Location"/>
            <datapack:column column-name="DOB"/>
        </datapack:delimited-to-map-transformer>

        <jdbc:outbound-endpoint queryKey="insertEmployee" exchange-pattern="request-response"/>

    </flow>
</mule>

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>             Fix For: 3.1.3
>
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=40538#comment-40538 ]

Roko Kruze edited comment on MULE-5351 at 5/23/11 11:21 PM:
------------------------------------------------------------

My config looks like the following:

{code:xml}
<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesoft.org/schema/mule/core"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:spring="http://www.springframework.org/schema/beans"
      xmlns:file="http://www.mulesoft.org/schema/mule/file"
      xmlns:vm="http://www.mulesoft.org/schema/mule/vm"
      xmlns:mule-xml="http://www.mulesoft.org/schema/mule/xml"
      xmlns:datapack="http://www.mulesoft.org/schema/mule/datapack"
      xmlns:quartz="http://www.mulesoft.org/schema/mule/quartz"
      xmlns:pm="http://www.mulesoft.org/schema/mule/peoplematter"
      xmlns:jdbc="http://www.mulesoft.org/schema/mule/jdbc"
      xmlns:http="http://www.mulesoft.org/schema/mule/http"
      xmlns:script="http://www.mulesoft.org/schema/mule/scripting"
      xmlns:mule-ss="http://www.mulesoft.org/schema/mule/spring-security"
      xmlns:ss="http://www.springframework.org/schema/security"
      xmlns:json="http://www.mulesoft.org/schema/mule/json"
      xsi:schemaLocation="
        http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/3.1/mule.xsd
        http://www.mulesoft.org/schema/mule/file http://www.mulesoft.org/schema/mule/file/3.1/mule-file.xsd
        http://www.mulesoft.org/schema/mule/vm http://www.mulesoft.org/schema/mule/vm/3.1/mule-vm.xsd
        http://www.mulesoft.org/schema/mule/xml http://www.mulesoft.org/schema/mule/xml/3.1/mule-xml.xsd
        http://www.mulesoft.org/schema/mule/datapack http://www.mulesoft.org/schema/mule/datapack/3.1/mule-datapack.xsd
        http://www.mulesoft.org/schema/mule/quartz http://www.mulesoft.org/schema/mule/quartz/3.1/mule-quartz.xsd
        http://www.mulesoft.org/schema/mule/peoplematter http://www.mulesoft.org/schema/mule/peoplematter/3.1/mule-peoplematter.xsd
        http://www.mulesoft.org/schema/mule/jdbc http://www.mulesoft.org/schema/mule/jdbc/3.1/mule-jdbc.xsd
        http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/3.1/mule-http.xsd
        http://www.mulesoft.org/schema/mule/scripting http://www.mulesoft.org/schema/mule/scripting/3.1/mule-scripting.xsd
        http://www.mulesoft.org/schema/mule/spring-security http://www.mulesoft.org/schema/mule/spring-security/3.1/mule-spring-security.xsd
        http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd
        http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/3.1/mule-json.xsd">

    <description>
        People Matter Testing
    </description>

    <mule-ss:security-manager>
        <mule-ss:delegate-security-provider name="memory-provider" delegate-ref="authenticationManager"/>
    </mule-ss:security-manager>

    <spring:beans>
        <ss:authentication-manager alias="authenticationManager">
            <ss:authentication-provider>
                <ss:user-service id="userService">
                   <!-- user info -->
                </ss:user-service>
            </ss:authentication-provider>
        </ss:authentication-manager>
    </spring:beans>

    <mule-xml:namespace-manager>
        <mule-xml:namespace prefix="hrxml" uri="http://www.hr-xml.org/3"/>
        <mule-xml:namespace prefix="oagis" uri="http://www.openapplications.org/oagis/9"/>
        <mule-xml:namespace prefix="pm" uri="http://www.peoplematter.com/release/1"/>
    </mule-xml:namespace-manager>

    <spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
        <spring:property name="driverName" value="com.mysql.jdbc.Driver"/>
        <spring:property name="url" value="...."/>
        <spring:property name="user" value="...."/>
        <spring:property name="password" value="...."/>
    </spring:bean>

    <jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
        <jdbc:query key="lookupJobTitleQuery"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JobTitle = #[xpath://hrxml:MasterPosition/hrxml:PositionTitle]"/>
        <jdbc:query key="lookupEmergencyContactQuery"
                    value="select * from EMERGENCYCONTACTLOOKUP WHERE PMDESCRIPTION = #[xpath://pm:EmergencyContactUserArea/pm:Relationship]"/>
        <jdbc:query key="lookupEthnicityMapping"
                    value="select * from ethnicityMapping WHERE PEOPLEMATTER = #[xpath://hrxml:EthnicityCode]"/>
        <jdbc:query key="selectJobTitle"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE"/>
        <jdbc:query key="selectJobTitleFromName"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLE = #[json:jobtitle]"/>
        <jdbc:query key="selectJobTitleFromID"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLEID = #[json:jobtitleid]"/>
        <jdbc:query key="createJobTitle"
                    value="INSERT INTO JOBTITLELOOKUPTABLE (JOBTITLE) VALUES(#[json:jobtitle]);"/>
        <jdbc:query key="updateJobTitles"
                    value="UPDATE JOBTITLELOOKUPTABLE SET orglvl1 = #[json:orglvl1], jobtitle = #[json:jobtitle],
                    isautopaid = #[json:isautopaid], eecscheduledworkhrs = #[json:eecscheduledworkhrs],
                    eecsalaryorhourly = #[json:eecsalaryorhourly], eecpaygroup = #[json:eecpaygroup],
                    eecjobcode = #[json:eecjobcode], eecfulltimeorparttime = #[json:eecfulltimeorparttime],
                    eecearngroupcode = #[json:eecearngroupcode], eecdebgroupcode = #[json:eecdebgroupcode],
                    accuraloption = #[json:accuraloption] WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="deleteJobTitle"
                    value="DELETE FROM JOBTITLELOOKUPTABLE WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="insertEmployee"
                    value="INSERT INTO previousEmployees_stage VALUES(#[map-payload:employeeID], #[map-payload:SSN],
                    #[map-payload:FirstName], #[map-payload:LastName], #[map-payload:DOB])"/>
        <jdbc:query key="deleteEmployeeTable_stage"
                    value="DELETE FROM previousEmployees_stage"/>
        <jdbc:query key="moveEmployeesFromStage"
                    value="DELETE FROM previousEmployees; INSERT INTO previousEmployee SELECT * FROM previousEmployees_stag"/>
    </jdbc:connector>

    <file:connector name="append" outputAppend="true"/>
    <file:connector name="normal"/>

    <quartz:connector name="quartzJobStore">
        <quartz:factory-property key="org.quartz.jobStore.class" value="org.quartz.impl.jdbcjobstore.JobStoreTX"/>
        <quartz:factory-property key="org.quartz.jobStore.driverDelegateClass"
                                 value="org.quartz.impl.jdbcjobstore.StdJDBCDelegate"/>
        <quartz:factory-property key="org.quartz.jobStore.dataSource" value="myDS"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.connectionProvider.class"
                                 value="org.mule.transport.quartz.config.MuleFriendlyConnectionProvider"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.driver" value="com.mysql.jdbc.Driver"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.URL"
                                 value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.user" value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.password" value="...."/>
        <quartz:factory-property key="org.quartz.scheduler.threadsInheritContextClassLoaderOfInitializer" value="true"/>
    </quartz:connector>

    <script:transformer name="genderMappingTransformer">
        <script:script engine="groovy">
            if (payload == "Male")
            {
                return "M";
            }
            else if (payload == "Female")
            {
                return "F";
            }
        </script:script>
    </script:transformer>

    <object-to-string-transformer name="objectToString"/>

    <flow name="ReadInEmployees">
        <file:inbound-endpoint path="/temp/ftpfiles" pollingFrequency="1000" connector-ref="normal"/>

        <jdbc:outbound-endpoint queryKey="deleteEmployeeTable_stage" exchange-pattern="request-response"/>

        <vm:outbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <jdbc:outbound-endpoint queryKey="moveEmployeesFromStage" exchange-pattern="request-response"/>

    </flow>

    <flow name="ReadInEmployees.split">
        <vm:inbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <splitter evaluator="string" expression="\n"/>

        <datapack:delimited-to-map-transformer delimiter=",">
            <datapack:column column-name="employeeID"/>
            <datapack:column column-name="SSN"/>
            <datapack:column column-name="FirstName"/>
            <datapack:column column-name="MiddleName"/>
            <datapack:column column-name="LastName"/>
            <datapack:column column-name="Location"/>
            <datapack:column column-name="DOB"/>
        </datapack:delimited-to-map-transformer>

        <jdbc:outbound-endpoint queryKey="insertEmployee" exchange-pattern="request-response"/>

    </flow>
</mule>
{code:xml}

      was (Author: rkruze):
    My config looks like the following:


<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesoft.org/schema/mule/core"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:spring="http://www.springframework.org/schema/beans"
      xmlns:file="http://www.mulesoft.org/schema/mule/file"
      xmlns:vm="http://www.mulesoft.org/schema/mule/vm"
      xmlns:mule-xml="http://www.mulesoft.org/schema/mule/xml"
      xmlns:datapack="http://www.mulesoft.org/schema/mule/datapack"
      xmlns:quartz="http://www.mulesoft.org/schema/mule/quartz"
      xmlns:pm="http://www.mulesoft.org/schema/mule/peoplematter"
      xmlns:jdbc="http://www.mulesoft.org/schema/mule/jdbc"
      xmlns:http="http://www.mulesoft.org/schema/mule/http"
      xmlns:script="http://www.mulesoft.org/schema/mule/scripting"
      xmlns:mule-ss="http://www.mulesoft.org/schema/mule/spring-security"
      xmlns:ss="http://www.springframework.org/schema/security"
      xmlns:json="http://www.mulesoft.org/schema/mule/json"
      xsi:schemaLocation="
        http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/3.1/mule.xsd
        http://www.mulesoft.org/schema/mule/file http://www.mulesoft.org/schema/mule/file/3.1/mule-file.xsd
        http://www.mulesoft.org/schema/mule/vm http://www.mulesoft.org/schema/mule/vm/3.1/mule-vm.xsd
        http://www.mulesoft.org/schema/mule/xml http://www.mulesoft.org/schema/mule/xml/3.1/mule-xml.xsd
        http://www.mulesoft.org/schema/mule/datapack http://www.mulesoft.org/schema/mule/datapack/3.1/mule-datapack.xsd
        http://www.mulesoft.org/schema/mule/quartz http://www.mulesoft.org/schema/mule/quartz/3.1/mule-quartz.xsd
        http://www.mulesoft.org/schema/mule/peoplematter http://www.mulesoft.org/schema/mule/peoplematter/3.1/mule-peoplematter.xsd
        http://www.mulesoft.org/schema/mule/jdbc http://www.mulesoft.org/schema/mule/jdbc/3.1/mule-jdbc.xsd
        http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/3.1/mule-http.xsd
        http://www.mulesoft.org/schema/mule/scripting http://www.mulesoft.org/schema/mule/scripting/3.1/mule-scripting.xsd
        http://www.mulesoft.org/schema/mule/spring-security http://www.mulesoft.org/schema/mule/spring-security/3.1/mule-spring-security.xsd
        http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd
        http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/3.1/mule-json.xsd">

    <description>
        People Matter Testing
    </description>

    <mule-ss:security-manager>
        <mule-ss:delegate-security-provider name="memory-provider" delegate-ref="authenticationManager"/>
    </mule-ss:security-manager>

    <spring:beans>
        <ss:authentication-manager alias="authenticationManager">
            <ss:authentication-provider>
                <ss:user-service id="userService">
                   <!-- user info -->
                </ss:user-service>
            </ss:authentication-provider>
        </ss:authentication-manager>
    </spring:beans>

    <mule-xml:namespace-manager>
        <mule-xml:namespace prefix="hrxml" uri="http://www.hr-xml.org/3"/>
        <mule-xml:namespace prefix="oagis" uri="http://www.openapplications.org/oagis/9"/>
        <mule-xml:namespace prefix="pm" uri="http://www.peoplematter.com/release/1"/>
    </mule-xml:namespace-manager>

    <spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
        <spring:property name="driverName" value="com.mysql.jdbc.Driver"/>
        <spring:property name="url" value="...."/>
        <spring:property name="user" value="...."/>
        <spring:property name="password" value="...."/>
    </spring:bean>

    <jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
        <jdbc:query key="lookupJobTitleQuery"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JobTitle = #[xpath://hrxml:MasterPosition/hrxml:PositionTitle]"/>
        <jdbc:query key="lookupEmergencyContactQuery"
                    value="select * from EMERGENCYCONTACTLOOKUP WHERE PMDESCRIPTION = #[xpath://pm:EmergencyContactUserArea/pm:Relationship]"/>
        <jdbc:query key="lookupEthnicityMapping"
                    value="select * from ethnicityMapping WHERE PEOPLEMATTER = #[xpath://hrxml:EthnicityCode]"/>
        <jdbc:query key="selectJobTitle"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE"/>
        <jdbc:query key="selectJobTitleFromName"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLE = #[json:jobtitle]"/>
        <jdbc:query key="selectJobTitleFromID"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLEID = #[json:jobtitleid]"/>
        <jdbc:query key="createJobTitle"
                    value="INSERT INTO JOBTITLELOOKUPTABLE (JOBTITLE) VALUES(#[json:jobtitle]);"/>
        <jdbc:query key="updateJobTitles"
                    value="UPDATE JOBTITLELOOKUPTABLE SET orglvl1 = #[json:orglvl1], jobtitle = #[json:jobtitle],
                    isautopaid = #[json:isautopaid], eecscheduledworkhrs = #[json:eecscheduledworkhrs],
                    eecsalaryorhourly = #[json:eecsalaryorhourly], eecpaygroup = #[json:eecpaygroup],
                    eecjobcode = #[json:eecjobcode], eecfulltimeorparttime = #[json:eecfulltimeorparttime],
                    eecearngroupcode = #[json:eecearngroupcode], eecdebgroupcode = #[json:eecdebgroupcode],
                    accuraloption = #[json:accuraloption] WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="deleteJobTitle"
                    value="DELETE FROM JOBTITLELOOKUPTABLE WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="insertEmployee"
                    value="INSERT INTO previousEmployees_stage VALUES(#[map-payload:employeeID], #[map-payload:SSN],
                    #[map-payload:FirstName], #[map-payload:LastName], #[map-payload:DOB])"/>
        <jdbc:query key="deleteEmployeeTable_stage"
                    value="DELETE FROM previousEmployees_stage"/>
        <jdbc:query key="moveEmployeesFromStage"
                    value="DELETE FROM previousEmployees; INSERT INTO previousEmployee SELECT * FROM previousEmployees_stag"/>
    </jdbc:connector>

    <file:connector name="append" outputAppend="true"/>
    <file:connector name="normal"/>

    <quartz:connector name="quartzJobStore">
        <quartz:factory-property key="org.quartz.jobStore.class" value="org.quartz.impl.jdbcjobstore.JobStoreTX"/>
        <quartz:factory-property key="org.quartz.jobStore.driverDelegateClass"
                                 value="org.quartz.impl.jdbcjobstore.StdJDBCDelegate"/>
        <quartz:factory-property key="org.quartz.jobStore.dataSource" value="myDS"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.connectionProvider.class"
                                 value="org.mule.transport.quartz.config.MuleFriendlyConnectionProvider"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.driver" value="com.mysql.jdbc.Driver"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.URL"
                                 value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.user" value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.password" value="...."/>
        <quartz:factory-property key="org.quartz.scheduler.threadsInheritContextClassLoaderOfInitializer" value="true"/>
    </quartz:connector>

    <script:transformer name="genderMappingTransformer">
        <script:script engine="groovy">
            if (payload == "Male")
            {
                return "M";
            }
            else if (payload == "Female")
            {
                return "F";
            }
        </script:script>
    </script:transformer>

    <object-to-string-transformer name="objectToString"/>

    <flow name="ReadInEmployees">
        <file:inbound-endpoint path="/temp/ftpfiles" pollingFrequency="1000" connector-ref="normal"/>

        <jdbc:outbound-endpoint queryKey="deleteEmployeeTable_stage" exchange-pattern="request-response"/>

        <vm:outbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <jdbc:outbound-endpoint queryKey="moveEmployeesFromStage" exchange-pattern="request-response"/>

    </flow>

    <flow name="ReadInEmployees.split">
        <vm:inbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <splitter evaluator="string" expression="\n"/>

        <datapack:delimited-to-map-transformer delimiter=",">
            <datapack:column column-name="employeeID"/>
            <datapack:column column-name="SSN"/>
            <datapack:column column-name="FirstName"/>
            <datapack:column column-name="MiddleName"/>
            <datapack:column column-name="LastName"/>
            <datapack:column column-name="Location"/>
            <datapack:column column-name="DOB"/>
        </datapack:delimited-to-map-transformer>

        <jdbc:outbound-endpoint queryKey="insertEmployee" exchange-pattern="request-response"/>

    </flow>
</mule>

 

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>             Fix For: 3.1.3
>
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=40538#comment-40538 ]

Roko Kruze edited comment on MULE-5351 at 5/23/11 11:21 PM:
------------------------------------------------------------

My config looks like the following:

{code}
<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesoft.org/schema/mule/core"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:spring="http://www.springframework.org/schema/beans"
      xmlns:file="http://www.mulesoft.org/schema/mule/file"
      xmlns:vm="http://www.mulesoft.org/schema/mule/vm"
      xmlns:mule-xml="http://www.mulesoft.org/schema/mule/xml"
      xmlns:datapack="http://www.mulesoft.org/schema/mule/datapack"
      xmlns:quartz="http://www.mulesoft.org/schema/mule/quartz"
      xmlns:pm="http://www.mulesoft.org/schema/mule/peoplematter"
      xmlns:jdbc="http://www.mulesoft.org/schema/mule/jdbc"
      xmlns:http="http://www.mulesoft.org/schema/mule/http"
      xmlns:script="http://www.mulesoft.org/schema/mule/scripting"
      xmlns:mule-ss="http://www.mulesoft.org/schema/mule/spring-security"
      xmlns:ss="http://www.springframework.org/schema/security"
      xmlns:json="http://www.mulesoft.org/schema/mule/json"
      xsi:schemaLocation="
        http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/3.1/mule.xsd
        http://www.mulesoft.org/schema/mule/file http://www.mulesoft.org/schema/mule/file/3.1/mule-file.xsd
        http://www.mulesoft.org/schema/mule/vm http://www.mulesoft.org/schema/mule/vm/3.1/mule-vm.xsd
        http://www.mulesoft.org/schema/mule/xml http://www.mulesoft.org/schema/mule/xml/3.1/mule-xml.xsd
        http://www.mulesoft.org/schema/mule/datapack http://www.mulesoft.org/schema/mule/datapack/3.1/mule-datapack.xsd
        http://www.mulesoft.org/schema/mule/quartz http://www.mulesoft.org/schema/mule/quartz/3.1/mule-quartz.xsd
        http://www.mulesoft.org/schema/mule/peoplematter http://www.mulesoft.org/schema/mule/peoplematter/3.1/mule-peoplematter.xsd
        http://www.mulesoft.org/schema/mule/jdbc http://www.mulesoft.org/schema/mule/jdbc/3.1/mule-jdbc.xsd
        http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/3.1/mule-http.xsd
        http://www.mulesoft.org/schema/mule/scripting http://www.mulesoft.org/schema/mule/scripting/3.1/mule-scripting.xsd
        http://www.mulesoft.org/schema/mule/spring-security http://www.mulesoft.org/schema/mule/spring-security/3.1/mule-spring-security.xsd
        http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd
        http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/3.1/mule-json.xsd">

    <description>
        People Matter Testing
    </description>

    <mule-ss:security-manager>
        <mule-ss:delegate-security-provider name="memory-provider" delegate-ref="authenticationManager"/>
    </mule-ss:security-manager>

    <spring:beans>
        <ss:authentication-manager alias="authenticationManager">
            <ss:authentication-provider>
                <ss:user-service id="userService">
                   <!-- user info -->
                </ss:user-service>
            </ss:authentication-provider>
        </ss:authentication-manager>
    </spring:beans>

    <mule-xml:namespace-manager>
        <mule-xml:namespace prefix="hrxml" uri="http://www.hr-xml.org/3"/>
        <mule-xml:namespace prefix="oagis" uri="http://www.openapplications.org/oagis/9"/>
        <mule-xml:namespace prefix="pm" uri="http://www.peoplematter.com/release/1"/>
    </mule-xml:namespace-manager>

    <spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
        <spring:property name="driverName" value="com.mysql.jdbc.Driver"/>
        <spring:property name="url" value="...."/>
        <spring:property name="user" value="...."/>
        <spring:property name="password" value="...."/>
    </spring:bean>

    <jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
        <jdbc:query key="lookupJobTitleQuery"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JobTitle = #[xpath://hrxml:MasterPosition/hrxml:PositionTitle]"/>
        <jdbc:query key="lookupEmergencyContactQuery"
                    value="select * from EMERGENCYCONTACTLOOKUP WHERE PMDESCRIPTION = #[xpath://pm:EmergencyContactUserArea/pm:Relationship]"/>
        <jdbc:query key="lookupEthnicityMapping"
                    value="select * from ethnicityMapping WHERE PEOPLEMATTER = #[xpath://hrxml:EthnicityCode]"/>
        <jdbc:query key="selectJobTitle"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE"/>
        <jdbc:query key="selectJobTitleFromName"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLE = #[json:jobtitle]"/>
        <jdbc:query key="selectJobTitleFromID"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLEID = #[json:jobtitleid]"/>
        <jdbc:query key="createJobTitle"
                    value="INSERT INTO JOBTITLELOOKUPTABLE (JOBTITLE) VALUES(#[json:jobtitle]);"/>
        <jdbc:query key="updateJobTitles"
                    value="UPDATE JOBTITLELOOKUPTABLE SET orglvl1 = #[json:orglvl1], jobtitle = #[json:jobtitle],
                    isautopaid = #[json:isautopaid], eecscheduledworkhrs = #[json:eecscheduledworkhrs],
                    eecsalaryorhourly = #[json:eecsalaryorhourly], eecpaygroup = #[json:eecpaygroup],
                    eecjobcode = #[json:eecjobcode], eecfulltimeorparttime = #[json:eecfulltimeorparttime],
                    eecearngroupcode = #[json:eecearngroupcode], eecdebgroupcode = #[json:eecdebgroupcode],
                    accuraloption = #[json:accuraloption] WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="deleteJobTitle"
                    value="DELETE FROM JOBTITLELOOKUPTABLE WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="insertEmployee"
                    value="INSERT INTO previousEmployees_stage VALUES(#[map-payload:employeeID], #[map-payload:SSN],
                    #[map-payload:FirstName], #[map-payload:LastName], #[map-payload:DOB])"/>
        <jdbc:query key="deleteEmployeeTable_stage"
                    value="DELETE FROM previousEmployees_stage"/>
        <jdbc:query key="moveEmployeesFromStage"
                    value="DELETE FROM previousEmployees; INSERT INTO previousEmployee SELECT * FROM previousEmployees_stag"/>
    </jdbc:connector>

    <file:connector name="append" outputAppend="true"/>
    <file:connector name="normal"/>

    <quartz:connector name="quartzJobStore">
        <quartz:factory-property key="org.quartz.jobStore.class" value="org.quartz.impl.jdbcjobstore.JobStoreTX"/>
        <quartz:factory-property key="org.quartz.jobStore.driverDelegateClass"
                                 value="org.quartz.impl.jdbcjobstore.StdJDBCDelegate"/>
        <quartz:factory-property key="org.quartz.jobStore.dataSource" value="myDS"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.connectionProvider.class"
                                 value="org.mule.transport.quartz.config.MuleFriendlyConnectionProvider"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.driver" value="com.mysql.jdbc.Driver"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.URL"
                                 value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.user" value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.password" value="...."/>
        <quartz:factory-property key="org.quartz.scheduler.threadsInheritContextClassLoaderOfInitializer" value="true"/>
    </quartz:connector>

    <script:transformer name="genderMappingTransformer">
        <script:script engine="groovy">
            if (payload == "Male")
            {
                return "M";
            }
            else if (payload == "Female")
            {
                return "F";
            }
        </script:script>
    </script:transformer>

    <object-to-string-transformer name="objectToString"/>

    <flow name="ReadInEmployees">
        <file:inbound-endpoint path="/temp/ftpfiles" pollingFrequency="1000" connector-ref="normal"/>

        <jdbc:outbound-endpoint queryKey="deleteEmployeeTable_stage" exchange-pattern="request-response"/>

        <vm:outbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <jdbc:outbound-endpoint queryKey="moveEmployeesFromStage" exchange-pattern="request-response"/>

    </flow>

    <flow name="ReadInEmployees.split">
        <vm:inbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <splitter evaluator="string" expression="\n"/>

        <datapack:delimited-to-map-transformer delimiter=",">
            <datapack:column column-name="employeeID"/>
            <datapack:column column-name="SSN"/>
            <datapack:column column-name="FirstName"/>
            <datapack:column column-name="MiddleName"/>
            <datapack:column column-name="LastName"/>
            <datapack:column column-name="Location"/>
            <datapack:column column-name="DOB"/>
        </datapack:delimited-to-map-transformer>

        <jdbc:outbound-endpoint queryKey="insertEmployee" exchange-pattern="request-response"/>

    </flow>
</mule>
{code}

      was (Author: rkruze):
    My config looks like the following:

{code:xml}
<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesoft.org/schema/mule/core"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:spring="http://www.springframework.org/schema/beans"
      xmlns:file="http://www.mulesoft.org/schema/mule/file"
      xmlns:vm="http://www.mulesoft.org/schema/mule/vm"
      xmlns:mule-xml="http://www.mulesoft.org/schema/mule/xml"
      xmlns:datapack="http://www.mulesoft.org/schema/mule/datapack"
      xmlns:quartz="http://www.mulesoft.org/schema/mule/quartz"
      xmlns:pm="http://www.mulesoft.org/schema/mule/peoplematter"
      xmlns:jdbc="http://www.mulesoft.org/schema/mule/jdbc"
      xmlns:http="http://www.mulesoft.org/schema/mule/http"
      xmlns:script="http://www.mulesoft.org/schema/mule/scripting"
      xmlns:mule-ss="http://www.mulesoft.org/schema/mule/spring-security"
      xmlns:ss="http://www.springframework.org/schema/security"
      xmlns:json="http://www.mulesoft.org/schema/mule/json"
      xsi:schemaLocation="
        http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/3.1/mule.xsd
        http://www.mulesoft.org/schema/mule/file http://www.mulesoft.org/schema/mule/file/3.1/mule-file.xsd
        http://www.mulesoft.org/schema/mule/vm http://www.mulesoft.org/schema/mule/vm/3.1/mule-vm.xsd
        http://www.mulesoft.org/schema/mule/xml http://www.mulesoft.org/schema/mule/xml/3.1/mule-xml.xsd
        http://www.mulesoft.org/schema/mule/datapack http://www.mulesoft.org/schema/mule/datapack/3.1/mule-datapack.xsd
        http://www.mulesoft.org/schema/mule/quartz http://www.mulesoft.org/schema/mule/quartz/3.1/mule-quartz.xsd
        http://www.mulesoft.org/schema/mule/peoplematter http://www.mulesoft.org/schema/mule/peoplematter/3.1/mule-peoplematter.xsd
        http://www.mulesoft.org/schema/mule/jdbc http://www.mulesoft.org/schema/mule/jdbc/3.1/mule-jdbc.xsd
        http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/3.1/mule-http.xsd
        http://www.mulesoft.org/schema/mule/scripting http://www.mulesoft.org/schema/mule/scripting/3.1/mule-scripting.xsd
        http://www.mulesoft.org/schema/mule/spring-security http://www.mulesoft.org/schema/mule/spring-security/3.1/mule-spring-security.xsd
        http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd
        http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/3.1/mule-json.xsd">

    <description>
        People Matter Testing
    </description>

    <mule-ss:security-manager>
        <mule-ss:delegate-security-provider name="memory-provider" delegate-ref="authenticationManager"/>
    </mule-ss:security-manager>

    <spring:beans>
        <ss:authentication-manager alias="authenticationManager">
            <ss:authentication-provider>
                <ss:user-service id="userService">
                   <!-- user info -->
                </ss:user-service>
            </ss:authentication-provider>
        </ss:authentication-manager>
    </spring:beans>

    <mule-xml:namespace-manager>
        <mule-xml:namespace prefix="hrxml" uri="http://www.hr-xml.org/3"/>
        <mule-xml:namespace prefix="oagis" uri="http://www.openapplications.org/oagis/9"/>
        <mule-xml:namespace prefix="pm" uri="http://www.peoplematter.com/release/1"/>
    </mule-xml:namespace-manager>

    <spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
        <spring:property name="driverName" value="com.mysql.jdbc.Driver"/>
        <spring:property name="url" value="...."/>
        <spring:property name="user" value="...."/>
        <spring:property name="password" value="...."/>
    </spring:bean>

    <jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
        <jdbc:query key="lookupJobTitleQuery"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JobTitle = #[xpath://hrxml:MasterPosition/hrxml:PositionTitle]"/>
        <jdbc:query key="lookupEmergencyContactQuery"
                    value="select * from EMERGENCYCONTACTLOOKUP WHERE PMDESCRIPTION = #[xpath://pm:EmergencyContactUserArea/pm:Relationship]"/>
        <jdbc:query key="lookupEthnicityMapping"
                    value="select * from ethnicityMapping WHERE PEOPLEMATTER = #[xpath://hrxml:EthnicityCode]"/>
        <jdbc:query key="selectJobTitle"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE"/>
        <jdbc:query key="selectJobTitleFromName"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLE = #[json:jobtitle]"/>
        <jdbc:query key="selectJobTitleFromID"
                    value="SELECT * FROM JOBTITLELOOKUPTABLE WHERE JOBTITLEID = #[json:jobtitleid]"/>
        <jdbc:query key="createJobTitle"
                    value="INSERT INTO JOBTITLELOOKUPTABLE (JOBTITLE) VALUES(#[json:jobtitle]);"/>
        <jdbc:query key="updateJobTitles"
                    value="UPDATE JOBTITLELOOKUPTABLE SET orglvl1 = #[json:orglvl1], jobtitle = #[json:jobtitle],
                    isautopaid = #[json:isautopaid], eecscheduledworkhrs = #[json:eecscheduledworkhrs],
                    eecsalaryorhourly = #[json:eecsalaryorhourly], eecpaygroup = #[json:eecpaygroup],
                    eecjobcode = #[json:eecjobcode], eecfulltimeorparttime = #[json:eecfulltimeorparttime],
                    eecearngroupcode = #[json:eecearngroupcode], eecdebgroupcode = #[json:eecdebgroupcode],
                    accuraloption = #[json:accuraloption] WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="deleteJobTitle"
                    value="DELETE FROM JOBTITLELOOKUPTABLE WHERE jobtitleid = #[json:jobtitleid]"/>
        <jdbc:query key="insertEmployee"
                    value="INSERT INTO previousEmployees_stage VALUES(#[map-payload:employeeID], #[map-payload:SSN],
                    #[map-payload:FirstName], #[map-payload:LastName], #[map-payload:DOB])"/>
        <jdbc:query key="deleteEmployeeTable_stage"
                    value="DELETE FROM previousEmployees_stage"/>
        <jdbc:query key="moveEmployeesFromStage"
                    value="DELETE FROM previousEmployees; INSERT INTO previousEmployee SELECT * FROM previousEmployees_stag"/>
    </jdbc:connector>

    <file:connector name="append" outputAppend="true"/>
    <file:connector name="normal"/>

    <quartz:connector name="quartzJobStore">
        <quartz:factory-property key="org.quartz.jobStore.class" value="org.quartz.impl.jdbcjobstore.JobStoreTX"/>
        <quartz:factory-property key="org.quartz.jobStore.driverDelegateClass"
                                 value="org.quartz.impl.jdbcjobstore.StdJDBCDelegate"/>
        <quartz:factory-property key="org.quartz.jobStore.dataSource" value="myDS"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.connectionProvider.class"
                                 value="org.mule.transport.quartz.config.MuleFriendlyConnectionProvider"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.driver" value="com.mysql.jdbc.Driver"/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.URL"
                                 value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.user" value="...."/>
        <quartz:factory-property key="org.quartz.dataSource.myDS.password" value="...."/>
        <quartz:factory-property key="org.quartz.scheduler.threadsInheritContextClassLoaderOfInitializer" value="true"/>
    </quartz:connector>

    <script:transformer name="genderMappingTransformer">
        <script:script engine="groovy">
            if (payload == "Male")
            {
                return "M";
            }
            else if (payload == "Female")
            {
                return "F";
            }
        </script:script>
    </script:transformer>

    <object-to-string-transformer name="objectToString"/>

    <flow name="ReadInEmployees">
        <file:inbound-endpoint path="/temp/ftpfiles" pollingFrequency="1000" connector-ref="normal"/>

        <jdbc:outbound-endpoint queryKey="deleteEmployeeTable_stage" exchange-pattern="request-response"/>

        <vm:outbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <jdbc:outbound-endpoint queryKey="moveEmployeesFromStage" exchange-pattern="request-response"/>

    </flow>

    <flow name="ReadInEmployees.split">
        <vm:inbound-endpoint path="ReadInEmployees" exchange-pattern="request-response"/>

        <splitter evaluator="string" expression="\n"/>

        <datapack:delimited-to-map-transformer delimiter=",">
            <datapack:column column-name="employeeID"/>
            <datapack:column column-name="SSN"/>
            <datapack:column column-name="FirstName"/>
            <datapack:column column-name="MiddleName"/>
            <datapack:column column-name="LastName"/>
            <datapack:column column-name="Location"/>
            <datapack:column column-name="DOB"/>
        </datapack:delimited-to-map-transformer>

        <jdbc:outbound-endpoint queryKey="insertEmployee" exchange-pattern="request-response"/>

    </flow>
</mule>
{code:xml}
 

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>             Fix For: 3.1.3
>
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

     [ http://www.mulesoft.org/jira/browse/MULE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrew Perepelytsya closed MULE-5351.
-------------------------------------

    Fix Version/s:     (was: 3.1.3)
       Resolution: Won't Fix or Usage Issue

Roko, please file new jiras for reported problems.

> JDBC driver found but is not loaded
> -----------------------------------
>
>                 Key: MULE-5351
>                 URL: http://www.mulesoft.org/jira/browse/MULE-5351
>             Project: Mule
>          Issue Type: Bug
>          Components: Core: Deployment
>    Affects Versions: 3.1.0
>            Reporter: Daniel Zapata
>            Assignee: Andrew Perepelytsya
>            Priority: Major
>
> I created a Mule application using the JDBC transport and copied the JDBC client jar to the <MULE_HOME>/apps/app-name/lib directory.  When I start Mule, it reports that it found the driver jar, but then later says it failed to load the driver.  See the log output section.  If I copy the jar to the <MULE_HOME>/lib/user directory instead, the application works fine.

--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[I82Much]

I'm having the exact same problem.  I'm not using a JDBC endpoint or anything, but instead I manually create a JDBC connection within my Component.  My output shows the MySQL connector being loaded:

INFO 2011-06-09 16:12:27,976 WrapperListener_start_runner org.mule.module.launcher.MuleApplicationClassLoader: XMLPlayer Loading the following jars:
=============================

file:/opt/local/Mule/mule-standalone-3.1.1/apps/XMLPlayer/lib/mysql-connector-java-5.1.13-bin.jar


but when I attempt to establish a connection:


WARN 2011-06-09 15:56:12,130 [http://XMLPlayer].connector.http.mule.default.receiver.2 org.hibernate.cfg.SettingsFactory: Could not obtain connection to query metadata
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/db


As soon as I move/copy the mysql-connector-java-5.1.13-bin.jar file into the lib/endorsed folder instead of leaving it in my app's lib folder, the connection works perfectly.