Linux+mono+Apache访问SQLServer数据库和Oracle数据库

最新推荐文章于 2024-06-10 20:16:00 发布
原创 最新推荐文章于 2024-06-10 20:16:00 发布 · 8k 阅读 · 4 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#sqlserver #数据库 #oracle #apache #linux #centos

本文详细介绍了如何在Linux CentOS 5.5系统上使用Apache、Mono来访问SQLServer和Oracle数据库。包括安装配置Mono 2.6、freetds和Oracle InstantClient，以及通过命令行和ASP.NET进行数据库操作的方法。此外，还解决了Apache下的环境变量问题以确保Oracle数据库的正常访问。

这几天研究Linux平台下，如果通过桌面程序和ASP.net访问SqlServer数据库和Oracle数据库，发现网上写的好多文章都不完善，很多是无用的多余的设置，而又不讲原理，本人研究了几日，经证实如下设置完全能满足要求。

前提：OS:CentOS5.5

A.安装mono2.6

增加一个新的代理文件，写入http://ftp.novell.com/pub/mono/download-stable/RHEL_5/。这是mono官方提供的针对CentOS的最新的mono平台。

yum --disablerepo=extras *mono* （注意：/etc/yum.repos.d/CentOS-Base.repo中的[extras]节也有一个版本的mono，不过很老了应该是1.1版本的，这里屏蔽掉了这个源，从而只安装最新版本的mono)

安装完后，会自动修改httpd相应的设置，无需手工再修改之。

B.安装freetds

yum install freetds

C.安装OracelInstantClient

去官方下载.zip压缩文件即可，就几十MB大小，解压到/opt/oracle/。

0. Linux下访问Oracle和SqlServer的小工具

 0.1命令行访问SqlServer

        安装完freetds后，会安装一个名为tsql的小工具，基本使用方法：

   #tsql -S SqlServer服务器IP地址 -p 端口号 -U 用户名 -P 密码

  正确登陆后，出现如下提示符：

  >

  输入

 >select * from 表名;回车

 >go;回车

然后会显示查询的内容。

 0.2命令行访问Oracle

 安装好InstantClient后，再下载一个sqlplus（很小）解压都同一目录下即可。把这一目录加入PATH

 然后执行如下命令连接远程Oracle数据库

