Sagy
|
Posted: 01/29/2006, 8:52 AM |
|
Hi,
I've been trying for a while now to connect from a JSP appliction built by the Application Builder (I'm using CCS 3.0.2.2) to a MS SQL server.
when I'm setting up the connection, the design server works fine. I'm able to connect and get the tables for the wizard. but the server on the Server tab doesnt seem to work. meaning, when I try the "Live Page" I get the empty template and 2 error messages saying "[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'tabel1'".
I've been playing with it for 2 days now - and can't seem to resolve it.
the debugger outputs:
CCLogger [29-01 06:47:05.384] INFO: Registered JDBC driver com.microsoft.jdbc.sqlserver.SQLServerDriver
CCLogger [29-01 06:47:05.399] INFO: Initialized pool Connection1
CCLogger [29-01 06:47:06.993] DEBUG: Process page /table1_list.jsp
CCLogger [29-01 06:47:07.399] DEBUG: PageController.process() started
CCLogger [29-01 06:47:07.493] DEBUG: Process record 'table1Search' ccsForm=null
CCLogger [29-01 06:47:07.493] DEBUG: Process Grid 'table1
CCLogger [29-01 06:47:07.774] INFO: Created a new connection in pool Connection1
CCLogger [29-01 06:47:07.774] DEBUG: DBConnectionManager.getConnection(): One connection taken
CCLogger [29-01 06:47:07.790] ERROR: Cannot execute RawCommand
RawCommand sql='SELECT table1.id, table1.FirstName, table1.LastName, table1.DOB, table1.Weight, table1.Income FROM table1 {SQL_Where} {SQL_OrderBy}'
where='null'
order=''
countSql='SELECT COUNT(*) FROM table1'
sqlString='SELECT COUNT(*) FROM table1'
startPos='1'
fetchSize='20'
connection='Connection1'
Parameters:none
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'table1'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
Any help would be appreciated.
Thanks.
|
|
|
Sagy
|
Posted: 01/30/2006, 12:33 AM |
|
Hi,
I found the problem and it works now.
I forgot to add the database name to the connect string...
Thanks anyway.
|
|
|
shravasti
|
Posted: 03/02/2006, 10:35 PM |
|
hi,
please tell me ,how to run the servlet using Tomcat4.1
and also tell me where to save the servlet file ,waiting for the reply
|
|
|
|