In your portal-ds.xml (you can just edit the original - no need to rename file,
create new file, etc...)
You should change the XML to something like this:
| <no-tx-datasource>
| <jndi-name>PortalDS</jndi-name>
|
<connection-url>jdbc:jtds:sqlserver://YOUR_DB_SERVER_HOST:1433/YOUR_DATABASE;SelectMethod=Cursor</connection-url>
| <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
| <user-name>your-portal-DB-user</user-name>
| <password>your-portal-DB-password</password>
| </no-tx-datasource>
|
NOTE - I used the jTDS(open source) JDBC Driver for MS SQL Server/Sybase. You
MUST use PortalDS as the jndi-name of your data source.
You may need to tweak the hibernate config file for the portal at:
${JBOSS_HOME}\server\default\deploy\jboss-portal.sar\conf\hibernate\hibernate.cfg.xml
and manually set the SQL dialect to
org.hibernate.dialect.SQLServerDialect
Chances are that the portal will automatically sense the dialect for you though.
Some suggestions
- avoid using the JDBC:ODBC Driver, instead use a pure Java (Type IV) JDBC
Driver
- you can use any file name you want as long as it ends in -ds.xml, however,
there's not too much advantage in doing so because you must use a datasource
named PortalDS for the portal to work.
Hope this helps.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3900712#3900712
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3900712
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
