以文本方式查看主题

-  中文XML论坛 - 专业的XML技术讨论区  (http://bbs.xml.org.cn/index.asp)
--  『 Web Services & Semantic Web Services 』  (http://bbs.xml.org.cn/list.asp?boardid=10)
----  Tomcat+Axis+Mysql下配置juddi问题!!!  (http://bbs.xml.org.cn/dispbbs.asp?boardid=10&rootid=&id=20855)


--  作者:dodo8091
--  发布时间:8/2/2005 11:40:00 PM

--  Tomcat+Axis+Mysql下配置juddi问题!!!
我打开http://127.0.0.1:8080/juddi/happyjuddi.jsp,可是出现如下信息:

jUDDI Dependencies: Class Files & Libraries
Looking for: org.juddi.registry.Registry
+Found in: F:\tomcat4\webapps\juddi\WEB-INF\lib\juddi.jar

Looking for: javax.xml.soap.SOAPMessage
+Found in: F:\tomcat4\common\lib\saaj.jar

Looking for: javax.xml.rpc.Service
+Found in: F:\tomcat4\common\lib\jaxrpc.jar

Looking for: org.apache.axis.transport.http.AxisServlet
+Found in: F:\tomcat4\webapps\juddi\WEB-INF\lib\axis.jar

Looking for: org.apache.commons.discovery.Resource
+Found in: F:\tomcat4\webapps\juddi\WEB-INF\lib\commons-discovery.jar

Looking for: org.apache.commons.logging.Log
+Found in: F:\tomcat4\webapps\juddi\WEB-INF\lib\commons-logging.jar

Looking for: org.apache.log4j.Layout
+Found in: F:\tomcat4\webapps\juddi\WEB-INF\lib\log4j-1.2.8.jar

Looking for: com.ibm.wsdl.factory.WSDLFactoryImpl
+Found in: F:\tomcat4\webapps\juddi\WEB-INF\lib\wsdl4j.jar

Looking for: javax.xml.parsers.SAXParserFactory
+Found in an unknown location

Looking for: javax.activation.DataHandler
+Found in: F:\tomcat4\common\lib\activation.jar

jUDDI Dependencies: Resource & Properties Files
Looking for: log4j.properties+Found in: F:\tomcat4\webapps\juddi\WEB-INF\classes\log4j.propertiesLooking for: juddi.properties+Found in: F:\tomcat4\webapps\juddi\WEB-INF\classes\juddi.properties

jUDDI DataSource Check
+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot create PoolableConnectionFactory)
- SELECT COUNT(*) FROM PUBLISHER failed (null)


jUDDI Properties
juddi.adminEmailAddress: admin@juddi.org
juddi.adminURL: http://localhost:8080/juddi/admin
juddi.authFactory: org.juddi.auth.simple.SimpleAuthenticatorFactory
juddi.dataStoreFactory: org.juddi.datastore.jdbc.JDBCDataStoreFactory
juddi.inquiryURL: http://localhost:8080/juddi/inquiry
juddi.jdbcDriver: com.mysql.jdbc.Driver
juddi.jdbcPassword: juddi
juddi.jdbcURL: jdbc:mysql://localhost/juddi
juddi.jdbcUser: juddi
juddi.maxMessageSize: 2097152
juddi.maxNameElementsAllowed: 5
juddi.maxNameLength: 255
juddi.operatorName: jUDDI.org
juddi.operatorSiteURL: http://localhost:8080/juddi
juddi.publishURL: http://localhost:8080/juddi/publish
juddi.transportClass: org.juddi.transport.axis.AxisTransport
juddi.useConnectionPool: false
juddi.uuidgenFactory: org.juddi.uuidgen.jvm.JavaUUIDGenFactory


System Properties
awt.toolkit: sun.awt.windows.WToolkit
catalina.base: F:\tomcat4
catalina.home: F:\tomcat4
catalina.useNaming: true
file.encoding: GBK
file.encoding.pkg: sun.io
file.separator: \
java.awt.graphicsenv: sun.awt.Win32GraphicsEnvironment
java.awt.printerjob: sun.awt.windows.WPrinterJob
java.class.path: F:\j2sdk1.4.0\lib\tools.jar;F:\tomcat4\bin\bootstrap.jar
java.class.version: 48.0
java.endorsed.dirs: F:\tomcat4\common\endorsed
java.ext.dirs: F:\j2sdk1.4.0\jre\lib\ext
java.home: F:\j2sdk1.4.0\jre
java.io.tmpdir: F:\tomcat4\temp
java.library.path: F:\j2sdk1.4.0\bin;.;C:\WINNT\system32;C:\WINNT;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;D:\PROGRA~1\ULTRAE~1;F:\ant\bin;F:\j2sdk1.4.0\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;d:\Program Files\Starbase\StarGate SDK\Lib;d:\Program Files\Starbase\StarGate SDK\Bin
java.naming.factory.initial: org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs: org.apache.naming
java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
java.runtime.version: 1.4.0-b92
java.specification.name: Java Platform API Specification
java.specification.vendor: Sun Microsystems Inc.
java.specification.version: 1.4
java.util.prefs.PreferencesFactory: java.util.prefs.WindowsPreferencesFactory
java.vendor: Sun Microsystems Inc.
java.vendor.url: http://java.sun.com/
java.vendor.url.bug: http://java.sun.com/cgi-bin/bugreport.cgi
java.version: 1.4.0
java.vm.info: mixed mode
java.vm.name: Java HotSpot(TM) Client VM
java.vm.specification.name: Java Virtual Machine Specification
java.vm.specification.vendor: Sun Microsystems Inc.
java.vm.specification.version: 1.0
java.vm.vendor: Sun Microsystems Inc.
java.vm.version: 1.4.0-b92
line.separator:

os.arch: x86
os.name: Windows 2000
os.version: 5.0
path.separator: ;
sun.arch.data.model: 32
sun.boot.class.path: F:\tomcat4\common\endorsed\xercesImpl.jar;F:\tomcat4\common\endorsed\xmlParserAPIs.jar;F:\tomcat4\common\endorsed\xerces.jar;F:\j2sdk1.4.0\jre\lib\rt.jar;F:\j2sdk1.4.0\jre\lib\i18n.jar;F:\j2sdk1.4.0\jre\lib\sunrsasign.jar;F:\j2sdk1.4.0\jre\lib\jsse.jar;F:\j2sdk1.4.0\jre\lib\jce.jar;F:\j2sdk1.4.0\jre\lib\charsets.jar;F:\j2sdk1.4.0\jre\classes
sun.boot.library.path: F:\j2sdk1.4.0\jre\bin
sun.cpu.endian: little
sun.cpu.isalist: pentium i486 i386
sun.io.unicode.encoding: UnicodeLittle
sun.io.useCanonCaches: false
sun.java2d.fontpath:
sun.os.patch.level: Service Pack 4
user.country: CN
user.dir: F:\tomcat4\bin
user.home: C:\Documents and Settings\Administrator
user.language: zh
user.name: Administrator
user.timezone: Asia/Shanghai
user.variant:

我用的是tomcat4.1,axis1.2.1,mysql4.1,
当我执行juddi_mysql.ddl的时候,提示说:

mysql-> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
    -> VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special taxon
omy consisting of namespace identifiers and the keywords associated with the nam
espaces');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'uuid:
4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used to categorize e' at
line 2


mysql> INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DE
SCR)
    -> VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel defines an unidentified taxonomy.');
ERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint f
ails


mysql> INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NA
ME,KEY_VALUE)
    -> VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672
