Pierrik Le Guennec
|
| Posted: 01/25/2003, 1:37 PM |
|
I have a war file with these parameters :
I am using Sun ONE Application Server 7, Standard Edition
CLASSPATH =
E:\Program Files\s1studio_jdk\j2sdk1.4.1;
E:\Program Files\s1studio_jdk\j2sdk1.4.1\lib;
E:\Program Files\s1studio_jdk\j2sdk1.4.1\jre\lib\rt.jar;
E:\j2sdkee1.3.1\lib\j2ee.jar;
E:\Sun\AppServer7\lib;
E:\Sun\AppServer7\share\lib\xercesImpl.jar;
E:\Sun\AppServer7\share\lib\xalan.jar;
E:\Sun\AppServer7\share\lib\dom.jar;
E:\Sun\AppServer7\share\lib\sax.jar
JAVA_HOME = E:\Program Files\s1studio_jdk\j2sdk1.4.1
ANT_HOME = E:\Sun\AppServer7\lib\ant
path =
E:\Sun\AppServer7\bin;
E:\Program Files\s1studio_jdk\j2sdk1.4.1\bin;
C:\Perl\bin\;
C:\WINDOWS\system32;
C:\WINDOWS;
C:\WINDOWS\System32\Wbem;
C:\Program Files\cvsnt;
C:\Program Files\Microsoft SQL Server\80\Tools\BINN
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for
JDBC\lib\mssqlserver.jar
JDBC parameters
JDBC driver : com.microsoft.jdbc.sqlserver.SQLServerDriver
DataBase URL : jdbc:microsoft:sqlserver://localhost:1443
With Admin Console of Application Server, Applications, Web Apps : war file.
Deploy from
E:\Sun\AppServer7\domains\domain1\server1\applications\j2ee-apps\agenda_jsp
The Web App is ok
But I have :
Sun ONE Application Server - HTTP Status 500 Error
The server encountered an internal error (Internal Server Error) that
prevented it from fulfilling this request.
Type: Exception Report
Message: Internal Server Error
Exception
java.lang.RuntimeException: Unable to create connection 'agenda' to the
database.
at
com.codecharge.db.PoolJDBCConnection.getConnection(PoolJDBCConnection.java:1
4)
at com.codecharge.db.JDBCConnection.(JDBCConnection.java:47)
at com.codecharge.db.PoolJDBCConnection.(PoolJDBCConnection.java:7)
at com.codecharge.PageController.processGrid(PageController.java:864)
at com.codecharge.PageController.process(PageController.java:244)
at _jasper._Cours_list_jsp._jspService(_Cours_list_jsp.java:90)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.iplanet.ias.web.jsp.JspServlet$JspServletWrapper.service(JspServlet.java
:552)
at com.iplanet.ias.web.jsp.JspServlet.serviceJspFile(JspServlet.java:368)
at com.iplanet.ias.web.jsp.JspServlet.service(JspServlet.java:287)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardW
rapperValve.java:720)
at
org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValv
e.java:118)
at
org.apache.catalina.core.StandardWrapperValve$1.run(StandardWrapperValve.jav
a:278)
at java.security.AccessController.doPrivileged(Native Method)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:274)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:212)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203
)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.ja
va:157)
at com.iplanet.ias.web.WebContainer.service(WebContainer.java:598)
I create a Connection Pool :
JNDI Name : agenda
Datasource Classname : com.microsoft.jdbc.sqlserver.SQLServerDriver
serverName : localhost
portNumber : 1443
user : user
databaseName : base
But I am not sure about syntax from CodeCharge, Sun, Microsoft...
|
|
|
|
Pierrik Le Guennec
|
| Posted: 01/27/2003, 11:29 AM |
|
> I create a Connection Pool :
> JNDI Name : agenda
> Datasource Classname : com.microsoft.jdbc.sqlserver.SQLServerDriver
> serverName : localhost
> portNumber : 1443
> user : user
> databaseName : base
Here is the problem :
portNumber : 1443
In fact, 1433 !
Another problem :
SQL Server an Windows authentification needeed.
|
|
|
|
|
|
