This content has been marked as final.
Show 4 replies
-
1. Re: seam gen and MS SQL server
kfletcher2005 Feb 13, 2008 9:02 PM (in response to mars1412)I just ran into this lately. The catalog and schema properties are important for seam-gen and sql2k5. Usually the catalog name is the same as the database name. Then enter your schema name also in the 'seam setup'. Also include your database (catalog) in your connection string. I finally got it working after I did this things.
jdbc:sqlserver://localhost\\dbact24:1433;databaseName=yourDatabaseName
-
2. Re: seam gen and MS SQL server
kfletcher2005 Feb 13, 2008 9:13 PM (in response to mars1412)Here is an example of my connect string url.
jdbc:sqlserver://CATL0DB49\DEVECOM:1433;databaseName=Test_Kent
And
Test-Kent
would be the catalog name. -
3. Re: seam gen and MS SQL server
mars1412 Feb 14, 2008 10:53 AM (in response to mars1412)thanks for the reply - I got it to work now
I forgot to set the schema correctly (dbo in my case)
complete seam-gen setup:[input] Enter the filesystem path to the JDBC driver jar [Z:\programme\Databases\MS Sql Server\MSSQL_JDBC\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar] [Z:\programme\Databases\MS Sql Server\MSSQL_JDBC\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar] [input] Enter JDBC driver class for your database [com.microsoft.sqlserver.jdbc.SQLServerDriver] [com.microsoft.sqls erver.jdbc.SQLServerDriver] [input] Enter the JDBC URL for your database [jdbc:sqlserver://localhost\dbact24:1433;databaseName=dbact24] [jdbc:sq lserver://localhost\dbact24:1433;databaseName=dbact24] [input] Enter database username [act24] [act24] [input] Enter database password [act24] [act24] [input] Enter the database schema name (it is OK to leave this blank) [dbo] [dbo] [input] Enter the database catalog name (it is OK to leave this blank) [dbact24] [dbact24]
-
4. Re: seam gen and MS SQL server
mars1412 Feb 14, 2008 10:55 AM (in response to mars1412)note: in a production database you should not use the default (dbo) schema and you should use a slightly better password :)