connecting to mssql from struts

2005-12-02 Thread Stanislav
I manage to set up realm inside jboss (tomcat) for mssql, but i have problem with inserting/selecting data from db. I put this code into struts-config: data-sources data-source type=org.apache.commons.dbcp.BasicDataSource set-property property=driverClassName

Re: connecting to mssql from struts

2005-12-02 Thread Robin Clarke
set-property property=url value=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=WorkFlow / Your URL does not look like a correct MySQL URL. It should look something like: jdbc:mysql://[host][,failoverhost...][:port]/[database]

re: connecting to mssql from struts

2005-12-02 Thread Stanislav
I manage to set up realm inside jboss (tomcat) for mssql, but i have problem with inserting/selecting data from db. ... I figure it out.. Wrong SQL Exceptio, and missing comit(); - To unsubscribe, e-mail: [EMAIL

Re: connecting to mssql from struts

2005-12-02 Thread Stanislav
set-property property=url value=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=WorkFlow / Your URL does not look like a correct MySQL URL. It should look something like: jdbc:mysql://[host][,failoverhost...][:port]/[database]