ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 10090] New: - ant sql cause UnsatisfiedLinkError when using oracle oci driver.
Date Thu, 20 Jun 2002 21:42:05 GMT
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: ant-dev@jakarta.apache.org
        ReportedBy: qren@point2.com


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:ant-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:ant-dev-help@jakarta.apache.org>


Mime
View raw message