-4404-9D70-39B756E62AB4','types','categorization');
ERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint f
ails

总是显示:
jUDDI DataSource Check
+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot create PoolableConnectionFactory)
- SELECT COUNT(*) FROM PUBLISHER failed (null)


另外,说
Looking for: javax.xml.parsers.SAXParserFactory
+Found in an unknown location

到底这个jar应该放在哪里阿?
万分感谢!!!


--  作者:lixiaoming
--  发布时间:12/11/2008 4:43:00 PM

--  
最后一个Looking for: javax.xml.parsers.SAXParserFactory
+Found in an unknown location
不用管它,都是这样的
至于你的
- DB connection was not aquired. (Cannot create PoolableConnectionFactory)
这个要看一下你的Tomcat中的server.xml里面的配置了:如果你的是Tomcat5.5的话
必须要保证你的jdbc驱动要放对了位置,按照论坛里面的做法
具体应该在<Host> </Host>中加入:<Context crossContext="true" path="/juddi" reloadable="true">    
    <Resource auth="Container" name="jdbc/juddiDB" type="javax.sql.DataSource" password="juddi"        driverClassName="com.mysql.jdbc.Driver" maxIdle="2" maxWait="5000" validationQuery="select count(*) from        PUBLISHER" username="juddi" url="jdbc:mysql://localhost/juddi" maxActive="4"/>    
</Context>   
要注意你的数据库名啊jdbc:mysql://localhost/juddi,juddi是你的数据库名,一般先看一下你的juddi中关于sql的脚本文件,我用的是mysql这样成功了

W 3 C h i n a ( since 2003 ) 旗 下 站 点
苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
46.875ms