DO NOT REPLY [Bug 10090] New: - ant sql cause UnsatisfiedLinkError when using oracle oci driver.

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10090>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10090

ant sql cause UnsatisfiedLinkError when using oracle oci driver.

           Summary: ant sql cause UnsatisfiedLinkError when using oracle oci
                    driver.
           Product: Ant
           Version: 1.5Beta2
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Major
          Priority: Other
         Component: Core tasks
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


If I use Oracle OCI driver, the sql will fail when it runs the second time. if 
I changed to use thin driver, it will be ok.

The script to test it is:

<project name="dts-run" default="test" basedir=".">
<!--
        <property name="project.dburl" 
value="jdbc:oracle:thin:@oracle.point2.com.:1521:migrate"/>
-->
        <property name="project.dburl" 
value="jdbc:oracle:oci8:@MIGRATE.POINT2.COM"/>
<!--
If this url is used, the following error will happen at the second sql task.
java.lang.UnsatisfiedLinkError: Native Library C:\oracle\ora81\bin\ocijdbc8.dll 
already loaded in another classloader
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1346)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1306)
        at java.lang.Runtime.loadLibrary0(Runtime.java:749)
        at java.lang.System.loadLibrary(System.java:820)
        at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:228)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance
(OracleDriver.java:365)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:419)
        at org.apache.tools.ant.Task.perform(Task.java:217)
        at org.apache.tools.ant.Target.execute(Target.java:184)
        at org.apache.tools.ant.Target.performTasks(Target.java:202)
        at org.apache.tools.ant.Project.executeTarget(Project.java:601)
        at org.apache.tools.ant.Project.executeTargets(Project.java:560)
        at org.apache.tools.ant.Main.runBuild(Main.java:454)
        at org.apache.tools.ant.Main.start(Main.java:153)
        at org.apache.tools.ant.Main.main(Main.java:176)
-->
        <property name="project.driver" 
value="oracle.jdbc.driver.OracleDriver"/>
        <property name="project.dbusername" value="sreilly"/>
        <property name="project.dbpassword" value="sreilly"/>
        <property name="project.dbclasspath" 
value="C:\catused\phoenix\deploy\lib\weblogic-java\classes12.zip"/>
        <target name="test">
                <sql classpath="${project.dbclasspath}" 
                        driver="${project.driver}" 
                        url="${project.dburl}" 
                        userid="${project.dbusername}" 
                        password="${project.dbpassword}" 
                        print="yes" 
                        showheaders="false">
                select 2 from dual;
                </sql>

                <sql classpath="${project.dbclasspath}" 
                        driver="${project.driver}" 
                        url="${project.dburl}" 
                        userid="${project.dbusername}" 
                        password="${project.dbpassword}" 
                        print="yes" 
                        showheaders="false">
                select * from tab;
                </sql>
        </target>

</project>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>