以文本方式查看主题 - 计算机科学论坛 (http://bbs.xml.org.cn/index.asp) -- 『 Semantic Web(语义Web)/描述逻辑/本体 』 (http://bbs.xml.org.cn/list.asp?boardid=2) ---- protege中建立的本体如何导入到sql server数据库 (http://bbs.xml.org.cn/dispbbs.asp?boardid=2&rootid=&id=36333) |
-- 作者:fangel2000 -- 发布时间:8/2/2006 8:36:00 PM -- protege中建立的本体如何导入到sql server数据库 大家好,我已经在protege中建立了一个本体,现在的问题是我如何导入到sql server数据库中呢,前段时间看了一篇文章是介绍导入到mysql数据库中的,我照着样子做了,但是无法导入到sql server数据库中,请问大侠们知道吗?帮帮忙,感激 |
-- 作者:nantianzhu -- 发布时间:8/3/2006 11:02:00 AM -- > Make sure that you: > > 1- have the correct drivers (MS JDBC drivers) in the correct folder so > Protégé can find them > 2- are using the correct class name (com.microsoft.jdbc.sqlserver.SQLServerDriver) > 3- are using the correct JDBC URL: > > jdbc:microsoft:sqlserver://[your server dns/ip address]:[MS SQL > port];DatabaseName=[Your DB name];SelectMethod=Cursor 其中 第一步要确保将 jdbc驱动中的3个jar文件以driver.jar driver1.jar driver2.jar 重命名放入protege目录下,其他操作和导入mysql一样 |
-- 作者:fangel2000 -- 发布时间:8/3/2006 11:39:00 AM -- 根据你的说法,在JDBC URL中填写:jdbc:microsoft:sqlserver://[fangel]:[MS SQL port];DatabaseName=database;SelectMethod=Cursor吗?显示语法错误啊 其中fangel为我的server dns,database为我建的数据库名。 另外jdbc驱动中有3个jar文件吗?我只找到了两个,求救 |
-- 作者:fangel2000 -- 发布时间:8/4/2006 4:13:00 PM -- 怎么还没有人回答我这个问题啊?帮帮忙啊 |
-- 作者:jelly_82 -- 发布时间:3/5/2007 8:14:00 PM -- 刚遇到这个问题,解决了. 按照二楼的朋友说的就行了. 楼主再看看,jdbc驱动目录lib下有三个.jar文件的. jdbc:microsoft:sqlserver://localhost:1433,SelectMethod=Cursor,Database=OntologyDB 我这样设就可以了. |
-- 作者:hnlyf -- 发布时间:3/9/2007 3:57:00 PM -- 学习………… |
-- 作者:coco -- 发布时间:3/15/2007 4:18:00 PM -- bucuo .学习了. |
-- 作者:giggs77777 -- 发布时间:3/16/2007 10:43:00 AM -- 导进去以后怎末用呢? 知识库和推理机应该是在sql上面另写一层吧,应该不能把逻辑直接写到存储过程中 不知道我的理解对否 |
-- 作者:giggs77777 -- 发布时间:3/16/2007 10:44:00 AM -- 导进去以后怎末用呢? 知识库和推理机应该是在sql上面另写一层吧,应该不能把逻辑直接写到存储过程中 不知道我的理解对否 |
-- 作者:iisamsung -- 发布时间:3/16/2007 1:50:00 PM -- 不错,顶一下 |
-- 作者:iisamsung -- 发布时间:3/16/2007 1:52:00 PM -- 为什么要用JDBC,不用ODBC呢,是跟java有关吗?不好意思,我不太懂 |
-- 作者:xmkcg -- 发布时间:3/17/2007 11:01:00 AM -- 学习中,顶。。 |
-- 作者:栀子花kkk -- 发布时间:3/27/2007 3:20:00 PM -- 请教搂主,您之前看的那篇介绍导入到mysql数据库中的文章,在哪里呢?能分享一下吗? |
-- 作者:boschye -- 发布时间:3/27/2007 10:03:00 PM -- 请教连接SQL Server与Oracle数据库的驱动在哪里下载啊? |
-- 作者:qxr777 -- 发布时间:3/28/2007 12:47:00 PM -- 在microsoft的官方网站就有针对JDBC的driver打包下载,三个JAR分别是msbase.jar, msutil.jar,mssqlserver.jar 但是将本体导入关系数据库,将可能损失掉本体中大量的语义信息 |
-- 作者:DustWater -- 发布时间:3/29/2007 9:04:00 AM -- 学习学习 |
-- 作者:piaor_123 -- 发布时间:4/13/2007 8:16:00 PM -- 我在连接protege与SQL Server时出现一个问题:提示驱动可以找到,但用driver url连接不上,可能是url syntax错误或用户名,密码非法 配置设置:class name:com.microsoft.jdbc.sqlserver.SQLServerDriver jdbc url:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ProtegeDB; SelectMethod=Cursor Table: Pizza username:sa password:1 请问这到底是什么问题呢?语法错误?用户名和密码都没有问题啊……望高手帮忙啊…… |
-- 作者:feng2007 -- 发布时间:4/19/2007 12:09:00 PM -- 不错,数据库能连上,但是在sql中无法看见数据,这又是怎么回事呢?出现这样的问题: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start manual transaction mode because there are cloned connections. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.setAutoCommit(Unknown Source) at edu.stanford.smi.protege.storage.database.RobustConnection.setAutoCommit(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseFrameDb.beginBatch(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseWriter.save(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.copyKnowledgeBase(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.copyKnowledgeBase(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.saveKnowledgeBase(Unknown Source) at edu.stanford.smi.protegex.owl.database.OWLDatabaseKnowledgeBaseFactory.saveKnowledgeBase(Unknown Source) at edu.stanford.smi.protege.model.Project.saveDomainKB(Unknown Source) at edu.stanford.smi.protege.model.Project.save(Unknown Source) at edu.stanford.smi.protege.ui.ProjectManager.save(Unknown Source) at edu.stanford.smi.protege.ui.ProjectManager.changeProjectStorageFormatRequest(Unknown Source) at edu.stanford.smi.protege.action.ChangeProjectStorageFormat.actionPerformed(Unknown Source) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) 请大家多多指点. |
-- 作者:scarel -- 发布时间:4/19/2007 2:37:00 PM -- 对,MYSQL,Oracle页都一样要几个jar文件 |
-- 作者:feng2007 -- 发布时间:4/19/2007 3:50:00 PM -- 我的连上了,但是在protege里面显示下面的内容: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start manual transaction mode because there are cloned connections. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.setAutoCommit(Unknown Source) at edu.stanford.smi.protege.storage.database.RobustConnection.setAutoCommit(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseFrameDb.beginBatch(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseWriter.save(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.copyKnowledgeBase(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.copyKnowledgeBase(Unknown Source) at edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.saveKnowledgeBase(Unknown Source) at edu.stanford.smi.protegex.owl.database.OWLDatabaseKnowledgeBaseFactory.saveKnowledgeBase(Unknown Source) at edu.stanford.smi.protege.model.Project.saveDomainKB(Unknown Source) at edu.stanford.smi.protege.model.Project.save(Unknown Source) at edu.stanford.smi.protege.ui.ProjectManager.save(Unknown Source) at edu.stanford.smi.protege.ui.ProjectManager.changeProjectStorageFormatRequest(Unknown Source) at edu.stanford.smi.protege.action.ChangeProjectStorageFormat.actionPerformed(Unknown Source) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) 同时在数据库中没有数据只有刚连上时建的两个表,没数据,怎么回事呢?请大虾指教!!! |
-- 作者:baobei223 -- 发布时间:4/22/2007 11:59:00 PM -- 我有一个cyc.owl文件大约23M,在protege中导入总是内存溢出,该怎么办? |
-- 作者:hxy -- 发布时间:7/23/2009 9:13:00 PM -- 我也遇到楼主的问题,请教哪位高手指点一下,qq:382535864,小弟感激不尽。 |
-- 作者:auto123 -- 发布时间:8/25/2009 9:48:00 AM -- protege 怎样连 sqlserver2005 sqlserver 2000 的 jdbc 有三个JAR包,2005只有一个. 用protege导出时能够找到驱动,但URL出错,该如何写? |
-- 作者:happytreeyang -- 发布时间:1/1/2011 10:39:00 AM -- 我也有类似问题,请教大家 |
W 3 C h i n a ( since 2003 ) 旗 下 站 点 苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》 |
109.009ms |