Saving data to SQL Server2005
I tried the example in post to save logs in my SQL Server 2005, but the server did not run and gave me this error:
java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
So I used sqljdbc4.jar , the server started but did not accept any client to connect. I'm using Wowza Media Server 2.2.3
I'm not sure. Sorry. I don't have a setup to test this. I would say upgrade to Wowza 3.0.5, and I will, you should, but I doubt it will affect this.
I don't want to upgrade now (money cost)
that's the error in details:
log4j:ERROR Failed to excute sql
java.sql.SQLException: No suitable driver found for jdbc:sqlserver:Myserver;databaseName=WowzaLog
at java.sql.DriverManager.getConnection(DriverManager .java:602)
at java.sql.DriverManager.getConnection(DriverManager .java:185)
at org.apache.log4j.jdbc.JDBCAppender.getConnection(U nknown Source)
at org.apache.log4j.jdbc.JDBCAppender.execute(Unknown Source)
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(Unk nown Source)
at org.apache.log4j.jdbc.JDBCAppender.append(Unknown Source)
at org.apache.log4j.AppenderSkeleton.doAppend(Unknown Source)
at org.apache.log4j.helpers.AppenderAttachableImpl.ap pendLoopOnAppenders
I tried sqljdbc.jar and sqljdbc4.jar and I defined classpath for the jar file.
FYI, the upgrade license from WMS2 to WMS3 is free.
Regarding your SQL issue, I suggest creating a new Java program outside of Wowza to test your ODBC code. I think this is more of a Java/ODBC/MSSQL question than a Wowza question.