On Dec 29, 7:58 pm, Manish Gupta <[email protected]> wrote:
> jtds driver works fine with MSSQL db for me , its open source can be
> found herehttp://jtds.sourceforge.net/
>
> Because I am using jre 1.6 I can not use the sqljdbc.jar. When I use the
> sqljdbc4.jar
everything appears to work fine but the tables are not created in the
daabase. If I migrate the database from mysql to sql server then I
think I may have some data conversion errors becuase although records
are in the database I get an error when trying to access openmeeetings
because of null sessions.
I also tried to use the jtds driver.
I am getting and invalid url error and I dont see anything wrong with
the url
java.sql.SQLException: The syntax of the connection URL
'jdbc:jtds:sqlsever://xxx.xxx.xxx.xxx:1433/openmeetings' is invalid.
Below are the lines in my hibernate.cff.xml
<!-- User / Password -->
<property name="connection.username">xxxx</property>
<property name="connection.password">xxxx</property>
<!-- Database Settings -->
<property
name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</
property>
<!-- for performance reasons changed to MyISAM from
org.hibernate.dialect.MySQLInnoDBDialect -->
<property
name="dialect">org.hibernate.dialect.SQLServerDialect</
property>
<property
name="connection.url">jdbc:jtds:sqlsever://127.0.0.1:1433/
openmeetings</property>
I input the bare minimum to see if could just get a connection.
If you can provide a sample of your hibernate.cfg.xml
or
If you can see what is wrong with the url above I would appreciate if
you can tell me.
> On Wed, Dec 30, 2009 at 7:13 AM, Aman Khanna <[email protected]> wrote:
> > I have not tried with sqljdbc4.jar but sqljdbc.jar worked fine for me.
>
> > I have specified userid and passoword as separate properties.
> > <property name="connection.username">xxxx</property>
>
> > <property name="connection.password">xxxx</property>
>
> > I had to change the connection URL to the format below for it to work.
> > <property
> > name="connection.url">jdbc:sqlserver://127.0.0.1:1433;databaseName=openmeetings;autoReconnect=true;useUnicode=true;createDatabaseIfNotExist=true;characterEncoding=utf-8</property>
>
> > Hope this helps.
>
> > On Tue, Dec 29, 2009 at 12:03 PM, HMiles <[email protected]> wrote:
>
> >> I have a couple of questions about the configuration for a mssql
> >> database.
> >> Can you tell me what I am doing wrong?
>
> >> 1. Does anyone know where I can get the mssql-jdbc.jar from..
> >> 2. Will the sqljdbc4.jar from microsoft work with openmeetings?
> >> 3. Does anyone have the syntax that will make it auto create the
> >> database is in MYSQL configuration?
> >> I taken the following steps and I am still unable to connect to my MS
> >> SQL SERVER:
>
> >> I copied the sqljdbc4.jar into the red5\webapps\openmeetings\WEB-INF
> >> \lib directory
> >> I changed the following lines in the hibernate.cfg.xml file
>
> >> 'Rem the User /Password are included in the connection.url
> >> 'Rem the dialect was changed to
> >> "org.hibernate.dialect.SQLServerDialect"
> >> 'Rem the connection.driver_class was changed to
> >> "com.microsoft.sqlserver.jdbc.SQLServerDriver"
> >> 'Rem the connection.url was change to " jdbc:sqlserver://
> >> xxx.xxx.xxx.xxx:1433;user=xxx;password=xxx;databasename=openmeetings?
>
> >> autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8"
>
> >> --
>
> >> You received this message because you are subscribed to the Google Groups
> >> "OpenMeetings User" group.
> >> To post to this group, send email to [email protected].
> >> To unsubscribe from this group, send email to
> >> [email protected].
> >> For more options, visit this group at
> >>http://groups.google.com/group/openmeetings-user?hl=en.
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "OpenMeetings User" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > For more options, visit this group at
> >http://groups.google.com/group/openmeetings-user?hl=en.- Hide quoted text -
>
> - Show quoted text -
--
You received this message because you are subscribed to the Google Groups
"OpenMeetings User" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/openmeetings-user?hl=en.
