SQL Server JDBC - Unknown properties specified:selectMethod

Author

Unknown properties specified:selectMethod

myagchev

2006-03-07, 7:23 am

Hi,

I use sqljdbc_1.0.809.102 connecting to MSSQL 2000

Here is the connection string:
jdbc:sqlserver:// HOST:1600;selectMeth
od=cursor;databaseNa
me=DB_NAME

Here is the exception:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed
Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Unknown properties
specified:selectMeth
od
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
Source)

This property is documented, so what's wrong?

Thanks,

Tom

2006-03-07, 8:23 pm

The property name is case sensitive. Type "SelectMethod".

Thanks

Tom

"myagchev" wrote:

> Hi,
>
> I use sqljdbc_1.0.809.102 connecting to MSSQL 2000
>
> Here is the connection string:
> jdbc:sqlserver:// HOST:1600;selectMeth
od=cursor;databaseNa
me=DB_NAME
>
> Here is the exception:
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed
> Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Unknown properties
> specified:selectMeth
od
> at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
> Source)
>
> This property is documented, so what's wrong?
>
> Thanks,

myagchev

2006-03-09, 3:23 am

Changing the case does't help.
I get this exception with JBoss 3.2.5 running on Sun JDK1.4.2_04.

Here is the datasource definition:
<local-tx-datasource>
<jndi-name>jdbc/JFDataSource</jndi-name>

<connection-url>jdbc:sqlserver:// HOST:1600;databaseNa
me=DB_NAME;SelectMet
hod=cursor</connection-url>

<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>auser</user-name>
<password>000000</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
</local-tx-datasource>

Here is the complete stack trace on the AS startup:
08:29:34,984 WARN & #91;JBossManagedConn
ectionPool] Throwable while attempting
to get a new connection: null
org.jboss.resource. JBossResourceExcepti
on: Could not create connection; -
nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException
: Failed Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Unknown
properties specified:SelectMeth
od)
at
org.jboss.resource.adapter.jdbc.local. LocalManagedConnecti
onFactory. createManagedConnect
ion(LocalManagedConn
ectionFactory.java:16
8)
at
org.jboss.resource.connectionmanager. InternalManagedConne
ctionPool. createConnectionEven
tListener(InternalMa
nagedConnectionPool.ja
va:504)
at
org.jboss.resource.connectionmanager. InternalManagedConne
ctionPool. getConnection(Intern
alManagedConnectionP
ool.java:214)
at
org.jboss.resource.connectionmanager. JBossManagedConnecti
onPool$BasePool. getConnection(JBossM
anagedConnectionPool
.java:534)
at
org.jboss.resource.connectionmanager. BaseConnectionManage
r2. getManagedConnection
(BaseConnectionManag
er2.java:444)
at
org.jboss.resource.connectionmanager.TxConnectionManager. getManagedConnection
(TxConnectionManager
.java:312)
at
org.jboss.resource.connectionmanager. BaseConnectionManage
r2. allocateConnection(B
aseConnectionManager
2.java:496)
at
org.jboss.resource.connectionmanager. BaseConnectionManage
r2$ConnectionManager
Proxy. allocateConnection(B
aseConnectionManager
2.java
:887)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(Wrappe
rDataSource.java:102)
at
org.jboss.mq.sm.jdbc. JDBCStateManager$JDB
CSession.<init>(JDBCStateManager.java:518)
at
org.jboss.mq.sm.jdbc.JDBCStateManager. initDB(JDBCStateMana
ger.java:432)
at
org.jboss.mq.sm.jdbc.JDBCStateManager. startService(JDBCSta
teManager.java:399)
at
org.jboss.system.ServiceMBeanSupport. jbossInternalStart(S
erviceMBeanSupport.java:271)
at
org.jboss.system.ServiceMBeanSupport. jbossInternalLifecyc
le(ServiceMBeanSuppo
rt.java:221)
at sun.reflect. GeneratedMethodAcces
sor2.invoke(Unknown Source)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.server.ReflectedDispatcher. dispatch(ReflectedDi
spatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:185)
at
org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:473)
at
org.jboss.system. ServiceController$Se
rviceProxy. invoke(ServiceContro
ller.java:837)
at $Proxy17.start(Unknown Source)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:367)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:389)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:389)
at sun.reflect. GeneratedMethodAcces
sor6.invoke(Unknown Source)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.server.ReflectedDispatcher. dispatch(ReflectedDi
spatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:185)
at
org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:473)
at org.jboss.mx.util.MBeanProxyExt. invoke(MBeanProxyExt
.java:176)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
at sun.reflect. GeneratedMethodAcces
sor16.invoke(Unknown Source)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.server.ReflectedDispatcher. dispatch(ReflectedDi
spatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:185)
at
org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:473)
at org.jboss.mx.util.MBeanProxyExt. invoke(MBeanProxyExt
.java:176)
at $Proxy7.deploy(Unknown Source)
at
org.jboss.deployment.scanner. URLDeploymentScanner
. deploy(URLDeployment
Scanner.java:304)
at
org.jboss.deployment.scanner. URLDeploymentScanner
. scan(URLDeploymentSc
anner.java:478)
at
org.jboss.deployment.scanner. AbstractDeploymentSc
anner$ScannerThread. doScan(AbstractDeplo
ymentScanner.java:201)
at
org.jboss.deployment.scanner. AbstractDeploymentSc
anner. startService(Abstrac
tDeploymentScanner.java:274)
at
org.jboss.system.ServiceMBeanSupport. jbossInternalStart(S
erviceMBeanSupport.java:271)
at
org.jboss.system.ServiceMBeanSupport. jbossInternalLifecyc
le(ServiceMBeanSuppo
rt.java:221)
at sun.reflect. GeneratedMethodAcces
sor2.invoke(Unknown Source)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.server.ReflectedDispatcher. dispatch(ReflectedDi
spatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:185)
at
org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:473)
at
org.jboss.system. ServiceController$Se
rviceProxy. invoke(ServiceContro
ller.java:837)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController. start(ServiceControl
ler.java:367)
at sun.reflect. GeneratedMethodAcces
sor6.invoke(Unknown Source)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.server.ReflectedDispatcher. dispatch(ReflectedDi
spatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:185)
at
org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:473)
at org.jboss.mx.util.MBeanProxyExt. invoke(MBeanProxyExt
.java:176)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:592)
at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
at
sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
at
sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.server.ReflectedDispatcher. dispatch(ReflectedDi
spatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:185)
at
org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:473)
at org.jboss.mx.util.MBeanProxyExt. invoke(MBeanProxyExt
.java:176)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:407)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:311)
at org.jboss.Main.boot(Main.java:145)
at org.jboss.Main$1.run(Main.java:399)
at java.lang.Thread.run(Thread.java:534)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed
Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Unknown properties
specified:SelectMeth
od
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.local. LocalManagedConnecti
onFactory. createManagedConnect
ion(LocalManagedConn
ectionFactory.java:15
8)
... 104 more

So, I still do not get what's wrong.

Igor

"Tom" wrote:
[color=darkred]
> The property name is case sensitive. Type "SelectMethod".
>
> Thanks
>
> Tom
>
> "myagchev" wrote:
>

Sponsored Links