<@U070SQMD1> So I had more time last night to brea...
# lucee
h
@zackster So I had more time last night to break one of my Lucee servers to try to figure out why I can't upgrade from 5.3.8.206 to 5.3.9.141.
I'm getting
Copy code
Error Occurred While Processing Request
org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getBundle()Lorg/apache/felix/framework/BundleImpl;
This made me think to check the Tomcat version. Lucee admin says it's at Servlet ContainerApache Tomcat/8.5.16
what's strange is it has no issues with some queries to the same MS SQL database. Here's the first part of the stack trace:
Copy code
lucee.runtime.exp.NativeException: org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getBundle()Lorg/apache/felix/framework/BundleImpl;
	at lucee.runtime.osgi.OSGiUtil.isValid(OSGiUtil.java:2027)
	at lucee.runtime.db.DatasourceConnectionPool.isValid(DatasourceConnectionPool.java:256)
	at lucee.runtime.db.DatasourceConnectionPool.getDatasourceConnection(DatasourceConnectionPool.java:133)
	at lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerImpl.java:82)
	at lucee.runtime.tag.Query.executeDatasoure(Query.java:1119)
	at lucee.runtime.tag.Query._doEndTag(Query.java:699)
	at lucee.runtime.tag.Query.doEndTag(Query.java:565)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at instrumentation.cfc.functions_cfc$cf.udfCall2(/instrumentation/cfc/functions.cfc:676)
	at instrumentation.cfc.functions_cfc$cf.udfCall(/instrumentation/cfc/functions.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
	at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1762)
	at instrumentation.cfc.functions_cfc$cf.udfCall2(/instrumentation/cfc/functions.cfc:647)
	at instrumentation.cfc.functions_cfc$cf.udfCall(/instrumentation/cfc/functions.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
Should I upgrade Tomcat or do you think something else is going on?
d
Did you also update the MSSQL drivers along with updating Lucee?
h
yep
on the latest version for jre8. 8.4.1.jre8
FWIW, here's the query it's complaining about.
Copy code
var sqlStmt = "SELECT s.name, s.display_name, st.columns
            FROM stations s INNER JOIN station_tables st 
                ON  s.station_id = st.station_id
            WHERE s.station_id IN (:station_id)
                AND st.line_number IN (2,3,6,7)
            ORDER BY st.line_number";

        var qStation = queryExecute(
            sqlStmt,
            {station_id : {value = arguments.station_id, cfsqltype = "integer", list = true}},
            {datasource : this.dsn}
        );
site works fine on version 5.3.8.206, so gotta be a driver incompatibility with the latest but I'm stumped.
d
Are you sure
this.dsn
is value you think it is?
h
did something in 9.133+ change that would affect this? I would think Lucee would just complain that the DSN is invalid. I'll test for this though, thanks for the suggestion.
hard coding the dsn didn't help, same error.
I updated Java to Java1.8.0_332 (Temurin) 64bit last night.
Is there a baseline recommendation for running Lucee 5.3.9.141? Tomcat, Java, etc?
z
as per the 5.3.9.133 release notes, https://dev.lucee.org/t/lucee-5-3-9-133-stable-released/10038 the installer bundles • Java 11.0.15+10 • Tomcat 9.0.62
h
Thanks Zac. I'll look into LDEV-3855.