Announcement

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

    Error while trying to obtain db connection with latest build

    SmartClient Version: v11.1p_2017-06-29/Enterprise Development Only (built 2017-06-29)

    Hello, while trying the latest build I've got this error:

    Code:
     2017-06-30 10:24:26,410 ERROR SQLConnectionManager [builtinApplication.null] Caught exception while trying to obtain connection to server: dbJFrame
      java.lang.NullPointerException
      at com.isomorphic.sql.SQLDriver.rawConnection(SQLDriver.java:807)
      at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:129)
      at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:138)
      at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:104)
      at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:76)
      at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:177)
      at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:946)
      at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:1387)
      at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:580)
      at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:574)
      at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1763)
      at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:434)
      at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:379)
      at com.isomorphic.datasource.DataSource.execute(DataSource.java:2224)
      at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:629)
      at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:546)
      at com.isomorphic.application.AppBase.execute(AppBase.java:489)
      at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2807)
      at com.juve.dmi.GruppiDMI.fetch(GruppiDMI.java:70)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
    My setup is Tomcat 7, Oracle db 11.2.0.4.0.
    Please let me know if you need other details.
    Last edited by claudiobosticco; 30 Jun 2017, 02:37.

    #2
    Did this just start happening? Do you remember the version number for a prior version that was working?

    What type of SQL setup are you using - JNDI, JDBC URL, etc?

    Comment


      #3
      yes, it was working with the 11.1d 2017-06-12.

      In my local setup (where I've tested it for now), I define the resources in the Context tag of the server.xml, like this:

      Code:
       <Resource driverClassName="oracle.jdbc.driver.OracleDriver"
               maxActive="5"
               maxIdle="4"
               maxWait="5000"
               minEvictableIdleTimeMillis="5000"
               numTestsPerEvictionRun="5"
               timeBetweenEvictionRunsMillis="10000"
               testOnBorrow="false"
               testOnReturn="true"
               removeAbandoned="true"
               removeAbandonedTimeout="6000"
               logAbandoned="true"
               name="jdbc/juve/dbJpcEP"
               password="secret"
               type="javax.sql.DataSource"
               factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
               url="jdbc:oracle:thin:@hostname:port:sid"
               username="foo"
               validationQuery="select 1 from dual"/>
      and then in server.properties:

      Code:
      sql.dbJpcEP.autoJoinTransactions: true
      sql.dbJpcEP.interface.type: jndi
      sql.dbJpcEP.driver.driverType: thin
      sql.dbJpcEP.driver.name: jdbc/juve/dbJpcEP
      sql.dbJpcEP.driver.autoConfigured: true
      sql.dbJpcEP.database.type: oracle

      Comment


        #4
        Same problem here - with jndi the reported exception is thrown.
        I have tested the 6.1-d20170625 with the same error. So there must be a regression between 2017-06-12 and 2017-06-25.

        Comment


          #5
          We believe we have identified the cause of this error. Please try your case with tomorrow's 6.1p build - dated 1st July or later - and let us know how that goes

          Comment


            #6
            SmartClient Version: v11.1p_2017-07-01/Enterprise Development Only (built 2017-07-01)

            Hello, with the latest build I've got a different error:
            Code:
             2017-07-01 15:17:13,445 DEBUG SQLDriver [builtinApplication.null] dbJFrame: Initializing SQL config via JNDI 
              2017-07-01 15:17:13,463 DEBUG JSTranslater [builtinApplication.null] disableStringInBrowser = false 
              2017-07-01 15:17:13,463 DEBUG SQLDriver [builtinApplication.null] dbJFrame: Database metadata: {
                  driverName:"Oracle JDBC driver",
                  driverMajorVersion:12,
                  driverMinorVersion:1,
                  databaseProductName:"Oracle",
                  databaseProductVersion:"Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options",
                  databaseMinorVersion:2,
                  databaseMajorVersion:11,
                  JDBCMinorVersion:1,
                  driverVersion:"12.1.0.1.0",
                  JDBCMajorVersion:4
              } 
              2017-07-01 15:17:13,677 DEBUG SQLDataSource [builtinApplication.null] DataSource 15 acquired SQLDriver instance 1522444671 during initialization 
              2017-07-01 15:17:13,694 INFO  SQLDataSource [builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause 
              2017-07-01 15:17:13,695 INFO  Velocity [builtinApplication.null] Velocity Tools not available - using standard Velocity Contexts. 
              2017-07-01 15:17:13,707 DEBUG Velocity [builtinApplication.null] Velocity config: {
              } 
              2017-07-01 15:17:13,754 DEBUG Velocity Log4JLogChute using logger 'org.apache.Velocity' 
              2017-07-01 15:17:13,754 DEBUG Velocity Initializing Velocity, Calling init()... 
              2017-07-01 15:17:13,754 DEBUG Velocity Starting Apache Velocity v1.7 (compiled: 2010-11-19 12:14:37) 
              2017-07-01 15:17:13,754 DEBUG Velocity Default Properties File: org/apache/velocity/runtime/defaults/velocity.properties 
              2017-07-01 15:17:13,754 DEBUG Velocity Trying to use logger class org.apache.velocity.runtime.log.Log4JLogChute 
              2017-07-01 15:17:13,754 DEBUG Velocity Using logger class org.apache.velocity.runtime.log.Log4JLogChute 
              2017-07-01 15:17:13,761 DEBUG Velocity ResourceLoader instantiated: org.apache.velocity.runtime.resource.loader.FileResourceLoader 
              2017-07-01 15:17:13,762 DEBUG Velocity Do unicode file recognition:  false 
              2017-07-01 15:17:13,762 DEBUG Velocity FileResourceLoader : adding path '' 
              2017-07-01 15:17:13,774 DEBUG Velocity ResourceCache: initialized (class org.apache.velocity.runtime.resource.ResourceCacheImpl) with class java.util.Collections$SynchronizedMap cache map. 
              2017-07-01 15:17:13,776 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Stop 
              2017-07-01 15:17:13,778 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Define 
              2017-07-01 15:17:13,779 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Break 
              2017-07-01 15:17:13,780 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Evaluate 
              2017-07-01 15:17:13,781 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Literal 
              2017-07-01 15:17:13,783 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Macro 
              2017-07-01 15:17:13,784 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Parse 
              2017-07-01 15:17:13,786 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Include 
              2017-07-01 15:17:13,787 DEBUG Velocity Loaded System Directive: org.apache.velocity.runtime.directive.Foreach 
              2017-07-01 15:17:13,826 DEBUG Velocity Created '20' parsers. 
              2017-07-01 15:17:13,836 DEBUG Velocity Velocimacro : "velocimacro.library" is not set.  Trying default library: VM_global_library.vm 
              2017-07-01 15:17:13,836 DEBUG Velocity Velocimacro : Default library not found. 
              2017-07-01 15:17:13,836 DEBUG Velocity Velocimacro : allowInline = true : VMs can be defined inline in templates 
              2017-07-01 15:17:13,836 DEBUG Velocity Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions 
              2017-07-01 15:17:13,836 DEBUG Velocity Velocimacro : allowInlineLocal = false : VMs defined inline will be global in scope if allowed. 
              2017-07-01 15:17:13,836 DEBUG Velocity Velocimacro : autoload off : VM system will not automatically reload global library macros 
              2017-07-01 15:17:13,849 INFO  SQLDataSource [builtinApplication.null] 15: Executing SQL query on 'dbJFrame': SELECT GRUPPI.ID_REC, GRUPPI.NOME_GRUPPO, GRUPPI.DES_GRUPPO, GRUPPI.DES_GRUPPO_EN, GRUPPI.ID_APP, GRUPPI.SUPER_ADMIN FROM DBJFRAME.GRUPPI WHERE ((GRUPPI.ID_APP = 'Jtk' AND GRUPPI.ID_APP IS NOT NULL) AND ((GRUPPI.NOME_GRUPPO = 'ROLE_GENERIC' AND GRUPPI.NOME_GRUPPO IS NOT NULL) OR (GRUPPI.NOME_GRUPPO = 'ROLE_ADMIN' AND GRUPPI.NOME_GRUPPO IS NOT NULL) OR (GRUPPI.NOME_GRUPPO = 'ROLE_ADMIN_LIS' AND GRUPPI.NOME_GRUPPO IS NOT NULL))) 
              2017-07-01 15:17:13,855 INFO  PoolManager [builtinApplication.null] SmartClient pooling disabled for 'dbJFrame' objects 
              2017-07-01 15:17:13,860 ERROR SQLConnectionManager [builtinApplication.null] Caught exception while trying to obtain connection to server: dbJFrame 
              java.sql.SQLException: The url cannot be null
              at java.sql.DriverManager.getConnection(DriverManager.java:556)
              at java.sql.DriverManager.getConnection(DriverManager.java:215)
              at com.isomorphic.sql.SQLDriver.rawConnection(SQLDriver.java:811)
              at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:129)
              at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:138)
              at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:104)
              at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:76)
              at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:177)
              at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:949)
              at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:1390)
              at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:580)
              at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:574)
              at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1763)
              at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:434)
              at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:379)
              at com.isomorphic.datasource.DataSource.execute(DataSource.java:2224)
              at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:629)
              at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:546)
              at com.isomorphic.application.AppBase.execute(AppBase.java:489)
              at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2807)
              at com.juve.dmi.GruppiDMI.fetch(GruppiDMI.java:70)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)

            Comment


              #7
              OK, sorry - the NPE was just a symptom of a more pervasive issue with missing context. This has now been fixed - please try tomorrow's builds (July 4th)

              Comment


                #8
                unfortunately the 11.1p build of 2017-07-04 is not available for download...

                also, the 11.1d branch is not accessible "Your account does not have access to licenses for SmartClient 11.1d...."

                Comment


                  #9
                  Originally posted by claudiobosticco View Post
                  unfortunately the 11.1p build of 2017-07-04 is not available for download..."
                  For Power, I do see a build here.

                  For the d builds, I assume that they are no longer created and should not be used. I do see the directories nevertheless as well.

                  Best regards
                  Blama


                  Comment


                    #10
                    Originally posted by Blama View Post
                    For Power, I do see a build here.
                    Yes, now it's available ;-)

                    Isomorphic I can confirm it's fixed, thank you very much.

                    Comment

                    Working...
                    X