我在C:\bea\weblogic700\server\bin\startWLS.cmd中添加了Oracle的驱动,然后启动的时候发现没有报找不到数据库驱动的错误了. 但还是有错误,连接池的问题??<2003-7-16 上午11时12分26秒> <Error> <JDBC> <001060> <Cannot startup connection pool "Pool" weblogic.common.ResourceException: weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: java.sql.SQLException: 调用中无效的参数 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857) at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:189) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365) //中间省略..... at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:235) at weblogic.t3.srvr.ServerLifeCycleList.resume(ServerLifeCycleList.java:61) at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:806) at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:295) at weblogic.Server.main(Server.java:32) > <2003-7-16 上午11时12分34秒> <Notice> <Management> <141052> <Application Poller started for development server.> <2003-7-16 上午11时12分40秒> <Notice> <WebLogicServer> <000354> <Thread "SSLListenThread.Default" listening on port 7002> <2003-7-16 上午11时12分40秒> <Notice> <WebLogicServer> <000354> <Thread "ListenThread.Default" listening on port 7001> <2003-7-16 上午11时12分40秒> <Notice> <WebLogicServer> <000331> <Started WebLogic Admin Server "myserver" for domain "mydomain" running in Development Mode> <2003-7-16 上午11时12分41秒> <Notice> <WebLogicServer> <000365> <Server state changed to RUNNING> <2003-7-16 上午11时12分41秒> <Notice> <WebLogicServer> <000360> <Server started in RUNNING mode>
Could not create pool connection. The DBMS driver exception was: java.sql.SQLException: 调用中无效的参数这句话什么意思?
Could not create pool connection. The DBMS driver exception was: java.sql.SQLException: 调用中无效的参数这句话什么意思?
现在的问题是: 我卸载了WL8, 然后删除bea文件夹.重新安装WL8后 WebLogic 810b启动没有问题. 但是不能将DataSource Deploy到myserver上. 在mydomain> JDBC Data Sources 下面看到的状态如下: Name :oraclesample4 JNDIName :oraclesample4 Pool Name :oraclepool Row Prefetch Enabled :false Enable Two Phase Commit :n/a Stream Chunk Size :256 Row Prefetch Size :48 Deployed :false <<--我想问题可能就出现在这里,无论如何,这里总是false!!并且在IE的左下角("Applet已启动"字样的左边)出现一个黄色感叹号图标,双击它弹出详细信息: 行:1203 字符:3 错误:对象不支持此属性或方法 代码:0 URL:http://localhost:7001/console/actions/mbean/DoMBeanWizardAction?parentMBean=mydomain%3AName%3Dmydomain4%2CType%3DDomain&attributes=weblogic.management.configuration.JDBCTxDataSourceMBean.Name%3Doraclesample4&attributes=weblogic.management.configuration.JDBCTxDataSourceMBean.JNDIName%3Doraclesample4&attributes=weblogic.management.configuration.JDBCDataSourceAssistant.Tx%3Dfalse&reloadNav=false&message&=wizardName=JDBCDataSourceAssistant&step=Pool&MBeanClass=weblogic.management.configuration.JDBCTxDataSourceMBean 下面还有两个: URL:http://localhost:7001/console/actions/mbean/EditMBeanAction?reloadNav=false&MBean=mydomain%3AName%3Doraclesample4%2CType%3DJDBCDataSource URL:http://localhost:7001/console/actions/mbean/DoEditMBeanAction?reloadNav=false&MBean=mydomain%3AName%3Doraclesample4%2CType%3DJDBCDataSource
给你一个我用的文档,关于配置数据源: Services->JDBC->Connection Pools->Configure a new JDBC Connection Pool... [Name]: ConnectionPool [URL]: jdbc:oracle:thin:@devsrv:1521:orcl [DriverClassName]: oracle.jdbc.driver.OracleDriver [Key-Value]: user=helios_user password=a dll=ocijdbc8 protocol=thin定位服务器。(参看TxDataSourceConf.txt)
Services->JDBC->Tx Data Sourcess->Create a new JDBCTxDataSource... [Name]: DataSource [JNDI Name]:DataSource [Pool Name]:ConnectionPool [Emulate Two-Phase Commit for non-XA Driver]: checked boxServices->JDBC->Tx Data Sourcess->LotteryDataSource->Targets 在Available内选择一个server到Chosen内。按APPLY。
This page allows you to view the general configuration of this Web Application module. Name: AccountTransactionWeb The name of this Web application deployment. Context Root: /AccountTransactionWeb The URI, located on the Administration Server, of the original source files for this Web application module. Path: C:\ bea\ user_projects\ mydomain\ .\ myserver\ upload\ AccountTransaction\ AccountTransaction.ear\ AccountTransactionWeb.war The location of the WAR file or exploded WAR directory ------------------------------------------------------------------------------- This page allows you to test the deployment of the Web application to make sure it was a successful one. myserver: http://localhost:7001/AccountTransactionWeb/ Welcome Files: There are no welcome files for this application. -------------------------------------------------------------------------------- Web 组件中,有一个名为 ManageAcc 的 servlet。servlet 执行诸如提款、存款之类的银行事务并显示执行后的余额。 ---------------------------------------------------------------------------------- 但是我在IE里浏览http://localhost:7001/AccountTransactionWeb/ManageAcc 却提示404 not found.错误 这是什么原因?
但还是有错误,连接池的问题??<2003-7-16 上午11时12分26秒> <Error> <JDBC> <001060> <Cannot startup connection pool "Pool" weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: 调用中无效的参数
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:189)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
//中间省略.....
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:235)
at weblogic.t3.srvr.ServerLifeCycleList.resume(ServerLifeCycleList.java:61)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:806)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:295)
at weblogic.Server.main(Server.java:32)
>
<2003-7-16 上午11时12分34秒> <Notice> <Management> <141052> <Application Poller started for development server.>
<2003-7-16 上午11时12分40秒> <Notice> <WebLogicServer> <000354> <Thread "SSLListenThread.Default" listening on port 7002>
<2003-7-16 上午11时12分40秒> <Notice> <WebLogicServer> <000354> <Thread "ListenThread.Default" listening on port 7001>
<2003-7-16 上午11时12分40秒> <Notice> <WebLogicServer> <000331> <Started WebLogic Admin Server "myserver" for domain "mydomain" running in Development Mode>
<2003-7-16 上午11时12分41秒> <Notice> <WebLogicServer> <000365> <Server state changed to RUNNING>
<2003-7-16 上午11时12分41秒> <Notice> <WebLogicServer> <000360> <Server started in RUNNING mode>
java.sql.SQLException: 调用中无效的参数这句话什么意思?
java.sql.SQLException: 调用中无效的参数这句话什么意思?
对于这个url和user /password在单独用其他工具直接连接数据库的时候是否是通的?
你要做的是换成9i的就好使的。
GOOD LUCK!!!
我为此写了个测试程序,可以说数据库的url,以及password是正确的.to langjianjun(绝对在乎你)
我在classpath里面设置的驱动是I:\ora9i\jdbc\lib\classes12.jar
这个classes12.jar是ORACLE8i的驱动程序?
那么9i的驱动在哪儿呢?以下为测试程序:
import java.sql.*;class TestOracle {
public static void main(String[] args) {
try
{
//DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.0.3:1521:oracl",
"system", "system");
System.out.println("Connection established successfully!");
conn.close();
}
catch(ClassNotFoundException cnfe)
{
System.err.println(cnfe);
}
catch(SQLException sqle)
{
System.err.println(sqle);
}
}
}
请高手们给个Entity bean的分发的例子.或者相关参考文档或网站.
多谢了
系统是2000 server.
2.如果回答是:说明与JBuilder无关。是WebLogic内部设置错误。
3.如果否,就是说,你在WL上deploy了一个应用,然后重新启动WL是报的错,如果是这种情况,启动WL后,先删除应用,再重新启动WL,就是回到2的情形,看是否抱错,如果不报,再把应用部署上,再启动WL,这次应该抱错。如果是这样,说明你的应用程序内部有问题,基本就是JBuilder内数据源的错误了。
我卸载了WL8, 然后删除bea文件夹.重新安装WL8后
WebLogic 810b启动没有问题. 但是不能将DataSource Deploy到myserver上.
在mydomain> JDBC Data Sources 下面看到的状态如下:
Name :oraclesample4
JNDIName :oraclesample4
Pool Name :oraclepool
Row Prefetch Enabled :false
Enable Two Phase Commit :n/a
Stream Chunk Size :256
Row Prefetch Size :48
Deployed :false <<--我想问题可能就出现在这里,无论如何,这里总是false!!并且在IE的左下角("Applet已启动"字样的左边)出现一个黄色感叹号图标,双击它弹出详细信息:
行:1203
字符:3
错误:对象不支持此属性或方法
代码:0
URL:http://localhost:7001/console/actions/mbean/DoMBeanWizardAction?parentMBean=mydomain%3AName%3Dmydomain4%2CType%3DDomain&attributes=weblogic.management.configuration.JDBCTxDataSourceMBean.Name%3Doraclesample4&attributes=weblogic.management.configuration.JDBCTxDataSourceMBean.JNDIName%3Doraclesample4&attributes=weblogic.management.configuration.JDBCDataSourceAssistant.Tx%3Dfalse&reloadNav=false&message&=wizardName=JDBCDataSourceAssistant&step=Pool&MBeanClass=weblogic.management.configuration.JDBCTxDataSourceMBean
下面还有两个:
URL:http://localhost:7001/console/actions/mbean/EditMBeanAction?reloadNav=false&MBean=mydomain%3AName%3Doraclesample4%2CType%3DJDBCDataSource
URL:http://localhost:7001/console/actions/mbean/DoEditMBeanAction?reloadNav=false&MBean=mydomain%3AName%3Doraclesample4%2CType%3DJDBCDataSource
Services->JDBC->Connection Pools->Configure a new JDBC Connection Pool...
[Name]:
ConnectionPool
[URL]:
jdbc:oracle:thin:@devsrv:1521:orcl
[DriverClassName]:
oracle.jdbc.driver.OracleDriver
[Key-Value]:
user=helios_user
password=a
dll=ocijdbc8
protocol=thin定位服务器。(参看TxDataSourceConf.txt)
[Name]: DataSource
[JNDI Name]:DataSource
[Pool Name]:ConnectionPool
[Emulate Two-Phase Commit for non-XA Driver]:
checked boxServices->JDBC->Tx Data Sourcess->LotteryDataSource->Targets
在Available内选择一个server到Chosen内。按APPLY。
2.按上面先走一,再走二。
相应的参数根据你的需要做修改了。一定能成。
以上问题已经解决了.是IE的问题.我的IE是5.0,也就是2000server自带的.
刚才我将IE升级到6.0 2800后,没有出现deploy DataSource fail的现象了.但我还是不明白,http://localhost:7001指的路径在本地哪儿?比如我的.jsp应该放在哪儿,然后就可以在IE中浏览呢?我的WebLogic 是8.1b的版本.
2.jsp放在WEB-INF上层目录。可以直接访问。
WEB-INF放哪? JBuiler内工程会自己建立。
Name: AccountTransactionWeb
The name of this Web application deployment.
Context Root: /AccountTransactionWeb
The URI, located on the Administration Server, of the original source files for this Web application module.
Path: C:\ bea\ user_projects\ mydomain\ .\ myserver\ upload\ AccountTransaction\ AccountTransaction.ear\ AccountTransactionWeb.war
The location of the WAR file or exploded WAR directory
-------------------------------------------------------------------------------
This page allows you to test the deployment of the Web application to make sure it was a successful one.
myserver: http://localhost:7001/AccountTransactionWeb/
Welcome Files: There are no welcome files for this application.
--------------------------------------------------------------------------------
Web 组件中,有一个名为 ManageAcc 的 servlet。servlet 执行诸如提款、存款之类的银行事务并显示执行后的余额。
----------------------------------------------------------------------------------
但是我在IE里浏览http://localhost:7001/AccountTransactionWeb/ManageAcc
却提示404 not found.错误
这是什么原因?