myeclipse 6.0.0.M1对sql server 2005 支持问题

mengweilil 2009-04-13 10:34:40
1、MyEclipse启动用的jdk是1.5.0_11-b03.
2、使用MyEclipse配置sql server2005,只能用sqljdbc.jar,不能用sqljdbc4.jar ,如果用4.jar,那么配置不起来。
3、如果你将项目的jdk设置为jdk1.6,而不是用myeclipse自带的jdk,那么,访问sql server2005,会报错,说jdk1.6必须用sqljdbc4.jar。。。。。。。(当然,如果你坚持用老版本的jdk开发,就没问题)

解决办法:修改myeclipse的启动jdk:

1、将myeclipse目录下的jre目录重命名为jre1(或者其他随便啥名字,删掉也可以)
2、将其他地方安装的1.6的jre拷贝过来,比如:c:\jre1.6.0_03,然后把这个目录重命名为jre。
3、启动myeclipse,现在myeclipse本身运行jre就是1.6.0_03,然后修改windows-》preferences-》java-》installed jres,增加jdk1.6的jvm,并设置为默认jvm。

现在,再添加sql server的driver的时候,可以选择sqljdbc4.jar了(当然还有一点儿小的显示bug——那就是当你再次edit这个driver的时候,driver template是空的(及时你选择了sql server2005,保存了,下次进来还是空的。。。。。),不过不影响使用。

这个无法配置sqljdbc4.jar目前未在网络上发现解决方案,在myeclipse的官方论坛,只发现这样一个链接(请用代理访问该链接):http://www.myeclipseide.com/index.php?name=PNphpBB2&file=viewtopic&t=22810&start=0&postdays=0&postorder=asc&highlight=sql+server

原文如下:(1、网站未给出解决方案,2、说明7.0的MyEclipse还是用1.5的jre。。。。。。)

Registered Member


Joined: May 16, 2006
Posts: 5


Hi,

I've been trying to connect to a SQL Server 2005 DB through the explorer and I have not been able to do it. When I try to create a new connection, I get: Driver class not found.

I have add the jar when I'm trying to set up the connection, but I still get the error. Any advice you can provide would be greatly appreciated.

Thanks!

View user's profile Send private message
Reply with quote Back to top
support-nipun

Post subject: RE: Can PostPosted: Jan 28, 2009 - 04:31 PM
Registered Member
Registered Member


Joined: Apr 18, 2007
Posts: 7065


Can you send me a link to the jar that you are using. I would like to test this at my end as well.

Also, can you go to MyEclipse > Installation Summary > Installation Details and paste the information here for me.

_________________
Nipun
MyEclipse Support

View user's profile Send private message Send e-mail
Reply with quote Back to top
NuAlphaMan

Post subject: RE: Can PostPosted: Jan 29, 2009 - 01:44 AM
Registered Member
Registered Member


Joined: May 16, 2006
Posts: 5


Here is the link:
http://msdn.microsoft.com/en-us/data/aa937724.aspx

I'm using the JDBC 2.0 Driver

*** Date:
Wednesday, January 28, 2009 8:41:41 PM EST

** System properties:
OS=WindowsVista
OS version=6.0.0
Java version=1.5.0_11


*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 7.0
Build id: 7.0-20081201


*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 7.0
Build id: 7.0-20081201




Eclipse Platform

Version: 3.4.1.r341_v20080731-9I96EiDElYevwz-p1bP5z-NlAaP7vtX6Utotqsu
Build id: M20080911-1700


Eclipse Java Development Tools

Version: 3.4.1.r341_v20080709-0800-7o7tEAfEF_U5qyUgrb2HAp539P97
Build id: M20080709-0800


Eclipse Graphical Editing Framework GEF

Version: 3.4.1.v20080806-67718083A56B4H2A3213573
Build id: 200809101400


Eclipse RCP

Version: 3.4.100.r341_v20080814-989JESIEdAciFYfkZZsBfSwQ2341
Build id: M20080703-0800


Eclipse Plug-in Development Environment

Version: 3.4.1.r341_v20080731-7T7U0E9mlRIuGUYviF_VP
Build id: M20080703-0800




Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Users\Bernie\AppData\Local\Genuitec\MyEclipse 7.0\myeclipse.exe
-name
Myeclipse
--launcher.library
C:\Users\Bernie\AppData\Local\Genuitec\MyEclipse 7.0\../Common\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.101.R34x_v20080731\eclipse_1115.dll
-startup
C:\Users\Bernie\AppData\Local\Genuitec\MyEclipse 7.0\../Common\plugins\org.eclipse.equinox.launcher_1.0.101.R34x_v20080819.jar
-clean
-configuration
C:\Users\Bernie\AppData\Local\Genuitec\MyEclipse 7.0\configuration
-vm
C:\Users\Bernie\AppData\Local\Genuitec\Common\binary\com.sun.java.jre.win32.x86_1.5.0.011\bin\client\jvm.dll

View user's profile Send private message
Reply with quote Back to top
support-nipun

Post subject: RE: Can PostPosted: Jan 29, 2009 - 05:39 PM
Registered Member
Registered Member


Joined: Apr 18, 2007
Posts: 7065


I was unable to reproduce this issue using the JAR available at the link you provided above. Added the sqljdbc.jar.

Can you hit the pm button at the bottom of my post and send me a screenshot with the error showing up.

_________________
Nipun
MyEclipse Support

View user's profile Send private message Send e-mail
Reply with quote Back to top
NuAlphaMan

Post subject: RE: Can PostPosted: Jan 30, 2009 - 01:43 AM
Registered Member
Registered Member


Joined: May 16, 2006
Posts: 5


I switched to this jar and it's working. I was using the sqljdbc4.jar and it wouldn't work with that jar. Thanks.

View user's profile Send private message
Reply with quote Back to top
support-nipun

Post subject: RE: Can PostPosted: Jan 30, 2009 - 06:22 PM
Registered Member
Registered Member


Joined: Apr 18, 2007
Posts: 7065


Your welcome.

_________________
Nipun
MyEclipse Support
...全文
227 3 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
lixilin0 2009-04-13
  • 打赏
  • 举报
回复
关注
mengweilil 2009-04-13
  • 打赏
  • 举报
回复
这个问题应该比较常见啊——但是在网上未发现解决方案。。。。。。。难道大家都用的是myeclipse自带的jre?或者都用sql server2000?或者都是mysql?

另外,像myeclipse的auto reploy,也未见解答。。。。。。。

真奇怪——当然,更大的可能性,是很多人都知道怎么解决,但从不上csdn?
ghostgant 2009-04-13
  • 打赏
  • 举报
回复
WebSphere 是 IBM 的软件平台。它包含了编写、运行和监视全天候的工业强度的随需应变 Web 应用程序和跨平台、跨产品解决方案所需要的整个中间件基础设施,如服务器、服务和工具。WebSphere 提供了可靠、灵活和健壮的软件。 WebSphere Application Server 是该设施的基础,其他所有产品都在它之上运行。WebSphere Process Server 基于 WebSphere Application Server 和 WebSphere Enterprise Service Bus,它为面向服务的体系结构 (SOA) 的模块化应用程序提供了基础,并支持应用业务规则,以驱动支持业务流程的应用程序。高性能环境还使用 WebSphere Extended Deployment 作为其基础设施的一部分。其他 WebSphere 产品提供了广泛的其他服务,如下所述。   WebSphere 是一个模块化的平台,基于业界支持的开放标准。您可以使用受信任和持久的接口,将现有资产插入 WebSphere,并且可以随着需要的增长继续扩展您的环境。WebSphere 可以在许多平台上运行,包括 Intel、Linux 和 z/OS。   WebSphere 是随需应变的电子商务时代的最主要的软件平台。它使您的公司可以开发、部署和整合新一代的电子商务应用,如B2B电子商务,并支持从简单的网页内容发布到企业级事务处理的商业应用。WebSphere 改变了业务管理者,合作伙伴和雇员之间的关系,例如您可以用它做如下工作:   创建高效的电子商务站点提高了网上交易的质量和数量。 把应用扩展到联合的移动设备上使销售人员可以为客户提供更方便、更快捷的服务。 整合已有的应用并提供自动简捷的业务流程。

58,452

社区成员

发帖
与我相关
我的任务
社区描述
Java Eclipse
社区管理员
  • Eclipse
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