Carsten Webering
|
| Posted: 03/03/2003, 8:21 AM |
|
Hi
Somebody manage to get the JSP code generation to work on
Tomcat 4.1
Microsofts SQL Server 2000
Java SDK 1.4
Microsofts JDBC driver
I'm confused on how to configure a data connection. Should I use the ODBC
Data Source or the Bind Connection string.
In the Java/JSP developer guide there are three ways of configuring for
Tomcat 1.4 but this tree ways of doing it isn't descibed with examples on
how to do it in the DB connection dialog.
When using the Data Source configuration with Data extensions the Tomcat
doesn't install the war file.
When configuring with Connection string binding I got an error can't connect
to Connection1. When using the Data Source configuration with Data
extensions it isn't possible to add configuration as shown in Tomcat 4.1
server.xml?
Best Regards Carsten
|
|
|
 |
jc
|
| Posted: 03/04/2003, 12:25 AM |
|
Carsten Webering wrote:
> Hi
>
> Somebody manage to get the JSP code generation to work on
>
> Tomcat 4.1
> Microsofts SQL Server 2000
> Java SDK 1.4
> Microsofts JDBC driver
>
> I'm confused on how to configure a data connection. Should I use the ODBC
> Data Source or the Bind Connection string.
For design time(tab Design) you can use either Bind Connection string or
ODBC Data Source, as you wish. Using Bind Connection string is better.
For example:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=<login>;Initial
Catalog=<dbName>;Data Source=<server>
For runtime(tab Server) you should configure the Server connection.
JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
DataBase URL:
jdbc:microsoft:sqlserver://<server>:<port>;DatabaseName=<dbname>
> In the Java/JSP developer guide there are three ways of configuring for
> Tomcat 1.4 but this tree ways of doing it isn't descibed with examples on
> how to do it in the DB connection dialog.
>
> When using the Data Source configuration with Data extensions the Tomcat
> doesn't install the war file.
>
> When configuring with Connection string binding I got an error can't connect
> to Connection1. When using the Data Source configuration with Data
> extensions it isn't possible to add configuration as shown in Tomcat 4.1
> server.xml?
>
> Best Regards Carsten
>
>
>
|
|
|
|
|
