billames
Posts: 5
|
| Posted: 02/12/2005, 10:56 AM |
|
I am wanting to connect to a remote MS SQL Server and can not get CSS to work with it. I have created my own small Java Application to test my driver, url, and database and ports and my application works fine. So I must be missing something in the CSS setup.
Below is part of my properties file followed by the error. Also note this CSS application works fine when I use a DSN instead of trying to connect through a URL.
[ Properties
Quote :#Connection 'Connection1' properties @1-53D66A90
Connection1.name=Connection1
Connection1.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection1.dbType=MSSQLServer
Connection1.url=jdbc:microsoft:sqlserver://lab3.school.edu:2541 <---(port is correct)
Connection1.maxconn=5
Connection1.user=removed
Connection1.password=removed
Connection1.timeout=500
Connection1.fieldLeftDelim=[
Connection1.fieldRightDelim=]
Connection1.dateLeftDelim='
Connection1.dateRightDelim='
Connection1.dbNameUppercase=True
Connection1.dateFormat=MM/dd/yyyy HH:mm:ss
Connection1.booleanFormat=true;false
Connection1.optimizeSQL=True
#End Connection 'Connection1' properties
Quote :HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.RuntimeException: Unable to create connection 'Connection1' to the database.
com.codecharge.db.PoolJDBCConnection.getConnection(PoolJDBCConnection.java:19)
com.codecharge.db.JDBCConnection.(JDBCConnection.java:80)
com.codecharge.db.PoolJDBCConnection.(PoolJDBCConnection.java:11)
com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:36)
com.codecharge.db.JDBCConnectionFactory.getJDBCConnection(JDBCConnectionFactory.java:27)
Default.booksDataObject.load(booksDataObject.java:131)
Default.DefaultAction$booksClass.read(DefaultAction.java:255)
Default.DefaultAction$booksClass.perform(DefaultAction.java:201)
Default.DefaultAction.perform(DefaultAction.java:54)
com.codecharge.ControllerServlet.service(ControllerServlet.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:861)
sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:246)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:268)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
CP is has:
mssqlserver.jar
msutil.jar
msbase.jar
servlet.jar
j2ee.jar
Any help or insight into this would be greatly appreciated. As I stated before, the app runs great when I use a DSN for the exact same database.
|
 |
 |
sbwtxj
Posts: 27
|
| Posted: 02/25/2005, 9:41 PM |
|
Try it :
Connection1.url=jdbc:microsoft:sqlserver://lab3.school.edu:2541 <---(port is correct)  ;DatabaseName=xxxxx
_________________
----------------
Regards,
shanbw |
|
|
|
hemant
|
| Posted: 04/07/2005, 12:24 AM |
|
hi all
im trying to save data written in hindi. on ms sql ....but i dont know how to do this ...plz help me ...im a beginner.
regards
hemant..
|
|
|
|
sbwtxj
Posts: 27
|
| Posted: 05/10/2005, 8:15 PM |
|
pls give me more the particular infor.
_________________
----------------
Regards,
shanbw |
|
|
|
sdfasdf
|
| Posted: 06/08/2005, 7:19 AM |
|
              Quote :djfa;lsmd;a dasfadfasdfsadfadf 
|
|
|
|
eserver221
|
| Posted: 06/16/2005, 6:51 PM |
|
Clear the user and password value in your site.properties file, Do just as the Manual described.
|
|
|
|
|
