Good morning. Getting the following error when cal...
# luceem
madmike_de
09/14/2023, 7:16 AMGood morning. Getting the following error when calling `web.cfm?action=services.datasource`:
Copy code
The Error Occurred in
D:\www\WEB-INF\lucee\context\admin\dbdriver\MSSQL.cfc: line 1
1: <cfcomponent extends="Driver" output="false" implements="IDriver">
2: <cfset this.className="com.microsoft.jdbc.sqlserver.SQLServerDriver">
3: <cfset this.dsn="jdbc:sqlserver://{host}:{port}">
called from /admin/services.datasource.cfm: line 15
called from /admin/web.cfm: line 564z
zackster
09/14/2023, 7:23 AMany more detail? 1.6. isn't supported anymore 😉
m
madmike_de
09/14/2023, 7:25 AMSure, sorry. It's the latest official 5.4.3
a
alexpixl8
09/14/2023, 7:25 AMWhat’s the actual error doesn’t seem a full one
z
zackster
09/14/2023, 7:26 AMthere should be a cat.gif ?
zackster
09/14/2023, 7:28 AMwhich mssql ext version and java version
m
madmike_de
09/14/2023, 7:28 AMOh man, what's wrong with me. Forgot really half of the error:
z
zackster
09/14/2023, 7:29 AMI'm using 12.2.0.jre8 on java 11.0.20
m
madmike_de
09/14/2023, 7:29 AMThis is the error message:
invalid interface definition, can't find interface [IDriver]madmike_de
09/14/2023, 7:29 AMAnd this is the stack:
Copy code
lucee.runtime.exp.ExpressionException: invalid interface definition, can't find interface [IDriver]
at lucee.runtime.component.ComponentLoader._search(ComponentLoader.java:196)
at lucee.runtime.component.ComponentLoader.searchInterface(ComponentLoader.java:159)
at lucee.runtime.InterfaceImpl.loadInterfaces(InterfaceImpl.java:104)
at lucee.runtime.ComponentImpl.init(ComponentImpl.java:411)
at dbdriver.mssql_cfc$cf.initComponent(/lucee/admin/dbdriver/MSSQL.cfc)
at dbdriver.mssql_cfc$cf.newInstance(/lucee/admin/dbdriver/MSSQL.cfc:1)
at lucee.runtime.component.ComponentLoader.initComponent(ComponentLoader.java:632)
at lucee.runtime.component.ComponentLoader._loadComponent(ComponentLoader.java:571)
at lucee.runtime.component.ComponentLoader.load(ComponentLoader.java:494)
at lucee.runtime.component.ComponentLoader._search(ComponentLoader.java:258)
at lucee.runtime.component.ComponentLoader._search(ComponentLoader.java:188)
at lucee.runtime.component.ComponentLoader.searchComponent(ComponentLoader.java:82)
at lucee.runtime.PageContextImpl.loadComponent(PageContextImpl.java:3280)
at lucee.runtime.functions.other.CreateObject.doComponent(CreateObject.java:148)
at lucee.runtime.functions.other.CreateObject.call(CreateObject.java:70)
at lucee.runtime.functions.other.CreateObject.call(CreateObject.java:49)
at services_datasource_cfm414$cf.call(/admin/services.datasource.cfm:15z
zackster
09/14/2023, 7:31 AMhmmm, sounds like a mapping problem https://github.com/lucee/Lucee/blob/6.0/core/src/main/java/resource/context/admin/dbdriver/types/IDriver.cfc
zackster
09/14/2023, 7:32 AMwhich ext version?
mine has for line 1
component extends="types.Driver" implements="types.IDatasource" {m
madmike_de
09/14/2023, 7:34 AMMicrosoft SQL Server (Vendor Microsoft) 12.2.0.jre8
and
jTDS (MSSQL,Sybase) 1.3.1
z
zackster
09/14/2023, 7:36 AMwait that looks like you have an extension installed in the web context ?
zackster
09/14/2023, 7:36 AMi.e.
Copy code
D:\www\WEB-INF\lucee\context\admin\dbdriver\MSSQL.cfczackster
09/14/2023, 7:37 AMi bet the one in C:\lucee\tomcat\lucee-server\context\context\admin\dbdriver looks more like my snippet?
m
madmike_de
09/14/2023, 7:37 AMIndeed.
z
zackster
09/14/2023, 7:37 AMnuke it from the web context
zackster
09/14/2023, 7:37 AMthe ext
m
madmike_de
09/14/2023, 7:37 AMI think somehow this installation is broken
madmike_de
09/14/2023, 7:38 AMthey are installed in the serveradmin and the
server.cfm?action=ext.applicationsmadmike_de
09/14/2023, 7:39 AMLet me reinstall new, something is totally wrong here
z
zackster
09/14/2023, 7:39 AMwait, what's the error
m
madmike_de
09/14/2023, 7:39 AM Copy code
Can't cast String [] to a value of type [Array]
lucee.runtime.exp.CasterException: Can't cast String [] to a value of type [Array] at lucee.runtime.op.Caster.toArray(Caster.java:2456) at ext_functions_cfm184$cf.udfCall1(/admin/ext.functions.cfm:54) at ext_functions_cfm184$cf.udfCall(/admin/ext.functions.cfm) 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:1775) at ext_applications_list_cfm966$cf.udfCall(/admin/ext.applications.list.cfm:13) 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) atz
zackster
09/14/2023, 7:45 AMcan you try 5.4.3.10 ?
m
madmike_de
09/14/2023, 7:50 AMExtensions work in 5.4.3.10
z
zackster
09/14/2023, 7:50 AM😉
m
madmike_de
09/14/2023, 7:55 AMI nuked the both Extensions mentioned above (MSSQL, jTDS), error is still the same.
madmike_de
09/14/2023, 7:55 AMAnd now the extension page says:
Copy code
Not installed
These applications are not yet installed on the system.
Unable to connect to the update server to get the list of Available Extensions. Please check your Internet Connectionz
zackster
09/14/2023, 8:11 AMah yeah, that logic is a bit screwy TBH, been battling with that locally, what's going on is the admin functions
getRHExtensions and getLocalExtensions are returning odd results
zackster
09/14/2023, 8:13 AM