Should I have any issues connecting to MS SQL 2016 from Luceee 4.5

dev google-group-archive
1

Does anyone know if this is an issue? I can create the datasource, and it
verifies OK, but when I try to run a query it just hangs and never returns
anything:

Connection string looks like this:

this.datasources[“lf-bugfix”] = { class:
‘com.microsoft.jdbc.sqlserver.SQLServerDriver’,connectionString:
‘jdbc:sqlserver://SQLSERVER1:1433;DATABASENAME=TESTDB;sendStringParametersAsUnicode=false;SelectMethod=direct’
, username: ‘testuser’ , password:
“encrypted:2ab191d6f621435235ec869da377b576b1df515f1f7b248fb82345bcd7b86e3ca11e2345dc4c3a107611758334534f6e2f49587fe38f3838e95e7d495921f2440ac1cc834aa527f55d10925dc4798d4338fe372a214267365a402556caf0bbe89a5d”
// optional settings , blob:true // default: false };

And it hangs with:

java.net.SocketInputStream.socketRead0(null:???)[Native Method]
java.net.SocketInputStream.read(null:???)
com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1782)
com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838)
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6154)
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6106)
com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1756)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1761)
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:1901)
lucee.runtime.db.driver.ConnectionProxy.setAutoCommit(ConnectionProxy.java:257)
lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerImpl.java:88)
lucee.runtime.tag.Query.executeDatasoure(Query.java:795)

2

Brook Davies wrote on 2016-10-26:

Does anyone know if this is an issue? I can create the datasource, and
it verifies OK, but when I try to run a query it just hangs and never
returns anything:

Can you verify that it works fine through port 1433 with that user/pass using another client? (e.g. Toad for MSSQL)> Connection string looks like this:

this.datasources[“lf-bugfix”] = { class:
‘com.microsoft.jdbc.sqlserver.SQLServerDriver’,connectionString:
‘jdbc:sqlserver://SQLSERVER1:1433;DATABASENAME=TESTDB;sendStringParamete
rsAsUnicode=false;SelectMethod=direct’ , username: ‘testuser’ ,
password:
“encrypted:2ab191d6f621435235ec869da377b576b1df515f1f7b248fb82345bcd7b86
e3ca11e2345dc4c3a107611758334534f6e2f49587fe38f3838e95e7d495921f2440ac1c
c834aa527f55d10925dc4798d4338fe372a214267365a402556caf0bbe89a5d” //
optional settings , blob:true // default: false };

And it hangs with:

java.net.SocketInputStream.socketRead0(null:???)[Native Method]
java.net.SocketInputStream.read(null:???)
com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1782)
com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838)
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:615
4)
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:610
6)
com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doE
xecute(SQLServerConnection.java:1756)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServ
erConnection.java:1715)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLS
erverConnection.java:1761)
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServe
rConnection.java:1901)
lucee.runtime.db.driver.ConnectionProxy.setAutoCommit(ConnectionProxy.j
ava:257)
lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerI
mpl.java:88) lucee.runtime.tag.Query.executeDatasoure(Query.java:795)

3

I can tellnet to port 1433, and I can connect using the JTDS driver only…
gonna download and try toad. Thanks!On Wed, Oct 26, 2016 at 11:45 PM, Hugo Ahlenius <@Hugo_Ahlenius> wrote:

Brook Davies wrote on 2016-10-26:

Does anyone know if this is an issue? I can create the datasource, and
it verifies OK, but when I try to run a query it just hangs and never
returns anything:

Can you verify that it works fine through port 1433 with that user/pass
using another client? (e.g. Toad for MSSQL)

Connection string looks like this:

this.datasources[“lf-bugfix”] = { class:
‘com.microsoft.jdbc.sqlserver.SQLServerDriver’,connectionString:
‘jdbc:sqlserver://SQLSERVER1:1433;DATABASENAME=TESTDB;sendStringParamete
rsAsUnicode=false;SelectMethod=direct’ , username: ‘testuser’ ,
password:
“encrypted:2ab191d6f621435235ec869da377b576b1df515f1f7b248fb82345bcd7b86
e3ca11e2345dc4c3a107611758334534f6e2f49587fe38f3838e95e7d495921f2440ac1c
c834aa527f55d10925dc4798d4338fe372a214267365a402556caf0bbe89a5d” //
optional settings , blob:true // default: false };

And it hangs with:

java.net.SocketInputStream.socketRead0(null:???)[Native Method]
java.net.SocketInputStream.read(null:???)
com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1782)
com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838)
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:615
4)
com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:610
6)
com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doE
xecute(SQLServerConnection.java:1756)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServ
erConnection.java:1715)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLS
erverConnection.java:1761)
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServe
rConnection.java:1901)
lucee.runtime.db.driver.ConnectionProxy.setAutoCommit(ConnectionProxy.j
ava:257)
lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerI
mpl.java:88) lucee.runtime.tag.Query.executeDatasoure(Query.java:795)

–
Get 10% off of the regular price for this years CFCamp in Munich, Germany
(Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€
instead of 210€. Visit https://ti.to/cfcamp/cfcamp-
2016/discount/Lucee@cfcamp

You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/lucee/03f701d2301d%24bd4fbcb0%2437ef3610%24%40oxel.net.
For more options, visit https://groups.google.com/d/optout.