Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    SmartClient 8.2 Connection Failue to Oracle 9i, 10g, 11g

    Application Server: Windows Server 2008R2(64bits), SmartClient_v82p_2012-08-17_Enterprise(SDK), ojdbc6, Java 1.6.0_30
    Oracle 9i DB Server : Windows 2000 Serever(32bits)
    Oracle 10g DB Server : Windows 2000 Serever(32bits)
    Oracle 11g DB Server : Windows Server 2008R2(64bits)

    Connect to Oracle 10g Server is OK, But Can't Browse from adminConsole.jsp

    Oracle 10G Connection Test: (Screen prompt OK)
    Code:
    === 2012-08-18 15:53:29,583 [sor4] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for 
    'Fairly' from system config - using DataSource:  oracle.jdbc.pool.OracleDataSource
    === 2012-08-18 15:53:29,583 [sor4] INFO  DataTools - setProperties: couldn't set:
    {
        context:"No such property"
    }
    === 2012-08-18 15:53:29,942 [sor4] DEBUG PoolableSQLConnectionFactory - Returning unpooled Connection
    
    === 2012-08-18 15:53:30,130 [sor4] DEBUG RPCDMI - rpc returned RPCResponse
    === 2012-08-18 15:53:30,130 [sor4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2012-08-18 15:53:30,145 [sor4] INFO  Compression - /tools/adminConsoleOperations.jsp: 112 -> 98 bytes
    Oracle 10g Connection success but can't Browse
    Code:
    === 2012-08-18 16:16:07,942 [sor8] DEBUG RPCDMI - Invocation threw exception
    java.lang.OutOfMemoryError: PermGen space
            at java.lang.ClassLoader.defineClass1(Native Method)
            at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
            at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
            at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
            at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1847
    )
            at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:873)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1326)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205)
            at java.lang.ClassLoader.defineClass1(Native Method)
            at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
            at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
            at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
            at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1847
    )
            at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:873)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1326)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205)
            at oracle.jdbc.driver.OraclePreparedStatement.<clinit>(OraclePreparedStatement.java:102)
            at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:67
    )
            at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3575)
            at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3461)
            at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:3066)
            at com.isomorphic.sql.SQLMetaData.getBasicTableDetailsForType(SQLMetaData.java:270)
            at com.isomorphic.sql.SQLMetaData.getTableNamesAndRemarks(SQLMetaData.java:250)
            at com.isomorphic.tools.BuiltinRPC.getTables(BuiltinRPC.java:200)
            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 com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:950)
            at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:803)
            at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:305)
            at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:66)
    === 2012-08-18 16:16:08,505 [sor8] ERROR [jsp] - Servlet.service() for servlet jsp threw exception
    java.lang.OutOfMemoryError: PermGen space
            at java.lang.ClassLoader.defineClass1(Native Method)
            at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
            at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
            at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
            at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1847
    )
            at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:873)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1326)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205)
            at java.lang.ClassLoader.defineClass1(Native Method)
            at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
            at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
            at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
            at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1847
    )
            at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:873)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1326)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205)
            at oracle.jdbc.driver.OraclePreparedStatement.<clinit>(OraclePreparedStatement.java:102)
            at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:67
    )
            at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3575)
            at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3461)
            at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:3066)
            at com.isomorphic.sql.SQLMetaData.getBasicTableDetailsForType(SQLMetaData.java:270)
            at com.isomorphic.sql.SQLMetaData.getTableNamesAndRemarks(SQLMetaData.java:250)
            at com.isomorphic.tools.BuiltinRPC.getTables(BuiltinRPC.java:200)
            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 com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:950)
            at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:803)
            at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:305)
            at com.isomorphic.rpc.RPCDMI.execute(RPCDMI.java:66)
    Connection failure to Oracle 9i DB Server
    Code:
    === 2012-08-18 16:01:14,989 [sor4] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for '
    Retail' from system config - using DataSource:  oracle.jdbc.pool.OracleDataSource
    === 2012-08-18 16:01:14,989 [sor4] INFO  DataTools - setProperties: couldn't set:
    {
        context:"No such property",
        driverName:"No such property"
    }
    === 2012-08-18 16:01:14,989 [sor4] INFO  BuiltinRPC - testDB (Retail) error: java.sql.SQLException:
    Invalid Oracle URL specified
    === 2012-08-18 16:01:14,989 [sor4] DEBUG RPCDMI - rpc returned RPCResponse
    === 2012-08-18 16:01:14,989 [sor4] DEBUG RPCManager - Content type for RPC transaction: text/plain; c
    harset=UTF-8
    === 2012-08-18 16:01:14,989 [sor4] INFO  Compression - /tools/adminConsoleOperations.jsp: 186 -> 174
    bytes
    Connection failure to Oracle 11g DB Server
    Code:
    === 2012-08-18 15:47:44,333 [sor3] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for '
    WAFN-P' from system config - using DataSource:  oracle.jdbc.pool.OracleDataSource
    === 2012-08-18 15:47:44,333 [sor3] INFO  DataTools - setProperties: couldn't set:
    {
        context:"No such property",
        driverName:"No such property"
    }
    === 2012-08-18 15:47:44,333 [sor3] INFO  BuiltinRPC - testDB (WAFN-P) error: java.sql.SQLException:
    Invalid Oracle URL specified 
    === 2012-08-18 15:47:44,333 [sor3] DEBUG RPCDMI - rpc returned RPCResponse
    === 2012-08-18 15:47:44,333 [sor3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2012-08-18 15:47:44,333 [sor3] INFO  Compression - /tools/adminConsoleOperations.jsp: 186 -> 174bytes

    #2
    SmartClient 8.2 Oracle Connection is OK

    The connection for Oracle 9i, 10g, 11g is success using the SmartClient path 2012-08-20.

    Comment

    Working...
    X