最低0.47元/天 解锁文章
15、Oracle RAC 架构与硬件选择全解析
t8u9v0的博客
06-18 40
本文全面解析了 Oracle RAC 架构及其硬件选择的关键因素。从快速启动故障转移、扩展距离集群到 Oracle Streams 的工作原理，文章详细阐述了 RAC 环境中的高可用性机制和数据复制技术。同时，文章还探讨了服务器性能、网络互连和存储阵列等硬件选择对集群性能的影响，并分析了集群扩展、软硬件协同配置以及未来硬件发展趋势。通过这些内容，为构建高效、稳定的 Oracle RAC 集群提供了全面的指导和建议。
Web服务器部署02: Apache + PHP + Oracle
字节跳动
07-13 1626
主题：Web服务器搭建；一 基本环境部署方案简介 Apache和Php环境部署，已做了总结，请参考”Apach集成PHP”; 数据库选用Oracle11g2r；在本地需要安装服务端和客户端；二 Oracle资源介绍 01 Oracle 服务端 资源列表： 11gR2_1of2.zip // 简称文件a 11gR2_2of2.zip
linux mono 调用windows sqlServer 2005
weixin_30721077的博客
06-10 151
1. 实现linux mono Develop中调用windows 中的ql Server 2005 llinux 与 windows 在一个局域网的网段中 lwindows 中安装 sql Server 2005 2. windows 中的设置 lsql sever 2005 northwin数据...
Linux下Apache+PHP+SQL Server
Yort
03-29 1673
此文档适用于CentOS6部署Apache+PHP连接SQL Server2008 软件版本： Apache: httpd-2.4.23 http://httpd.apache.org/download.cgi#apache24 PHP: php-5.5.12 Apr: apr apr-1.5.2 Apr-util: apr-util-1.5.4 libiconv: libiconv
mono：数据库开发
08-02 204
mono：数据库开发 这个例子采用mysql测试数据库操作。你需要到http://sourceforge.net/projects/mysqlnet下载mysql的.net数据库驱动。这个驱动需要SharpZipLib,你可以到http://www.icsharpcode.net/OpenSource/SharpZipLib/default.asp取下载。 解压后需...
Mono+MsSQLServer
秋的专栏
12-02 982
最近把.net写项目移值到linux下,使用Mono运行.开始以为在linux下要使用微软的MsSQlServer很困难.但是通过试验,Mono真的做的不错,对MsSQlServer也完全支持.
mono 访问 oracle、mysql
我想我是海 冬天的大海 心情随风轻摆
12-06 911
访问oracle : http://www.mono-project.com/docs/database-access/providers/oracle/ 访问mysql : http://www.mono-project.com/docs/database-access/providers/mysql/
=================================== 2025-09-15 14:15:40.006 [scheduling-1] DEBUG o.s.data.redis.core.RedisConnectionUtils - Fetching Redis Connection from RedisConnectionFactory 2025-09-15 14:15:40.007 [scheduling-1] DEBUG io.lettuce.core.RedisChannelHandler - dispatching command AsyncCommand [type=GET, output=ValueOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-15 14:15:40.007 [scheduling-1] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x0923a51f, /127.0.0.1:19257 -> localhost/127.0.0.1:6379, epid=0x1] write() writeAndFlush command AsyncCommand [type=GET, output=ValueOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-15 14:15:40.007 [lettuce-nioEventLoop-5-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x0923a51f, /127.0.0.1:19257 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] write(ctx, AsyncCommand [type=GET, output=ValueOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command], promise) 2025-09-15 14:15:40.008 [scheduling-1] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x0923a51f, /127.0.0.1:19257 -> localhost/127.0.0.1:6379, epid=0x1] write() done 2025-09-15 14:15:40.008 [lettuce-nioEventLoop-5-1] DEBUG io.lettuce.core.protocol.CommandEncoder - [channel=0x0923a51f, /127.0.0.1:19257 -> localhost/127.0.0.1:6379] writing command AsyncCommand [type=GET, output=ValueOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-15 14:15:40.009 [lettuce-nioEventLoop-5-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x0923a51f, /127.0.0.1:19257 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] Received: 5 bytes, 1 commands in the stack 2025-09-15 14:15:40.009 [lettuce-nioEventLoop-5-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x0923a51f, /127.0.0.1:19257 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] Stack contains: 1 commands 2025-09-15 14:15:40.009 [lettuce-nioEventLoop-5-1] DEBUG io.lettuce.core.protocol.RedisStateMachine - Decode done, empty stack: true 2025-09-15 14:15:40.009 [lettuce-nioEventLoop-5-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x0923a51f, /127.0.0.1:19257 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] Completing command LatencyMeteredCommand [type=GET, output=ValueOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.AsyncCommand] 2025-09-15 14:15:40.010 [scheduling-1] DEBUG o.s.data.redis.core.RedisConnectionUtils - Closing Redis Connection. xx = null 2025-09-15 14:15:40.025 [reactor-http-nio-3] DEBUG reactor.netty.http.server.HttpServerOperations - [e7d590bf, L:/0:0:0:0:0:0:0:1:9000 - R:/0:0:0:0:0:0:0:1:19306] New http connection, requesting read 2025-09-15 14:15:40.025 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [5aba2990, L:/0:0:0:0:0:0:0:1:9000 - R:/0:0:0:0:0:0:0:1:19305] New http connection, requesting read 2025-09-15 14:15:40.025 [reactor-http-nio-3] DEBUG reactor.netty.transport.TransportConfig - [e7d590bf, L:/0:0:0:0:0:0:0:1:9000 - R:/0:0:0:0:0:0:0:1:19306] Initialized pipeline DefaultChannelPipeline{(reactor.left.httpCodec = io.netty.handler.codec.http.HttpServerCodec), (reactor.left.httpTrafficHandler = reactor.netty.http.server.HttpTrafficHandler), (reactor.right.reactiveBridge = reactor.netty.channel.ChannelOperationsHandler)} 2025-09-15 14:15:40.025 [reactor-http-nio-2] DEBUG reactor.netty.transport.TransportConfig - [5aba2990, L:/0:0:0:0:0:0:0:1:9000 - R:/0:0:0:0:0:0:0:1:19305] Initialized pipeline DefaultChannelPipeline{(reactor.left.httpCodec = io.netty.handler.codec.http.HttpServerCodec), (reactor.left.httpTrafficHandler = reactor.netty.http.server.HttpTrafficHandler), (reactor.right.reactiveBridge = reactor.netty.channel.ChannelOperationsHandler)} 2025-09-15 14:15:40.047 [reactor-http-nio-3] DEBUG reactor.netty.http.server.HttpServerOperations - [e7d590bf, L:/0:0:0:0:0:0:0:1:9000 - R:/0:0:0:0:0:0:0:1:19306] Increasing pending responses, now 1 2025-09-15 14:15:40.063 [reactor-http-nio-3] DEBUG reactor.netty.http.server.HttpServer - [e7d590bf-1, L:/0:0:0:0:0:0:0:1:9000 - R:/0:0:0:0:0:0:0:1:19306] Handler is being applied: org.springframework.http.server.reactive.ReactorHttpHandlerAdapter@624c2589 2025-09-15 14:15:40.092 [reactor-http-nio-3] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [e7d590bf-1] HTTP GET "/factory/query?pageIndex=1&pageSize=10" 2025-09-15 14:15:40.124 [reactor-http-nio-3] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerMapping - [e7d590bf-1] Mapped to com.hvlink.controller.FactoryController#getFactory(FactoryDTO, BasePageParam) 2025-09-15 14:15:40.188 [reactor-http-nio-3] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-09-15 14:15:40.196 [reactor-http-nio-3] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5a08cbdc] was not registered for synchronization because synchronization is not active 2025-09-15 14:15:40.356 [reactor-http-nio-3] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-15 14:15:40.551 [reactor-http-nio-3] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited 2025-09-15 14:15:41.016 [reactor-http-nio-3] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: bb5bf1d4-b1d2-4437-9e0f-80e7d4cc69a6] will not be managed by Spring 2025-09-15 14:15:41.020 [reactor-http-nio-3] DEBUG com.hvlink.mapper.FactoryMapper.getFactory_mpCount - ==> Preparing: SELECT COUNT(*) AS total FROM tm_factory 2025-09-15 14:15:41.045 [reactor-http-nio-3] DEBUG com.hvlink.mapper.FactoryMapper.getFactory_mpCount - ==> Parameters: 2025-09-15 14:15:41.078 [reactor-http-nio-3] DEBUG com.hvlink.mapper.FactoryMapper.getFactory_mpCount - <== Total: 1 2025-09-15 14:15:41.088 [reactor-http-nio-3] DEBUG com.hvlink.mapper.FactoryMapper.getFactory - ==> Preparing: SELECT factory_code,factory_name,status FROM tm_factory OFFSET ? ROWS FETCH NEXT ? ROWS ONLY 2025-09-15 14:15:41.093 [reactor-http-nio-3] DEBUG com.hvlink.mapper.FactoryMapper.getFactory - ==> Parameters: 0(Long), 10(Long) 2025-09-15 14:15:41.113 [reactor-http-nio-3] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5a08cbdc] 2025-09-15 14:15:41.153 [reactor-http-nio-3] DEBUG o.s.beans.factory.xml.XmlBeanDefinitionReader - Loaded 11 bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 2025-09-15 14:15:41.154 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'DB2' 2025-09-15 14:15:41.159 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Derby' 2025-09-15 14:15:41.159 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'H2' 2025-09-15 14:15:41.160 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'HDB' 2025-09-15 14:15:41.161 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'HSQL' 2025-09-15 14:15:41.162 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Informix' 2025-09-15 14:15:41.162 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'MS-SQL' 2025-09-15 14:15:41.162 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'MySQL' 2025-09-15 14:15:41.162 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Oracle' 2025-09-15 14:15:41.163 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'PostgreSQL' 2025-09-15 14:15:41.163 [reactor-http-nio-3] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Sybase' 2025-09-15 14:15:41.164 [reactor-http-nio-3] DEBUG o.s.jdbc.support.SQLErrorCodesFactory - Looking up default SQLErrorCodes for DataSource [com.hvlink.config.DataSourceConfig$1@2b0454d2] 2025-09-15 14:15:41.166 [reactor-http-nio-3] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-15 14:15:41.169 [reactor-http-nio-3] DEBUG o.s.jdbc.support.SQLErrorCodesFactory - SQL error codes for 'Microsoft SQL Server' found 2025-09-15 14:15:41.169 [reactor-http-nio-3] DEBUG o.s.jdbc.support.SQLErrorCodesFactory - Caching SQL error codes for DataSource [com.hvlink.config.DataSourceConfig$1@2b0454d2]: database product name is 'Microsoft SQL Server' 2025-09-15 14:15:41.169 [reactor-http-nio-3] DEBUG o.s.j.support.SQLErrorCodeSQLExceptionTranslator - Unable to translate SQLException with Error code '102', will now try the fallback translator 2025-09-15 14:15:41.169 [reactor-http-nio-3] DEBUG o.s.jdbc.support.SQLStateSQLExceptionTranslator - Extracted SQL state class 'S0' from value 'S0001' 2025-09-15 14:15:41.176 [reactor-http-nio-3] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerAdapter - [e7d590bf-1] Using @ExceptionHandler com.hvlink.exceptions.ExceptionHandle#handleException(Exception) 2025-09-15 14:15:41.184 [reactor-http-nio-3] ERROR com.hvlink.exceptions.ExceptionHandle - ===服务器内部错误== org.springframework.jdbc.UncategorizedSQLException: ### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “@P0”附近有语法错误。 ### The error may exist in file [D:\SHProjects\hv-link-backend\dao\target\classes\mapper\FactoryMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT factory_code,factory_name,status FROM tm_factory OFFSET ? ROWS FETCH NEXT ? ROWS ONLY ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “@P0”附近有语法错误。 ; uncategorized SQLException; SQL state [S0001]; error code [102]; “@P0”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “@P0”附近有语法错误。 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy118.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy120.getFactory(Unknown Source) at com.hvlink.service.impl.FactoryServiceImpl.getFactoryList(FactoryServiceImpl.java:92) at com.hvlink.controller.FactoryController.getFactory(FactoryController.java:80) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.reactive.result.method.InvocableHandlerMethod.lambda$invoke$0(InvocableHandlerMethod.java:145) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:125) at reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1839) at reactor.core.publisher.MonoZip$ZipCoordinator.signal(MonoZip.java:258) at reactor.core.publisher.MonoZip$ZipInner.onNext(MonoZip.java:347) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180) at reactor.core.publisher.FluxDefaultIfEmpty$DefaultIfEmptySubscriber.onNext(FluxDefaultIfEmpty.java:101) at reactor.core.publisher.FluxHide$SuppressFuseableSubscriber.onNext(FluxHide.java:137) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.complete(MonoIgnoreThen.java:292) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onNext(MonoIgnoreThen.java:187) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:236) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onComplete(MonoIgnoreThen.java:203) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onComplete(MonoPeekTerminal.java:299) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onComplete(MonoPeekTerminal.java:299) at reactor.core.publisher.MonoIgnoreElements$IgnoreElementsSubscriber.onComplete(MonoIgnoreElements.java:89) at reactor.core.publisher.FluxPeek$PeekSubscriber.onComplete(FluxPeek.java:260) at reactor.core.publisher.FluxPeek$PeekSubscriber.onComplete(FluxPeek.java:260) at reactor.core.publisher.FluxMap$MapSubscriber.onComplete(FluxMap.java:144) at reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1840) at reactor.core.publisher.MonoZip$ZipCoordinator.signal(MonoZip.java:258) at reactor.core.publisher.MonoZip$ZipInner.onNext(MonoZip.java:347) at reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1839) at reactor.core.publisher.MonoCacheTime.subscribeOrReturn(MonoCacheTime.java:151) at reactor.core.publisher.Mono.subscribe(Mono.java:4475) at reactor.core.publisher.MonoZip.subscribe(MonoZip.java:129) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.FluxFlatMap.trySubscribeScalarMap(FluxFlatMap.java:203) at reactor.core.publisher.MonoFlatMap.subscribeOrReturn(MonoFlatMap.java:53) at reactor.core.publisher.Mono.subscribe(Mono.java:4475) at reactor.core.publisher.MonoZip.subscribe(MonoZip.java:129) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:240) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onComplete(MonoIgnoreThen.java:203) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onComplete(MonoFlatMap.java:181) at reactor.core.publisher.Operators.complete(Operators.java:137) at reactor.core.publisher.MonoZip.subscribe(MonoZip.java:121) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:157) at reactor.core.publisher.FluxSwitchIfEmpty$SwitchIfEmptySubscriber.onNext(FluxSwitchIfEmpty.java:74) at reactor.core.publisher.MonoNext$NextSubscriber.onNext(MonoNext.java:82) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.innerNext(FluxConcatMap.java:282) at reactor.core.publisher.FluxConcatMap$ConcatMapInner.onNext(FluxConcatMap.java:863) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:129) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180) at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2400) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.request(MonoPeekTerminal.java:139) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.request(FluxMapFuseable.java:171) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.set(Operators.java:2196) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onSubscribe(Operators.java:2070) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onSubscribe(FluxMapFuseable.java:96) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onSubscribe(MonoPeekTerminal.java:152) at reactor.core.publisher.MonoJust.subscribe(MonoJust.java:55) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.drain(FluxConcatMap.java:451) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.onSubscribe(FluxConcatMap.java:219) at reactor.core.publisher.FluxIterable.subscribe(FluxIterable.java:201) at reactor.core.publisher.FluxIterable.subscribe(FluxIterable.java:83) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDeferContextual.subscribe(MonoDeferContextual.java:55) at reactor.netty.http.server.HttpServer$HttpServerHandle.onStateChange(HttpServer.java:1112) at reactor.netty.ReactorNetty$CompositeConnectionObserver.onStateChange(ReactorNetty.java:707) at reactor.netty.transport.ServerTransport$ChildObserver.onStateChange(ServerTransport.java:481) at reactor.netty.http.server.HttpServerOperations.onInboundNext(HttpServerOperations.java:626) at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:114) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at reactor.netty.http.server.HttpTrafficHandler.channelRead(HttpTrafficHandler.java:230) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:436) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562) at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) at java.lang.Thread.run(Thread.java:750) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “@P0”附近有语法错误。 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:648) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:567) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7675) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4137) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:544) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy216.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at com.sun.proxy.$Proxy214.query(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy213.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
最新发布
09-16
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “@P0”附近有语法错误。 ... ### SQL: SELECT factory_code,factory_name,status FROM tm_factory OFFSET ? ROWS FETCH NEXT ? ROWS ONLY ``` --...
数据库轮询调度为何被淘汰？资源消耗与延迟响应的4项量化指标对比真相
在早期分布式系统架构中，数据库轮询调度曾是实现数据变更感知的主要手段。其核心思想是通过定时任务周期性地查询数据库表，判断是否有新记录或更新，从而触发后续业务逻辑。该机制实现简单，兼容性强，适用于缺乏...
monogb数据库
xiaomin1328的博客
05-27 272
1、启动monogb数据库：如果要在非本机远程连接该数据库，需要添加–bind_ip_all，再启动monodb即可 …\mongodb-win32-x86_64-2012plus-4.2.2\bin\mongod --dbpath mongodata --bind_ip_all
Mono人体运动数据库文档
08-25
Mono人体运动数据库文档,Mono人体运动数据库文档
.Net数据库操作基类 - 通用于Windows及Linux的Mono环境
04-04
1、.Net数据库操作基类，支持Mysql、Sql Server、Oracle等多种数据库； 2、同一项目可以支持调用不同数据库，只需在调用前调用DataBaseOperator.Init方法； 3、采用绑定变量调用，参数通过ParamCollections对象实现； 4、调用方便，一次初使化连接池名，后续直接调用； 5、详细使用说明见我博客。
C#mono for android最实用的数据库链接代码（详细解释）
10-17
mono for android网络资源极其稀少， 自己编写的数据库连接 详细方法， 包含 执行str返回结果，执行str返回string，执行str返回数据集dataset，通过批处理执行str，创建手机本地sqlite数据库，创建手机本地数据库表，填写数据等。 另外 pubclass中包含 解决toast不能及时显示的方法：调用类库内的公共方法立即显示当前的并结束之前的。
Linux下通过python访问MySQL、Oracle、SQL Server数据库的方法
09-21
主要介绍了Linux下通过python访问MySQL、Oracle、SQL Server数据库的方法,需要的朋友可以参考下
Linux+php+apache+oracle环境搭建之CentOS下安装Oracle数据库
M201170944的博客
03-14 997
转发
Oracle 访问SQL Server的数据 （通过Oracle gataway）
文档搬运工
06-30 3450
测试例子：通过Oracle的GateWay，访问SQLServer的数据。 Oracle 信息： Oracle所在机器的IP ： 192.168.2.28 oracle SID ：test Oracle 版本： 11.2.0.4 SQL Server 信息： SQL Server所在机器的IP ： 192.168.2.28 SQLServer SID ： MSSQLSERVER ...
Oracle数据库连接并访问Microsoft SQL Server数据库
3301
06-10 4065
Oracle数据库连接SQLServer数据库
mono下使用Nhibernate
ass673556617的专栏
02-26 657
突发奇想要在mac下写ASP.NET, 选择了mono之后出了一堆的问题。 昨天尝试使用Sqlite作为数据库结果花费了大量的时间一致没有找明白该如何解决，今天尝试连接mysql终于成功了。这里简单回顾下如何使用NHibernate操作mysql数据库。 把能注意到的问题在这里总结一下。 明后天的任务是学习c#语法，熟悉ASP.NET 的机制，学习NHibernate操作数据库。
树莓派：使用mono和C#调用MSSQL数据库
ki1381的专栏
12-29 987
工作关系，接触最多的数据库还是微软的SQL Server，所以哪怕玩树莓派，都想着如何访问一下MSSQL。目前我能想到并且测试成功的有Python和PHP，以及能带UI的QT。Python和QT需要安装unixodbc，php则需要php-sybase库。最近突然又想起久闻大名的mono了，何不也试试？ 说干就干，sudo apt-get install mono-complete 暂时只需要...
使用VS2015 Xamarin开发Android应用并连接SQL Server数据库
如果存在SQL Server连接的代码部分，开发者可能还需要配置相应的网络设置和数据库连接字符串，以及确保数据库服务器的安全性设置，如使用加密连接、配置防火墙规则等。 综上所述，此文件涉及到的知识点非常丰富，...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值