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:14)
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(StandardWrapperValve.java:720)
at org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValve.java:118)
at org.apache.catalina.core.StandardWrapperValve$1.run(StandardWrapperValve.java:278)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:274)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: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.java: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...
|
|
|
|
RG
|
| Posted: 01/26/2003, 8:04 PM |
|
Are you aware that the "standard" port number for MS sql server is: 1433 and not 1443!
|
|
|
|
Pierrik Le Guennec
|
| Posted: 01/27/2003, 11:44 AM |
|
Exactly !
> 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.
Thanks !
|
|
|
|
RG
|
| Posted: 01/27/2003, 12:39 PM |
|
Another problem :
SQL Server an Windows authentification needeed.
^
Sorry, I don't understand the question.
|
|
|
|
|
|
