Use new jdbc jar to update extension

hacking extensions
1

Hi,

I have done Oracle 12.2 and MySQL 8.0.11 and they are working well.

However, when I tried to update the MS SQL Server extension (using v6.4.0, jre8), here is the error message I got

Unable to resolve com.microsoft.sqlserver.mssql-jdbc [85](R 85.0): 
  missing requirement [com.microsoft.sqlserver.mssql-jdbc [85](R 85.0)] osgi.wiring.package;
  (osgi.wiring.package=javax.security.auth.kerberos) Unresolved requirements: 
  [[com.microsoft.sqlserver.mssql-jdbc [85](R 85.0)] osgi.wiring.package; 
  (osgi.wiring.package=javax.security.auth.kerberos)]

However, in “bundle” view it is loaded

image
image939Ă—194 8.58 KB

Do I miss anything?

(I also attached the lex file)

Thanks.

Allen

com.microsoft.sqlserver.mssql-jdbc-6.4.0.jre8.lex (862.4 KB)

2

which version of lucee are you running?

3

The latest one, released on Star Wars Day

4

ahh, you’re updating the existing extension with the latest driver?

5

yes!

6

Hi @Allen_Weng,

I’ve checked with your lex file it throw error like “Unable to resolve com.microsoft.sqlserver.mssql-jdbc [99](R 99.0): missing requirement [com.microsoft.sqlserver.mssql-jdbc [99](R 99.0)] osgi.wiring.package; (osgi.wiring.package=javax.security.auth.kerberos) Unresolved requirements: [[com.microsoft.sqlserver.mssql-jdbc [99](R 99.0)] osgi.wiring.package; (osgi.wiring.package=javax.security.auth.kerberos)]”

Lucee has latest version as 6.2.2.jre8 for MSSQL server. But your lex file version is 6.4.0.jre8. I don’t know where did you get form this. Can you please open the ticket in JIRA we will address it ASAP. As of now please use the lucee version 6.2.2.jre version

https://luceeserver.atlassian.net/

7

@cfmitrah I follow the mssql extension project to make a new one by myself for testing. I will open a new ticket in JIRA.

I have also updated my mysql and oracle extensions - they both work.

for mssql I am still using 6.2.2.

Thanks,

Allen

8

For the record, I believe this issue was resolved in Lucee 5.3.2.63: [LDEV-2195] - Lucee

1 Like
9

Hello. I’d like to start using the Oracle 12.2 driver as well. Can you tell me how you installed it in Lucee? Thanks!

10

Hi Erick,

isn’t the extension available in the Lucee Administrator? Please see https://docs.lucee.org/guides/cookbooks/Extension-Installation.html

11

Hi. Yes, but only lower versions are available.

image
image771Ă—430 21.1 KB