測試連結INFORMIX DB產生JSP,執行Go Live有問題
發表於 : 2004-04-16 14:27:51
本主機平台為NT,DB為Informix&已裝JRun,Code如下列設定
Design的環境是可以讀取Informix DataBase的資料,但是
Server端的設定不知是否如下設定即可,Go Live,
QQ測試粉久總是會出現Bug,請求Help,Thanks...
--------------------------------------------------
Server
Location: Local/Network
Connection String
jdbc:informix-qli://IP:PORT/DBName:INFORMIXSERVER=
Login:xxx
PassWord:xxx
Database Driver
com.informix.jdbc.IfxDriver
--------------------------------------------------
Error Message 如下
500 Internal Server Error
/test/jsp/jsp/Page.jsp:
javax.servlet.ServletException: Exception thrown on line '19' from page 'D:\Progame File\servers\default\test\jsp\jsp\Page.jsp'.
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537).....
請在站台設定->一般->伺服主機應用路徑
裡設定正確的路徑...
如:c:/tomcat/codecharge/
Informix JDBC DataSource 已經測試 OK !!
但 Go Live 仍有 Null 之問題~~
但又有下列 Error Message :
==================================================
/6tom/default.jsp:
null
java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:380)
at jrun__default2ejspc$TextTemplate.parse(jrun__default2ejspc.java:166)
at jrun__default2ejspc.comprod_Show(jrun__default2ejspc.java:813)
at jrun__default2ejspc._jspService(jrun__default2ejspc.java:76)
at allaire.jrun.jsp.HttpJSPServlet.service(../jsp/HttpJSPServlet.java:40)
....
不知是否資料內存在null值,才當機
Installing and Testing JDBC for Informix Systems
http://www.inquiry.com/techtips/info_pr ... in0800.asp
No suitable driver
即jdk找不到您database的Driver
請確認您的informix的JDBC Driver有放在系統路徑
CLASSPATH中...
還有您的jdbc連結字串可能有誤,不知是不是漏打
應是jdbc:informix-sqli://127.0.0.1:1533/database:INFORMIXSERVER=informix
是infomix-sqli不是informix-qli
Design的環境是可以讀取Informix DataBase的資料,但是
Server端的設定不知是否如下設定即可,Go Live,
QQ測試粉久總是會出現Bug,請求Help,Thanks...
--------------------------------------------------
Server
Location: Local/Network
Connection String
jdbc:informix-qli://IP:PORT/DBName:INFORMIXSERVER=
Login:xxx
PassWord:xxx
Database Driver
com.informix.jdbc.IfxDriver
--------------------------------------------------
Error Message 如下
500 Internal Server Error
/test/jsp/jsp/Page.jsp:
javax.servlet.ServletException: Exception thrown on line '19' from page 'D:\Progame File\servers\default\test\jsp\jsp\Page.jsp'.
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537).....
請在站台設定->一般->伺服主機應用路徑
裡設定正確的路徑...
如:c:/tomcat/codecharge/
Informix JDBC DataSource 已經測試 OK !!
但 Go Live 仍有 Null 之問題~~
但又有下列 Error Message :
==================================================
/6tom/default.jsp:
null
java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:380)
at jrun__default2ejspc$TextTemplate.parse(jrun__default2ejspc.java:166)
at jrun__default2ejspc.comprod_Show(jrun__default2ejspc.java:813)
at jrun__default2ejspc._jspService(jrun__default2ejspc.java:76)
at allaire.jrun.jsp.HttpJSPServlet.service(../jsp/HttpJSPServlet.java:40)
....
不知是否資料內存在null值,才當機
Installing and Testing JDBC for Informix Systems
http://www.inquiry.com/techtips/info_pr ... in0800.asp
No suitable driver
即jdk找不到您database的Driver
請確認您的informix的JDBC Driver有放在系統路徑
CLASSPATH中...
還有您的jdbc連結字串可能有誤,不知是不是漏打
應是jdbc:informix-sqli://127.0.0.1:1533/database:INFORMIXSERVER=informix
是infomix-sqli不是informix-qli