You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by tv...@apache.org on 2006/07/18 21:21:45 UTC
svn commit: r423216 - in /db/torque/test/trunk/profile/tv: Torque.properties
project.properties project.xml
Author: tv
Date: Tue Jul 18 12:21:45 2006
New Revision: 423216
URL: http://svn.apache.org/viewvc?rev=423216&view=rev
Log:
Added MS-SQL test environment
Modified:
db/torque/test/trunk/profile/tv/Torque.properties
db/torque/test/trunk/profile/tv/project.properties
db/torque/test/trunk/profile/tv/project.xml
Modified: db/torque/test/trunk/profile/tv/Torque.properties
URL: http://svn.apache.org/viewvc/db/torque/test/trunk/profile/tv/Torque.properties?rev=423216&r1=423215&r2=423216&view=diff
==============================================================================
--- db/torque/test/trunk/profile/tv/Torque.properties (original)
+++ db/torque/test/trunk/profile/tv/Torque.properties Tue Jul 18 12:21:45 2006
@@ -19,14 +19,21 @@
#
torque.database.default = bookstore
-torque.database.bookstore.adapter = mysql
+#torque.database.bookstore.adapter = mysql
+torque.database.bookstore.adapter = mssql
+torque.database.schema = sa
#Using commons-dbcp
torque.dsfactory.bookstore.factory = org.apache.torque.dsfactory.SharedPoolDataSourceFactory
-torque.dsfactory.bookstore.connection.driver = org.gjt.mm.mysql.Driver
-torque.dsfactory.bookstore.connection.url = jdbc:mysql://gatekeeper.home.lan:3306/bookstore
-torque.dsfactory.bookstore.connection.user = torque
-torque.dsfactory.bookstore.connection.password = torque
+#torque.dsfactory.bookstore.connection.driver = org.gjt.mm.mysql.Driver
+#torque.dsfactory.bookstore.connection.url = jdbc:mysql://gatekeeper.home.lan:3306/bookstore
+#torque.dsfactory.bookstore.connection.user = torque
+#torque.dsfactory.bookstore.connection.password = torque
+
+torque.dsfactory.bookstore.connection.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
+torque.dsfactory.bookstore.connection.url = jdbc:sqlserver://localhost;databaseName=bookstore
+torque.dsfactory.bookstore.connection.user = sa
+torque.dsfactory.bookstore.connection.password = apache
torque.dsfactory.bookstore.pool.validationQuery = SELECT 1
Modified: db/torque/test/trunk/profile/tv/project.properties
URL: http://svn.apache.org/viewvc/db/torque/test/trunk/profile/tv/project.properties?rev=423216&r1=423215&r2=423216&view=diff
==============================================================================
--- db/torque/test/trunk/profile/tv/project.properties (original)
+++ db/torque/test/trunk/profile/tv/project.properties Tue Jul 18 12:21:45 2006
@@ -25,12 +25,20 @@
torque.generateBeans = true
torque.useManagers = true
-torque.database = mysql
-torque.database.createUrl = jdbc:mysql://gatekeeper.home.lan:3306/mysql
-torque.database.buildUrl = jdbc:mysql://gatekeeper.home.lan:3306/bookstore
-torque.database.driver = org.gjt.mm.mysql.Driver
-torque.database.user = torque
-torque.database.password = torque
+#torque.database = mysql
+#torque.database.createUrl = jdbc:mysql://gatekeeper.home.lan:3306/mysql
+#torque.database.buildUrl = jdbc:mysql://gatekeeper.home.lan:3306/bookstore
+#torque.database.driver = org.gjt.mm.mysql.Driver
+#torque.database.user = torque
+#torque.database.password = torque
+
+torque.database = mssql
+torque.database.createUrl = jdbc:sqlserver://localhost
+torque.database.buildUrl = jdbc:sqlserver://localhost;databaseName=bookstore
+torque.database.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
+torque.database.user = sa
+torque.database.password = apache
#settings for the datadump and jdbc task
-torque.database.url = jdbc:mysql://gatekeeper.home.lan:3306/bookstore
\ No newline at end of file
+#torque.database.url = jdbc:mysql://gatekeeper.home.lan:3306/bookstore
+torque.database.url = jdbc:sqlserver://localhost;databaseName=bookstore
\ No newline at end of file
Modified: db/torque/test/trunk/profile/tv/project.xml
URL: http://svn.apache.org/viewvc/db/torque/test/trunk/profile/tv/project.xml?rev=423216&r1=423215&r2=423216&view=diff
==============================================================================
--- db/torque/test/trunk/profile/tv/project.xml (original)
+++ db/torque/test/trunk/profile/tv/project.xml Tue Jul 18 12:21:45 2006
@@ -32,4 +32,11 @@
<version>3.1.12-bin</version>
</dependency>
</dependencies>
+ <dependencies>
+ <dependency>
+ <artifactId>sqljdbc</artifactId>
+ <groupId>mssql</groupId>
+ <version>1.1</version>
+ </dependency>
+ </dependencies>
</project>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
Re: svn commit: r423216 - in /db/torque/test/trunk/profile/tv: Torque.properties
project.properties project.xml
Posted by Thomas Vandahl <th...@tewisoft.de>.
Greg Monroe wrote:
> Hmm, downloading to test this and noticed that your tv test
> profile uses the MySQL jdbc driver and adaptor. Doesn't
> match the comment that it's for MS SQL.
It actually contains both. It allows me to switch between setups by
removing and setting a few comment signs.
Bye, Thomas.
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
RE: svn commit: r423216 - in /db/torque/test/trunk/profile/tv: Torque.properties project.properties project.xml
Posted by Greg Monroe <Gr...@DukeCE.com>.
Hmm, downloading to test this and noticed that your tv test
profile uses the MySQL jdbc driver and adaptor. Doesn't
match the comment that it's for MS SQL.
FWIW, http://issues.apache.org/jira/browse/TORQUE-17, has my
take on a SQL 2000 profile using jTDS.
Am going to test your TORQUE-20 resolution against my SQL-2000
setup now.
Greg
> -----Original Message-----
> From: tv@apache.org [mailto:tv@apache.org]
> Sent: Tuesday, July 18, 2006 3:22 PM
> To: torque-commits@db.apache.org
> Subject: svn commit: r423216 - in
> /db/torque/test/trunk/profile/tv: Torque.properties
> project.properties project.xml
>
> Author: tv
> Date: Tue Jul 18 12:21:45 2006
> New Revision: 423216
>
> URL: http://svn.apache.org/viewvc?rev=423216&view=rev
> Log:
> Added MS-SQL test environment
>
> Modified:
> db/torque/test/trunk/profile/tv/Torque.properties
> db/torque/test/trunk/profile/tv/project.properties
> db/torque/test/trunk/profile/tv/project.xml
>
> Modified: db/torque/test/trunk/profile/tv/Torque.properties
> URL:
> http://svn.apache.org/viewvc/db/torque/test/trunk/profile/tv/T
> orque.properties?rev=423216&r1=423215&r2=423216&view=diff
> ==============================================================
> ================
> --- db/torque/test/trunk/profile/tv/Torque.properties (original)
> +++ db/torque/test/trunk/profile/tv/Torque.properties Tue Jul 18
> +++ 12:21:45 2006
> @@ -19,14 +19,21 @@
> #
>
> torque.database.default = bookstore
> -torque.database.bookstore.adapter = mysql
> +#torque.database.bookstore.adapter = mysql
> +torque.database.bookstore.adapter = mssql torque.database.schema = sa
>
> #Using commons-dbcp
> torque.dsfactory.bookstore.factory =
> org.apache.torque.dsfactory.SharedPoolDataSourceFactory
> -torque.dsfactory.bookstore.connection.driver =
> org.gjt.mm.mysql.Driver
> -torque.dsfactory.bookstore.connection.url =
> jdbc:mysql://gatekeeper.home.lan:3306/bookstore
> -torque.dsfactory.bookstore.connection.user = torque
> -torque.dsfactory.bookstore.connection.password = torque
> +#torque.dsfactory.bookstore.connection.driver =
> org.gjt.mm.mysql.Driver
> +#torque.dsfactory.bookstore.connection.url =
> +jdbc:mysql://gatekeeper.home.lan:3306/bookstore
> +#torque.dsfactory.bookstore.connection.user = torque
> +#torque.dsfactory.bookstore.connection.password = torque
> +
> +torque.dsfactory.bookstore.connection.driver =
> +com.microsoft.sqlserver.jdbc.SQLServerDriver
> +torque.dsfactory.bookstore.connection.url =
> +jdbc:sqlserver://localhost;databaseName=bookstore
> +torque.dsfactory.bookstore.connection.user = sa
> +torque.dsfactory.bookstore.connection.password = apache
>
> torque.dsfactory.bookstore.pool.validationQuery = SELECT 1
>
>
> Modified: db/torque/test/trunk/profile/tv/project.properties
> URL:
> http://svn.apache.org/viewvc/db/torque/test/trunk/profile/tv/p
> roject.properties?rev=423216&r1=423215&r2=423216&view=diff
> ==============================================================
> ================
> --- db/torque/test/trunk/profile/tv/project.properties (original)
> +++ db/torque/test/trunk/profile/tv/project.properties Tue Jul 18
> +++ 12:21:45 2006
> @@ -25,12 +25,20 @@
> torque.generateBeans = true
> torque.useManagers = true
>
> -torque.database = mysql
> -torque.database.createUrl =
> jdbc:mysql://gatekeeper.home.lan:3306/mysql
> -torque.database.buildUrl =
> jdbc:mysql://gatekeeper.home.lan:3306/bookstore
> -torque.database.driver = org.gjt.mm.mysql.Driver
> -torque.database.user = torque -torque.database.password = torque
> +#torque.database = mysql
> +#torque.database.createUrl =
> +jdbc:mysql://gatekeeper.home.lan:3306/mysql
> +#torque.database.buildUrl =
> +jdbc:mysql://gatekeeper.home.lan:3306/bookstore
> +#torque.database.driver = org.gjt.mm.mysql.Driver
> #torque.database.user
> += torque #torque.database.password = torque
> +
> +torque.database = mssql
> +torque.database.createUrl = jdbc:sqlserver://localhost
> +torque.database.buildUrl =
> +jdbc:sqlserver://localhost;databaseName=bookstore
> +torque.database.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
> +torque.database.user = sa
> +torque.database.password = apache
>
> #settings for the datadump and jdbc task
> -torque.database.url = jdbc:mysql://gatekeeper.home.lan:3306/bookstore
> \ No newline at end of file
> +#torque.database.url =
> jdbc:mysql://gatekeeper.home.lan:3306/bookstore
> +torque.database.url =
> jdbc:sqlserver://localhost;databaseName=bookstore
> \ No newline at end of file
>
> Modified: db/torque/test/trunk/profile/tv/project.xml
> URL:
> http://svn.apache.org/viewvc/db/torque/test/trunk/profile/tv/p
> roject.xml?rev=423216&r1=423215&r2=423216&view=diff
> ==============================================================
> ================
> --- db/torque/test/trunk/profile/tv/project.xml (original)
> +++ db/torque/test/trunk/profile/tv/project.xml Tue Jul 18
> 12:21:45 2006
> @@ -32,4 +32,11 @@
> <version>3.1.12-bin</version>
> </dependency>
> </dependencies>
> + <dependencies>
> + <dependency>
> + <artifactId>sqljdbc</artifactId>
> + <groupId>mssql</groupId>
> + <version>1.1</version>
> + </dependency>
> + </dependencies>
> </project>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>
>
Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited.
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org