JNDI Help

[gwt.client]

Can anybody provide me the snippets of the server.properties file for connecting to the Database through JNDI look up?

[bftanase]

You don't have to set anything in server.properties.

Just edit your ds.xml file and enter that info there:

<DataSource
dbName="jdbc/myDatabase" <!-- JDNI name -->
  tableName="myTable"
  serverType="sql"
   ...

[gwt.client]

I am getting following Exception.


criteria:{},
operationConfig:{dataSource:"dsEmp", operationType:"fetch", textMatchStyle:"substring"},
startRow:0,
endRow:75,
componentId:"isc_OID_67",
appID:"builtinApplication",
operation:"dsEmp_fetch",
oldValues:{}
}
INFO IDACall - Performing 1 operation(s)
DEBUG DataSource - Creating instance of DataSource 'dsEmp'
DEBUG AppBase - [builtinApplication.dsEmp_fetch] No userTypes defined, allowing anyone access to all operations for this application
DEBUG AppBase - [builtinApplication.dsEmp_fetch] No public zero-argument method named '_dsEmp_fetch' found, performing generic datasource operation
INFO SQLDataSource - [builtinApplication.dsEmp_fetch] Performing fetch operation with
criteria: {} values: {}
INFO SQLWhereClause - [builtinApplication.dsEmp_fetch] empty condition
DEBUG SQLDataSource - [builtinApplication.dsEmp_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
DEBUG PoolableSQLConnectionFactory - [builtinApplication.dsEmp_fetch] Returning unpooled Connection
INFO SQLDriver - [builtinApplication.dsEmp_fetch] Executing SQL query on 'jdbc/myDatasource': SELECT COUNT(*) FROM Emp WHERE ('1'='1')
DEBUG SQLServerDriver - [builtinApplication.dsEmp_fetch] SQL Server version is Microsoft SQL Server Yukon - 9.00.4035
WARN RequestContext - dsRequest.execute() failed:
java.lang.NumberFormatException: For input string: "Microsoft SQL Server Yukon - 9"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1239)
at java.lang.Float.parseFloat(Float.java:409)
at com.isomorphic.sql.SQLServerDriver.supportsSQLLimit(SQLServerDriver.java:104)
at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1226)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1036)
at com.isomorphic.sql.SQLDataSource.execute(SQLDataSource.java:208)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:728)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:665)
at com.isomorphic.application.AppBase.execute(AppBase.java:498)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1209)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:154)



Here is my ds.xml file entry.

<DataSource ID="dsEmp" dataFormat="iscServer" serverType="sql" dbName="jdbc/myDatasource" tableName="Emp">

We are trying to deploy our application on Websphere server 6.1,we are getting lot of issues.

Can you please drop me an email if you have any sample example

gwt.client@gmail.com

[Isomorphic]

This particular error is because even though there are separate getDatabaseProductName() and getDatabaseProductVersion() APIs in the java.sql.DatabaseMetaData class, Microsoft's driver chooses to return the String "Microsoft SQL Server Yukon - 9.00.4035" from getDatabaseProductVersion(), at least under JNDI.

We have worked around it for 2.1. The free evaluation is available now:

http://forums.smartclient.com/showthread.php?t=4839

[gwt.client]

Thanks a lot.It is working fine with SmartGWT V 2.1

Thanks a lot.It is working fine with SmartGWT V 2.1.