Error while trying to obtain db connection with latest build

[claudiobosticco]

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:

 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.

[Isomorphic]

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?

[claudiobosticco]

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:

 <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:

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

[helmut]

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.

[Isomorphic]

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

[claudiobosticco]

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:

 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)

[Isomorphic]

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)

[claudiobosticco]

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...."

[Blama]

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

[claudiobosticco]

For Power, I do see a build here.

Yes, now it's available ;-)

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