Archive for the ‘ Java ’ Category

SmartFox and SQL Server 2005 Connection

For Java 1.6

Downloaded Microsoft SQL Server JDBC Driver 3.0

copy sqljdbc4.jar to SmartFoxServerPRO_1.6.6\jre\lib\ext

Remove sqljdbc.jar or else error while starting server to put sqljdbc4.jar

Change config.xml for zone you need to create extension for.

<DatabaseManager active=”true”>

<Driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</Driver>
<ConnectionString>jdbc:sqlserver://;serverName=yourip;databaseName=dbname</ConnectionString>

<UserName>username</UserName>
<Password>password</Password>

<TestSQL><![CDATA[SELECT COUNT(*) FROM Game]]></TestSQL>

<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>

<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>

</DatabaseManager>

Set your connection type to active=true in order to excute DB ..

check sample application from smartfoxServerDoc

Jasper Reports Java Objects/Class Map Example

Hi All,

Jasper Report Java Object Mapping example..

Following link give most of it. though it is back dated..

http://ireport.sourceforge.net/cap3.html

There are few books on IReport >> You might want to download from here.
Guide To IReport
The Definitive Guide to iReport (Expert's Voice)

Guide To JasperReport for Java
JasperReports for Java Developers: Create, Design, Format and Export Reports with the world's most popular Java reporting library