Can't load IA 32-bit .dll on a AMD 64-bit platform

[Tan Mit]

I recently moved on Windows 7 (64 bit) and have been trying to build my project thru Maven. I keep getting the below error when I try to build a project which talks to DB. I have 32 bit Oracle 11g on my system. Please let me know how I can resolve this.


Caused by: java.lang.UnsatisfiedLinkError: C:\oracle\product\11.2.0\client_1\bin
\ocijdbc11.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1807)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1732)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1028)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3171)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java
:3167)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:233)

[William P O'Sullivan]

Is this at runtime?

If so, it's telling you that you should install the 64bit AMD Oracle native client components.

WP

[Tan Mit]

Yes its run time. Yeah I am trying to get it installed on my machine but apparently Quest TOAD doesn't work on 64 bit. So I need both 32 and 64 bit on my machine and while installing 64 it merges them both. IT help desk is helping me in it.

One more que - Using JDK 32 or 64 bit will not make any difference .. right? I can use either?

[Tan Mit]

I got rid of that but now I am getting this error

[12.08.08 11:20:05:544 PDT]  INFO main - Building new Hibernate SessionFactory
[12.08.08 11:20:05:544 PDT] DEBUG main - Creating new JDBC DriverManager Connect
ion to [jdbc:oracle:oci:@e511]
[12.08.08 11:20:05:554 PDT]  INFO main - Destroying singletons in org.springfram
ework.beans.factory.support.DefaultListableBeanFactory@7f8062: defining beans [o
rg.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSour
ce,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.t
ransaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework
.transaction.interceptor.TransactionInterceptor#0,org.springframework.transactio
n.config.internalTransactionAdvisor,sessionFactory,transactionManager,org.spring
framework.context.config.internalBeanConfigurerAspect,org.springframework.contex
t.annotation.internalConfigurationAnnotationProcessor,org.springframework.contex
t.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.an
notation.internalRequiredAnnotationProcessor,org.springframework.context.annotat
ion.internalCommonAnnotationProcessor,org.springframework.context.annotation.int
ernalPersistenceAnnotationProcessor,acctPrefDao,bankingDAOFactory,stageTransferD
ao,userPrefDao,bankingDAOUtils,org.springframework.context.annotation.Configurat
ionClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy

[12.08.08 11:20:05:714 PDT] ERROR main - Caught exception while allowing TestExe
cutionListener [org.springframework.test.context.support.DependencyInjectionTest
ExecutionListener@6a435f] to prepare test instance [com.unionbank.banking.dao.Tr
ansferStageDAOTest@da9ea4]
java.lang.IllegalStateException: Failed to load ApplicationContext
        at org.springframework.test.context.TestContext.getApplicationContext(Te
stContext.java:157)
        at org.springframework.test.context.support.DependencyInjectionTestExecu
tionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:10
9)
        at org.springframework.test.context.support.DependencyInjectionTestExecu
tionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:7
5)
        at org.springframework.test.context.TestContextManager.prepareTestInstan
ce(TestContextManager.java:321)
        at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.creat
eTest(SpringJUnit4ClassRunner.java:211)
        at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.run
ReflectiveCall(SpringJUnit4ClassRunner.java:288)
        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCal
lable.java:15)
        at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.metho
dBlock(SpringJUnit4ClassRunner.java:290)
        at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runCh
ild(SpringJUnit4ClassRunner.java:231)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRun
ner.java:49)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
        at org.springframework.test.context.junit4.statements.RunBeforeTestClass
Callbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
        at org.springframework.test.context.junit4.statements.RunAfterTestClassC
allbacks.evaluate(RunAfterTestClassCallbacks.java:71)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
        at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(S
pringJUnit4ClassRunner.java:174)
        at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.
java:59)
        at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTes
tSet(AbstractDirectoryTestSuite.java:120)
        at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(Ab
stractDirectoryTestSuite.java:103)
        at org.apache.maven.surefire.Surefire.run(Surefire.java:169)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(Su
refireBooter.java:350)
        at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.j
ava:1021)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'sessionFactory' defined in class path resource [hibernateCont
ext.xml]: Invocation of init method failed; nested exception is java.lang.Unsati
sfiedLinkError: oracle.jdbc.driver.T2CConnection.t2cCreateState([BI[BI[BI[BI[BIS
I[S[B[BZ)I
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:294)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:225)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:291)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:193)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:591)
        at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:918)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:469)
        at org.springframework.test.context.support.AbstractGenericContextLoader
.loadContext(AbstractGenericContextLoader.java:103)
        at org.springframework.test.context.support.AbstractGenericContextLoader
.loadContext(AbstractGenericContextLoader.java:1)
        at org.springframework.test.context.support.DelegatingSmartContextLoader
.loadContext(DelegatingSmartContextLoader.java:228)
        at org.springframework.test.context.TestContext.loadApplicationContext(T
estContext.java:124)
        at org.springframework.test.context.TestContext.getApplicationContext(Te
stContext.java:148)
        ... 28 more
Caused by: java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.t2cC
reateState([BI[BI[BI[BI[BISI[S[B[BZ)I
        at oracle.jdbc.driver.T2CConnection.t2cCreateState(Native Method)
        at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:338)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
490)
        at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
        at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtensio
n.java:53)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tionFromDriverManager(DriverManagerDataSource.java:173)
        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tionFromDriver(DriverManagerDataSource.java:164)
        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get
ConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get
Connection(AbstractDriverBasedDataSource.java:119)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:81)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
113)
        at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j
ava:2119)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115
)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1339)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(Annotat
ionConfiguration.java:867)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession
Factory(LocalSessionFactoryBean.java:860)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:779)
        at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:188)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
        ... 42 more
[12.08.08 11:20:05:754 PDT] DEBUG main - After test class: context [[TestContext
@1f2cea2 testClass = TransferStageDAOTest, testInstance = [null], testMethod = [
null], testException = [null], mergedContextConfiguration = [MergedContextConfig
uration@3a9bba testClass = TransferStageDAOTest, locations = '{classpath:dbTestC
ontext.xml}', classes = '{}', activeProfiles = '{}', contextLoader = 'org.spring
framework.test.context.support.DelegatingSmartContextLoader']]], dirtiesContext
[false].
Tests run: 2, Failures: 0, Errors: 2, Skipped: 0, Time elapsed: 3.804 sec <<< FA
ILURE!

[Tan Mit]

I got rid of that but this is still there

java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.t2cCreateState([BI[BI[BI[BI[BISI[S[B[BZ)I
	at oracle.jdbc.driver.T2CConnection.t2cCreateState(Native Method)
	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:338)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
	at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:154)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113)
	at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
	at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
	at com.util.HibernateUtil.init(HibernateUtil.java:35)
	at com.db.DatabaseAccessServiceTest.setUp(DatabaseAccessServiceTest.java:40)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:59)
	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:120)
	at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:103)
	at org.apache.maven.surefire.Surefire.run(Surefire.java:169)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)
	at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021)

[Tan Mit]

Could someone please advice on this?

[Raja Ram M]

For anyone, using Oracle SQL and facing this issue;
Go to Connection> select the existing one, Change Connection_Type to Basic and fill out appropriate information.
You need to add the Service Name too;
Test it and you might see Success.

This process is basically a bypass.

[Raja Ram M]

please find attached image.

[Raja Ram M]

please find attached image.