• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL server 2000 connection problem in weblogic7.0  RSS feed

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
plaese read the one by one line.. clarify the error... while connecting the database...sqlserver2000
E:\bea\weblogic700\samples\server\config\examples>setExamplesEnv
E:\bea\weblogic700\samples\server\config\examples>set SAMPLES_HOME=E:\bea\weblo
ic700\samples
E:\bea\weblogic700\samples\server\config\examples>set APPLICATIONS=E:\bea\weblo
ic700\samples\server\config\examples\applications
E:\bea\weblogic700\samples\server\config\examples>set CLIENT_CLASSES=E:\bea\web
ogic700\samples\server\stage\examples\clientclasses
E:\bea\weblogic700\samples\server\config\examples>set SERVER_CLASSES=E:\bea\web
ogic700\samples\server\stage\examples\serverclasses
E:\bea\weblogic700\samples\server\config\examples>set COMMON_CLASSES=E:\bea\web
ogic700\samples\server\stage\common
E:\bea\weblogic700\samples\server\config\examples>set EX_WEBAPP_CLASSES=E:\bea\
eblogic700\samples\server\stage\examples\examplesWebApp\WEB-INF\classes
E:\bea\weblogic700\samples\server\config\examples>set WEBSERVICES_JAR=E:\bea\we
logic700\server\lib\webservices.jar
CLASSPATH=E:\bea\jdk131_03\lib\tools.jar;E:\bea\weblogic700\server\lib\weblogic
sp.jar;E:\bea\weblogic700\server\lib\weblogic.jar;E:\bea\weblogic700\server\lib
webservices.jar;E:\bea\weblogic700\samples\server\stage\examples\clientclasses;
:\bea\weblogic700\samples\server\stage\examples\serverclasses;E:\bea\weblogic70
\samples\server\eval\pointbase\lib\pbserver42ECF183.jar;E:\bea\weblogic700\samp
es\server\eval\pointbase\lib\pbclient42ECF183.jar;E:\bea\weblogic700\server\lib
classes12.zip;E:\bea\weblogic700\server\lib\mssqlserver4v65.jar;E:\bea\weblogic
00\samples\server\stage\common
PATH=E:\bea\weblogic700\server\bin;E:\bea\jdk131_03\bin;E:\bea\weblogic700\serv
r\bin;E:\bea\jdk131_03\bin;E:\bea\weblogic700\server\bin;E:\bea\jdk131_03\bin;E
\bea\weblogic700\server\bin;E:\bea\jdk131_03\bin;E:\bea\weblogic700\server\bin;
:\bea\jdk131_03\bin;E:\bea\weblogic700\server\bin;E:\bea\jdk131_03\bin;E:\bea\w
blogic700\server\bin;E:\bea\jdk131_03\bin;E:\bea\weblogic700\server\bin;E:\bea\
dk131_03\bin;E:\bea\weblogic700\server\bin;E:\bea\jdk131_03\bin;E:\bea\weblogic
00\server\bin;E:\bea\jdk131_03\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32
Wbem;d:\jdk1.3.1\bin;d:\jdk1.3.1\lib\tools.jar;d:\ant-1.6.1\bin;d:\junit3.8.1\j
nit.jar;d:\log4j-1.2.8\dist\classes;E:\CBuilderX\bin;d:\Sun\AppServer\bin;D;C:\
RAWIN\BIN;;E:\bea\weblogic700\samples\server\eval\pointbase\tools;E:\bea\weblog
c700\samples\server\eval\pointbase\tools;E:\bea\weblogic700\samples\server\eval
pointbase\tools;E:\bea\weblogic700\samples\server\eval\pointbase\tools;E:\bea\w
blogic700\samples\server\eval\pointbase\tools;E:\bea\weblogic700\samples\server
eval\pointbase\tools;E:\bea\weblogic700\samples\server\eval\pointbase\tools;E:\
ea\weblogic700\samples\server\eval\pointbase\tools;E:\bea\weblogic700\samples\s
rver\eval\pointbase\tools;E:\bea\weblogic700\samples\server\eval\pointbase\tool

Your environment has been set.
E:\bea\weblogic700\samples\server\config\examples>java utils.dbping MSSQLSERVE
4 sa "" tcl@saigun-server:1433
Error encountered:
java.sql.SQLException: I/O exception while talking to the server, java.net.Sock
tException: Connection reset by peer: socket write error Unable to connect, ple
se check your server's version and availability.
at weblogic.jdbc.mssqlserver4.TdsStatement.microsoftLogin(TdsStatement.
ava:2823)
at weblogic.jdbc.mssqlserver4.MicrosoftConnection.beginLogin(MicrosoftC
nnection.java:44)
at weblogic.jdbc.mssqlserver4.TdsConnection.login(TdsConnection.java:59
at weblogic.jdbc.mssqlserver4.MicrosoftConnection.login(MicrosoftConnec
ion.java:55)
at weblogic.jdbc.mssqlserver4.BaseConnection.prepareConnection(BaseConn
ction.java:181)
at weblogic.jdbc.mssqlserver4.Driver.newConnection(Driver.java:34)
at weblogic.jdbc.mssqlserver4.ConnectDriver.connect(ConnectDriver.java:
48)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:141)
at utils.dbping.main(dbping.java:157)
E:\bea\weblogic700\samples\server\config\examples>java utils.dbping MSSQLSERVE
4 sa "" saigun-server:1433/tcl
Error encountered:
java.sql.SQLException: Invalid port: 1433/tcl
at weblogic.jdbc.mssqlserver4.ConnectionInfo.<init>(ConnectionInfo.java
193)
at weblogic.jdbc.mssqlserver4.ConnectDriver.parse(ConnectDriver.java:33
)
at weblogic.jdbc.mssqlserver4.ConnectDriver.connect(ConnectDriver.java:
02)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:141)
at utils.dbping.main(dbping.java:157)
E:\bea\weblogic700\samples\server\config\examples>
 
Alex Sharkoff
Ranch Hand
Posts: 209
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kanikanti,


java.sql.SQLException: I/O exception while talking to the server, java.net.SocktException: Connection reset by peer: socket write error Unable to connect, please check your server's version and availability.

Looks like SQLServer got shut down after the app server(in your case this is weblogic) was started.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!